What are the responsibilities and job description for the Senior Analytics Engineer position at Harnham?
Senior Analytics Engineer
Location: Scottsdale, AZ (4 days/week onsite)
Role Overview:
A major environmental services enterprise is looking to hire a Senior Analytics Engineer to own data modeling standards and enable high‑impact analytics across the business. This is a high‑visibility role for someone who can partner with stakeholders, shape data architecture, and still write production‑quality code.
You will:
- Establish data modeling practices for analytical and operational use cases, including canonical and semantic models and a medallion‑style architecture.
- Lead a greenfield effort to design and implement new modeling standards from scratch.
- Work closely with domain experts and data engineers to translate business needs into scalable models, metrics, and data products.
- Act as the modeling expert and advisor across the broader engineering and analytics teams.
Time breakdown:
- 40% data modeling
- 30% core engineering (SQL/Snowflake/dbt, performance tuning, pipelines)
- 30% stakeholder interaction (requirements, prioritization, communication)
Requirements:
- 5–7 years in analytics or data engineering with expert‑level data modeling experience.
- Deep SQL skills for complex transformations, change tracking, and ensuring clean, well‑structured data.
- Strong experience with Snowflake (priority) and dbt, plus AWS data services.
- Excellent communication skills and ability to explain technical concepts to non‑technical partners and influence architecture decisions.
Nice to have:
- Python for automation and analytics engineering.
- Experience with Kinesis or Kafka.
- Familiarity with Copilot/agent tools for productivity and with SQL DBM and Lucid for schema and documentation.
Salary : $130,000 - $150,000