Snr Associate / Manager, Data Engineer

Eli Lilly

Eli Lilly

Data Science
Cork, Ireland
Posted on Saturday, August 31, 2024

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.

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 39,000 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 patients around the world.

Eli Lilly Cork, is made up of a talented diverse team of over 1,600 employees across 38 nationalities who deliver innovative solutions that add value across a variety of Business Service functions including Finance, Information Technology, Medical, Clinical Trials and more.

Lilly offers a premium workspace across our campus in Little Island, complete with flexible hybrid working options, healthcare, pension and life assurance benefits, subsidized 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.


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

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

What You’ll Be Doing:

A data engineer is responsible for designing, developing, and maintaining the data solutions that ensure the availability and quality of data for analysis and/or business transactions. They design and implement efficient data storage, processing and retrieval solutions for datasets and build data pipelines, optimize database designs, and work closely with data scientists, architects, and analysts to ensure data quality and accessibility. Data engineers require strong skillsets in data integration, acquisition, cleansing, harmonization, and transforming data. They play a crucial role in transforming raw data into datasets designed for analysis which enable organizations to unlock valuable insights for decision making.

How You’ll Succeed:

· Engage and partner with cross-functional tech teams across Global Services, internal partners, third party solution delivery providers, and data architects to understand the business problem and enhance/develop the appropriate data solution leveraging the modern tech stack

· Design and implement highly performant data ingestion/processing pipelines from multiple sources

· Develop technical solutions which combine disparate information to create meaningful insights for business partners

· Operate with a quality mindset always considering the impact of design decisions on the long-term support and maintenance of data pipelines/jobs

· Ensure data integrity, security, and privacy requirements are met · Stay abreast of tools and technologies to influence our strategy so that it provides best usage opportunities for business

What You Should Bring:

· A foundational set of knowledge in: communication, leadership, teamwork, problem solving skills, solution / blueprint definition, business acumen, architectural processes (e.g. blueprinting, reference architecture, governance, etc.), technical standards, project delivery, and industry knowledge.

· Strong skillsets in data integration, acquisition, cleansing, harmonization, and transforming data

· Experience designing large scale data models for functional, operational, and analytical environments (Conceptual, Logical, Physical & Dimensional)

  • Experience in several of the following disciplines: statistical methods, data modeling, ontology development, semantic graph construction and linked data, relational schema design.
  • Demonstrated SQL/PLSQL and data modeling proficiency.
  • Experience with data modeling tools
  • Experience in 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 data sets
  • 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 effective data loading strategy (CDC, incremental loads)
  • Demonstrated ability to analyze large, complex data domains and craft practical solutions for subsequent data exploitation via analytics.
  • Demonstrated ability to communicate with a geographically dispersed group of business and technical colleagues
  • Ability to review and provide practical recommendations on design patterns, performance considerations & optimization, database versions, and database deployment strategies
  • Knowledgeable in data functions such as Data Governance, Master Data Management, Business Intelligence
  • Experience with PowerBI

Basic Qualifications:

· Bachelors Degree in computer science, information technology, or management information systems.

· Experience in data integration, acquisition, cleansing, harmonization, and transforming data

· Demonstrated ability to analyze large, complex data domains and craft practical solutions for subsequent data exploitation via analytics.

Additional Preferences:

· CDMP Certification or will consider obtaining certification within a year

· AWS Solution Architect or will consider obtaining certification within a year

· Understanding of a highly regulated environment that involves data privacy and confidential information requirements

Eli Lilly and Company, Lilly USA, LLC and our wholly owned subsidiaries (collectively “Lilly”) are committed to help individuals with disabilities to participate in the workforce and ensure equal opportunity to compete for jobs. If you require an accommodation to submit a resume for positions at Lilly, please email Lilly Human Resources ( Lilly_Recruiting_Compliance@lists.lilly.com ) for further assistance. Please note This email address is intended for use only to request an accommodation as part of the application process. 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.

#WeAreLilly