Lead Data Engineer

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%