Analyst / Sr. Analyst – Data Engineer, Global Transparency at Eli Lilly and Company – IE: Global Business Solutions – Cork

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 deliver life-changing medicines to those who need them, advance the understanding and management of diseases, and give back to our communities through philanthropy and volunteerism. We are dedicated to our work and we put people first. We seek out people who are committed to making life better for people around the world.

At Lilly, we unite care with discovery to make life better for people around the world. We are a global healthcare leader headquartered in Indianapolis, Indiana. Our 39,000 employees around the world work to discover and deliver life-changing medicines to those who need them, advance the understanding and management of diseases, and give back to our communities through philanthropy and volunteerism. We are dedicated to our work and we put people first. We seek out people who are committed to making life better for patients around the world.

Eli Lilly Cork is comprised of a talented and diverse team of more than 1,600 employees from 38 nationalities who deliver innovative solutions that add value to a variety of business services functions, including finance, information technology, medicine, clinical trials and more.

Lilly offers a premium workplace at our Little Island campus, complete with flexible hybrid work options, healthcare, retirement and life insurance benefits, subsidized cafeteria, on-site gym, travel subsidies and on-site parking. Internal People Development services, Educational Assistance and our ‘Live Your BEST Life’ wellbeing initiatives are just some of the holistic benefits that enhance our colleagues’ career experience.

Join our team – be creative, be an innovator and most importantly, be yourself!

Do you enjoy learning new domains of knowledge and answering compelling questions? The Global Transparency Tech at Lilly team is actively seeking a Data Engineer to collaborate with internal business and Tech at Lilly partners to accelerate the delivery of data solutions for analytics and business purposes.

What you will do:

As a Data Engineer within the Global Transparency space, you will be responsible for working with our Global Transparency business team and our Data Architect to help design, develop, and maintain the complex data solutions that ensure the availability and quality of data for analysis and reporting to external government and regulatory functions. We design and implement efficient data storage, processing, and retrieval solutions for datasets and build data pipelines, optimize database designs, and work closely with architects and analysts to ensure data quality and accessibility. Data Engineers require strong skills in data integration, acquisition, cleansing, harmonization, and transformation. They play a critical role in transforming raw data into datasets designed for analysis, enabling organizations to unlock valuable insights for decision making.

How you will succeed:

Collaborate with cross-functional technical teams within Global Services, internal partners, external solution providers, and data architects to understand business challenges and develop/enhance the right data solution leveraging the modern technology stack.
Design and implement high-performance data entry/processing pipelines from multiple sources
Develop technical solutions that combine disparate information to create meaningful insights for business partners
Help us improve our reporting solutions to help our business partners meet ongoing third-party reporting requirements.
Work with a quality mindset and always consider the impact of design decisions on the long-term support and maintenance of data pipelines/tasks.
Ensure data integrity, security and privacy requirements are met. Stay up to date on tools and technologies to influence our strategy so that it provides the best use cases for businesses.

What to bring:

A strong preference for communication. The ability to communicate at all levels, to communicate effectively with individuals from different technical backgrounds.
A self-starter, someone who is curious about how technology works.
Demonstrated self-leadership, teamwork, problem-solving skills, solution/blueprint definition, business acumen, architecture processes (e.g. blueprints, reference architecture, governance, etc.), technical standards, and project delivery.
Strong skills in data integration, acquisition, cleansing, harmonization and transformation
Experience in designing data models for functional, operational and analytical environments (conceptual, logical, physical and dimensional)
Demonstrable knowledge of SQL/PLSQL.
Experience with AWS or Azure Tech Stack
Experience in building/integrating APIs
Experience in creating data products using APIs
Experience with security models and development on large datasets
Experience with multiple database technologies
Experience with multiple database solutions (e.g. Postgres, Redshift, Aurora, Athena) and formal database designs (3NF, dimensional models)
Experience with Agile Development, CI/CD, Jenkins, Github, automation platforms
Experience in implementing an effective data loading strategy (CDC, incremental loads)
Demonstrated ability to analyze large, complex data domains and devise practical solutions for the subsequent exploitation of data through analytics.
Ability to assess design patterns, performance considerations and optimization, database versions, and database implementation strategies and make practical recommendations
Knowledge of data functions such as Data Governance, Master Data Management, Business Intelligence
Experience with PowerBI

Basic requirements:

Bachelor’s degree in Computer Science, Information Technology, or Management Information Systems.
Experience with data integration, acquisition, cleansing, harmonization and transformation
Demonstrated ability to analyze large, complex data domains and devise practical solutions for the subsequent exploitation of data through analytics.

Additional preferences:

AWS Solution Architect or considering obtaining certification within a year
Understanding of a highly regulated environment that places demands on data privacy and confidential information

Lilly is committed to helping people with disabilities participate actively in the workplace and ensuring equal opportunity when competing for positions. If you require an 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 be responded to.

Lilly does not discriminate based on age, race, color, religion, sex, sexual orientation, gender identity, gender expression, national origin, protected veteran status, disability or any other legally protected status.

#WeAreLilly