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

• Degree in sciences or quantitative discipline i.e., Statistics, Mathematics, Finance, Engineering or Computer Sciences from Tier-I institute. MBA/post-graduation will be preferred.
• 3+ years’ experience in data modelling and schema design, preferably within Microsoft Fabric or similar platforms.
• 3+ years' experience in developing, deploying and maintaining analytical models in production environments, including performance monitoring and model lifecycle management.
• 3+ years' experience in data visualization in Power BI.
• Skilled in leveraging DAX in Power BI, ensuring scalable and responsive Power BI reports across large datasets.
• Strong understanding of financial data structures and reporting requirements.
• Familiarity with SAP S4, Ariba, and other finance-related data sources is a plus.
  
  
  

Behavioural Skills

• Strong work ethic and personal motivation
• Strong analytical thinking and problem-solving skills.
• Ability to translate complex data into actionable insights for non-technical audiences.
• Good presentation skills.
• Interpersonal and communication skills, with the ability to work remotely across time zones.
• Stakeholder management skills.
• Team player who is dynamic and results-oriented.
  
  
  

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.

#WeAreLillyUKandIreland