Lorien
Analytics Engineer
Get notified of more jobs like this · No spam, ever
How your CV stacks up
Upload your CV to see how well it fits this job role
?%
Analytics Engineer
12-Month Contract | Inside IR35 | 2 Days Onsite at Heathrow
We're looking for an experienced Analytics Engineer to join a high-profile transformation programme, operating at the intersection of data engineering, analytics, and AI-enabled decision making.
This is a fantastic opportunity for someone who enjoys turning complex business challenges into scalable, trusted, and reusable data products. You'll play a key role in defining and building a governed semantic layer that enables self-service analytics, reporting, applications, and AI-driven solutions.
Key Responsibilities
- Translate business requirements into well-structured data models, including conformed dimensions, facts, and metric definitions.
- Design, build, and maintain transformation pipelines using dbt and Snowflake, orchestrated through Airflow.
- Create and manage semantic models and metrics layers to ensure consistent reporting and analytics across the organisation.
- Partner closely with business stakeholders to understand decision-making requirements and deliver data products that support self-service analytics.
- Develop clean, governed datasets that can be reliably consumed by both users and AI/LLM-powered applications.
- Migrate legacy reporting and embedded business logic into a centralised, governed data layer.
- Champion analytics engineering best practices including testing, documentation, version control, and CI/CD.
- Drive standards around data modelling, naming conventions, metrics management, and governance.
- Mentor and support analysts and engineers in modern analytics engineering practices.
Reasons to use Rodeo
Start with a chat, not a search bar
Grad scheme, placement, apprenticeship? Not sure what you want yet — that's fine. Your agent talks it through with you and turns "I have no idea" into a shortlist.
It searches the market for you
Every day your agent scans the market matching roles against what actually matters to you, not just keywords on a CV.
Only hits
No noise. No "maybe this fits." Just roles with a clear explanation of why they're right — and where to focus when applying.
Technical Environment
- Snowflake
- dbt
- Airflow
- AWS
- Semantic Layers / Metrics Frameworks
- Tableau / Power BI
- AI & LLM-enabled analytics solutions
Essential Skills & Experience
- Advanced SQL skills with strong expertise in dimensional/Kimball modelling techniques.
- Hands-on experience building and maintaining dbt models within Snowflake environments.
- Experience orchestrating data pipelines using Airflow or similar workflow tools.
- Proven experience creating semantic layers and metric models (e.g. dbt Semantic Layer, MetricFlow, Cube, LookML, AtScale, or similar).
- Strong background delivering self-service analytics solutions.
- Experience designing data products and models for AI/LLM consumption.
- Regular use of AI-assisted development tools within engineering workflows.
- Strong understanding of testing, Git-based version control, and CI/CD practices.
- Proven ability to engage with stakeholders and translate business requirements into scalable data solutions.
Get help with your application
Your very own career expert that helps elevate your application to the next level.
Desirable Experience
- Tableau and/or Power BI.
- Experience supporting data consumption through applications and AI agents.
- Data governance, cataloguing, and lineage tooling.
- AWS cloud technologies.
- Experience within operations, engineering, transport, or aviation environment
If you're an Analytics Engineer who enjoys combining robust data modelling, modern cloud technologies, and AI-driven data solutions, we'd love to hear from you.
Please apply with your latest CV for immediate consideration.
“It took my CV and asked me questions relevant to understanding what kind of jobs to suggest for me. Suggestions were almost perfect. Jobs were exactly what I’ve been looking for.”
Jessica, London
Location