Sr. Analyst / Manager - Business Intelligence Analyst

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.

Eli Lilly Cork is made up of a talented diverse team of over 2000 employees across 60 nationalities who deliver innovative solutions that add value across a variety of Business Service functions including Finance, Information Technology, Medical, Clinical Trials and more. Eli Lilly Cork offers a premium workspace across our campus in Little Island, complete with flexible hybrid working options, healthcare, pension and life assurance benefits, subsidised canteen, onsite gym, travel subsidies and on-site parking. Inhouse People Development services, Educational Assistance, and our ‘Live Your BEST Life’

wellbeing initiatives are just some of the holistic benefits that enhance the career experience for our colleagues.

Eli Lilly Cork is committed to diversity, equity and inclusion (DEI). We cater for all dimensions ensuring inclusion of all ethnicities, nationalities, cultural backgrounds, generations, sexuality, visible and invisible disabilities and gender, with four pillars: EnAble, embRACE, LGBTQ+ & Ally and GIN-Gender Inclusion Network. EnAble, our pillar for people with disabilities and those that care for them, partners with the Access Lilly initiative to make our physical and digital environment accessible and inclusive for all. Together they are committed to promoting awareness to create a disability confident culture both at Eli Lilly Cork and beyond.

Come join our team - Be Creative, Be an Innovator, and most of all, Be Yourself!

The GCOA team is responsible for finding, assessing, and developing solutions within Lilly’s business service towers, and consulting with teams on the most effective approach to leveraging technology to automate and enhance their processes and procedures. Solutions can range from RPA to Power Platform to analytics.

This role 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.
• 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.
• Promote data accessibility by developing datasets that are secure, reliable, and easy to consume across business units.
• 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.

Experience

• 3+ years’ experience in data modelling and schema design, preferably within Microsoft Fabric or similar platforms.
• 3+ years' hands-on experience in developing and operationalizing analytical models
• 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 ability to work, remotely, across time zones
• Stakeholder management skills
• Team player who is dynamic and result oriented

Education

• 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.

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.