Senior Analytics Engineer

Metropolis; Seattle (WA); On-site; USD 130,000 - 175,000; Full time

Benefits offered by this job

Health benefits

401(k) plan

Stock options

Bonus plans

Job summary

A leading tech firm in Seattle seeks a Senior Analytics Engineer to join its Data Engineering and Analytics team. The role involves designing large-scale data warehouses with a focus on accessibility and actionable insights while leveraging SQL and dbt for data transformation. Candidates should have over five years of experience in analytics engineering with strong skills in SQL and Python. The position requires a collaborative approach across teams and a commitment to data quality. Competitive salary and benefits offered.

Qualifications

• 5+ years of experience in data/analytics engineering with proficiency in Python and SQL.
• 3+ years of experience with dbt.
• Expert in SQL with experience in window functions and performance optimization.
• Led large-scale data projects and designed data warehouses.
• Experience mentoring stakeholders on data best practices.

Responsibilities

• Design and implement large-scale data warehouses and data marts.
• Build and maintain data transformation pipelines using SQL frameworks.
• Write complex SQL and manage DAGs for task optimization.
• Implement metadata management and ensure data quality.
• Mentor others on data best practices and drive technical excellence.

Skills

Data/analytics engineering

SQL

Python

dbt

Data project ownership

Cross-functional partnering

Data warehousing design

Query optimization

Data quality assurance

Tools

Snowflake

dbt

Job description

The real world is the next frontier, and at Metropolis, we are creating the artificial intelligence to make it responsive. We are pioneering the Recognition Economy — a future where mundane repetition disappears and being known unlocks access, comfort and belonging everywhere you go. From transforming parking into a seamless drive-in, drive-out experience for millions of Members to expanding our intelligence layer across retail and hospitality, we are building a world that feels instinctive and magical. The future isn’t coming; it’s here, and we need builders, innovators and problem solvers to help us create it.

Who you are

Metropolis is seeking a Senior Analytics Engineer to join our Data Engineering and Analytics team. The ideal candidate will possess a passion for creating value using data and a strong foundation in all aspects of analytics engineering. 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 and drive impact through your data vision and architecture.

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

4 Days in Office: Metropolis values in‑person collaboration to drive innovation, strengthen culture, and enhance the Member experience. Our corporate team members hold 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.

When you join Metropolis, you’ll join a team of world‑class product leaders and engineers, building an ecosystem of technologies at the intersection of parking, mobility, and real estate. Our goal is to build an inclusive culture where everyone has a voice and the best idea wins. The anticipated base salary for this position is $130,000.00 USD to $175,000.00 USD annually. 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.

Metropolis Technologies is an equal opportunity employer. We make all hiring decisions based on merit, qualifications, and business needs, without regard to race, color, religion, sex (including gender identity, sexual orientation, or pregnancy), national origin, disability, veteran status, or any other protected characteristic under federal, state, or local law.