Data & Automation Engineer

Location: Leeds, United Kingdom

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

Key Responibilties

• 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.

About You

We are 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 will 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.