DATA ANALYST – MEDICAL AFFAIRS

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 & visualization
• Execute 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 quality
• Respond to queries from internal stakeholders
• Consistently meet operations SLAs
• Perform incident resolution and root cause analysis to support data and reporting operations
• Consistent delivery of high quality, timely and insightful reports to enable stakeholders and senior leadership to take key decisions
• Develop and publish regularly, different execution dashboard as per the business roadmap & requirements
• Descriptive analytics and visualization to provide data-based insights on planning, execution and outcomes
• Demonstrate deep understanding of information and material flows, processes, procedures, systems, and methods
• Demonstrate understanding of internal business partners’ people, processes, and technology
• Partner and collaborate with other site-level teams to identify synergies and implementation of best practices
• Technical Skills
• Expertise 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 have
• Analytical Skills
• Experience in business analytics
• Data 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 datasets
• Experience 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 motivation
• Interpersonal and communication skills with ability to work across time zones.
• Strong stakeholder management skills
• Ability to operate effectively in an international matrix environment.
• Strong team player who is dynamic and result oriented
• Proven planning and organizational skills
• Proven ability to manage multiple projects at a time with flexibility to adjust quickly and effectively to frequent change and altered priorities
• Product Launch experience
• Demonstrated 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