Analyst - Risk Data Engineer
Company: Eli Lilly and Company
Location: Indianapolis
Posted on: January 8, 2026
|
|
|
Job Description:
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
Keywords: Eli Lilly and Company, Greenwood , Analyst - Risk Data Engineer, IT / Software / Systems , Indianapolis, Indiana