Associate Director - Integrated Risk Data Engineer

Eli Lilly and Company • Us, IN

4d • Onsite

About The Position

The Integrated Risk Management (IRM) program at Lilly is a strategic initiative aimed at transforming traditional risk management into a competitive advantage. It achieves this by combining cross-functional expertise with advanced analytics and technology. The IRM program facilitates faster, more informed decision-making to protect Lilly's operations, reputation, and its ability to deliver life-saving medicines. This integrated approach fosters a coordinated and proactive system, enhancing Lilly's resilience and agility as it expands its reach to more patients globally. The Integrated Risk Data Engineer is a pivotal technical role within the centralized IRM Analytics team, responsible for the data foundation that powers enterprise-wide risk intelligence. This individual will lead data architecture and engineering initiatives from inception to completion, integrating disparate systems, developing unified data pipelines, and ensuring risk leaders have access to comprehensive, accurate, and timely risk data. The role involves defining and implementing the Microsoft Fabric architecture and data governance framework to connect various risk platforms, such as ServiceNow GRC, assurance systems, enterprise applications, and business-specific tools, into cohesive data ecosystems for enhanced risk visibility. This position requires deep expertise in data engineering, serving as a key technical resource within the IRM function. The role will own the design and maintenance of robust data infrastructure using Microsoft Fabric's medallion architecture, lead data pipeline and transformation efforts, and establish data governance standards for data quality, security, and accessibility across all IRM functions. The position balances hands-on delivery with standards definition and technical leadership, aiming to transform the flow of risk data within the organization, break down silos, and create analytics and AI-ready datasets for 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.
• Expert proficiency with Microsoft Fabric (preferred) or similar cloud data platforms (Azure Data Factory, Synapse Analytics, Databricks), with ability to define architecture standards and best practices.
• Advanced SQL and Python/PySpark skills, with hands-on experience building data pipelines in Spark notebook environments (Fabric, Databricks, or similar), using Git-based version control.
• Experience integrating LLM/API-based workflows (RAG, embeddings, enterprise LLM gateways), with interest or exposure to agentic tool-calling protocols such as MCP.
• Demonstrated experience independently leading data engineering projects from planning through delivery, including architecture design and standards definition.
• Demonstrated ability to translate complex business requirements into scalable technical data solutions with sound decision-making within functional guidelines.
• Strong understanding of Power BI data modeling, semantic model design, and optimizing datasets for analytical performance.
• 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.
• Strong problem-solving skills with ability to anticipate, diagnose, and resolve complex data integration challenges.
• Proven ability to collaborate effectively with both technical teams and non-technical business stakeholders, translating technical concepts into business language.
• Detail-oriented with commitment to data quality and comprehensive documentation.
• Self-directed professional who works independently, takes initiative on complex problems, and proactively identifies opportunities for improvement.
• Demonstrated strong motivation, rapid learning agility, and growth mindset.

Nice To Haves

• 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.

Responsibilities

• Own the Microsoft Fabric architecture for IRM, defining standards, design patterns, and best practices for 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 various systems including 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 cross-functional risk analytics, ensuring data consistency, accuracy, and accessibility across all risk functions.
• Establish and own the data governance framework for IRM, including data quality standards, validation rules, monitoring processes, security protocols, and access controls.
• Serve as a key technical resource partnering with Analytics Developers, Architects, and Data Scientists to deliver datasets for dashboards, reports, predictive models, and risk assessments.
• Architect and build scalable, automated data solutions using Fabric pipelines and dataflows to reduce manual data preparation and enable real-time or near-real-time risk monitoring.
• Optimize data pipeline performance using Fabric's compute resources and data storage options (Lakehouse, Data Warehouse) to ensure timely and accurate risk intelligence.
• Design and implement data observability and monitoring solutions to proactively identify and resolve data quality issues.
• Lead migration and integration initiatives as new risk technologies and platforms are adopted, owning project planning, solution architecture, and delivery.
• Independently respond to complex data requests from risk functions, producing clean, well-documented datasets in Fabric Lakehouses and Data Warehouses.
• Anticipate and resolve complex data quality issues, working with source system owners and business partners to implement sustainable fixes.
• Define and maintain comprehensive documentation standards for data lineage, transformation logic, data dictionaries, and technical architecture.
• Build strategic relationships with Tech@Lilly (IT), risk platform administrators, and business data owners to identify and resolve data integration challenges.
• Lead standardization of data definitions, taxonomies, and integration patterns across risk functions, influencing technical decisions.
• Lead the upskilling of IRM team members and business partners in data engineering concepts, serving as a subject matter expert.
• Stay current on emerging data engineering technologies, practices, and tools, evaluating and applying relevant innovations.

Benefits

• company bonus (depending, in part, on company and individual performance)
• 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
• well-being benefits (e.g., employee assistance program, fitness benefits, and employee clubs and activities)

What This Job Offers

• Job Type: Full-time
• Career Level: Senior