Data Engineer

About the Role

Key Responsibilities

• Provide data-driven insights and execute recommendations as part of the Data Engineering team.
• Maintain financial analysis, customer analytics, data engineering, web analytics, and analysis of offline activities.
• Interface with other developers, product owners, and business analysts to understand data needs.
• Develop and maintain Scholastic's data infrastructure to drive efficient and reliable processes.
• Utilize data to analyze the effectiveness of Scholastic's marketing efforts across channels.
• Develop dashboards and improve reporting measures, operations, and supply chain processes.
• Support the daily production jobs that run on complex data pipelines using EMRs and EC2s.
• Create and support frameworks for operational data stores and data migration processes.
• Set up automated lifecycle policies on AWS resources such as Sagemaker notebooks to optimize costs.
• Implement and support data transformation tools like dbt for ETL processes.
• Develop quality monitors using metaplane and send notifications via Webhooks.
• Integrate metaplane notifications with tools like JIRA and MS Office.

Requirements

• Bachelor's degree in Computer Science, Computer Engineering, Engineering, Math or a closely related quantitative discipline.
• Three (3) years of experience as a Data Engineer, Data Warehouse Analyst, Data Warehouse Solution Architect, Graduate Assistant or related role.
• At least 2 years of experience with SQL for data extraction, transformation, cleaning, and analysis.
• Proficiency in Excel, SAS, R or Python for analysis, statistics, and charting.
• Experience setting up frameworks for Operational Data Stores with real-time data availability.
• Experience creating migration run books for moving processes to AWS Glue Framework.
• Experience setting up automated lifecycle policies on AWS Sagemaker and other AWS resources.
• Experience supporting data pipelines using EMRs and EC2s.
• Knowledge of git for source code control and change management.
• Ability to develop quality monitors using metaplane and send notifications via Webhooks.
• Experience integrating notifications with tools like JIRA and MS Office.

Nice to Have

• Experience with AWS services such as Sagemaker, Glue, EMRs, and EC2s.
• Familiarity with data transformation tools like dbt.
• Knowledge of cost optimization strategies on cloud platforms.

Qualifications

• Bachelor's degree in a relevant field.
• Minimum of 3 years of professional experience in data engineering or related roles.

Benefits & Perks

• Competitive annual salary range of $120,000.00 - $132,000.00.
• Full-time employment with standard working hours (9am - 6pm, Monday - Friday).
• Remote work permitted within reasonable commuting distance of New York, NY.