Data Engineer I (HR Data and Analytics)

John Hopkin’s University

Baltimore (MD)

Hybrid

USD 88,000 - 154,000

Full time

14 days+

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

The Johns Hopkins University seeks a Data Engineer I to design and maintain data pipelines, enabling acquisition, transformation, and delivery of data for visualization and decision support. You will work on ETL/ELT processes, data quality monitoring, and scripts for data cleaning and preparation, collaborating with researchers, policy experts, and developers across the organization.

This hybrid role at Johns Hopkins University emphasizes enterprise data architectures, HR analytics, and scalable

Qualifications

Bachelor’s degree required with related experience.
Three years of relevant experience or equivalent education substituted per policy.
Experience with ETL/ELT and data warehousing concepts.

Responsibilities

Design, develop, and maintain data pipelines for acquisition, management, and transformation.
Develop and maintain ETL/ELTs across sources, structured and unstructured.
Support data scraping systems and data architecture, ensuring data quality.
Input/output data from databases and perform queries to aid analyses.
Create scripts to clean, transform, and analyze data for visualization.

Skills

Data pipeline

ETL/ELT development

Database querying

Data warehousing

Data validation

Web scraping

Programming languages

Troubleshooting

Project management

Education

Bachelor’s Degree

Tools

Workday HCM

SAP HCM

HR data warehouse

Power BI

Tableau

Workday Reporting

Prism Analytics

Job description

We are seeking a Data Engineer I to 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.

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.

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 working with Workday HCM, including workforce, organizational, position, job, compensation, talent, and security data structures.
Familiarity with HR technology ecosystems and integrations, including Workday HCM, SAP HCM, HR data warehouses, and reporting platforms.
Understanding of human resources data domains and workforce analytics, including recruiting, talent management, compensation, organizational management, learning, and employee lifecycle processes.
Knowledge of HR data governance, metadata management, data dictionaries, and standardized data definitions.
Experience supporting large-scale HR system implementations, migrations, or transformations, particularly HCM platform transitions.
Familiarity with enterprise reporting and analytics tools such as Power BI, Tableau, Workday Reporting, Prism Analytics, or similar platforms.
Experience supporting data quality monitoring, reconciliation, and audit processes for HR and workforce data.

Technical Skills & Expected Level Of Proficiency