Senior Analytics Engineer
Metropolis is seeking a Senior Analytics Engineer to join our Data Engineering and Analytics team in New York, New York. 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 including window functions and STRUCT/ARRAY manipulations, and manage and optimize DAGs. 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 owning 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 is also required.
Metropolis values in-person collaboration to drive innovation, strengthen culture, and enhance the Member experience. Our corporate team members adhere to an 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, 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.