Data Analytics

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, Age & Culture, LGBTQ+ 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

Overview:

The candidate will be responsible for designing, developing, and maintaining advanced data analytics, reporting and dashboarding solutions using Analytical tools like PowerBI, Tableau, QuickSight and SQL databases. The ideal candidate will have over 10 years of experience in data analysis, with a strong focus on creating semantic models and utilizing complex DAX measures. A limited understanding of AWS and Azure Cloud technologies is an advantage to have.

Key Responsibilities:

1. Develop, implement, and maintain complex dashboards and reports using PowerBI, Tableau and QuickSight.
2. Design and optimize SQL queries to extract, transform, and load data from various sources.
3. Create and manage effective semantic models across cloud platforms and source applications to support data analysis and reporting needs.
4. Utilize DAX measures to enhance data analysis capabilities within PowerBI or in other relevant technology stack.
5. Collaborate with cross-functional teams to gather requirements and deliver data-driven information insights.
6. Ensure data accuracy, integrity, and security maintained across all reporting solutions.
7. Provide training and support to end-users on the use of reporting tools and dashboards.
8. Stay updated with the latest trends and best practices in data analysis and reporting.
9. Assist in the integration of AWS and Azure Cloud technologies into existing data workflows.
10. Ability to create dataflows and Power Queries to do minimalistic ETLs when required for dynamic transformations.

Qualifications:

1. Bachelor's degree in Computer Science, Information Technology, Data Science, or a related field.
2. Over 8 years of experience in data analysis, reporting, and dashboarding.

Additional Skills/Preferences:

1. Data Programmatic skills in Python, R, Spark and Notebooks.
2. Expert proficiency in Visualization tools like PowerBI, Tableau, and SQL databases.
3. Strong understanding of creating semantic models and using DAX measures.
4. Limited understanding of AWS and Azure Cloud technologies.
5. Excellent analytical, problem-solving, and communication skills.
6. Ability to work independently and as part of a team in a fast-paced environment.