# Senior Analytics Engineer
**Company:** [Metropolis](https://hotfix.jobs/companies/metropolis)
**Location:** Los Angeles, CA
**Salary:** $130K-$175K
**Experience:** 5+ years
**Skills:** Snowflake, dbt, SQL, Python, Dags, Data Vault, Star Schema, ELT, Data Lineage, Window Functions
**Posted:** 2026-05-13
> Designs and implements large-scale data warehouses using Snowflake and dbt, builds transformation pipelines with complex SQL and Python, optimizes performance, ensures data quality, and mentors stakeholders. Requires 5+ years experience in data engineering.
## Job Description
## What you'll do

- Design and implement large-scale data warehouses and data marts using **Snowflake**, **Star**, or **Data Vault 2.0** schemas
- Build and maintain data transformation pipelines using **SQL** frameworks like **dbt** to abstract model code
- Write complex **SQL** including window functions and **STRUCT/ARRAY** manipulations while adhering to performance best practices
- Manage and optimize **DAGs**, including troubleshooting task failures and improving run times
- Implement metadata management, data lineage, and security principles such as least-privilege access
- Use a test-driven approach to design systems that trap poor quality data and trigger alerts within the data flow
- Partner with engineering, data science, and business stakeholders to own project scopes
- Mentor others on data best practices to drive impact through your data vision
- Provide architectural guidance to ensure data is accessible and actionable across the company
- Drive technical excellence within the data engineering and analytics domain

## What we're looking for

- **5+ years** of experience in data/analytics engineering with proficiency in **Python** and **SQL** within **Snowflake**
- **3+ years** of experience with **dbt**
- Owned large-scale data projects that drove significant impact through effective cross-functional partnering
- Led the design, implementation, and monitoring of data warehouses that enable clear product-focused insights
- Expert at **SQL**, window functions, and query optimization for complex data manipulations
- Applied performance best practices, including partitions, sort keys, and incremental modeling
- Designed 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
- Skill in using tools like **dbt** to build data transformation pipelines
- Experience mentoring stakeholders in Data Science, Analytics, PM, and Engineering on data best practices

## Nice to haves

- A **dbt** certification

**Compensation:** Base salary $130,000 - $175,000 USD annually, plus benefits including healthcare, 401(k), stock options, bonus plans.
**Apply:** https://hotfix.jobs/jobs/senior-analytics-engineer-at-metropolis-2696bbd6-559f-40b9-8acd-18f7e8573797
**Canonical:** https://hotfix.jobs/jobs/senior-analytics-engineer-at-metropolis-2696bbd6-559f-40b9-8acd-18f7e8573797