Data Engineer for KDI (Staff)

Oak Ridge National Laboratory - Oak Ridge, TN

Full-time - Mid Level

Oak Ridge, TN

Professional, Scientific, and Technical Services

About the position

The Data Engineer for KDI will focus on developing and maintaining data pipelines, including ETL and reporting workflows, to support research activities at Oak Ridge National Laboratory (ORNL). This role involves working with various technologies to facilitate impactful research in healthcare informatics, bioinformatics, and computer science, while ensuring data management and lifecycle processes are effectively implemented.

Responsibilities

• Developing high-scale, robust data warehouses and data lakes for healthcare, life sciences, and genomics.
• Working with research teams to understand data needs and providing domain expertise on data models and query optimizations.
• Designing, building, and launching new data marts for national research programs and ETL processes.
• Designing and developing architectures for data intake, curation, organization, and dissemination.
• Researching and evaluating state-of-the-art data management technologies.
• Collaborating with scientists and engineers to produce reliable data products and systems.
• Aligning behaviors and priorities with ORNL's core values of Impact, Integrity, Teamwork, Safety, and Service.

Requirements

• A BS in computer science, information technology, mathematics, engineering, or a related field and 5-7 years of aligned experience.
• Three or more years of proven experience in database design and/or development.

Nice-to-haves

• MS or Doctorate in computer science, information technology, mathematics, engineering, or a related field.
• At least 3 years of experience in SQL, database programming, and scripting languages (Python preferred).
• Experience with data warehousing systems and data-driven software development.
• Solid understanding of database system administration.
• Expertise with OLTP and data warehousing, preferably SQL Server.
• Experience designing analytics data systems and working with Big Data processing frameworks like Spark and Pandas.
• Experience with healthcare informatics and AI/ML data requirements.

Benefits

• Medical and retirement plans
• Flexible work hours
• On-site fitness, banking, and cafeteria facilities
• Prescription Drug Plan
• Dental Plan
• Vision Plan
• 401(k) Retirement Plan
• Contributory Pension Plan
• Life Insurance
• Disability Benefits
• Generous Vacation and Holidays
• Parental Leave
• Legal Insurance with Identity Theft Protection
• Employee Assistance Plan
• Flexible Spending Accounts
• Health Savings Accounts
• Wellness Programs
• Educational Assistance
• Relocation Assistance
• Employee Discounts