AtLilly,theworkisdemandingbecausepatientsarewaiting.Weunitecaringwithdiscoverytohelpmakelifebetterforpeoplearoundtheworld,knowingthateverydecision,everydetail,andeverydaymatters.HeadquarteredinIndianapolis,Indiana,ourover50,000employeesaroundtheglobaltakeoncomplexchallengestodiscoveranddeliverlife-changingmedicines,strengthenhowhealthisunderstoodandmanaged,andsupportthecommunitiesweserve.Thisishard,urgent,selflesswork—butit’sworkworthdoing.Ifyou’redrivenbypurposeandreadytobringyourbesttoworkthattrulymattersforpatients,weinviteyoutojoinus.
Integrated Risk Management Program Overview
Lilly'sIntegratedRiskManagement(IRM)programisastrategicenterpriseinitiativethattransformstraditionalriskmanagementintoacompetitiveadvantagebyunitingcross-functionalexpertisewithcutting-edgeanalyticsandtechnology.IRMenablesfaster,betterinformeddecision-makingthatprotectswhatmattersmost:ouroperations,reputation,andabilitytodeliverlife-savingmedicinestopatients.ThisintegratedapproachcreatesacoordinatedandproactivesystemthathelpsLillystayresilientandagileaswecontinuereachingmorepatientsthaneverbefore.
Position Description
TheIntegratedRiskDataEngineerservesasthetechnicalexpertwhoownsthedatafoundationpoweringriskintelligenceacrosstheenterprise.Thisroleindependentlyleadsdataarchitectureandengineeringinitiativesfromconceptionthroughdelivery,integratingfragmentedsystems,designingunifieddatapipelines,andensuringriskleadershaveaccesstocomplete,accurate,andtimelyriskdata.WorkingwithinthecentralizedIRMAnalyticsteam,youwilldefineandimplementtheMicrosoftFabricarchitectureanddatagovernanceframeworkthatconnectsdisparateriskplatforms,includingServiceNowGRC,assurancesystems,enterpriseapplications,andbusiness-specifictools,intocohesivedataecosystemsthatenablecomprehensiveriskvisibility.Thisrolerequiresdepthandbreadthofexpertiseindataengineering,withrecognizedproficiencythatpositionsyouasakeytechnicalresourcewithintheIRMfunction.YouwillownthedesignandmaintenanceofrobustdatainfrastructureusingMicrosoftFabric'smedallionarchitecture,leaddatapipelineandtransformationinitiatives,andestablishdatagovernancestandardsthatensuredataquality,security,andaccessibilityacrossallIRMfunctions.Balancinghands-ondeliverywithstandardsdefinitionandtechnicalleadership,youwilltransformhowriskdataflowsthroughtheorganization—breakingdownhistoricalsilosandcreatinganalyticsandAI-readydatasetsthatenableadvancedanalytics,real-timemonitoring,andpredictiveriskintelligence.
PrimaryPositionResponsibilities
- OwntheMicrosoftFabricarchitectureforIRM,definingstandards,designpatterns,andbestpracticesthatensurescalable,maintainable,andhigh-performingdatainfrastructureacrosstheriskecosystem
- Design,build,andmaintainenterpriseriskdatapipelinesusingMicrosoftFabricwithmedallionarchitecture (bronze,silver,goldlayers)thatintegratedatafrommultipleriskdomainsandenterprisesystems
- ArchitectandimplementdataengineeringworkflowsusingFabricDataFactory,SynapseDataEngineering (Sparknotebooks),andDataflowsGen2toconsolidatefragmentedriskdatafromServiceNowGRC,SAP,Workday,SuccessFactors,assuranceplatforms,andotherenterpriseandfunction-specificsystems
- DesignunifieddatamodelsandPowerBIsemanticmodelsthatenablecross-functionalriskanalytics,ensuringdataconsistency,accuracy,andaccessibilityacrossallriskfunctions
- EstablishandownthedatagovernanceframeworkforIRM,includingdataqualitystandards,validationrules,monitoringprocesses,securityprotocols,andaccesscontrolsthatprotectsensitiveriskinformationwhileenablingappropriatedatasharing
SolutionDelivery&TechnicalExcellence
- ServeasakeytechnicalresourcepartneringwithAnalyticsDevelopers,Architects,andDataScientiststounderstanddatarequirementsanddeliverdatasetsthatpowerdashboards,reports,predictivemodels,andriskassessments
- Architectandbuildscalable,automateddatasolutionsusingFabricpipelinesanddataflowsthatreducemanualdatapreparationeffortsandenablereal-timeornear-real-timeriskmonitoringcapabilities
- OptimizedatapipelineperformanceusingFabric'scomputeresourcesanddatastorageoptions(Lakehouse,DataWarehouse)toensurestakeholdersreceivetimely,accurateriskintelligencewhendecisionsneedtobemade
- Designandimplementdataobservabilityandmonitoringsolutionsthatproactivelyidentifyandresolvedataqualityissuesbeforetheyimpactbusinessdecisions
- Leadmigrationandintegrationinitiativesasnewrisktechnologiesandplatformsareadoptedacrosstheenterprise,independentlyowningprojectplanning,solutionarchitecture,anddelivery
OperationalExcellence&StandardsDefinition
- Independentlyrespondtocomplexdatarequestsfromriskfunctions,producingclean,well-documenteddatasetsinFabricLakehousesandDataWarehousesthatsupportriskassessments,audits,investigations,andstrategicinitiatives
- Anticipateandresolvecomplexdataqualityissues,workingwithsourcesystemownersandbusinesspartnerstoimplementsustainablefixesthatpreventrecurrence
- Defineandmaintaincomprehensivedocumentationstandardsfordatalineage,transformationlogic,datadictionaries,andtechnicalarchitecturethatenableknowledgesharingandmaintaininstitutionalknowledge
- BuildstrategicrelationshipswithTech@Lilly(IT),riskplatformadministrators,andbusinessdataownerstoidentifyandresolvedataintegrationchallengesthatimpactthebroaderIRMfunction
StrategicPartnership&Influence
- Buildandmaintainstrategicrelationshipswithriskdataowners,assurancefunctionpartners,andenterprisedatateamstoidentifyinternalcustomerrequirementsandopportunitiestoimprovedataavailability,quality,andintegration
- Leadstandardizationofdatadefinitions,taxonomies,andintegrationpatternsacrossriskfunctions,influencingtechnicaldecisionsthatenablemoreeffectivecross-functionalanalytics
- LeadtheupskillingofIRMteammembersandbusinesspartnersindataengineeringconcepts,servingasasubjectmatterexpertandcontributingtodataliteracyacrosstheorganization
- Staycurrentonemergingdataengineeringtechnologies,practices,andtools,evaluatingandapplyingrelevantinnovationstoenhanceLilly'sriskdatacapabilities
BasicQualifications/Requirements
- Bachelor'sDegreeinComputerScience,InformationSystems,DataEngineering,orrelatedfield
- 5+yearsofrelevantprofessionalexperienceindataengineering,ETLdevelopment,ordataintegration,withdemonstratedprogressioninresponsibilityandcomplexity.
AdditionalSkills/Preferences
- ExpertproficiencywithMicrosoftFabric(preferred)orsimilarclouddataplatforms(AzureDataFactory,SynapseAnalytics,Databricks),withabilitytodefinearchitecturestandardsandbestpractices
- AdvancedSQLandPython/PySparkskills,withhands-onexperiencebuildingdatapipelinesinSparknotebookenvironments(Fabric,Databricks,orsimilar),usingGit-basedversioncontrol
- ExperienceintegratingLLM/API-basedworkflows(RAG,embeddings,enterpriseLLMgateways),withinterestorexposuretoagentictool-callingprotocolssuchasMCP
- Demonstratedexperienceindependentlyleadingdataengineeringprojectsfromplanningthroughdelivery,includingarchitecturedesignandstandardsdefinition
- Demonstratedabilitytotranslatecomplexbusinessrequirementsintoscalabletechnicaldatasolutionswithsounddecision-makingwithinfunctionalguidelines
- StrongunderstandingofPowerBIdatamodeling,semanticmodeldesign,andoptimizingdatasetsforanalyticalperformance
- Hands-onexperiencewithMicrosoftFabriccomponentsincludingDataFactory,SynapseDataEngineering,DataWarehouse,Lakehouse,andDataflowsGen2
- Experiencedesigningandimplementingmedallionarchitectureorsimilarlayereddatalakedesignpatternsatenterprisescale
- ExperiencewithServiceNowplatform,ServiceNowGRC,orothergovernance,risk,andcompliancesystems
- Proficiencyindimensionalmodeling,starschemadesign,anddatawarehouseconcepts
- Experienceinpharmaceutical,healthcare,orhighlyregulatedindustrieswithcomplexdatagovernancerequirements
- Backgroundinriskmanagement,audit,compliance,orassurancedomaindata
- FamiliaritywithPowerPlatformintegration(PowerAutomate,PowerApps)withFabric
- Strongproblem-solvingskillswithabilitytoanticipate,diagnose,andresolvecomplexdataintegrationchallenges
- Provenabilitytocollaborateeffectivelywithbothtechnicalteamsandnon-technicalbusinessstakeholders,translatingtechnicalconceptsintobusinesslanguage
- Detail-orientedwithcommitmenttodataqualityandcomprehensivedocumentation
- Self-directedprofessionalwhoworksindependently,takesinitiativeoncomplexproblems,andproactivelyidentifiesopportunitiesforimprovement
- Demonstratedstrongmotivation,rapidlearningagility,andgrowthmindset
Travel
TravelUpto5-10%travelbasedonbusinessneeds
Lillyisdedicatedtohelpingindividualswithdisabilitiestoactivelyengageintheworkforce,ensuringequalopportunitieswhenvyingforpositions.IfyourequireaccommodationtosubmitaresumeforapositionatLilly,pleasecompletetheaccommodationrequestform(https://careers.lilly.com/us/en/workplace-accommodation)forfurtherassistance.Pleasenotethisisforindividualstorequestanaccommodationaspartoftheapplicationprocessandanyothercorrespondencewillnotreceivearesponse.
LillyisproudtobeanEEOEmployeranddoesnotdiscriminateonthebasisofage,race,color,religion,genderidentity,sex,genderexpression,sexualorientation,geneticinformation,ancestry,nationalorigin,protectedveteranstatus,disability,oranyotherlegallyprotectedstatus.Ouremployeeresourcegroups(ERGs)offerstrongsupportnetworksfortheirmembersandareopentoallemployees.Ourcurrentgroupsinclude:Africa,MiddleEast,CentralAsia(AMECA),BlackEmployeesatLilly(BE@Lilly),ChineseCultureNetwork(CCN),EnAble,Evolve,LillyIndianNetwork(LIN),OrganizationofLatinxatLilly(OLA),Pride(LGBTQ+Allies),VeteransLeadershipNetwork(VLN)andWomen’sInitiativeforLeadingatLilly(WILL).
Actualcompensationwilldependonacandidate’seducation,experience,skills,andgeographiclocation.Theanticipatedwageforthispositionis$124,500-$182,600Full-timeequivalent employeesalsowillbeeligibleforacompanybonus(depending,inpart,oncompanyandindividualperformance).Inaddition,Lillyoffersacomprehensivebenefitprogramtoeligibleemployees,includingeligibilitytoparticipateinacompany-sponsored401(k);pension;vacationbenefits;eligibilityformedical,dental,visionandprescriptiondrugbenefits;flexiblebenefits(e.g.,healthcareand/ordependentdaycareflexiblespendingaccounts);lifeinsuranceanddeathbenefits;certaintimeoffandleaveofabsencebenefits;andwell-beingbenefits(e.g.,employeeassistanceprogram,fitnessbenefits,andemployeeclubsandactivities).
- 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)
Lillyreservestherighttoamend,modify,orterminateitscompensationandbenefitprogramsinitssolediscretionandLilly’scompensationpracticesandguidelineswillapplyregardingthedetailsofanypromotionortransferofLillyemployees. #WeAreLilly At Lilly we strive to ensure our employees are part of a team that cares about them and our shared purpose of making life better for those around the world. How do we do this? We continue to look for ways to include, innovate, accelerate and deliver while maintaining integrity, excellence and respect for people. We hope that you seek to join us on our journey as we create medicine and deliver improved outcomes for patients across the globe! #WeAreLilly