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.

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 I

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

The listed salary range represents the minimum and maximum Johns Hopkins University offers for this position, based on a good faith estimate at the time of posting. Actual compensation will vary depending on factors such as location, skills, experience, market conditions, education, and internal equity. Not all candidates will qualify for the highest salary in the range.

Johns Hopkins provides a comprehensive benefits package supporting health, career, and retirement. Learn more: https://hr.jhu.edu/benefits-worklife/.

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