Lead Data Engineer

Location: Gurugram, India

Time Type: Full time

Job Description

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%