Senior Analytics Engineer

United KingdomFull-TimeSenior

Salary not disclosed

Apply NowOpens the employer's application page

Job Details

Experience: 3+ years
Required Skills: SQLApache AirflowArtificial IntelligenceSnowflakeCI/CDBigQuerydbtGitHubGitLab

3+ years of highly technical experience with dbt and SQL
Write DRY, optimised code, build macros, manage dbt packages, and troubleshoot performance bottlenecks
Strong hands-on experience with AWS Redshift (or a similar cloud warehouse like Snowflake/BigQuery)
Solid understanding of query optimisation and warehouse architecture
Familiarity with DAG structures and how the transformation layer interfaces with orchestration tools like Apache Airflow or similar
Experience mentoring or supporting more junior data team members
Comfort partnering with non-technical stakeholders across Product, Commercial, and Ops to understand data needs and translate them into well-structured solutions
Ability to proactively flag data quality or architectural issues and suggest improvements
Solid experience working with the code-first backend of modern BI tools (ideally Lightdash & Count, or similar)
Good understanding of Semantic Layer concepts
Genuine interest in engineering efficiency
Experience or appetite to build experience using AI and automation tools, scripting, and workflows to reduce repetitive manual work within a data function

Play a key role in the Analytics Engineering function and dbt environment
Build and maintain scalable data models from the staging layer through to the "Golden Layer," with a focus on performance and reliability on AWS Redshift
Serve as a technical data partner for Product, Operations, Commercial, and other business functions
Translate business requirements into robust data models and ensure cross-functional teams have the reliable data foundations they need
Work closely with the Lead Data Engineer and Analytics Lead to contribute to the overall data strategy
Support the growth of more junior team members through code reviews, knowledge sharing, and day-to-day guidance
Contribute to the code-based backend of our BI environment (Lightdash & Count)
Support the development and maintenance of the Semantic Layer and assisting in the integration of AI capabilities (e.g text-to-SQL) to advance self-serve analytics
Actively champion software engineering best practices within the data team, including Gitlab/GitHub workflows, CI/CD pipelines, testing frameworks, and documentation-as-code
Contribute to the development of automations and AI capabilities within the Analytics Engineering function

View Full Description & ApplyYou'll be redirected to the employer's site