Data Engineer

Johns Hopkins University • Full-time • Remote (Baltimore, Maryland, United States) • $99.80k - $175k / year • 2d ago

IT@JH Office of Deputy CIO is seeking a Data Engineer whois responsible for the data architecture and integration of university processes, systems and data to improve reporting and analytics across functions, offices and schools. This includes the architecture, design and implementation of infrastructure and operations for the University Data Warehouse (UDW), complementary Lakehouse, and other modern data technologies.

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 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.

On-Call Rotation

Seven day on-call rotation required

Minimum Qualifications

Bachelor's Degree required.
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

Five years progress responsibility for data architecture in complex environment, extensive experience with relational, analytic, and other primary data and BI development approaches
Implementation and support experience with large-scale real-time and batch ETL/ELT for data ingestion and integration
Experience in dimensional modeling, student systems and information, APIs, advanced SQL, Power BI, Fabric, Azure, pipelines

Classified Title: Data Engineer
Role/Level/Range: ATP/04/PG
Starting Salary Range: $99,800 - $175,000 Annually (Commensurate w/exp.)
Employee group: Full Time
Schedule: Mon-Fri 8:30am-5:00pm
FLSA Status: Exempt
Location: Remote
Department name: IT@JH Office of the Deputy CIO
Personnel area: University Administration

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 strongly encourages, but no longer requires, at least one dose of the COVID-19 vaccine. The COVID-19 vaccine does not apply to positions located in the State of Florida. We still require all faculty, staff, and students to receive the seasonal flu vaccine. Exceptions to the COVID and 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. This change does not apply to the School of Medicine (SOM). SOM hires must be fully vaccinated with an FDA COVID-19 vaccination and provide proof of vaccination status. For additional information, applicants for SOM positions should visit https://www.hopkinsmedicine.org/coronavirus/covid-19-vaccine/ and all other JHU applicants should visit https://covidinfo.jhu.edu/health-safety/covid-vaccination-information/.

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.