AI-Driven Data & Automation Engineer — Hybrid Role

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

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.