Senior Analytics Engineer

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

Senior Analytics Engineer role focused on designing and implementing large-scale data warehouses and data transformation pipelines using Snowflake and dbt. Responsibilities include writing complex SQL, managing DAGs, implementing metadata management and security, and ensuring data quality through testing. The role also involves mentoring and providing 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 transformation pipelines
  • window functions
  • query optimization
  • performance best practices
  • ELT processes
  • data quality
  • data lineage
  • security principles

Nice to have

  • dbt certification