Data Analyst

Job Description

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 35,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.

Key Responsibilities:

• Project Execution:
  • Build and exhibit deep expertise on available marketing data sets and supports data enabled decision making using data from different Lilly affiliates
  • Apply knowledge of digital activities to integrate data into customer journeys
  • Perform root cause analysis in collaboration with end-users, related to reports, dashboards, visualizations
  • Consistent delivery of high quality, timely and insightful reports to enable brand and senior leadership to track performance of Eli Lilly brands
    • Develop and publish regularly, marketing reports on KPIs related to P2P and Video On Demand and non-personal channel promotional impressions and engagement metrics etc.
  • Work on descriptive analytical models, to perform exploratory data analysis and answer unstructured questions from the business.
    • Conversion funnel analytics
    • Sales Rep Compliance analytics
    • Brand marketing analytics
  • Support various phases of the project including kick-off, methodology development, execution, insight generation and data visualization and results presentation to various stakeholders
  • Find and execute opportunities for productivity improvements by automation or process changes

Requirements

• Preferred degree in sciences or quantitative discipline i.e. Econometrics, Statistics, Engineering or Computer Sciences
• At least 5 years of evolving experience in business analytics, performance reporting and/or descriptive analytics for Marketing or other commercial leadership, with demonstrated results in understanding, structuring and making sense of unfamiliar and messy datasets
• Experience in working with business partners located in another country
• Interpersonal and communication skills, with ability to work, remotely, across time zones
• Ability to operate effectively in an international matrix environment

Preferred Technical Skills

• Hands-on experience of managing and querying data on a range of relational and decisional data servers
• Expertise in writing and debugging efficient SQL queries, Excel and VBA
• Knime & Tableau experience highly desirable
• Experience in business analytics tasks like data cleaning, data enrichment, preparation and basics of good reporting
• High learning agility and focus on integration

Eli 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 a resume for positions at Lilly, please email Lilly Human Resources ( [email protected] ) for further assistance. Please note This email address is intended for use only to request an accommodation as part of the application process. 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.