DATA ANALYST - MEDICAL AFFAIRS

Job 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: bachelors or masters degree in sciences or quantitative discipline ie 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 (eg, 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