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 cross-functional expertise with cutting-edge 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 Risk Data Engineer creates the data foundation that powers risk intelligence across the enterprise by integrating fragmented systems, building 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 architect and implement data solutions using Microsoft Fabric that connect 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 focuses on designing and maintaining robust data infrastructure using Microsoft Fabric's medallion architecture, implementing data pipelines and transformation workflows, and establishing data governance frameworks 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.
Primary Position Responsibilities
Data Infrastructure Development
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
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
Create unified data models and Power BI semantic models that enable cross-functional risk analytics, ensuring data consistency, accuracy, and accessibility across all risk functions
Develop and maintain data quality frameworks, validation rules, and monitoring processes that ensure leadership has reliable, credible risk intelligence
Establish and enforce data governance standards, security protocols, and access controls that protect sensitive risk information while enabling appropriate data sharing
Solution Delivery
Partner with Risk Analytics Developers, Risk Insights Architects, and Risk Data Scientists to understand data requirements and deliver datasets that power dashboards, reports, predictive models, and risk assessments
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 customers receive timely, accurate risk intelligence when decisions need to be made
Implement data observability and monitoring solutions that proactively identify and resolve data quality issues before they impact business decisions
Support migration and integration efforts as new risk technologies and platforms are adopted across the enterprise
Operational Excellence
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 central initiatives
Solve and resolve data quality issues, working with source system owners and business partners to implement sustainable fixes
Document data lineage, transformation logic, data dictionaries, and technical architecture to enable knowledge sharing and maintain institutional knowledge
Partner with Tech@Lilly (IT), risk platform administrators, and business data owners to identify and resolve data integration challenges
Process Ownership
Collaborate with risk data owners, assurance function partners, and enterprise data teams to see opportunities to improve data availability, quality, and integration
Drive standardization of data definitions, taxonomies, and integration patterns across risk functions to enable more effective multi-functional analytics
Support the upskilling of IRM team members and business partners in data engineering concepts, contributing to data literacy across the organization
Stay ahead of on emerging data engineering technologies, practices, and tools, applying relevant innovations to enhance Lilly's risk data capabilities
Basic Qualifications/Requirements
Bachelor's Degree in Computer Science, Information Systems, Data Engineering, or related field.
3+ years of relevant professional experience in data engineering, ETL development, or data integration
Strong proficiency with Microsoft Fabric or similar cloud data platforms (Azure Data Factory, Synapse Analytics, Databricks)
Advanced SQL skills and experience with both relational and non-relational database technologies
Experience designing and implementing ETL processes and data pipelines
Demonstrated ability to translate business requirements into technical data solutions
Understanding of Power BI data modeling and semantic model design
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.
Additional Skills/Preferences
Hands-on experience with Microsoft Fabric components including Data Factory, Synapse Data Engineering, Data Warehouse, Lakehouse, and Dataflows Gen2
Experience implementing medallion architecture or similar layered data lake design patterns
Knowledge of Power BI semantic models, DirectLake, and optimizing datasets for analytical performance
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 diagnose and resolve sophisticated data integration challenges
Excellent collaboration skills with both technical teams and non-technical business stakeholders
Detail-oriented with commitment to data quality and comprehensive documentation
Self-starter who works independently and proactively identifies opportunities for improvement
Demonstrated strong motivation, rapid learning agility, and growth mindset
Travel
Up to 5-10% travel based on business needs
Lilly is dedicated to helping individuals with disabilities to actively engage in the workforce, ensuring equal opportunities when vying for positions. If you require accommodation to submit a resume for a position at Lilly, please complete the accommodation request form ( https://careers.lilly.com/us/en/workplace-accommodation ) for further assistance. Please note this is for individuals to request an accommodation as part of the application process and any other correspondence will not receive a response.
Lilly is proud to be an EEO Employer and does not discriminate on the basis of age, race, color, religion, gender identity, sex, gender expression, sexual orientation, genetic information, ancestry, national origin, protected veteran status, disability, or any other legally protected status.
Our employee resource groups (ERGs) offer strong support networks for their members and are open to all employees. Our current groups include: Africa, Middle East, Central Asia Network, Black Employees at Lilly, Chinese Culture Network, Japanese International Leadership Network (JILN), Lilly India Network, Organization of Latinx at Lilly (OLA), PRIDE (LGBTQ+ Allies), Veterans Leadership Network (VLN), Women's Initiative for Leading at Lilly (WILL), enAble (for people with disabilities). Learn more about all of our groups.
Actual compensation will depend on a candidate's education, experience, skills, and geographic location. The anticipated wage for this position is
$64,500 - $151,800
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).Lilly reserves the right to amend, modify, or terminate its compensation and benefit programs in its sole discretion and Lilly's compensation practices and guidelines will apply regarding the details of any promotion or transfer of Lilly employees.
WeAreLilly
