About the position
Metropolis is seeking a hands-on thought leader to drive the technical vision, design, and development of their data systems. The ideal candidate will have expertise in data APIs, data modeling, serverless cloud platforms, data pipelines, and machine learning operations. They will play a key role in defining and building the data tech stack, enabling the business teams to leverage data for meeting their goals. This position requires strong collaboration with application and engineering teams, as well as experience in data ingestion, data integration, and ETL processes.
Responsibilities
- Collaborate with Application and Engineering teams to build a strong understanding of the source data systems
- Leverage understanding of the source data systems to design and build conceptual, logical, and physical data models for the Data Warehouse, Data Marts, and MDM repositories
- Collaborate with analytics and business teams to architect and implement performant data solutions for Analytics and ML business use cases
- Design and lead the implementation of frameworks and best practices for data ingestion, data integration, and ETL processes
- Design and lead the implementation of data quality framework including data quality metrics and continuous data quality monitoring, assessment, and resolution
- Create business data catalog and/or data dictionaries to document data lineages, data definitions, and metadata for data domains
- Assist with establishing best practices and standards for data privacy and data security
- Work closely with data engineering, analytics, business, and offshore/onshore consulting teams to ensure alignment on architecture and design
- Provide technical oversight and mentor development teams
- Hands-on development to support DW and ETL initiatives
Requirements
- Bachelor's degree in a STEM discipline or related field
- 10+ years of relevant hands-on experience in data and analytics domain/teams
- Expert level proficiency in SQL
- 5+ years of demonstrated experience in building relational and dimensional data warehouse data models. Experience with Data Vault methodology would be a plus.
- 5+ years experience in data ingestion (batch, streaming, API, etc.) and data integration (ETL) development using Informatica, Talend, AWS Glue or similar.
- 3+ years experience working with cloud data warehousing platforms such as Snowflake, AWS Redshift, Databricks
- Familiarity with Python, Scala, SparkSQL, Airflow, Tableau, and AWS Sagemaker would be beneficial
- Strong understanding of source data systems and ability to design and build conceptual, logical, and physical data models
- Ability to architect and implement performant data solutions for analytics and machine learning use cases
- Experience in designing and leading the implementation of frameworks and best practices for data ingestion, data integration, and ETL processes
- Knowledge of data quality frameworks and ability to establish data quality metrics and continuous monitoring processes
- Familiarity with data privacy and data security best practices
- Ability to collaborate with cross-functional teams and provide technical oversight and mentorship to development teams
- Hands-on development experience in data warehousing and ETL initiatives.
Benefits
- Inclusive culture where everyone has a voice and the best idea wins
- Opportunity to work with world-class product leaders and engineers
- Building an ecosystem of technologies at the intersection of parking, mobility, and real estate
- Hybrid working environment (3 days in office per week)
- Anticipated base salary of $180,000.00 to $220,000.00 annually
- Access to or eligibility for healthcare benefits
- 401(k) plan
- Short-term and long-term disability coverage
- Basic life insurance
- Lucrative stock option plan
- Bonus plans