IT@JH Office of Deputy CIO is seeking a Data Engineer who is 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.

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

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