Lead Data Engineer

Location: United States

Department: Data Science & Business Intelligence

Work Mode: Remote

About the Role

Could your creative thinking build the future of education? As a Lead Data Engineer at McGraw Hill, you'll make a profound impact on learners and educators worldwide. Our innovative Data Science & Business Intelligence team is seeking a visionary leader to transform financial, product, customer, and third-party data into actionable insights that power enterprise learning solutions. In this remote role, open to U.S.-authorized applicants, you'll architect scalable platforms using OCI/Exadata, IICS, Databricks, AWS, and advanced SQL, ensuring stakeholder-aligned outcomes that elevate education technology. You'll develop cutting-edge data solutions with AWS and Oracle technologies, employing robust data modeling, SCD practices, and cloud architecture to translate business needs into technical designs, including star schemas and integration models. Build high-performance ETL pipelines via Informatica, enhanced by Unix scripting for automation, while optimizing cloud performance to meet SLAs across Oracle ERP and DB systems. Provide hands-on leadership across the software lifecycle, championing Agile/Kanban with Git and Jira to foster collaboration and continuous improvement in our dynamic, innovation-driven culture. With 8+ years in data engineering, expertise in Informatica/IICS, Oracle, AWS services, Databricks, and cloud environments like OCI/AWS/Azure, you'll thrive here. Strong programming in Python/Scala/Java/Node, Unix scripting, and experience with financial datasets plus Tableau/Alteryx are essential. Preferred: publishing/education domain knowledge and IBM Planning Analytics (TM1). Join McGraw Hill to design content that shapes education's future, with competitive pay ($108,180-$145,000), comprehensive benefits, and a fulfilling mission that inspires greatness.

Key Responsibilities

• Develop and deliver scalable data solutions using AWS and/or Oracle technologies, leveraging strong data modeling skills, SCD practices, and modern cloud architecture
• Translate business requirements into technical designs, creating detailed specifications, solution documentation, and end-to-end integration models (facts, dimensions, star schemas, aggregations)
• Build optimized, parallel-processing ETL pipelines using Informatica and advanced transformations, supported by Unix scripting for workflow automation, cleanup, and file management
• Manage and enhance cloud platform performance to meet daily runbook SLAs, ensuring reliable, efficient data operations across financial and operational systems like Oracle ERP and Oracle DB
• Provide technical leadership through the full software development lifecycle, offering guidance from requirements through implementation while supporting Agile/Kanban delivery practices
• Utilize Git, Jira, and other engineering tools to maintain version control, collaborate effectively, and support continuous improvement in data engineering processes
• Transform financial, product, customer, and third-party information into timely, actionable insights for education technology solutions
• Oversee platform performance while architecting scalable reporting, analytics, and modeling solutions using OCI/Exadata, IICS or Databricks, AWS, and advanced SQL
• Strengthen McGraw Hill’s intelligence and data capabilities to empower students and institutions

Required Qualifications

• 8+ years of data engineering experience using Informatica/IICS, Oracle DB, Oracle packages, AWS data services such as Athena with Iceberg, Lambda, EMR, Glue, and platforms like Databricks
• Expertise in data warehousing, modern data lake architectures, and large-scale data engineering practices
• Strong programming skills in Python, Scala, Java, or Node, along with at least 1 year of Unix shell scripting
• 5+ years working with cloud environments including OCI, AWS, or Azure with a focus on data technologies
• Experience working with financial datasets such as sales, revenue, COGS, and manufacturing
• Familiarity with Tableau or Alteryx

Preferred Qualifications

• Preferred experience in the publishing or education domain
• Experience with IBM Planning Analytics (TM1)

Required Skills

• Informatica/IICS
• Oracle DB and Oracle packages
• AWS data services (Athena with Iceberg, Lambda, EMR, Glue)
• Databricks
• Data modeling (SCD, star schemas, facts, dimensions, aggregations)
• ETL pipeline development with parallel processing
• Unix shell scripting
• Python, Scala, Java, or Node programming
• Cloud platforms (OCI, AWS, Azure)
• Advanced SQL
• Git for version control
• Jira for Agile/Kanban
• Data warehousing and data lake architectures
• Financial data handling (sales, revenue, COGS, manufacturing)
• Tableau or Alteryx
• Technical leadership and stakeholder collaboration
• Agile software development lifecycle

Benefits

• Competitive base pay range of $108,180 - $145,000 annually, based on experience and location
• Full range of medical, dental, and vision benefits
• 401(k) retirement savings plan with company match
• Paid time off and flexible remote work options
• Professional development and tuition reimbursement for continuous learning
• Wellness programs and employee assistance resources
• Stock purchase plan and performance bonuses
• Parental leave and family-friendly policies

McGraw Hill is an Equal Opportunity Employer.