Lilly Jobs

Job Information

Lilly Associate-Data-Unites States Commercial Analytics in Indianapolis, Indiana



This job involves a depth of understanding of all Lilly sales and marketing databases as well as an understanding of the available third party data sources needed for core analytic processes. This position will be responsible for analytic data processing, integration and maintenance and will support data needs of US internal analytics team, analytic vendors, and marketing brand teams. This position will liaison with internal functions (statisticians, IT, sales reporting, market research, operations, brand teams) and suppliers to ensure consistency in data definitions and data utilization for core analytic processes across the US affiliate. Additional responsibility includes ensuring supplier and Lilly Analytics team access and confidentiality to Lilly data and defining and applying standard business rules for consistent use in all internal and supplier analysis.

Key Objectives:

This position will oversee:

  • Monthly execution and maintenance of the analytic data marts and other analytic platforms

  • Stewardship and integration of data in Customer 360, serving as a liaison between business and analytics teams

  • Monthly and weekly data pulls from various master source systems - Product, Customer, and Alignment, US Sales data warehouse

  • Data understanding and access for all vendors and Lilly analytics team

  • Ad-hoc data pulls

  • Creating and maintaining data related documentation

  • Demonstrate in-depth understanding and application of core analytic processes and data supporting them

  • Partner with IT, sales reporting, market research, and external data vendors to ensure quality in data availability and provide appropriate data access

  • Owner of standard data definitions and business rules for utilization of Lilly data with suppliers

Req ID:


Additional Skills/Preferences:

  • Bachelor’s Degree in a quantitative analysis discipline, i.e. Statistics, Mathematics, Engineering or Computer Science

  • Proficiency with Netezza Database,Oracle, & UNIX

  • Experience with management of large databases and data warehousing

  • Experience with pharmaceutical sales and marketing data

  • Proficiency in MSWord, PowerPoint, and Excel

  • Data integration from multiple sources experience

  • Experience with execution and implementation of core analytic processes

  • Experience in PL/SQL and Stored Procedures within Netezza DB

  • Project management experience

  • Six Sigma (black or green belt) experience

Additional Information:

Lilly is an EEO/Affirmative Action Employer and 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.

Workplace Arrangement:


Location Details:



Commercial Data Analyst – US Commercial Analytics

Job Category:


Basic Qualifications:

  • Bachelor’s Degree

  • Minimum of 2 years of strong experience with SAS and SQL

Qualified candidates must be legally authorized to be employed in the United States. Lilly does not anticipate providing sponsorship for employment visa status (e.g., H-1B or TN status) for this employment position.

Company Overview:

At Lilly, we unite caring with discovery to make life better for people around the world. We are a global healthcare leader headquartered in Indianapolis, Indiana. Our 39,000 employees around the world work to discover and bring life-changing medicines to those who need them, improve the understanding and management of disease, and give back to our communities through philanthropy and volunteerism. We give our best effort to our work, and we put people first. We’re looking for people who are determined to make life better for people around the world.





State / Province:



North America