Associate Director - Integrated Risk Data Engineer

Lilly•Indianapolis, IN

About The Position

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 give our best effort to our work, and we put people first. We’re looking for people who are determined to make life better for people around the world. Integrated Risk Management Program Overview Lilly's Integrated Risk Management (IRM) program is a strategic enterprise initiative that transforms traditional risk management into a competitive advantage by uniting multi-functional expertise with pioneering analytics and technology. IRM enables faster, better informed decision-making that protects what matters most: our operations, reputation, and 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 than ever before. Position Description The Integrated Risk Data Engineer serves as the technical expert who is 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 ServiceNow 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. Balancing hands-on delivery with standards definition and technical leadership, 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.

Requirements

Bachelor's Degree in Computer Science, Information Systems, Data Engineering, or related field
5+ years of relevant professional experience in data engineering, ETL development, or data integration, with demonstrated progression in responsibility and complexity
Qualified applicants must be authorized to work in the United States on a full-time basis. Lilly will not provide support for or sponsor work authorization and/or visas for this role.
Sophisticated SQL skills and deep experience with both relational and non-relational database technologies
Demonstrated experience independently leading data engineering projects from planning through delivery, including architecture design and standards definition
Demonstrated ability to translate sophisticated business requirements into scalable technical data solutions with sound decision-making within functional guidelines
Solid understanding of Power BI data modeling, semantic model design, and optimizing datasets for analytical performance
Expert proficiency with Microsoft Fabric (preferred) or similar cloud data platforms (Azure Data Factory, Synapse Analytics, Databricks), with ability to define architecture standards and guidelines
Hands-on experience with Microsoft Fabric components including Data Factory, Synapse Data Engineering, Data Warehouse, Lakehouse, and Dataflows Gen2
Experience designing and implementing medallion architecture or similar layered data lake design patterns at enterprise scale
Experience with ServiceNow platform, ServiceNow GRC, or other governance, risk, and compliance systems
Proficiency in dimensional modeling, star schema design, and data warehouse concepts
Experience in pharmaceutical, healthcare, or highly regulated industries with complex data governance requirements
Background in risk management, audit, compliance, or assurance domain data
Familiarity with Power Platform integration (Power Automate, Power Apps) with Fabric
Strong problem-solving skills with ability to anticipate, diagnose, and resolve complex data integration challenges
Demonstrable ability to collaborate effectively with both technical teams and non-technical business collaborators, translating technical concepts into business language
Diligent with commitment to data quality and comprehensive documentation
Self-directed professional who works independently, takes initiative on sophisticated problems, and proactively sees opportunities for improvement
Demonstrated strong motivation, rapid learning agility, and growth mindset

Responsibilities

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 ServiceNow GRC, SAP, Workday, SuccessFactors, 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 Lakehouses and Data Warehouses that support risk assessments, audits, investigations, and critical initiatives
Anticipate and resolve complex data quality issues, working with source system owners and business partners to implement sustainable fixes that prevent recurrence
Define and maintain comprehensive documentation standards for data lineage, transformation logic, data dictionaries, and technical architecture that enable knowledge sharing and maintain institutional knowledge
Build strategic relationships with Tech@Lilly (IT), risk platform administrators, and business data owners to identify and resolve data integration challenges that impact the broader IRM function
Strategic Partnership & Influence
Build and maintain strategic relationships with risk data owners, assurance function partners, and enterprise data teams to identify internal customer requirements and opportunities to improve data availability, quality, and integration
Lead standardization of data definitions, taxonomies, and integration patterns across risk functions, influencing technical decisions that enable more effective multi-functional analytics
Lead the upskilling of IRM team members and business partners in data engineering concepts, serving as an authority and contributing to data literacy across the organization
Know the latest on emerging data engineering technologies, practices, and tools, evaluating and applying relevant innovations to enhance Lilly's risk data capabilities

Benefits

Full-time equivalent employees also will be eligible for a company bonus (depending, in part, on company and individual performance).
In addition, Lilly offers a comprehensive benefit program to eligible employees, including eligibility to participate in a company-sponsored 401(k); pension; vacation benefits; eligibility for medical, dental, vision and prescription drug benefits; flexible benefits (e.g., healthcare and/or dependent day care flexible spending accounts); life insurance and death benefits; certain time off and leave of absence benefits; and well-being benefits (e.g., employee assistance program, fitness benefits, and employee clubs and activities).

Stand Out From the Crowd

Upload your resume and get instant feedback on how well it matches this job.

Upload and Match Resume