Data Analyst - Consumer Analytics-2

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

Consumer Marketing Analytics Team: Data Analyst

As Eli Lilly strives to achieve its purpose of making life better for patients, we have been building up our in-house ‘Consumer Experience’ function, which will design and execute next-generation marketing campaigns aimed at informing and educating consumers (or patients) directly.

To support the Consumer marketing teams in their decision-making, a data and analytics team has been set up in Indianapolis (HQ) and Bengaluru (LCCI). This team will be responsible for setting up the data warehouses necessary to handle large volumes of digital streaming data, create meaningful analyses, analytics and deliver recommendations to leadership.

As part of the LCCI team, we are excited to offer the role of a data analyst who will be an integral part of the Consumer analytics team.

Core Responsibilities:

• Working with media and digital advertising experts to help answer business questions by analysing large volumes of data from sources like Google Ad Server, DCM, Double Click, Google Search/Ads. Campaign Metadata etc.
• Share findings from analysis along with recommendations to a wide variety of business and technical stakeholders
• Perform detailed analysis of Media, Marketing, Search Engine and Social Ad server’s data sources for to define cleansing rules for data quality and modelling
• Stay up to date in the ever changing ad-tech/mar-tech ecosystem and identify areas to drive more data driven thinking throughout the organization

Required

• Strong hands-on experience with SQL. Working knowledge of R or Python are good to have but not mandatory
• Strong analytical experience for 7 to10 years of experience.
• Demonstrated history of breaking down unstructured business problems and translating them to more tangible problem solving approaches

• Experience in gathering business requirements, transforming data and preparing readout and recommendation narratives from Analytics to share with Business users.
• Knowledge of digital advertising data and strategies highly preferred though not mandatory
• Strong working knowledge of visualization tools such as (PowerBI preferred)

• Comfort with ambiguity and a willingness to work with a high degree of autonomy
• Demonstrated experience working in cross-functional, cross-geography teams

Preferred Qualifications

• Experience in Data and/or Business Analysts from Healthcare/Pharma/Retail/BFSI/Digital/ Media Ad companies
• Bachelor’s degree or master’s degree in technology, Statistics or Computer Science background

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