At a Glance
- Tasks: Design and maintain complex data models, manage ingestion pipelines, and optimise cloud data warehouse performance.
- Company: Join i6, a leader in aviation fuel management technology with a remote-first culture.
- Benefits: Enjoy 25 days annual leave, private healthcare, and a 5% pension contribution.
- Other info: Collaborative team environment with excellent career growth opportunities.
- Why this job: Make a real impact on sustainability while working with cutting-edge data technologies.
- Qualifications: 3-4+ years in Data Engineering, expert SQL skills, and dbt experience required.
The predicted salary is between 50000 - 65000 £ per year.
About us
i6 provides the world’s most advanced end-to-end Aviation fuel management technology - enabling operational efficiency, transparency, and sustainability for airlines, fuel service providers, and suppliers. Our cloud-based solutions digitise the entire aviation fuel lifecycle through real-time fuel inventory and into-plane management platforms, patented electronic refuelling technology, and advanced fuel analytics and insights. With the adoption of our technology, our customers have been able to reduce thousands of tonnes of CO2 and benefited from millions in cost savings. i6 Group is a remote first company, however we have offices in Manchester and Surrey for occasional team collaboration sessions. We are only able to consider applicants based in the UK.
Your new role
In your new role as an Analytics Engineer at i6 you will be responsible for designing, building, and maintaining complex data models using dbt (Jinja, Macros, Incremental strategies) and managing high-availability ingestion pipelines. You will focus on the "build" phase of the data lifecycle—implementing DataOps best practices, including CI/CD via GitHub Actions and automated testing frameworks. You will optimise warehouse performance (BigQuery/Snowflake) to support millions of rows of data and collaborate across teams to ensure data contracts are met and data quality is guaranteed before it reaches the end-user.
What you will do
- Own the Transformation Layer: Design, build, and maintain complex dbt models to power internal BI and external customer analytics.
- Pipeline Management: Manage and monitor data ingestion pipelines to ensure high availability and low latency.
- Performance Tuning: Optimise cloud data warehouse costs and query performance (clustering, partitioning) for sub-second response times.
- Data Quality & Testing: Build and maintain automated testing frameworks (dbt test, Great Expectations) to proactively catch data issues.
- DataOps: Maintain CI/CD pipelines (GitHub Actions) for data deployment, applying software engineering principles to data workflows.
- Collaboration: Partner with Data Analysts to provide clean models and work with the Data Engineering Lead on architectural infrastructure decisions.
- Technical Documentation: Document data models, macros, and transformation logic clearly to ensure team scalability.
Who you are
- 3-4+ years of experience in Data or Analytics Engineering.
- Expert SQL: Ability to write complex window functions, optimise joins, and debug query plans.
- dbt Expertise: Deep hands-on experience in production (snapshots, incremental models, custom generic tests, Jinja/Macros).
- Cloud Data Warehousing: Deep understanding of BigQuery or Snowflake, specifically clustering and partitioning strategies.
- Version Control: Expert-level comfort with Git, branching strategies, and Pull Request workflows.
- Orchestration: Experience with Airflow, Dagster, or similar tools.
- NoSQL Knowledge: Understanding of NoSQL structures and how to transform them into relational models.
- Data Contracts: Understanding of data contracts and their role in pipeline stability.
You will be a great fit for this role if in addition to the above you have the following:
- Experience with Google Cloud Platform (GCP) and its data services (BigQuery).
- Familiarity with Infrastructure-as-Code (Terraform).
- Experience with Containerization (Docker).
- Programming proficiency in Python for automation and data manipulation.
A bit more about us
We’ve recently raised our Series B funding. We are a remote first company with offices in Farnborough and Manchester. A number of our team are fully remote and some teams are primarily remote, typically meeting in the office once a month. We aim for all of the company to come together for a day once a quarter. Our benefits include: 25 days annual leave + your birthday day off, private healthcare and 5% pension contribution.
Analytics Engineer employer: i6 Group
i6 Group is an exceptional employer, offering a remote-first work culture that prioritises flexibility and collaboration. With offices in Manchester and Farnborough, employees enjoy the benefits of occasional team interactions while working towards meaningful sustainability goals in aviation fuel management. The company fosters professional growth through innovative projects, competitive benefits including 25 days of annual leave plus a birthday day off, private healthcare, and a 5% pension contribution, making it an attractive place for talented individuals seeking impactful careers.
StudySmarter Expert Advice🤫
We think this is how you could land Analytics Engineer
✨Get Involved in Data Science Meetups
Tap into local data science meetups or workshops to connect with fellow enthusiasts and professionals. These events are goldmines for networking, and sometimes even lead directly to job openings at companies like i6 Group!
✨Show Off Your Projects
Start building a public portfolio showcasing your data science projects on platforms like GitHub or personal websites. Highlight unique analyses or models you've developed. This not only demonstrates your skills but also gets your name out there for roles like Analytics Engineer at i6 Group.
✨Leverage Professional Networks
Join professional bodies related to data science, like the Data Science Society or similar organisations. Getting involved can lead to mentorship opportunities and insider knowledge about full-time positions at companies like i6 Group.
✨Apply Directly through Our Website
When you find a suitable opening like Analytics Engineer at i6 Group, make sure to apply directly through our website. It gives you an edge and shows you're keen to join our team. Plus, who doesn’t love a direct application? It’s easier than navigating through job boards!
We think you need these skills to ace Analytics Engineer
Some tips for your application 🫡
Show Off Your Projects:In the world of data science, your projects can speak volumes about your skills. Make sure to showcase a few key projects in your CV or portfolio, especially those that highlight your ability to work with data sets, build models, or use relevant tools like Python, R, or SQL. Don’t forget to include links to any GitHub repositories if applicable!
Quantify Your Achievements:Employers love numbers! When drafting your CV, highlight your achievements with quantifiable results. For instance, mention how your data analysis led to a certain percentage increase in efficiency or revenue at a previous job or project. These details can really make your application pop!
Craft a Tailored Cover Letter:For a full-time role at i6 Group, your cover letter should reflect your passion for data science and your excitement about the specific projects or values of the company. Dive into why you’re a good fit, how your skills align with their needs, and any unique perspectives you can bring to the team.
Stand Out with Relevant Courses and Certifications:Although experience talks, relevant courses or certifications can be your ticket to impressing hiring managers at i6 Group. Mention any standout courses you've completed that equipped you with essential skills, such as machine learning certifications or data visualisation courses. This shows your commitment to continuously developing your skills in the field!
How to prepare for a job interview at i6 Group
✨Brush Up on Your Statistics
For a data science role, we need to seriously sharpen our statistics skills. Get ready to tackle technical questions on probability distributions, hypothesis testing, and regression analysis. These are often the bread and butter of data science interviews, so don't just skim over them!
✨Showcase Your Projects
Prepare a killer portfolio showcasing your data science projects. We should include details about the datasets used, the tools and techniques applied, and the impact of your findings. If we can walk them through a particularly challenging project or a cool visualisation that had real-world implications, it’ll really make us stand out!
✨Get Comfortable with Python and R
Most data science positions require us to be proficient in programming languages like Python and R. We should practice common libraries like pandas, NumPy, and scikit-learn, and be ready for live coding exercises or algorithm questions. Showing off our coding chops can really impress the interviewers at i6 Group!
✨Prepare for Case Studies
Expect to encounter real-world case studies during the interview. We might be asked how we’d approach a data problem or analyse a dataset to extract insights. It's essential to think out loud and demonstrate our problem-solving process so that the interviewer can see our logical thinking in action.
