Role Summary
The Associate Director - Integrated Risk Analytics Developer leads analytics initiatives within Lilly's Integrated Risk Management program, translating complex business questions into actionable intelligence to inform strategic decisions across the IRM ecosystem. This individual contributor designs and delivers executive dashboards, enterprise Power BI solutions, and self-service analytics capabilities to help risk leaders monitor portfolios, anticipate threats, and make data-driven decisions. Working within the centralized IRM Insights Hub, you will own end-to-end solution delivery for high-impact analytics initiatives spanning multiple risk domains. Based in Indianapolis, Indiana, this role leverages Microsoft Fabric and Power BI, integrating data from enterprise systems such as ServiceNow GRC, SAP, and Workday to break down data silos and enable analytics for everyone.
Responsibilities
- Lead end-to-end analytics initiatives from requirements gathering through deployment, independently owning project planning, solution architecture, development, and delivery for high-visibility risk intelligence capabilities
- Design and develop Power BI dashboards and executive visualizations that analyze risk data across the enterprise, identifying emerging threats, trends, and insights to support function-level and senior leadership decision-making
- Architect self-service analytics capabilities that enable risk leaders and business partners to supervise risk portfolios and make real-time, data-driven decisions without ongoing developer support
- Design and implement artificial intelligence and automation solutions using Power Platform (Power Automate, Copilot Studio), Claude, and Microsoft Fabric capabilities to address complex risk management challenges
- Architect data integration solutions that leverage multiple enterprise sources including ServiceNow GRC, SAP, Workday, SuccessFactors, and assurance platforms using Microsoft Fabric's data engineering capabilities
- Drive process standardization and automation strategies that enable IRM and partner risk functions to operate more effectively and efficiently at scale
Operational Excellence & Technical Leadership
- Serve as a key technical resource for analytics requests from risk functions, independently producing sophisticated datasets and insights that support risk assessments, audits, investigations, and critical initiatives
- Lead enterprise risk reporting initiatives to business partners, risk owners, senior leadership, and key collaborators, ensuring analytics outputs meet executive decision-making needs
- Partner with risk function leaders to anticipate and identify control risks and emerging threats relative to regulations, policies, procedures, and business objectives
- Develop and maintain comprehensive documentation of analytics tools, data models, semantic models, data pipelines, and methodologies; support the definition of standards and governance practices that enable knowledge sharing and team scalability
Strategic Partnership & Influence
- Build and maintain strategic relationships with risk data owners, assurance function partners, and business leaders across risk functions to identify internal customer requirements, unmet analytics needs, and process improvement opportunities
- Lead the upskilling of risk functions and business partners in data analytics domains, serving as a subject matter expert and contributing to the "Analytics for Everyone" vision
- Lead and collaborate on multi-functional analytics initiatives that strengthen Lilly's integrated risk intelligence capabilities, influencing technical decisions that impact the broader IRM function
Qualifications
- Required: 5+ years of relevant professional experience in data analytics
- Required: Authorized to work in the United States on a full-time basis; Lilly will not provide sponsorship
Education
- Bachelor's Degree in Business Analytics, Statistics, Data Science, Computer Science, or related field
Skills
- Preferred: Power BI, including sophisticated DAX, data modeling, performance optimization, and executive dashboard design with SQL and data transformation tools
- Preferred: Demonstrated experience independently leading analytics projects from planning through delivery
- Preferred: Strong critical thinking skills applied to complex, ambiguous problem spaces with ability to make sound technical decisions
- Preferred: Experience with Microsoft Fabric components (Data Factory, Synapse Data Engineering, Data Warehouse, Real-Time Analytics)
- Preferred: Familiarity with medallion architecture and modern data platform design patterns
- Preferred: Experience developing artificial intelligence solutions or working with AI platforms
- Preferred: Experience working in or supporting risk management, internal audit, compliance, or assurance functions
- Preferred: Familiarity with ServiceNow GRC or enterprise risk management platforms
- Preferred: Experience in pharmaceutical, healthcare, or highly regulated industries
- Preferred: Proven ability to build relationships and collaborate effectively with diverse multi-functional partners across technical and business domains
- Preferred: Strong written and interpersonal communication skills, with demonstrated ability to translate technical insights into business language for senior leadership audiences
- Preferred: Meticulous with high degree of accuracy and ability to thrive in fast-paced, dynamic environments with competing priorities
- Preferred: Self-directed professional who works independently, takes initiative on complex problems, and proactively collaborates across distributed teams
- Preferred: Track record of recognizing opportunities for process enhancement and implementing lasting, innovative solutions
- Preferred: Demonstrated strong motivation, rapid learning agility, and growth mindset
Additional Requirements
- Travel: Up to 5-10% travel based on business needs