Role Summary
The Risk Analytics Developer translates complex business questions into actionable intelligence by building executive dashboards, Power BI reports, and self-service analytics tools that enable risk leaders to monitor portfolios, identify emerging threats, and make data-driven decisions in real time. Working as part of the centralized IRM Insights Hub team, you will develop solutions across multiple risk domains to create visibility and insight across Lilly's integrated risk landscape. The role balances new capability development with operational support of current tools, focusing on discovering useful insights, supporting leadership decision-making, and driving continuous improvement across risk processes. You will leverage Microsoft Fabric for data engineering and Power BI for visualization, integrating data from enterprise systems to create unified analytics that enable “Analytics for Everyone.”
Responsibilities
- Develop Power BI dashboards and executive visualizations that analyze risk data across the enterprise, identifying emerging threats, trends, and insights across multiple risk domains
- Build self-service analytics capabilities enabling risk leaders and business partners to monitor risk portfolios and make real-time, data-driven decisions
- Create artificial intelligence and automation solutions using Power Platform (Power Automate, Copilot Studio), Claude, and Microsoft Fabric capabilities
- Leverage and integrate data from multiple sources including ServiceNow GRC, SAP, Workday, SuccessFactors, and assurance platforms using Microsoft Fabric data integration
- Drive process standardization and automation to enable IRM and partner risk functions to operate more effectively and efficiently
- Respond to analytics requests from risk functions, producing datasets and insights that support risk assessments, audits, investigations, and strategic initiatives
- Support enterprise risk reporting to business partners, risk owners, senior leadership, and key stakeholders
- Partner with risk function personnel to 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 to enable knowledge sharing and team scalability
- Forge partnerships with risk data owners, assurance function partners, and business leaders to identify unmet analytics needs and process improvement opportunities
- Support the upskilling of risk functions and business partners in data analytics domains, contributing to the “Analytics for Everyone” vision
- Participate in cross-functional analytics initiatives that strengthen Lilly's integrated risk intelligence capabilities
Qualifications
- Required: Bachelor's Degree in Business Analytics, Statistics, Data Science, or related field
- Required: 3+ years of relevant professional experience in data analytics
- Required: Advanced proficiency with Power BI, including DAX, data modeling, and dashboard design
- Required: Strong proficiency with SQL and data transformation tools
- Required: Experience in project management and delivering analytics solutions in business environments
- Required: Authorized to work in the United States on a full-time basis (no sponsorship provided)
- 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: Professional experience building automation solutions using Power Platform (Power Automate, Power Apps)
- 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: Ability to collaborate with diverse cross-functional partners and translate technical insights into business language
- Preferred: Detail-oriented with high accuracy, able to thrive in fast-paced environments with competing priorities
- Preferred: Self-starter, proactive across distributed teams, and capable of recognizing opportunities for process enhancement
- Preferred: Demonstrated motivation, rapid learning agility, and growth mindset
- Preferred: Demonstrated critical thinking skills applied to complex, ambiguous problem spaces
Education
- Bachelor's Degree in Business Analytics, Statistics, Data Science, or related field
Additional Requirements
- Travel: Up to 5-10% travel based on business needs