Senior Analytics Engineer
Metropolis is seeking a Senior Analytics Engineer to join our Data Engineering and Analytics team. In this pivotal role, you will be instrumental in making data accessible and actionable, facilitating informed decision-making throughout the company. You will partner and lead across multiple product team functions and domains, driving impact through your data vision and architecture.
Key responsibilities include designing and implementing large-scale data warehouses and data marts using Snowflake, Star, or Data Vault 2.0 schemas. You will build and maintain data transformation pipelines using SQL frameworks like dbt, write complex SQL queries adhering to performance best practices, and manage and optimize DAGs, including troubleshooting task failures and improving run times. Additionally, you will implement metadata management, data lineage, and security principles such as least-privilege access, and use a test-driven approach to design systems that trap poor quality data and trigger alerts within the data flow.
The ideal candidate will have over 5 years of experience in data/analytics engineering with proficiency in Python and SQL within Snowflake, and at least 3 years of experience with dbt. You should have a proven track record of leading large-scale data projects that drove significant impact through effective cross-functional partnering. Expertise in SQL, window functions, and query optimization for complex data manipulations is essential, along with experience in designing systems using test-driven approaches to ensure data quality and flow integrity. Familiarity with ELT processes and tools to prepare and clean data for analysis, and skill in using tools like dbt to build data transformation pipelines are also required.
Metropolis values in-person collaboration to drive innovation, strengthen culture, and enhance the Member experience. Our corporate team members adhere to our office-first model, which requires employees to be on-site at least four days a week, fostering organic interactions that spark creativity and connection. The anticipated base salary for this position is $130,000.00 USD to $175,000.00 USD annually. The actual base salary offered is determined by a number of variables, including the applicant's qualifications for the position, years of relevant experience, distinctive skills, level of education attained, certifications or other professional licenses held, and the location of residence and/or place of employment. Base salary is one component of Metropolis's total compensation package, which may also include access to or eligibility for healthcare benefits, a 401(k) plan, short-term and long-term disability coverage, basic life insurance, a lucrative stock option plan, bonus plans, and more.
When you join Metropolis, you'll become part of a team of world-class product leaders and engineers, building an ecosystem of technologies at the intersection of parking, mobility, and real estate. Our goal is to build an inclusive culture where everyone has a voice and the best idea wins. You will play a key role in building and maintaining this culture as our organization grows.