Sightline Data Engineer I

Johns Hopkins University; Baltimore (MD); Hybrid; USD 88,000 - 154,000; Full time

Job summary

Johns Hopkins University is seeking a Sightline Data Engineer I to build and maintain data pipelines from raw data to visualization. You will support software infrastructure for automatic data extraction, transformation, and loading, and help input/output data in databases with complex queries.

The role includes monitoring data quality, auditing sources, and collaborating with multiple teams to answer policy-relevant questions. Remote work is limited to under 10% on-site at Baltimore.

Qualifications

• Bachelor’s degree and 3 years of related experience or higher education substitutions per policy.
• Experience designing and maintaining data pipelines and data workflows.
• Familiarity with cloud-based analytics platforms and Python-based tooling.

Responsibilities

• Design, produce, and maintain data pipelines for acquisition, management, and transformation.
• Contribute to ETL/ELT processes across structured and unstructured data sources.
• Develop and maintain web data scraping systems for automatic data acquisition.
• Assist in data architecture design and maintain database inputs/outputs and queries.
• Create scripts to clean, transform, and analyze data for production pipelines.
• Develop production software to monitor data quality and detect anomalies; perform QA tasks.
• Support, maintain, and troubleshoot the software infrastructure.
• Source data, analyze, visualize, and generate insights for ongoing research and requests.
• Collaborate with researchers, analysts, data scientists, partners, and vendors.

Skills

Data pipeline design

ETL/ELT development

Python scripting

Data quality monitoring

Collaboration with stakeholders

Education

Bachelor’s degree

Tools

Microsoft Fabric

Azure Cloud

CI/CD

Infrastructure as Code

Job description

Sightline Data Engineer I (Sightline Information Technology)

Sightline, Johns Hopkins University Administration | Baltimore, MD | Remote (less than 10% on-site) | Full-time, Exempt | Requisition 122431

Starting salary range: $87,635 - $153,545 annually (commensurate with experience) | Schedule: Monday-Friday 8:30 am - 4:30 pm

About the Role

Johns Hopkins University is 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, help input and output data from databases and realize complex queries, and support the creation of scripts for data manipulation, cleaning, filtering, and preparation of data outputs for visualization or web display.

The role also includes creating parts of systems to monitor and guarantee data quality, performing daily data quality assurance tasks, maintaining and troubleshooting the infrastructure, auditing data sources, and exploring and analyzing data to answer policy-related questions as needed.

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.
• 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 in designing data architecture and provide ongoing support, including database input/output and queries.
• Assist in the creation of scripts to clean, transform, and analyze data, and contribute to production data pipelines using data warehousing systems.
• Create and implement production software to monitor data quality and detect data anomalies, and 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, and collaborate with external partners, contractors, and vendors.

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 high school, 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 and developing Python-based data engineering solutions.
• Familiarity with DevOps methodologies, version control systems, and CI/CD deployment practices.
• Experience implementing Infrastructure as Code (IaC) solutions.
• 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.