Key skills
PythonSQLETLData EngineeringAnalyticsBISnowflakeBigQueryRedshiftAirflowdbtSaaSMentoring
About this role
Harnham is a fast-growing SaaS company seeking a Senior Analytics Engineer to join their data team. This role involves designing and building dimensional data models, developing dbt models, and implementing data quality checks to support strategic analytics across various metrics.
Responsibilities:
- Designing and building dimensional data models in Snowflake that underpin analytics across the business
- Developing and optimising dbt models to turn raw source data into clean, trusted datasets
- Partnering with analysts and business stakeholders to translate their needs into scalable data solutions
- Implementing data quality checks and owning the reliability of analytics datasets
- Contributing to data governance including PII handling, metadata management, and documentation
- Supporting strategic analytics across customer journeys, revenue metrics, and product usage
- Mentoring junior team members and championing best practices
Requirements:
- 5+ years in analytics engineering, data engineering, or a similar data-focused role
- Expert-level SQL: complex queries, CTEs, window functions
- Strong hands-on dbt experience
- Snowflake (or equivalent cloud warehouse: BigQuery, Redshift)
- Solid understanding of dimensional modelling and data warehouse design patterns
- Experience with SaaS metrics: MRR, churn, CLV etc
- Python for data work or automation
- Familiarity with data orchestration tools (Airflow / MWAA)
- Comfortable working remotely and cross-functionally with distributed teams
- Experience with reverse ETL tools such as Hightouch
- Exposure to BI tools (Hex preferred)
- Understanding of data mesh or domain-oriented architecture concepts