Lead Data Engineer

Job Overview

Overview

Impact the Moment 

Do you enjoy testing the limits of possibility? At McGraw Hill, our Data & Analytics organization drives progress and helps build the future of learning. If you have the passion and technical expertise to thrive in an innovative and agile environment, we want to learn more about you.

Your impact on the team 

The Lead Data Engineer in Data and Analytics is responsible for enhancing McGraw-Hill Education’s 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 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. 

This is a remote position open to applicants authorized to work for any employer within the United States, preferably those who are in Eastern time zone. Up to 25% travel may be required, so preference will be given to candidates within commuting distance of a McGraw Hill office. 

 

What can you expect from the position?  

• Develop and deliver data solutions with Oracle technologies and/or AWS. 

• Run cloud platform with optimized solution architecture with the ability to meet the daily runbook SLA. 

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

• Design and build integrations supporting standard data modelling objects (Fact dimensions, aggregations, star schema, etc.) 

• Provide end-to-end technical guidance on the software development life cycle (requirements through implementation). 

• Create high quality solution design documentation for end-to-end solutions. 

What can you bring to the role? 

• 8+ years of experience in data engineering, specializing in data warehousing, modern data lakes, and cloud-based data architectures using Oracle Cloud (OCI) and/or AWS. 

• Hands-on experience in Data Engineering using tools such as: 

• Informatica/IICS, Oracle DB and Oracle packages 

• Scripting in Python, Scala, Java, or Node. 

• AWS services (Athena with Iceberg, Lambda, EMR, Glue) and Databricks.

• At least 1+ years of experience in Unix shell scripting. 

• Proven expertise in data modeling, ETL pipeline development, and delivering scalable data solutions with Oracle, and/or AWS, and Informatica IICS. 

• 5+ years working with cloud data technologies across OCI, AWS, and/or Azure, with experience in cloud platform optimization and meeting SLA requirements. 

• Strong experience with version control (GIT), project management tools like Jira, and Agile/Kanban methodologies. 

• Ability to translate business requirements into technical solutions and create technical specifications for data initiatives. 

• Experience working with financial and operational data, including sales, revenue, COGS, and manufacturing metrics, with a solid understanding of slow-changing dimensions (SCD). 

• Experience with Tableau, Alteryx, and IBM Planning Analytics (TM1) is a nice to have. 

• Industry experience in Publication and Education domains is a plus.

Why work for us? 

There has never been a better time to join McGraw Hill. In our culture of curiosity and innovation, you will be able to own your growth and develop as we do. 

 
The pay range for this position is between $140,975 - $145,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. 

McGraw Hill recruiters always use a "@mheducation.com" email address and/or from our Applicant Tracking System, iCIMS. Any variation of this email domain should be considered suspicious. Additionally, McGraw Hill recruiters and authorized representatives will never request sensitive information in email. 

48760