Analyst - Business intelligence Developer

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.

Overview  

The GBS Capability Optimisation and Automation (GCOA) organisation is a strategic function focused on transforming finance operations through intelligent automation and AI. GCOA acts as a centralised capability hub, enabling scalable, secure, and compliant solutions that deliver measurable business value.  

GCOA partners with finance and technology teams to:  

• Identify automation opportunities. 

• Design innovative solutions. 

• Embed automation as a core enabler of operational excellence and digital transformation. 

This Analyst - Business Intelligence Developer role (P1-P3) is responsible for working on data projects as the finance organisation is putting a greater emphasis on data analysis. The role will be working collaboratively with other members of the team and provide expertise in data modelling, schema design, data visualisation and analytics. 

The individual will be a proactive and driven self-starter with the ability to communicate with key stakeholders at all levels and from a mixture of technical and non-technical backgrounds. 

Responsibilities 

• Design and implement data models using modern data platforms (e.g., Microsoft Fabric, Databricks, Snowflake), ensuring alignment with enterprise architecture and analytics goals. 

• Deploy and operationalise analytical models, ensuring they are scalable, maintainable, and integrated into business workflows. 

• Work closely with finance teams, data engineers, and business analysts to understand requirements and deliver data solutions that meet operational and strategic needs. 

• Design and implement intuitive Power BI reports and enhance with advanced analytics. 

• Build and maintain datasets that integrate SAP and non-SAP financial data sources, enabling seamless access for reporting and analytics. 

• Ensure metadata is accurately captured and maintained for lineage and governance. 

• Work closely with finance teams, data engineers, and business analysts to understand requirements and deliver data solutions that meet operational and strategic needs. 

• Adhere to enterprise data standards and governance frameworks. 

• Assesses the functions objectives and requirements of the organisation partnering with us. 

• Determines the appropriate method of data integration and methodology, analyses and interprets information gained and implements recommendations.  

• Use data to identify problems concerned with business strategy, organisation, procedures & performance and present findings. 

• Analyses and interprets information gained and makes recommendations to business partners. 

Experience 

• Degr