Lead Data Engineer

About the job

Work Flexibility: Hybrid

What you will do

- Design, build, and maintain automation solutions (primarily Power Automate ) to reduce manual effort in evidence workflows.

- Implement and maintain REST API integrations to connect systems (e.g., DistillerSR, SharePoint, Power BI) and enable seamless, scheduled data flow.

- Develop reusable, scalable data pipelines and processes (automated extract → store → refresh cycles).

- Operationalize agreed data structures; migrate and maintain structured evidence data into controlled, analytics-ready datasets.

- Implement processes to monitor data quality, keeping data accurate, traceable, and available for stakeholders.

- Build and maintain Power BI dashboards from CDS-managed datasets to enable scalable reporting and evidence visibility.

- Enable self-service analytics so stakeholders can access insights without ad-hoc requests.

- Explore and implement AI-enabled solutions (e.g., agents that transform unstructured clinical report content into structured data).

- Identify and eliminate manual, repetitive work; document and maintain solutions across updates.

- Help build repeatable ways of working — shared methods, templates, and clear documentation — so solutions are easy to maintain and reuse across teams and time zones.

What you need Basic Qualifications

- Bachelor's degree in a technical or quantitative field (e.g., computer science, data/software engineering, information systems, mathematics, physics, or related).

- Approximately 6–8+ years of relevant experience in an IT, data engineering, automation, BI, or systems-/business-analytics role.

- Strong hands-on Power Automate skills, including calling REST APIs from Power Automate .

- Demonstrated experience building REST API integrations between systems.

- Proficiency in at least one scripting/programming language, ideally Python .

- Working knowledge of SQL and core relational data concepts.

- Ability to translate technical concepts for non-technical stakeholders and to collaborate effectively across time zones.

Preferred Qualifications

- Broader Microsoft Power Platform experience (Power Apps) and relevant certifications (Microsoft, AWS, Google, IBM).

- Python with PySpark ; exposure to Azure, Databricks, or Microsoft Fabric (data flows / notebooks).

- Power BI dashboard development.

- Data modeling and experience building/optimizing data pipelines and architectures.

- Experience with tools/sources such as SharePoint, Oracle, SQL Server, DB2.

- Prior experience delivering technical solutions in a regulated environment (medical device, pharma, CRO) or with clinical IT systems such as DistillerSR .

Travel Percentage: 10%