Senior Analytics Engineer

What you'll do

• Design and maintain reusable analytics models, metrics, access controls, tests, documentation, and Lightdash agent guidance.
• Work with stakeholders to define requirements, validate results, and publish production data products; reconcile conflicting source-system concepts and surface mappings and quality checks.
• Diagnose incorrect or stale results, review modeling changes, and collaborate with data engineering and teammates on shared standards.

What they ask for

• 5+ years of analytics engineering or equivalent experience, including contribution to a production dbt project with tests, CI, incremental models, and documentation.
• Strong dimensional modeling judgment, including designing conformed entities and facts at the correct grain and resolving conflicting source definitions.
• Experience delivering a metrics or semantic layer used by people and tools, with safe access controls for sensitive data.
• Strong SQL, enough Python to understand existing pipelines and build transformation tasks, and regular use of AI coding agents with verification of their output.

Nice to have

• Experience with Lightdash or another semantic layer managed as code.
• AWS knowledge and familiarity with Athena, Iceberg, and Spark.

Pay

$175,000 to $215,000 per year (base salary)

Tools

dbt, SQL, Python, Lightdash, AWS, Athena, Iceberg, Spark

AI focus

Use AI coding agents regularly, verify their output, and provide guidance for Lightdash AI agents to answer questions correctly.