Senior Analytics Engineer

Metropolis Metropolis · Vertical AI · Chicago, IL +5 · Data Engineering & Analytics

Metropolis is seeking a Senior Analytics Engineer to join their Data Engineering and Analytics team. The role involves designing and implementing large-scale data warehouses and data transformation pipelines using Snowflake and dbt, writing complex SQL, managing DAGs, and implementing metadata management and data lineage. The candidate will also mentor others on data best practices and provide architectural guidance.

What you'd actually do

  1. Design and implement large-scale data warehouses and data marts using Snowflake, Star, or Data Vault 2.0 schemas
  2. Build and maintain data transformation pipelines using SQL frameworks like dbt to abstract model code
  3. Write complex SQL including window functions and STRUCT/ARRAY manipulations while adhering to performance best practices
  4. Manage and optimize DAGs, including troubleshooting task failures and improving run times
  5. Implement metadata management, data lineage, and security principles such as least-privilege access

Skills

Required

  • Python
  • SQL
  • Snowflake
  • dbt
  • data warehousing
  • data modeling
  • ETL/ELT
  • performance optimization
  • data quality
  • metadata management
  • data lineage

Nice to have

  • dbt certification

What the JD emphasized

  • 5+ years of experience in data/analytics engineering
  • 3+ years of experience with dbt
  • Owned large-scale data projects
  • Led the design, implementation, and monitoring of data warehouses
  • Expert at SQL, window functions, and query optimization