Data & Automation Engineer

Rosemont Pharmaceuticals; Leeds; Hybrid; GBP 60,000 - 90,000; Full time

Benefits offered by this job

Healthcare Cash Plan

3% Employee / 5% Company Pension

26 Days Annual Leave + Bank Holidays

Flexible Working

Free On-Site Parking

Rosemont Rewards Platform

Job summary

Rosemont Pharmaceuticals is seeking a Data & Automation Engineer to join the Group IT team in Leeds. The role focuses on turning architectural thinking into production-ready data pipelines, automation, and AI-assisted development.

You will work with Microsoft Fabric, Python, SQL and Power BI to deliver scalable data solutions, while maintaining governance and security in a regulated pharmaceutical environment. The position requires in-office attendance in Leeds at least twice weekly.

Qualifications

• Hands-on experience with Microsoft Fabric, including Lakehouse, Pipelines, Notebooks and Semantic Models.
• Strong data engineering skills across Python, SQL/T-SQL, ETL/ELT and API integration.
• Practical experience with Medallion Architecture and data modelling, applied when building and maintaining data pipelines.
• Strong Power BI skills, with Power Automate and Power Apps useful supporting capabilities.
• Experience actively using AI coding tools to accelerate development.
• Experience using Git/Azure DevOps and controlled deployment processes.

Responsibilities

• Design, build and operate data pipelines in Microsoft Fabric, using Medallion Architecture across Bronze, Silver and Gold layers.
• Develop scalable ETL/ELT solutions using Python and SQL, with data modelling and API integrations.
• Build and enhance Power BI reports and dashboards across data and visualization layers.
• Deliver automation and integration solutions using Fabric, Python, Power Automate and Power Platform.
• Support AI-driven automation for R&D, regulatory reporting and operations.
• Ensure documentation, traceability, security and controlled deployment in a regulated environment.

Skills

Microsoft Fabric

Python

SQL

Power BI

Azure DevOps

Git

AI tools

Tools

Microsoft Fabric

Azure DevOps

Power Automate

Power Platform

Job description

For over 50 years, Rosemont Pharmaceuticals has been a trusted name in the development and manufacture of oral liquid medicines. With a portfolio of over 130 products - including 70 licensed medicines - we’re proud to support healthcare professionals and patients, especially those with swallowing difficulties.

Our purpose is clear: to improve patient outcomes through innovation in liquid formulations. We’re highly respected across the pharmaceutical industry and have played a key role in establishing best practices for dysphagia care.

Our mission is to create a globally connected, people-focused organisation where every individual is empowered to thrive and achieve their best. If you're passionate about making a meaningful impact to patients across the world and want to be part of a company with a strong heritage and ambitious vision, we’d love to hear from you.

The Role

We’re looking for a Data & Automation Engineer to join our Group IT team and help turn great architectural thinking into working, production-ready solutions.

This is a hands-on engineering role with an AI-first approach to development. You’ll use modern AI tools to accelerate the creation of data pipelines, integrations and automation, while applying your own engineering judgement to validate, test and productionise the results.

Working closely with our Data & Solutions Architect, you’ll have the opportunity to build solutions across Microsoft Fabric, Power BI, Python, SQL and automation technologies, helping us deliver better data and insight across the organisation.

This is a hybrid position so the successful candidate will be required to attend the Leeds office at least twice a week.

What You’ll Be Doing

• Design, build and operate data pipelines in Microsoft Fabric, using Medallion Architecture across Bronze, Silver and Gold layers.
• Work hands-on with Lakehouses, Pipelines, Notebooks and Semantic Models as part of our modern data platform.
• Develop scalable ETL/ELT solutions using Python and SQL, with data modelling and API integrations, transforming source data into reliable, production-ready datasets.
• Build and enhance Power BI reports and dashboards, working across both the data and visualisation layers.
• Deliver automation and integration solutions using Fabric, Python and, where appropriate, Power Automate and Power Platform. Support and troubleshoot existing internally built solutions, including Power Apps and Power Automate.
• Use AI development tools to rapidly prototype and accelerate engineering, while retaining ownership for testing, quality and production readiness. Support and prototype AI-driven automation for R&D, regulatory reporting and operations.
• Build solutions suitable for a regulated pharmaceutical environment, with strong documentation, traceability, security, testing standards and controlled deployment practices.
• Use Git and Azure DevOps to support source control, pull requests and controlled release pipelines, following Rosemont’s evidence-management standards.
• Work with business stakeholders and managed services partners to understand requirements and deliver and support solutions.

What We’re Looking For

We’re particularly interested in demonstrated capability, engineering judgement and your ability to deliver solutions end-to-end. Years of experience are a guide rather than a filter.

Ideally, you’ll bring:

• Hands-on experience with Microsoft Fabric, including Lakehouse, Pipelines, Notebooks and Semantic Models.
• Strong data engineering skills across Python, SQL/T-SQL, ETL/ELT and API integration.
• Practical experience with Medallion Architecture and data modelling, applied when building and maintaining data pipelines.
• Strong Power BI skills, with Power Automate and Power Apps useful supporting capabilities.
• Experience actively using AI coding tools such as Microsoft Copilot, GitHub Copilot, Claude or Cursor to accelerate development.
• Experience using Git/Azure DevOps and working through controlled Dev, QA and Production deployment processes.
• The engineering judgement to assess AI-generated outputs critically rather than simply accepting them.
• A structured, logical approach and the confidence to take ownership from requirements through to production.
• Experience with SAP S/4HANA, working in a regulated environment, or DP-600/DP-700 certification would be advantageous, but isn’t essential. Practical capability matters more to us.

At Rosemont, we believe great benefits go beyond salary. That’s why our offering is shaped by what our people truly value:

Healthcare Cash Plan – Personal cover to support your health and wellbeing

3% Employee / 5% Company Pension Contribution – Helping you plan for the future

26 Days Annual Leave + Bank Holidays

Flexible Working – Including hybrid and flexible working hours available.

Free On-Site Parking – Convenient access to our Leeds facility

Rosemont Rewards Platform – Discounts, free perks, and wellbeing tools for all employees

We are committed to fostering an environment of enablement where our people can grow, develop their talents, and pursue meaningful career paths. By placing patients and customers at the heart of everything we do, we drive high performance through accountability, consistency, and a strong governance structure. We champion inclusion, community, and a rewarding employee experience - creating a culture that supports development, celebrates achievement, and empowers individuals to thrive.

Diversity & Inclusion is integral to our culture and reflecting the patients we serve. At Rosemont, we believe equal opportunity for all is fundamental to our company's values and all our applicants can expect fairness and transparency in our recruitment process.

Ready to Make an Impact?

If you’re excited by the opportunity to combine data engineering, automation and AI-assisted development in a role where you can see your work move from idea to production, we’d love to hear from you.