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%