Organization Overview:In 1992, Eli Lilly and Company established the Delivery Device business for the purpose of creating, developing, launching and continuously improving proprietary delivery device systems. This business is unique to the broader Lilly Research Labs organization due to its focus on patient centered delivery system solutions, its innovative approach to delivery platforms utilizing both internal and external technologies, and its level of integration with the commercial groups and Business Units. The DDCS organization leverages many alliances in design and manufacturing to rapidly convert proprietary product concepts into products that meet the users' needs and intended uses.
Position Overview:The Delivery Device and Connected Systems (DDCS) group is looking for a candidate who can serve as the Business Analytics Data Lead for DDCS portfolio reporting and insights. This role is accountable for pulling and integrating data from key sources, translating it into clear business meaning, and creating executive-ready narratives that inform decisions. The person in this role will proactively highlight risk areas (e.g., portfolio health, resource constraints, schedule risk, and operational bottlenecks) and recommend actions based on data.
This role is a hands-on "doer" role-owning the work of building analyses, dashboards, and recurring insights-not just coordinating it. The role reports to a leader who serves as the connector to external functions and senior leaders; the Business Analytics Data Lead ensures leadership has high-quality, accurate, and decision-relevant insights on DDCS portfolio performance.
Key Responsibilities:- Portfolio analytics & reporting (primary): Develop, maintain, and continuously improve DDCS portfolio analytics and reporting that enable leadership decision-making.
- Pull, integrate, and validate data from relevant systems and sources (e.g., portfolio trackers, Smartsheet, Power BI datasets, extracts, and other approved repositories).
- Create clear definitions and governance for metrics (e.g., milestone health, resource/FTE views, throughput, cycle time, productivity indicators, and adoption/usage measures).
- Ensure data quality through reconciliation, standardization, and routine checks; document assumptions, definitions, and limitations.
- Insight generation & business interpretation: Convert raw data into actionable insights that explain what is happening, why it matters, and what leadership should do next.
- Identify trends, drivers, and outliers; perform root-cause exploration where appropriate.
- Translate analysis into implications for DDCS strategy, portfolio prioritization, resourcing, and operational execution.
- Executive storytelling & stakeholder communication: Be the DDCS portfolio data storyteller-creating digestible, leadership-ready narratives and visuals.
- Deliver concise readouts (written and visual) for leadership forums, including risks, trade-offs, and recommended actions.
- Tailor communication for different audiences (technical vs. business) while maintaining accuracy and clarity.
- Risk identification & escalation: Proactively identify program and portfolio risk signals and ensure they are visible early.
- Highlight risk areas such as schedule slippage, milestone readiness gaps, resource constraints, data integrity issues, and dependencies across functions.
- Recommend mitigation actions and track follow-through with owners as appropriate.
- Cross-functional alignment (in support of connector leader): Partner closely with DDCS Operations and cross-functional stakeholders to ensure consistent metrics and aligned reporting.
- Coordinate with Tech[redacted], PRD, and Bengaluru data teams to enable consistency, reuse, and synergy where possible.
- Align outputs to broader standards and enterprise initiatives as applicable.
- Support additional initiatives and side projects as needed (e.g., process improvements, communications, AI adoption, and tools/systems implementation) to strengthen DDCS portfolio execution and decision-making.
- Develop scope of work, priority, timing/milestones, resource estimates; inform DDCS business planning.
- Evaluate and design business processes/best practices/templates/tools to guide execution.
- Lead initiatives/project that require cross functional/external collaboration.
- Coordinate and synchronize deliverables; establish team operating cadence.
- Design, collect, and communicate meaningful metrics to gage and communicate progresses (e.g. equivalent FTE saved)
- Proactively identify program issues/risks and recommend/ implement solutions.
Basic Requirements:- Earned Bachelor's degree in engineering, life sciences, business, analytics, or related field.
- 7+ years of experience in business analytics, portfolio analytics, operations analytics, data management, and/or program/portfolio reporting in a complex environment (regulated environment preferred).
- Demonstrated ability to independently pull data, analyze and translate it into business insights and recommendations.
- Demonstrated experience building executive-ready visuals and narratives (dashboards, scorecards, concise readouts, etc.).
- Proficient AI operating skills, including practical use (preferably with Copilot and/or Claude) to accelerate analysis, drafting, summarization, and stakeholder communications while maintaining appropriate judgment, confidentiality, and data integrity.
- Technical leadership: ability to speak both "IT" and "business" languages and translate requirements between stakeholders.
Additional Preferences: - Strong proficiency with analysis and reporting tools (e.g., Excel; Power BI or equivalent tools).
- Experience with data querying and preparation (e.g., SQL or similar), data modeling concepts, and working with large datasets.
- Comfort working across multiple data sources with imperfect inputs; ability to define data standards and improve quality over time.
- Ability to create and manage a recurring operating cadence for portfolio insights (weekly/monthly views), including metric definitions and refresh routines.
- Strong influencing skills with no direct authority; able to drive alignment through clarity, logic, and stakeholder partnership.
- Experience identifying and communicating risk in a structured way (risk signals, triggers, mitigations, decision points).
- Experience supporting AI enablement and/or analytics tool and system implementations (e.g., piloting, requirements definition, rollout communications, training, and adoption tracking).
Other Information: - Position is located at the Indianapolis: LTC-N building
Actual compensation will depend on a candidate's education, experience, skills, and geographic location. The anticipated wage for this position is
$115,500 - $169,400
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