Data & Insights Associate - B2B & Sales Ops

At Lilly, the work is demanding because patients are waiting. We unite caring with discovery to help make life better for people around the world, knowing that every decision, every detail, and every day matters. Headquartered in Indianapolis, Indiana, our over 50,000 employees around the globe take on complex challenges to discover and deliver life-changing medicines, strengthen how health is understood and managed, and support the communities we serve. This is hard, urgent, selfless work—but it’s work worth doing. If you’re driven by purpose and ready to bring your best to work that truly matters for patients, we invite you to join us.

The Data & Insights Associate - B2B & Sales Ops   will   automate data collection and consolidation   across   Commercial Programs, Chains, Trade Marketing, and Sales Operations , turning fragmented, manually maintained information into   reliable, timely, and decision-ready business insights.

This role acts as the   data enablement layer   for the four functions it serves, working under the   MarTech Associate Director's data and analytics architecture , while partnering closely with the functional leads of Commercial Programs, Chains, Trade Marketing, and Sales Operations, who remain the   business owners   of the decisions those insights inform.

Key Responsibilities

1. Data Automation & Integration

- Identify manual, spreadsheet-based, or duplicated data processes across Commercial Programs, Chains, Trade Marketing, and Sales Operations, and   redesign them as automated data flows   (Power BI, Power Automate, Python, SQL, or Lilly-approved MarTech/data platforms).

- Design and own the end-to-end data architecture underpinning automation across the four functions — source systems, data flows, integration points, storage, and governance — ensuring it is scalable, documented, and maintainable as new processes are added.

- Build and maintain   data pipelines and connectors   between source systems (Veeva, Salesforce, ERP, distributor/chain data feeds) and reporting layers, ensuring data integrity and version control.

- Standardize   data definitions and taxonomies   across the four service areas so metrics are comparable and auditable.

2. Business Insights & Analytics

- Translate raw operational data into   actionable insights and recommendations   for Commercial Programs, Chains, Trade Marketing, and Sales Ops decision-making.

- Develop   recurring and ad hoc analyses   (e.g., chain performance, trade investment ROI, sales force execution, program compliance) that support quarterly business reviews and MMC-level reporting.

- Flag   data anomalies, risks, or opportunities   proactively, rather than waiting for a request.

3. Dashboards & Reporting

- Design and maintain   self-service dashboards   (Power BI or equivalent) with clear ownership, refresh cadence, and access governance.

- Ensure dashboards are built and maintained as decision-ready tools for Commercial Programs, Chains, Trade Marketing, and Sales Operations — surfacing the metrics each area needs to act, not just data for data's sake .

4. Cross-Functional Service & Governance

- Serve as the   single point of contact for data requests   from Commercial Programs, Chains, Trade Marketing, and Sales Ops, prioritizing intake against business impact.

- Operate within a clear   Governace : this role is accountable for data accuracy, automation, and insight generation; functional leads remain accountable for the business decisions and outcomes.

- Ensure all data handling complies with   Lilly data privacy, security, and compliance standards , and route anything with commercial, pricing, or promotional implications through the appropriate MLR/compliance channel.

5. Continuous Improvement

- Document processes and build   simple SOPs/playbooks   so automated processes are sustainable beyond the individual.

- Bring forward   tooling or process improvement ideas   to the MarTech Associate Director as part of the broader MarTech roadmap.

Expected Deliverables

- Automated Data Pipelines:   At least the top manual reporting processes across the four service areas migrated to automated flows within the first year.

- Unified Reporting Layer:   A consolidated dashboard suite covering Chains, Trade Marketing, Sales Operations, and Commercial Programs performance.

- Insight Briefs:   Recurring (monthly/quarterly) business insight summaries feeding into MMC or leadership reviews.

- Data Governance Notes:   Documented data definitions, access rules, and refresh cadences for each dashboard/report in scope.

- Process SOPs:   Documentation enabling continuity and scale of the automated processes.

Qualifications & Requirements

- Bachelor's degree   in Business, Engineering, Data Analytics, Statistics, or a related field.

- 2 to 4 years   of experience in data analytics, business intelligence, sales operations, or trade marketing analytics, ideally in a matrixed or pharma/CPG environment.

- Hands-on proficiency in   Power BI, Excel (advanced), SQL ; Python or similar scripting is a plus.

- Working knowledge of   CRM/data platforms   such as Veeva or Salesforce, and familiarity with distributor/chain data structures.

- Strong   analytical rigor and attention to detail , with the ability to translate data into a clear business narrative for non-technical stakeholders.

- Demonstrated ability to   manage multiple internal stakeholders   and prioritize competing data requests without close supervision.

- Understanding of   pharma commercial compliance   (MLR, data privacy) is a plus.

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 does not discriminate on the basis of age, race, color, religion, gender, sexual orientation, gender identity, gender expression, national origin, protected veteran status, disability or any other legally protected status.

#WeAreLilly