Skip to content
Metropolis

Senior Analytics Engineer

Designs and implements large-scale data warehouses and transformation pipelines using Snowflake, dbt, SQL, and Python. Partners cross-functionally to ensure data quality, accessibility, and impact; requires 5+ years experience.

130k – 175kSeattle, WAData EngineeringOnsite5+ YOE
Apply

About the role

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

While not required, these are a plus:

  • A dbt certification

Compensation: Anticipated base salary $130,000 - $175,000 USD annually, plus benefits including healthcare, 401(k), stock options, bonus plans.

Skills

SnowflakeSQLdbtPythonDagsData Vault 2.0Window FunctionsELTData LineageQuery Optimization

Similar roles

Data Engineering jobs
Metropolis

Senior Analytics Engineer

Designs and implements large-scale data warehouses and transformation pipelines using Snowflake and dbt. Partners cross-functionally to deliver actionable insights, mentors on data best practices, and ensures data quality and performance. Requires 5+ years experience with SQL/Python.

130k – 175kChicago, ILData EngineeringOn-site5+ YOEdbtSQL
Metropolis

Senior Analytics Engineer

Designs and builds large-scale data warehouses and transformation pipelines using Snowflake, dbt, SQL, and Python. Partners cross-functionally to deliver actionable insights, mentors on best practices, and ensures data quality and performance. Requires 5+ years experience.

130k – 175kNew York, NYData EngineeringOn-site5+ YOESQLdbt
Metropolis

Senior Analytics Engineer

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.

130k – 175kLos Angeles, CAData EngineeringOn-site5+ YOEdbtSQL
Metropolis

Senior Analytics Engineer

Designs and implements large-scale data warehouses and transformation pipelines using Snowflake, dbt, SQL, and Python. Partners cross-functionally to deliver actionable insights, mentors on best practices, and ensures data quality and performance. Requires 5+ years experience.

130k – 175kNashville, TNData EngineeringOn-site5+ YOESQLdbt
Apartment List

Senior Data Engineer

Senior Data Engineer responsible for designing, building, and operating scalable data pipelines and workflows using Airflow, BigQuery, and dbt to support analytics and decision-making.

126k – 180kUnited StatesData EngineeringRemote5+ YOEdbtETL