This role supports the design and deployment of complex data architectures to enable robust data integration, curation, and analysis across enterprise research pipelines. The position uses tools such as Databricks, Microsoft Fabric, ETL solutions, and Python to manage data workflows within Johns Hopkins University IT@JH Univ Data Analytics & Engineering.
Responsibilities
- Contribute to the design, production, and ongoing 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 and ELT processes that operate across structured and unstructured sources.
- Develop and sustain web data scraping systems to support automatic data collection.
- Assist in data architecture design and deliver ongoing support.
- Handle input and output operations with databases and execute queries.
- Create scripts to clean, transform, and analyze data.
- Deploy production data pipelines within data warehousing environments.
- Develop 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, perform analyses, visualize results, and generate insights to support current research projects and other organizational requests.
- Collaborate with developers, analysts, data scientists, researchers, policy experts, and other partners.
- Communicate with division leadership and team members.
- Coordinate with external partners, contractors, and vendors.
- Perform other duties as assigned.
Requirements
- Bachelor’s Degree.
- Five years of related work experience focused on database management and design, plus business requirements gathering.
- Equivalency options may substitute for required experience or education in accordance with the JHU equivalency formula.
- Experience with data standards such as controlled vocabularies (SNOMED, LOINC, ICD) and the OMOP common data model.
- Experience working with electronic health record data, particularly EPIC data models such as Clarity and Caboodle.
- Experience handling diverse data types, including semi-structured and unstructured data.
- Experience in a decentralized, consensus-driven environment typical of academic institutions.
- Experience directly engaging with end users to understand requirements and implement effective architectures.
- Thorough knowledge of data warehousing, data management principles, and database development.
- Strong proficiency in SQL programming, including query writing, performance tuning, and database technologies.
Technologies
- Databricks
- Microsoft Fabric
- Python
- SQL
- Clarity
- Caboodle
Affiliated Office Address
Baltimore, MD, United States
Requisition ID
121358
Date Created
May 25, 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-5:00pm
Worksite
46-MD:JH at Harbor East
Work Modality
Remote: Not on-site or less than 10 percent of hours on-site
Total Rewards
The base salary range represents the low and high end of Johns Hopkins University's salary band for this role. Not all candidates will be eligible for the upper end. Exact salary will depend on factors including geographic location, skills, work experience, education, and other qualifications. Johns Hopkins offers a comprehensive total rewards package that supports health, life, career and retirement. More information is available 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. JHU Equivalency Formula: 30 undergraduate credit hours or 18 graduate credit hours may substitute for one year of experience. Additional related experience may substitute for required education on the same basis. Up to two years of non-related college coursework may be applied toward the total minimum education/experience for the respective job.
Applicants Completing Studies
Applicants who have not yet completed their degree but are in their final academic term may be considered eligible for employment and may be asked to provide documentation confirming their completion date.
Background Checks
A pre-employment background check is required. Johns Hopkins supports consideration of applicants with a justice-involved background in accordance with policy. A prior criminal history does not automatically disqualify a candidate; each case is reviewed individually to determine relevance to essential job qualifications.
Diversity and Inclusion
Johns Hopkins University values diversity, equity and inclusion and pursues these goals through 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
For special assistance or accommodations during the pre-employment process, contact the Talent Acquisition Office at jhurecruitment@jhu.edu. TTY users may call Maryland Relay or dial 711. For workplace accommodations information, visit: https://accessibility.jhu.edu/.
Vaccination Requirements
All faculty, staff and students are required to receive the seasonal flu vaccine. Exceptions for religious beliefs or medical reasons may be requested and must be submitted to the JHU vaccination registry.
The following additional provisions may apply
Depending on campus, a pre-employment physical for clinical areas, laboratories, research subjects, or community contact may require documentation of immune status against Rubella, Rubeola, Mumps, Varicella, Hepatitis B, and vaccination with Tdap. Documentation of two MMR vaccines, two Varicella vaccines, or antibody status may be required. Vaccinations are provided at no cost through the Occupational Health office. The recruiter will advise accordingly.
