Lead Data Engineer

Mheducation; Northern (KY); Hybrid; USD 115,000 - 150,000; Full time

Job summary

McGraw Hill Education is seeking a Lead Data Engineer to enhance our BI and data services, delivering timely insights to support financial, product, customer, user and partner data needs. You will perform hands-on data engineering using OCI/Exadata, IICS, Databricks and AWS, design scalable reporting and data models, and collaborate with stakeholders to ensure on-time delivery and quality.

The ideal candidate has 8+ years in data engineering, strong cloud experience (OCI/AWS), and expertise in

Qualifications

• Bachelor's degree or equivalent experience.
• 8+ years of experience in data engineering.
• 1+ years of Unix shell scripting.
• 5+ years of experience with OCI/AWS/Azure on data technologies.

Responsibilities

• Lead data engineering efforts delivering data solutions with AWS and/or Oracle technologies.
• Work with data from financial and operational systems and model architecture (SCD).
• Run cloud platform with optimized architecture to meet runbook SLA.
• Collaborate with stakeholders to translate business requirements into technical deliverables.
• Design and build end-to-end ETL solutions for efficient processing.
• Create data mappings and implement transformations (e.g., Joiner, Router, Lookup).
• Develop shell scripts for Informatica workflow wrappers and housekeeping.

Skills

AWS

OCI

Databricks

IICS

SQL

Git

Jira

Agile/Kanban

Data modelling

ETL

Unix shell

Python

Scala/Java/Node

Education

Bachelor's degree or equivalent

Tools

Informatica IICS

Oracle DB

AWS services

Databricks

Athena/EMR/Glue

Job description

Overview

Build the Future

At McGraw Hill, we create best-in-class, next-generation learning experiences that are used by millions of students and educators worldwide every day. We design intuitive and effective tools that maximize teachers’ time and students’ learning. And we do all of this in a supportive and collaborative environment where we work alongside brilliant colleagues, touch lives around the world, see the difference our hard work makes, and continue on our own paths of lifelong learning.

How can you make an impact?

The Lead Data Engineer in Data and Analytics is responsible for enhancing McGraw-Hill Education’s (MHE) business intelligence and data services capabilities, ensuring the delivery of actionable and timely insights to support financial, product, customer, user, and third-party data. This role also involves managing and monitoring the performance of the Data Platform, ensuring efficiency and reliability with hands-on data engineering, designing and architecting dynamic reporting, analytics, and modeling solutions to drive success in the education domain.

The ideal candidate will have a strong data engineering background, with expertise in Oracle Cloud Infrastructure (OCI) with Exadata, Informatica Intelligent Cloud Services (IICS) and/or Databricks, AWS, with advanced proficiency in SQL queries. Additionally, this role requires close collaboration with stakeholders to ensure the successful delivery of projects.

This is a remote position open to applicants authorized to work for any employer within the United States.

What You’ll Do:

• Lead Data Engineer must have prior hands-on experience developing and delivering data solutions with AWS and/or Oracle technologies.
• Strong knowledge working with data from financial and operational systems, such as Oracle ERP Sales, Oracle DB and data modelling architecture with slow changing dimension (SCD).
• Experience in running cloud platform with optimized solution architecture with the ability to meet the daily runbook SLA.
• Strong experience with version control software like GIT and project management software like Jira with Agile/Kanban.
• Strong experience with Data Modelling concepts and Modern data architecture including cloud technologies.
• Ability to translate business requirements into technical requirements and deliveries.
• Design and develop parallel processing ETL solutions for optimal resource usage and faster processing.
• Understand ETL specification documents for mapping requirements and create mappings using transformations such as the Aggregator, Lookup, Router, Joiner, Union, Sorter, Normalizer and Update Strategy.
• Create UNIX shell scripts as Informatica workflow wrapper and perform housekeeping activities like cleanup and archive files.
• Experience in technical specification design - Proven experience in designing and building integrations supporting standard data modelling objects (Fact dimensions, aggregations, star schema, etc.)
• Ability to provide end-to-end technical guidance on the software development life cycle (requirements through implementation).
• Ability to create high-quality solution design documentation for end-to-end solutions

What You Bring:

• Bachelor's degree in related field or equivalent experience.
• Expertise in Data warehousing and modern data lake concepts.
• 8+ years of experience in Data Engineering using tools such as:
  • Informatica/IICS, Oracle DB and Oracle packages
  • AWS services and Data platforms like Athena with iceberg, lambda, EMR, and glue
  • Databricks
  • Scripting languages like Python, Scala, Java or node
• 1+ years of experience in Unix shell scripting
• 5+ years of experience working with Cloud like OCI, AWS, and Azure on Data technologies.

Preferred Experience & Skills:

• Experience with Publication and Education domain.
• Prior experience or familiarity with Tableau/Alteryx.
• Experience working with financial data like sales, revenue, cogs and manufacturing etc.
• Experience with IBM planning Analytics (TM1).

Why work for us?

The work you do at McGraw Hill will be work that matters. We are collectively building experiences that will help shape the future of education. Play your part and experience a sense of fulfilment that will inspire you to even greater heights. The pay range for this position is between $115,000-$150,000 annually. However, base pay offered may vary depending on job-related knowledge, skills, experience, and location. An annual bonus plan may be provided as part of the compensation package, in addition to a full range of medical and/or other benefits, depending on the position offered. Click here to learn more about our benefit offerings.