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.
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
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
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.
Commercial Data Analyst – US Commercial Analytics
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.
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: