Sightline Data Engineer I (Sightline Information Technology)

The Johns Hopkins University; Baltimore (MD); Presencial; USD 88.000 - 154.000; Jornada completa

Descripción de la vacante

The Johns Hopkins University is seeking a Sightline Data Engineer I to help build and maintain complex data pipelines from raw data to visualization. You will support ETL/ELT processes, data acquisition, and data quality monitoring across diverse sources for policy-relevant research.

Responsibilities include developing back-end code to power data apps, writing data manipulation scripts, and collaborating with researchers, analysts, and partners. Location: Mount Washington Campus, Baltimore.

Formación

• Bachelor's Degree and at least three years of related experience, or equivalent education/experience.
• Experience with data pipelines, ETL/ELT, and cloud-based analytics.
• Knowledge of Azure data services and data governance principles.

Responsabilidades

• Design, produce, and maintain data pipelines for data acquisition, management, and transformation.
• Develop and maintain ETL/ELT processes across structured and unstructured data.
• Create scripts to clean, transform, and analyze data for visualization.
• Monitor data quality and troubleshoot data infrastructure.
• Collaborate with researchers, analysts, and partners across the organization.

Conocimientos

Microsoft Fabric

Lakehouse Architecture

Cloud Data Eng (Azure)

Python Data Notebooks

CI/CD DevOps

IaC

Data Observability

Cloud Data Architecture

Educación

Bachelor's Degree

Descripción del empleo

• Cloud Data Engineering (Azure Preferred) - Intermediate


• Python Development & Data Engineering Notebooks - Intermediate

We are seeking a Sightline 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.

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 Microsoft Fabric or similar cloud-based analytics and data engineering platforms.


• Experience designing and maintaining data pipelines in cloud environments.


• Experience developing and maintaining Python-based data engineering solutions.


• Familiarity with DevOps methodologies, version control systems, and CI/CD deployment practices.


• Experience implementing Infrastructure as Code (IaC) solutions using industry-standard tools and frameworks.


• Knowledge of modern data lake, lakehouse, and data warehouse architectures.


• Familiarity with cloud platforms such as Microsoft Azure and related data services.


• Understanding of data governance, security, and data lifecycle management principles.

Preferred Technical Skills

• Microsoft Fabric - Intermediate


• Lakehouse Architecture & Data Management - Intermediate


• Cloud Data Engineering (Azure Preferred) - Intermediate


• Python Development & Data Engineering Notebooks - Intermediate


• CI/CD and DevOps Practices - Intermediate


• Infrastructure as Code (IaC) - Intermediate


• Data Platform Monitoring & Observability - Intermediate


• Cloud Data Architecture - Intermediate

Classified Title: Data Engineer I

Job Posting Title (Working Title): Sightline Data Engineer I (Sightline Information Technology)

Role/Level/Range: ATP/04/PF

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

Employee group: Full Time

Schedule: Monday - Friday 8:30 am - 4:30 pm

FLSA Status: Exempt

Location: Mount Washington Campus

Department name: Sightline

Personnel area: University Administration