Affiliated Office Address

Baltimore, MD, United States

Requisition ID

122371

Date Created

August 31, 2026

Job Family

Data Management

Job Subfamily

Data Management

Job Function

Information Technology

Exempt Status

Exempt

Shift Type

Full Time

Schedule

Mon-Fri; 8:30am-5pm

Worksite

01-MD:Homewood Campus

Work Modality

Remote: Not on-site or < 10% of hours worked on-site

The Library Systems department of Sheridan Libraries, Archives, and Museums is seeking a Data Engineer II. This position has primary responsibility for data extract, transform, and load (ETL) processes across all Library operations except cataloging and collection management. The role is responsible for ensuring data capture workflows, translation processes, deposit methods, and quality assurance protocols meet the requirements of the Libraries. Processed data and data systems support data access and reuse, analytics and assessment, strategic planning, marketing and communications, operational efficiency improvements, and metadata enrichment and crosswalks. The data engineer will follow an iterative design and development approach with continual review cycle conducted in collaboration with stakeholders and Library leadership.

The Data Engineer II will also design, produce, and maintain software infrastructure to automatically extract, transform, and load data from diverse sources. Additionally, this role will input/output data from databases, realize complex queries, and be responsible for the creation of scripts for data manipulation, cleaning, filtering, and preparation of data outputs to be used for data visualization or web display. This work will also include creating systems to monitor and guarantee data quality, perform daily data quality assurance tasks, maintain, and troubleshoot the infrastructure, and audit data sources. Lastly, the data engineer will also contribute to exploration and analysis of data to answer policy-related questions as needed.

Specific Duties & Responsibilities

Collaborate with Business Analysts to manage roadmap for ETL and reporting projects.
Serve as team lead for ETL and data exchange software development life cycle.
Lead the development of tools and process to capture, normalize, and make available research and library collections data for study and research through the central data store and AI-ready data platform being developed by Library IT.
Support library catalog and institutional repository systems through work with bibliographic metadata, including quality assurance, large-scale enrichment and corrections, and creating crosswalks to exchange or migrate metadata between systems that use different metadata schemas.
Documentation of data pipelines for both developers and non-technical stakeholders following best practices for technical writing and systems diagrams.
Contribute to the design, production, and maintenance of data pipelines for data acquisition, management, transformation, and back-end code development to power data web applications and convert raw data into usable information.
Write and maintain ETL/ELTs that operate on a variety of structured and unstructured sources.
Develop and maintain web data scraping systems for automatic data acquisition.
Help design data architecture and provide ongoing support.
Input/output data from databases and perform queries.
Create scripts to clean, transform, and analyze data.
Put into 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.
Collaborate with 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 duties & responsibilities above

Collaborate with Business Analysts to manage roadmap for ETL and reporting projects.
Serve as team lead for ETL and data exchange software development life cycle.
Lead the development of tools and process to capture, normalize, and make available research and library collections data for study and research through the central data store and AI-ready data platform being developed by Library IT.
Support library catalog and institutional repository systems through work with bibliographic metadata, including quality assurance, large-scale enrichment and corrections, and creating crosswalks to exchange or migrate metadata between systems that use different metadata schemas.
Documentation of data pipelines for both developers and non-technical stakeholders following best practices for technical writing and systems diagrams.

Minimum Qualifications

Bachelor’s Degree.
Five years of related work experience focused within database management and design and business requirement gathering.
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

Proficiency in working with bibliographic metadata standards including MARC and Dublin Core.
Familiarity with Business Intelligence systems and tools such as Power BI and Tableau.
Experience with AWS and Microsoft Azure data utilities
Experience designing and implementing ETL processes using stored procedures in an enterprise SQL Server environment. Experience performing data normalization following traditional and dimensional data modelling.
Experience developing software and scripts (using SQL, Python, or other relevant languages) to automate ETL and other data analysis and manipulation tasks.
Demonstrated ability and willingness to learn, adopt, and apply emerging technologies, including AI-enabled tools, in support of professional responsibilities.

Technical Skills & Expected Level of Proficiency

Data Management and Analysis - Intermediate
Data Pipeline Architecture & ETL/ELT Development - Intermediate
Database Querying - Intermediate
Data Validation and Quality Assurance - Intermediate
Data Visualization - Intermediate
Data Warehousing & Architecture - Intermediate
Oral and written communications: Intermediate
Programming Languages - 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 II

Role/Level/Range: ATP/04/PG

Starting Salary Range: $102,295 - $140,835 - $179,375 Annually (Commensurate w/exp.)

Employee group: Full Time

Schedule: Mon-Fri; 8:30am-5pm

FLSA Status: Exempt

Location: Remote

Department name: Library Systems

Personnel area: Libraries

Total Rewards

The referenced base salary range represents the low and high end of Johns Hopkins University’s salary range for this position. Not all candidates will be eligible for the upper end of the salary range. Exact salary will ultimately depend on multiple factors, which may include the successful candidate's geographic location, skills, work experience, market conditions, education/training and other qualifications. Johns Hopkins offers a total rewards package that supports our employees' health, life, career and retirement. More information can be found here: https://hr.jhu.edu/benefits-worklife/.

Education and Experience Equivalency

Please refer to the job description above to see which forms of equivalency are permitted for this position. If permitted, equivalencies will follow these guidelines: JHU Equivalency Formula: 30 undergraduate degree credits (semester hours) or 18 graduate degree credits may substitute for one year of experience. Additional related experience may substitute for required education on the same basis. For jobs where equivalency is permitted, up to two years of non-related college course work may be applied towards the total minimum education/experience required for the respective job.

Applicants Completing Studies

Applicants who do not meet the posted requirements but are completing their final academic semester/quarter will be considered eligible for employment and may be asked to provide additional information confirming their academic completion date.

Background Checks

The successful candidate(s) for this position will be subject to a pre-employment background check. Johns Hopkins is committed to hiring individuals with a justice-involved background, consistent with applicable policies and current practice. A prior criminal history does not automatically preclude candidates from employment at Johns Hopkins University. In accordance with applicable law, the university will review, on an individual basis, the date of a candidate's conviction, the nature of the conviction and how the conviction relates to an essential job-related qualification or function.

Diversity and Inclusion

The Johns Hopkins University values diversity, equity and inclusion and advances these through our key strategic framework, the JHU Roadmap on Diversity and Inclusion.

Equal Opportunity Employer

All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.

EEO is the Law

https://www.eeoc.gov/sites/default/files/2023-06/22-088_EEOC_KnowYourRights6.12ScreenRdr.pdf

Accommodation Information

If you are interested in applying for employment with The Johns Hopkins University and require special assistance or accommodation during any part of the pre-employment process, please contact the Talent Acquisition Office at jhurecruitment@jhu.edu. For TTY users, call via Maryland Relay or dial 711. For more information about workplace accommodations or accessibility at Johns Hopkins University, please visit: https://accessibility.jhu.edu/.

Vaccine Requirements

Johns Hopkins University requires all faculty, staff, and students to receive the seasonal flu vaccine. Exceptions to the flu vaccine requirements may be provided to individuals for religious beliefs or medical reasons. Requests for an exception must be submitted to the JHU vaccination registry.

The following additional provisions may apply, depending upon campus. Your recruiter will advise accordingly.

The pre-employment physical for positions in clinical areas, laboratories, working with research subjects, or involving community contact requires documentation of immune status against Rubella (German measles), Rubeola (Measles), Mumps, Varicella (chickenpox), Hepatitis B and documentation of having received the Tdap (Tetanus, diphtheria, pertussis) vaccination. This may include documentation of having two (2) MMR vaccines; two (2) Varicella vaccines; or antibody status to these diseases from laboratory testing. Blood tests for immunities to these diseases are ordinarily included in the pre-employment physical exam except for those employees who provide results of blood tests or immunization documentation from their own health care providers. Any vaccinations required for these diseases will be given at no cost in our Occupational Health office.

Data Engineer II (Library Systems)

Job description