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.

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 35,000 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.

Eli Lilly Services India Pvt Ltd

BIG COE: Data Analyst – Associate Manager

This role will be part of the Business Intelligence COE, which is a global team that leverages technical expertise to enable Lilly to achieve our financial objectives. We support global Planning Forecasting and Reporting (PFR) to all affiliates, hubs, regions, and corporate consolidations. Over the next few years Lilly is focussing on digital transformation for current planning, forecasting, and reporting tools and technology to new cloud-based solutions. The BI Reporting and Data Analytics will play a pivotal role in transforming data into actionable insights that drive financial decision-making and strategic planning on a global scale.

Core Responsibilities

Power BI Development: Design, develop, and maintain Power BI reports and dashboards to provide actionable insights to business users.Data Visualization: Create visually appealing and interactive data visualizations that effectively communicate key business metrics and trends.Data Modelling: Develop and maintain data models, including creating relationships, hierarchies, and calculated columns/measures in Power BI.Data Integration: Integrate data from various sources into Power BI, ensuring data accuracy and consistency.Performance Optimization: Optimize Power BI reports and dashboards for performance and usability.User Training and Support: Provide training and support to business users on Power BI usage and best practices.Collaboration: Work closely with stakeholders to gather requirements, incorporate feedback, and align analytical work with business objectives.Documentation: Create clear, comprehensive, and well-organized documentation for Power BI reports and dashboards.Data Governance: Ensure data governance and security standards are maintained in Power BI solutions.

Required

3-5 years of experience in data visualization and business intelligence, with a strong focus on Power BI.Strong working knowledge of visualization tools such as (Tableau and PowerBI preferred).Advanced working knowledge of Power BI, including DAX, Power Query, and data modelling.In-depth hands-on experience in data warehousing Redshift or any OLAP to support business/data analytics, business intelligence (BI)Advanced working SQL knowledge and experience working with relational databases, query authoring (SQL) as well as working familiarity with a variety of databases and Cloud Data warehouse like Redshift and Azure Lakehouse.Involvement in process to create clear, comprehensive, and well-organized documentation ensuring clarity, consistency, and efficiency in operations.Collaborate effectively with cross-functional teams to gather requirements, incorporate feedback, and align analytical work with business objectives.Data Model development, additional Dims and Facts creation and creating views and procedures, enable programmability to facilitate Automation.Experience building and optimizing “big data” data pipelines, architectures and data sets.Experience performing root cause analysis on internal and external data and processes to answer specific business questions and identify opportunities for improvement.Strong analytic skills related to working with structured and unstructured datasets.

Preferred Qualifications/Expertise

Experience with other data visualization tools such as Power BI and Tableau.Experience in the healthcare or pharmaceutical industry.Knowledge of data warehousing concepts and big data technologies.Experience with scripting languages such as Python or R.

Education:

Bachelor’s degree on Technology and Computer Science backgroundMaster’s in business administration (MBA) (Additional Advantage)

Company Profile

Eli Lilly and Company discovers, develops, manufactures, and sells pharmaceutical products worldwide. The company offers products across a broad range of therapeutic areas including Diabetes, Oncology, Neuroscience, Neurology, Cardiovascular and Endocrinology. Eli Lilly and Company was founded in 1876 and is headquartered in Indianapolis, Indiana. Mission We make medicines that help people live longer, healthier, more active lives. Values Integrity, excellence, respect for people Vision We will make a significant contribution to humanity by improving global health in 21st century.

Eli Lilly and Company, Lilly USA, LLC and our wholly owned subsidiaries (collectively “Lilly”) are committed to help individuals with disabilities to participate in the workforce and ensure equal opportunity to compete for jobs. If you require an accommodation to submit a resume for positions at Lilly, please email Lilly Human Resources (Lilly_Recruiting_Compliance@lists.lilly.com ) for further assistance. Please note This email address is intended for use only to request an accommodation as part of the application process. 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.

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