Data & Insights Associate - B2B & Sales Ops

Eli Lilly and Company; Indianapolis (IN); On-site; MXN 350,000 - 480,000; Full time

Job summary

Eli Lilly and Company is seeking a Data & Insights Associate to automate data collection and deliver reliable, decision-ready insights across Commercial Programs, Chains, Trade Marketing, and Sales Operations.

The role focuses on building a scalable data architecture, dashboards, and governance. Collaboration with cross-functional teams is essential to translate data into actionable business narratives while ensuring compliance.

Qualifications

• Bachelor’s degree in Business, Engineering, Data Analytics, Statistics, or related field.
• 2–4 years in data analytics, BI, sales ops, or trade marketing analytics.
• Proficient in Power BI, Excel, SQL; Python is a plus.
• Knowledge of Veeva or Salesforce CRM platforms; pharma/commercial compliance is a plus.

Responsibilities

• Automate data collection and consolidation across four functions (Commercial Programs, Chains, Trade Marketing, Sales Ops).
• Build and maintain end-to-end data architecture and data pipelines for automated flows.
• Develop self-service dashboards (Power BI) with clear ownership and governance.
• Translate raw data into actionable insights and recommendations for decision-making.
• Coordinate with functional leads and manage data requests with governance and privacy in mind.

Skills

Power BI

Excel

SQL

Python

Education

Bachelor’s degree in Business, Engineering, Data Analytics, Statistics, or related field

Tools

Veeva

Salesforce

Job description

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.

The 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

• 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.
• 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.
• 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.
• 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.
• 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