Data Engineer for KDI

Oak Ridge National Laboratory - Oak Ridge, TN

Full-time - Entry Level

Oak Ridge, TN

Professional, Scientific, and Technical Services

About the position

We are hiring a Data Engineer for KDI to focus on work with the sponsors and research users to deliver and maintain data pipelines including ETL and reporting workflows as well as data management and data lifecycles! The Knowledge Discovery Infrastructure (KDI) program serves to facilitate research activities on data that has been entrusted to ORNL by the U.S Department of Veteran's Affairs (VA) and other agencies. As such, you will have the opportunity to work on some of the most ambitious and impactful research and development programs in healthcare informatics, bioinformatics, and computer science. This position resides in the Emerging Technologies & Computing group of the Research Computing division of the Information Technology Services Directorate at Oak Ridge National Laboratory (ORNL). Our Data Engineers should be comfortable with several technologies including Linux, SQL, Python, containers, Pandas, Spark, and source control in a high security environment.

Responsibilities

• Developing high-scale, robust data warehouses, and data lakes with special focus on the state-of-the-art solutions for healthcare, life sciences, and genomics.
• Working with research teams to understand data needs, and providing domain expertise to research teams, and other team members about the data models, query optimizations, and schema interpretation.
• Designing, building, and launching new data marts for the major national research programs and for ETL processes.
• Designing and developing architectures for intake, curation, organization, and dissemination of data in support of data science and related fields.
• Designing and development of high-performance database architectures.
• Researching and evaluating the state-of-the-art data and information management technologies.
• Working on a variety of data assignments; collaborate with scientists and engineers and expect to produce reliable data products and systems.
• Deliver ORNL's mission by aligning behaviors, priorities, and interactions with our core values of Impact, Integrity, Teamwork, Safety, and Service. Promote diversity, equity, inclusion, and accessibility by encouraging a respectful workplace.

Requirements

• A BS in computer science, information technology, mathematics, engineering, or a related field of study and two (2) to four (4) years of aligned experience is required for consideration.
• Two (2) 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 of study.
• At least 2 years of proven experience in basic and advanced SQL, database programming, and scripting languages (Python preferred).
• Experience in data warehousing systems and data driven software development.
• Solid understanding of database system administration.
• Demonstrated expertise with OLTP and data warehousing, SQL Server is preferred.
• Experience in designing analytics data systems.
• Experience working with Big Data processing frameworks such as Spark, Dask, and Pandas and familiarity with NoSQL architectures.
• Demonstrated experience with collecting, organizing, storing, and preparing data analysis.
• Experience with health care informatics is highly desired.
• Working experience or basic understanding of AI/ML data requirements.

Benefits

• Medical and retirement plans
• Flexible work hours
• On-site fitness facilities
• Banking facilities
• 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