Associate Ii

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.

**Job Title: Supply chain Data analyst(R1-R2)**

**Path/Level**:
R1-R2

**Company Overview**:
At Lilly, our mission is to make medicines that help people live longer, healthier, more active lives. While following our three core values - integrity, excellence, and respect for people - Lilly’s vision is to make a significant contribution to humanity by improving global health in the 21st century. With innovative technology, exceptional business practices, and unparalleled leadership, Lilly is dedicated to our mission

**Organization Overview**

Lilly has embarked on a very broad Digital Transformation journey in the Manufacturing & Supply Chain space with a goal to modernize and digitize operations in Planning, Purchasing, Manufacturing, Storage and Distribution of our products.

The scope of Supply chain solutions is broad, and the role will contribute to the elaboration of the multi-year implementation programs within the Manufacturing and Quality (M&Q) IDS organization.

**Responsibilities**:
**Technical Skills**:

- In-depth knowledge of the visualization ecosystem is essential, encompassing Fabric, Power BI Desktop, Power BI Service, Power Query, DAX, data modelling, visualisation. Proficiency in Azure/AWS is expected. SQL expertise is a prerequisite.
- Experience with the Microsoft BI stack is required, particularly strong Power BI capabilities and familiarity with machine learning and data mining, as well as large-scale computing systems. Skills in SQL, R/Python/Azure ML or equivalent languages are highly desirable.
- Design and business intelligence architecture skills, along with collaboration with engineering and information architecture teams, are advantageous.

**MS Fabric and Business Intelligence Development**:

- Design, develop, and maintain Power BI reports and dashboards that meet business requirements.
- Create data models, transformations, and data visualizations to support decision-making processes.
- Able to create dataflows, DataMart’s for various transformations.
- Collaborate with cross-functional teams to understand data needs and develop solutions accordingly.

**Integration And Automation**
- Integrate Power BI with various data sources (SAP SharePoint, spreadsheets) and systems.
- Develop and maintain ETL processes to ensure timely and accurate data availability for reporting.
- Automate routine tasks and processes to improve efficiency.

**Documentation, Testing And Training**
- Document configurations, processes, and best practices for fabric and Power BI administration.
- Conduct training sessions for end-users and internal teams to enhance their Power BI proficiency.
- Hands-on experience in extracting various reports from SAP, analysing information and automating the report/dashboard generation process.
- Should have Hands-on experience in report and data validation with best testing practices.

**Process Improvement**
- Identify inefficiencies in supply chain operations and recommend data-driven solutions for optimization.
- Collaborate with cross-functional teams to implement these improvements.

**Stakeholder Communication**: Serve as a key point of contact for internal and external stakeholders, presenting findings, reports, and recommendations effectively to both technical and non-technical audiences.

**Performance Monitoring & Dashboards**
- Develop and maintain interactive dashboards and KPIs using Power BI.
- Exceptional analytical skills: the ability to see patterns; and a structured and logical approach to decision making

**Basic Qualifications/Requirements**:

- Experience: 3-6 years in data analytics or related fields.
- HPALM or any testing platform understanding would be added advantage.
- Previous experience in supply chain analytics with SAP data would be added advantage.
- A solid understanding of database structures and SQL. Atleast 1-2 years of experience in writing scripts for data analysis using Python, SQL, or R.
- Experience with Power Platform would be an added advantage.
- Capable of handling multiple projects simultaneously and efficiently managing time.
- Project Management: Familiarity with PMO methodologies and background in supporting or managing projects.
- Communication: Strong verbal and written communication skills, capable of clearly presenting complex data insights.
- Problem-Solving: Highly analytical mindset with a proactive approach to resolving operational challenges.
- Attention to Detai