Job Req ID:  113285

Data Engineer

Development and Alumni Relations (DAR) supports Johns Hopkins’ focus on research, teaching and patient care, and its role as a national and global leader in higher education. We create and foster enduring relationships that result in advocacy and philanthropic support for Johns Hopkins University & Medicine; strengthening the institution through partnerships with donors, alumni, volunteer leaders, faculty, students, staff, and patients.


Johns Hopkins University supports a flexible work model which includes four different work modalities. This role has a modified-hybrid work arrangement with an onsite presence of 1-2 days per week. The manager will confirm the team’s core onsite days where the majority/all team members will work in the office. Employees who travel on university business can count those days towards their onsite days.


The primary responsibility of the Data Engineer is data standards and procedures, warehousing, design and development of logical and physical data models and databases, distributed data management, and information management functions. As Data Architect, you will be responsible for:

  • Strategically designing, developing, and implementing data models for an enterprise data warehouse.
  • Act as a primary advocate of data modeling methodologies and data processing best practices.


Specific duties and responsibilities:

  • Create and maintain documentation and define best practices in support of proper change management, security and operational requirements
  • Create the design of physical and logical data warehouse models identifying data sources, data movement, interfaces, and analytics, with the goal of ensuring data quality.
  • Investigate and understand new technologies and additional capabilities of current platforms that support vision of Big Data, leading to their adoption when appropriate.
  • Educate peers and cross-train teammates with Big Data concepts and application of technology to serve DAR needs
  • Create and maintain a current and accurate view of the “bigger data picture” by documenting the data architecture and environment
  • Creatively develop opportunities for data reuse, migration, or retirement
  • Create ETL specification documents
  • Develop testing analysis. Lead functional testing, quality assurance testing and end-user validation.
  • Troubleshoot, diagnose and resolve problems in the data and reporting environment
  • Utilize APIs provided by 3rd party hosted solutions for data collection and interface to data warehouse
  • Be on call for data problems that require immediate resolution
  • Responsible for developing and maintaining robust, scalable data pipelines capable of ingesting and processing large volumes of structured and unstructured data.
  • Oversight of specific projects like implementing a new data warehouse, migrating data to cloud-based storage solutions, or integrating new data sources into existing pipelines.
  • Ensuring the integrity and security of data systems in compliance with company policies and regulatory standards.


This is a term-limited position with a length of up to 24 months.



Minimum Qualifications
  • Bachelor’s degree required.
  • Five years of related work experience focused within database management and design and business requirement gathering.
  • Additional experience may be substituted for education to the extent permitted by the JHU equivalency formula.


Preferred Qualifications
  • Master's degree preferred.
  • Strong and demonstrated experience with data management, high availability, disaster recover, data replication, performance tuning and application integration in data platforms
  • Experience in Data Modeling and Data Warehousing
  • Knowledge of dimensional modeling and other data warehouse design techniques
  • Strong conceptual, problem solving, and analytical skills.
  • Strong knowledge of RDBMS (DB2, Oracle, SQL Server) including SQL
  • Hands on knowledge of technologies/solutions adopted by DAR including but not limited to:
    • Microsoft Power BI
    • Salesforce
    • Tableau
    • MS SharePoint/Teams
    • Talend


All applicants are expected to uphold the university’s core values which includes diversity and inclusion. All staff treat people with dignity and respect by being fair and consistent. We demonstrate an open-minded approach to understanding people regardless of their race, gender, age, national origin, religion, ethnicity, disability status or other characteristics. We show respect for the beliefs and traditions of others; encourage and promote practices that support cultural diversity; and discourage behaviors or practices that may be perceived as unfair, biased, or critical toward people with certain backgrounds.

 


 

Classified Title: Data Engineer 
Job Posting Title (Working Title): Data Engineer   
Role/Level/Range: ATP/04/PG  
Starting Salary Range: Minimum: $98,800 - Maximum: $173,300 (targeted salary: $133,835; commensurate with experience) 
Employee group: Full Time 
Schedule: Monday-Friday 8:30 am - 5:00 pm 
Exempt Status: Exempt 
Location: JH at Keswick 
Department name: 10001640-DAR Customer Service 
Personnel area: University Administration 

 

 

Total Rewards
The referenced salary range is based on Johns Hopkins University’s good faith belief at the time of posting. Actual compensation may vary based on factors such as geographic location, work experience, market conditions, education/training and skill level. 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/.

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

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.

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

Johns Hopkins has mandated COVID-19 and influenza vaccines, as applicable. The COVID-19 vaccine does not apply to positions located in the State of Florida. 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. 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.

JH at Keswick