Data Engineer II

1 week ago

Baltimore, Maryland, United States Johns Hopkins University Full time

Office of Deputy CIO is seeking a Data Engineer II 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

  • Contribute to the design, production, and 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/ELTs that operate on a variety of structured and unstructured sources.
  • Develop and maintain web data scraping systems for automatic data acquisition.
  • Help design data architecture and provide ongoing support.
  • Input/output data from databases and perform queries.
  • Create scripts to clean, transform, and analyze data.
  • Put data pipelines into production 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.
  • Collaborate with 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

This position requires a support rotation, which may entail some off-hour support.

Minimum Qualifications

  • Bachelor's Degree.
  • 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 of progressive 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.

Technical Skills & Expected Level of Proficiency

  • Data Management and Analysis - Intermediate
  • Data Pipeline Architecture & ETL/ELT Development - Intermediate
  • Database Querying - Intermediate
  • Data Validation and Quality Assurance - Intermediate
  • Data Visualization - Intermediate
  • Data Warehousing & Architecture - Intermediate
  • Oral and written communications - Intermediate
  • Programming Languages - Intermediate
    Web Scraping and Data Acquisition - Intermediate

Classified Title: Data Engineer II

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-5pm

FLSA Status: Exempt

Location: Remote

Department name: Office of the Deputy CIO

Personnel area: University Administration

  • Engineering Maintenance Technician I or II

    2 days ago

    Baltimore, Maryland, United States Johns Hopkins Medical Management Corporation Full time

    Overview:Johns Hopkins Intrastaff is the internal staffing agency for the Johns Hopkins Health System and partner hospitals, providing temporary support to a variety of the Johns Hopkins locations. Our employees are the strength of our service. Intrastaff is unique because it's one of the very few agencies where a person has the benefit of being a temporary...

  • Data Engineer I

    1 week ago

    Baltimore, Maryland, United States Johns Hopkins University Full time

    The Pathology Department is seeking a Data Engineer I - Pathology who will assist with the creation and maintenance of complex data pipelines from raw acquisition of data to visualization. The Data Engineer I will support the design, production, and maintenance of software infrastructure to automatically extract, transform, and load data from diverse...

  • Network Engineer II

    1 week ago

    Baltimore, Maryland, United States Johns Hopkins University Full time

    Johns Hopkins Public Safety is seeking a Network Engineer I I who will be responsible for planning, forecasting, implementing, and identifying resource requirements for network backbone infrastructures (inclusive of wireless technologies) of moderate complexity to support the Johns Hopkins Police Department (JHPD) and the Johns Hopkins Public Safety (JHPS)....

  • Coding Specialist II

    2 days ago

    Baltimore, Maryland, United States Johns Hopkins Health System Full time

    YOU BELONG HEREWhat Awaits You?Career growth and developmentEmployee and Dependent Tuition AssistanceDiverse and collaborative working environmentAffordable and comprehensive benefits packageOur competitive Benefit Package is designed to support the well-being and financial security of our employees. You can explore the details of our benefits offering by...

  • Research Project Assistant II

    2 days ago

    Baltimore, Maryland, United States Johns Hopkins University Full time

    We are seeking a Research Project Assistant II who will support the conduct of a research project. Collects and organizes data through study-specific procedures that may include community outreach, data collection, sample collection, laboratory work, and/or field work. Provides general administrative support for meetings/events, communications, reporting,...

  • Research Assistant II

    2 days ago

    Baltimore, Maryland, United States Kennedy Krieger Institute Full time

    Overview:The Research Assistant II will collect, organize, and maintain research data; assist with preparing data for analysis for research projects; coordinate with program staff to recruit subjects for research protocols; and provide clinical interventions under supervision per research protocols.Responsibilities:Prepare materials for and conduct baseline...

  • Oncology Clinical Data Specialist II

    1 week ago

    Baltimore, Maryland, United States Johns Hopkins Health System Full time

    100% Remote / Flexable work schedulePosition Summary:The Data Specialist assists in the review of patient information and medical records. This role assists with inquiries, providing information about medical records and addressing concerns. The Data Specialist is required to complete accurate input of patient demographics information, medical histories,...

  • Maryland EXCELS Program Quality Specialist II

    2 days ago

    Baltimore, Maryland, United States Johns Hopkins University Full time

    The Johns Hopkins University Center for Technology in Education (CTE) changes lives through knowledge that matters by designing, developing, and implementing learner-centered, technology-enhanced solutions to ensure equal access to education in classrooms and work settings across the globe. Our work at CTE involves many aspects of technology and innovation...

  • Mobile Diesel Mechanic II Overnight

    3 weeks ago

    Baltimore, Maryland, United States Fleet Services by Cox Automotive Full time

    *** If you have any questions or to connect with a recruiter while your application is being reviewed, please Text DFS3 to *******Veterans encouraged to apply****Fleet Services – A Cox Automotive Company keeps your fleet movingHeadquartered in Indianapolis, Fleet Services by Cox Automotive has grown to become one of the largest fleet maintenance companies...

  • Senior Staff Electrical Engineer

    1 week ago

    Baltimore, Maryland, United States Johnson Controls Full time $115,000 - $150,000

    Who we areJohnson Controls is powered by your talent. We are the power behind the customer mission. Together we are building a world that's safe, comfortable and sustainable. Our diverse global team of 100,000 experts in more than 150 countries creates innovative, integrated solutions to make cities more connected, buildings more intelligent and environments...