Associate Director - Integrated Risk Data Engineer

At Lilly, we unite caring with discovery to make life better for people around the world. We are a global healthcare leader headquartered in Indianapolis, Indiana. Our employees around the world work to discover and bring life-changing medicines to those who need them, improve the understanding and management of disease, and give back to our communities through philanthropy and volunteerism. We put people first and are looking for individuals determined to make life better for people around the world.

Integrated Risk Management (IRM) is a strategic enterprise initiative that transforms traditional risk management into a competitive advantage by uniting multi-functional expertise with analytics and technology. IRM enables faster, better informed decision-making that protects operations, reputation, and the ability to deliver life-saving medicines to patients. This integrated approach creates a coordinated and proactive system that helps Lilly stay resilient and agile as we continue reaching more patients.

The Integrated Risk Data Engineer serves as the technical expert responsible for the data foundation powering risk intelligence across the enterprise. This individual contributor role independently leads data architecture and engineering initiatives from conception through delivery, integrating fragmented systems, designing unified data pipelines, and ensuring risk leaders have access to complete, accurate, and timely risk data. Working within the centralized IRM Analytics team, you will define and implement the Microsoft Fabric architecture and data governance framework that connects disparate risk platforms, including Service Now GRC, assurance systems, enterprise applications, and business-specific tools, into cohesive data ecosystems that enable comprehensive risk visibility.

This role requires depth and breadth of expertise in data engineering, with recognized proficiency that positions you as a key technical resource within the IRM function. You will lead the design and maintenance of robust data infrastructure using Microsoft Fabric’s medallion architecture, lead data pipeline and transformation initiatives, and establish data governance standards that ensure data quality, security, and accessibility across all IRM functions.

You will transform how risk data flows through the organization—breaking down historical silos and creating analytics- and AI-ready datasets that enable advanced analytics, real-time monitoring, and predictive risk intelligence.

Data Architecture & Infrastructure Leadership

• Lead the Microsoft Fabric architecture for IRM, defining standards, design patterns, and procedures that ensure scalable, maintainable, and high-performing data infrastructure across the risk ecosystem
• Design, build, and maintain enterprise risk data pipelines using Microsoft Fabric with medallion architecture (bronze, silver, gold layers) that integrate data from multiple risk domains and enterprise systems
• Architect and implement data engineering workflows using Fabric Data Factory, Synapse Data Engineering (Spark notebooks), and Dataflows Gen2 to consolidate fragmented risk data from Service Now GRC, SAP, Workday, Success Factors, assurance platforms, and other enterprise and function-specific systems
• Design unified data models and Power BI semantic models that enable multi-functional risk analytics, ensuring data consistency, accuracy, and accessibility across all risk functions
• Establish and lead the data governance framework for IRM, including data quality standards, validation rules, supervising processes, security protocols, and access controls that protect critical risk information while enabling appropriate data sharing

Solution Delivery & Technical Excellence

• Serve as a key technical resource partnering with Analytics Developers, Architects, and Data Scientists to understand data requirements and deliver datasets that power dashboards, reports, predictive models, and risk assessments
• Architect and build scalable, automated data solutions using Fabric pipelines and dataflows that reduce manual data preparation efforts and enable real-time or near-real-time risk monitoring capabilities
• Optimize data pipeline performance using Fabric's compute resources and data storage options (Lakehouse, Data Warehouse) to ensure collaborators receive timely, accurate risk intelligence when decisions need to be made
• Design and implement data observability and monitoring solutions that proactively identify and resolve data quality issues before they impact business decisions
• Lead migration and integration initiatives as new risk technologies and platforms are adopted across the enterprise, independently owning project planning, solution architecture, and delivery

Operational Excellence & Standards Definition

• Independently respond to sophisticated data requests from risk functions, producing clean, well-documented datasets in Fabric Lake houses and Data Warehouses that…