Consultant/Sr.Consultant - Data Visualization

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.

For more than 140 years, Eli Lilly and Company has been dedicated to the discovery and development of medicines to address the health care needs of people around the world.  Driven by the broader, consumer-focused digital revolution and in anticipation of this same revolution in health care, Lilly is now further expanding the definition of product to include the design, build, integration and orchestration of digitally enabled health care interactions and has established a Connected Medicine Business Unit to accomplish these goals in across all disease areas. 

More specifically, we are interested in using digital technologies to improve the health outcomes of those using our products and are formalizing our ecosystem of capabilities to orchestrate personalized engagement to patients. Coupling our medicines, devices, and digital solutions with consumer health solutions and health systems, we believe we can partner with providers and payers to enable significant improvements in health outcomes for our customers.

The purpose of the LCCI Connected Medicine team is to partner with Connected Medicine Data Insights & Customer Behavior team in providing high quality analytical support through right data, smart analytics and actionable insights. The LCCI Connected Medicine Team Lead will lead a team comprising of creative problem solvers who support achievement of the brand’s goals, while always striving for process improvement and innovation

This role will be accountable for operational execution of identified analytics capabilities across connected care ecosystem inclusive of execution of Reports & Dashboards to highlight Exploratory, Predictive and Causal analytics  

Position Responsibilities

• Project Execution: as individual contributor
  • Develop, design, and maintain interactive dashboards and reports using PowerBI and Tableau
  • To understand business requirements in the BI context and design data models to convert raw data to meaningful insights.
  • To analyse data and present it through reports that can help in decision-making
  • To be able to convert business requirements into technical specifications and decide the timeline to accomplish tasks
  • Develop and optimize scripts in Power BI and Tableau and perform efficient detailed analysis
  • Utilize DAX for Power BI and calculated fields for Tableau effectively
  • Implement robust data warehousing strategies and build comprehensive data models tailored to Tableau and Power BI environments
  • Knowledge of databases as SQL and hands on experience in writing SQL Queries
  • To create charts and document data with algorithms, parameters, models, and relations explanations
  • Participating in meetings with stakeholders and communicating the final outputs and recommendations
  • Ensure high stakeholder satisfaction through consistent delivery of high quality, timely and insightful outputs

• Project Delivery: as team member, supporting the team lead in driving
  •  Quality, speed, value and compliance throughout the analytics value chain
  •  Project management for seamless project execution, prioritization and high-quality delivery
  •  Creation and maintenance of standard operating procedures (SOPs), quality checklists that will enable excellent quality outputs
  •  Shared learning forums to identify challenges and establish best practices

Basic Qualifications

• Minimum of 7 years of experience in data visualization and business intelligence
• Bachelor's degree or equivalent in Computer Science, Information Technology, Advanced Analytics and Data Science, or other relevant degree area; Master’s degree preferred in these disciplines
• Working knowledge of SQL
• Proficiency in PowerBI, with a strong understanding of its advanced features and capabilities.
• Experience with Tableau, including creating complex visualizations and dashboards.
• Strong analytical and problem-solving skills.
• Experience with the following technologies: Cloud platforms like AWS & Azure

Additional Skills/Preferences

• High learning agility
• Proven ability to rally resources to achieve project and business results
• Candidates should be comfortable working in ambiguity/whitespace and in working in a fast-moving environment
• Exceptional listening skills, with an ability to ask the right questions and uncover hidden insights
• Ability to collaborate with strategists, consultants, creatives, and technologists

Excellent communication (written & verbal), storytelling, and interpersonal influencing skills and prioritization skills with attention to detail

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