Senior Analytics Engineer
Job Summary
As a Senior Analytics Engineer, you will design and maintain the data layer models powering business decisions. You will own the dbt project and Snowflake data assets while mentoring peers and collaborating across engineering and product teams. The role emphasizes modern, AI-assisted workflows to build reliable and documented analytical assets.
Responsibilities
- Design and maintain scalable dbt models
- Optimize Snowflake query performance and costs
- Define team modeling and documentation standards
- Mentor junior analytics engineers
- Implement AI-assisted development workflows
Required Skills
- 5+ years Analytics Engineering experience
- Expert dbt and Snowflake proficiency
- Advanced SQL and performance tuning
- Experience with BI tools (Looker/Tableau/Sigma)
- AI-assisted development workflow proficiency
Job Details
Responsibilities:
- Design, build, and maintain scalable dbt models following modular, layered architecture.
- Own model performance: optimize Snowflake queries, configure materializations (incremental, table, view) and clustering strategies.
- Evolve dbt best practices: testing coverage, documentation, and source freshness checks.
- Conduct code reviews for dbt PRs, establish modeling conventions, and contribute to the team’s analytics engineering playbook.
- Design Snowflake database and schema structures, manage roles and access controls, and optimize warehouse sizing.
- Monitor and reduce compute costs through query profiling, result caching, and warehouse auto-suspend policies.
- Partner with Data Platform/Engineering on ingestion pipelines, Snowpipe configurations, and external stage setups.
- Use Claude and other AI tools to accelerate model generation, documentation writing, SQL refactoring, and test creation.
- Champion AI-assisted workflows, sharing effective prompting patterns to improve team velocity.
- Partner with business stakeholders to translate requirements into robust data models.
- Guide and mentor Associate and mid-level Analytics Engineers through code reviews and pairing sessions.
Qualifications:
- 5+ years of experience in analytics engineering or data engineering.
- Expert-level dbt (Core or Cloud): layered modeling, advanced testing, macros, and CI/CD integration.
- Deep Snowflake expertise: query optimization, materialization strategies, and access control.
- Advanced SQL and performance tuning skills.
- Experience with BI semantic layers (Sigma, Looker, Tableau, or Power BI).
- Excellent documentation habits.
- Strong written and verbal communication skills.
- Hands-on experience with AI tools for development (query writing, debugging, code review).
- Proficiency in Python for data transformation or pipeline scripting.
- Experience with orchestration tools (Airflow, Dagster, or dbt Cloud jobs).