Senior Analytics Engineer

Mistral Data

Mistral Data, a part of FirstGroup, is a leading transport operator in the UK, focusing on sustainable and efficient travel solutions. They are looking to hire a Senior Analytics Engineer to design and develop data-driven solutions. With a primary focus on AWS and big data platforms, this role offers the chance to work on impactful train service performance projects and beyond.

In this role you can expect to have the responsibilities:

• Design and develop comprehensive BI solutions.
• Collaborate with stakeholders and users to gather requirements.
• Ensure compatibility with necessary analytics tools.
• Create analytical dashboards as per user needs.
• Provide documentation and consulting to support database queries.
• Identify and solve performance and data quality issues proactively.
• Maintain data integrity within the platforms.
• Develop and secure interfaces with IT colleagues.
• Manage third-party relations to ensure SLA compliance.
• Enhance platform security by addressing new threats.

This role comes with the following benefits:

• An inclusive work environment celebrating diversity.
• Opportunities for growth across various projects.
• Encouragement of flexible working options.

This role requires you to have:

• Expertise in SQL and database design.
• Proficiency in Business Intelligence data modeling.
• Experience with AWS cloud computing technologies.
• Knowledge of cloud data warehouses: Redshift, Snowflake, etc.
• Strong Python coding skills.
• Familiarity with data visualization tools like Power BI.

You would benefit from having:

• Experience with Amazon Redshift.
• Knowledge of statistical and data science tools.
• Service management expertise.
• Understanding of train operational data.
• Experience in AGILE and sprint planning.

Mistral Data is committed to inclusivity, valuing diversity, and providing equal opportunities. They offer support for candidates with disabilities or neurodivergent conditions to ensure a fair recruitment process.