[Hiring] Lead Data Engineer @McGraw Hill LLC.

Role Description

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.

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

Qualifications

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

Benefits

• The pay range for this position is between $115,000-$150,000 annually.
• 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.
• A full range of medical and/or other benefits, depending on the position offered.