Indiana Stem Jobs

Mobile Indiana Career Connect Logo

Job Information

Eli Lilly and Company Associate-Commercial Analytics Data - R-11637 in Indianapolis, Indiana

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. Were looking for people who are determined to make life better for people around the world.Position Overview:This job involves a depth of understanding of all Lilly sales and marketing databases as well as an understanding of the available 3rd 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. It will also 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 supplierand 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:Create and maintain optimal data pipeline architecture ETL/ ELT into structured dataResponsible for execution and maintenance of the analytic data marts and other analytic platformsResponsible for data loads, processing, and validation for analytics and reporting purposesResponsible for stewardship and integration of commercial data, serving as a liaison between business partners and analytics teamsResponsible for monthly and weekly data pulls from various source systems - Product, Customer, Alignment, Payer, and other dataResponsible for ad-hoc data pullsDemonstrate in-depth understanding and application of core analytic processes and data supporting themResponsible for creating and maintaining data related documentationPartner with IT, Reporting, Brand teams, and external data vendors to ensure quality in data availability and provide appropriate data accessEnsure high stakeholder satisfaction through consistent delivery of high quality, timely and insightful outputs throughout analytics value chain on various objectivesMaintain standard data definitions and business rules for utilization of US Lilly dataPosition Requirements:Strong experience in SQL (2 yrs preferably post degree completion)Proficiency with Netezza DB, Oracle, and UNIXExperience with AWS cloud environmentExperience with management of large databasesProficiency in MSWord, PowerPoint, and ExcelEducation RequirementsBachelors or Masters Degree in quantitative discipline i.e. Statistics, Mathematics, Finance, Engineering or Computer Sciences is preferredAdditional Preferences:Strong experience with with SAS (2 yrs)Experience with pharmaceutical sales and marketing dataExperience with data integration from multiple sourcesExperience with execution and implementation of core analytic processesExperience in PL/SQL and Stored ProceduresExperience in data visualization tools e.g. TableauExperience with Lambda, Glue, S3, Redshift toolsExperience with Data Model development, additional Dims and Facts creation and creating views and procedures, enable programmability to facilitate automationExperience with stream-processing systems: Storm, Spark-Streaming, etc.Experience with object-oriented/object function scripting languages: Python, Java, R, C , etc.Project management experienceEli Lilly and Company, Lilly USA, LLC and our wholly owned subsidiaries (collectively Lilly) are committed to help individuals with disabilities to participate in the workforce and ensure equal opportunity to compete for jobs. If you require an accommodation to submit