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.

Position Description:

The purpose of this role is to serve as a trusted partner with Business Unit Medical Affairs and Internal Global Medical Affairs Organization (GMAO) teams to lead creation of high-quality data reporting and visualization support that can drive better customer experience and business impact. This role will champion our self-service reporting strategy and would play a key role in helping us automate and create scalable frameworks for our reporting and analytics. We are looking for a hands-on person who can help expand our analytics & reporting capabilities and drive business-critical initiatives.

Key Objectives/Deliverables:

Know Lilly TA business and our internal business partners.Build and exhibit deep expertise on available data sets and supports data enabled decision making by developing data lakes, insights, reporting & visualizationExecute and monitor operations tasks to ensure timely availability of data in a reporting / dashboard structure to the business.Perform thorough data validations to ensure data qualityRespond to queries from internal stakeholdersConsistently meet operations SLAsPerform incident resolution and root cause analysis to support data and reporting operationsConsistent delivery of high quality, timely and insightful reports to enable stakeholders and senior leadership to take key decisionsDevelop and publish regularly, different execution dashboard as per the business roadmap & requirementsDescriptive analytics and visualization to provide data-based insights on planning, execution and outcomesDemonstrate deep understanding of information and material flows, processes, procedures, systems, and methodsDemonstrate understanding of internal business partners’ people, processes, and technologyPartner and collaborate with other site-level teams to identify synergies and implementation of best practicesTechnical SkillsExpertise in writing and debugging efficient SQL queries.Strong experience in data visualization tools - Power BI or Tableau (Power BI preferred) – Should be able to independently design and develop dashboards as per business requirement.Advanced MS-office skills (MS-Excel and MS-PowerPoint)Coding: SQL mandatory and one of R, Python would be good to haveAnalytical SkillsExperience in business analyticsData cleaning and preparation skill (database querying, descriptive statistics)Problem solving skills and lateral thinking ability and an eye for detail

Educational Requirements:

Bachelor’s or Master’s degree in sciences or quantitative discipline i.e. Finance, Econometrics, Statistics, Engineering or Computer Sciences

Additional Preferences:

At least 7-9 years of evolving experience in data management, pharma market intelligence, performance reporting/visualization and/or descriptive analytics for leadership, with demonstrated results in understanding, structuring, and making sense of unfamiliar and messy datasetsExperience with project management software (e.g., Wrike, JIRA, Adobe Workfront) and proficiency in a variety of PC applications and multifunctional diagramming tools including Microsoft Project, Visio, Lucid Chart etc.Strong work ethic and personal motivationInterpersonal and communication skills with ability to work across time zones.Strong stakeholder management skillsAbility to operate effectively in an international matrix environment.Strong team player who is dynamic and result orientedProven planning and organizational skillsProven ability to manage multiple projects at a time with flexibility to adjust quickly and effectively to frequent change and altered prioritiesProduct Launch experienceDemonstrated enthusiasm and the ability to work under pressure to meet deadlines

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