Data & Automation Engineer - #2193006

We Are Rosemont

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.

Benefits

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

Annual Bonus – Recognising your contribution to Rosemont.

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.

Apply today and help us build the data and automation capabilities that will support Rosemont’s next chapter!