Data Engineer I (Epidemiology)

John Hopkin’s University; Baltimore (MD); Sur place; USD 88 000 - 154 000; Plein temps

Résumé du poste

Johns Hopkins University seeks a Data Engineer I to help design and maintain data pipelines, ETL/ELT processes, and data quality systems for research projects focused on epidemiology and disease dynamics.

The role supports extraction, transformation, and loading of data from diverse sources, including web scraping, and collaborates with researchers to produce actionable insights for public health policy.

Qualifications

• Bachelor’s degree required. Three years of related experience. Additional education may substitute for experience.
• Experience in infectious disease modeling and epidemiology is preferred.
• Proficiency in R and handling big data encouraged.

Responsabilités

• Design, produce, and maintain data pipelines for acquisition, management, and transformation.
• Develop and maintain ETL/ELT processes for structured and unstructured data.
• Build web data scraping systems for automatic data collection.
• Assist data architecture design and provide ongoing support.
• Handle input/output from databases and execute queries.
• Create scripts to clean, transform, and analyze data.
• Develop production data pipelines and data warehousing solutions.
• Monitor data quality and detect anomalies in production systems.
• Perform daily data quality assurance tasks and troubleshoot infrastructure.
• Collaborate with researchers, policy experts, and partners to generate insights.

Connaissances

Data pipeline architecture

ETL/ELT development

Database querying

Data tools

Data validation & QA

Data warehousing

Project management

Programming languages

Troubleshooting

Web scraping & data acquisition

Formation

Bachelor's Degree

Outils

R programming

Big data management

Description du poste

We are seeking a Data Engineer I who will assist with the creation and maintenance of complex data pipelines from raw acquisition of data to visualization. The Data Engineer I will support the design, production, and maintenance of software infrastructure to automatically extract, transform, and load data from diverse sources. The Data Engineer I will help input/output data from databases and realize complex queries. The Data Engineer I will support the creation of scripts for data manipulation, cleaning, filtering, and preparation of data outputs to be used for data visualization or web display. This will also include creating parts of systems to monitor and guarantee data quality, perform daily data quality assurance tasks, maintain, and troubleshoot the infrastructure, and audit data sources. The Data Engineer I will help explore and analyze data to answer policy-related questions as needed.

The Data Engineer I will lead the development of mathematical and statistical models of infectious disease transmission including a focus on the analysis of epidemiological and molecular data sets about infection dynamics. The Data Engineer I will develop statistical tools to analyze infectious disease dynamics. This project will focus on the use of various data sets (human behavior, genomics, serological status, and epidemiological information) to predict the spatial and temporal dynamics of vector-borne (malaria, dengue) and vaccine-preventable (SARS-CoV-2, measles, rubella) diseases. The position will require the development, evaluation, and investigation of statistical frameworks to understand disease transmission and ultimately inform public health policy.

Specific Duties & Responsibilities

• Assist with the design, production, and maintenance of data pipelines for data acquisition, management, and transformation, and back-end code development to power data web applications and convert raw data into usable information.
• Contribute to writing and maintenance of ETL/ELTs that operate on a variety of structured and unstructured sources.
• Assist with the development and maintenance of web data scraping systems for automatic data acquisition.
• Assist design data architecture and provide ongoing support.
• Assist with input/output data from databases and perform queries.
• Assist in the creation of scripts to clean, transform, and analyze data.
• Contribute to production data pipelines using data warehousing systems.
• Create and implement production software to monitor data quality and detect data anomalies.
• Perform daily manual data quality assurance tasks.
• Support, maintain, and troubleshoot the software infrastructure.
• Source data, conduct analyses, visualize data, and generate insights to support ongoing research projects and other requests across the organization.
• Assist developers, analysts, data scientists, researchers, policy experts, and other partners.
• Communicate with division leadership, and others on the team.
• Collaborate with external partners, contractors, and vendors.
• Other duties as assigned.

In addition to the duties described above

• Develop infectious disease models.
• Integrate molecular and epidemiological data into computational frameworks.
• Create reproducible analyses and code.

Minimum Qualifications

• Bachelor’s Degree.
• Three years of related experience.
• Additional education may substitute for required experience, and additional related experience may substitute for required education beyond a high school diploma/graduation equivalent, to the extent permitted by the JHU equivalency formula

Preferred Qualifications

• Experience in infectious disease modeling is essential, particularly those related to vaccine-preventable, vector-borne diseases, and/or general infectious disease epidemiology.
• Experience in advanced biostatistical and mathematical methods.
• Experience with coding in R and management of 'big data'.
• Experience working on spatial transmission models and working on the epidemiology of vaccine-preventable diseases.
• Knowledge of infectious disease epidemiology.

Technical Skills & Expected Level Of Proficiency

• Data Pipeline Architecture & ETL/ELT Development - Intermediate
• Database Querying - Intermediate
• Data Tools and Platforms - Intermediate
• Data Validation and Quality Assurance - Intermediate
• Data Warehousing & Architecture - Intermediate
• Project Management - Intermediate
• Programming Languages - Intermediate
• Troubleshooting - Intermediate
• Web Scraping and Data Acquisition - Intermediate

The core technical skills listed are most essential; additional technical skills may be required based on specific division or department needs.

Classified Title: Data Engineer I

Role/Level/Range: ATP/04/PF

Starting Salary Range: $87,635 - $153,545 Annually (Commensurate w/exp.)

Employee group: Full Time

Schedule: Monday to Friday: 9:00am - 5:00pm

FLSA Status: Exempt

Location: School of Public Health

Department name: Epidemiology

Personnel area: School of Public Health