HMH is a learning technology company committed to delivering connected solutions that engage learners, empower educators, and improve student outcomes. HMH partners with educators and school districts to uncover solutions that unlock students' potential and extend teachers' capabilities.
Requirements
- 3 years of object-oriented design & programming skills, including the application of design patterns and avoidance of anti-patterns.
- 3 years of experience working in an AGILE/SCRUM environment.
- 3 years of experience working in a collaborative team of application developers and source code repositories.
- 3 years of experience working across multiple tiers of an application, including a database, network, operating system, and containers.
- 3 years of experience having designed one or more major components of an application, ETL Tools (e.g., SSIS) and Data Modeling Techniques.
- 3 years of experience working with PowerShell scripting for automation and data pipelines.
- 3 years of experience working with Data Visualization tools. (e.g., Power BI, Tableau).
Responsibilities
- Design logical, physical, and conceptual data models tailored to meet business needs, utilizing normalization techniques for transactional systems and denormalization for optimized data warehousing in alignment with Relational Database Management System (RDBMS) principles.
- Develop complex Transact-SQL (T-SQL) stored procedures to efficiently join and transform tables within the reporting DataMart, ensuring accurate input for SQL Server Reporting Services (SSRS) reports based on intricate business rules.
- Build and deploy robust ETL (Extract, Load, Transform) packages using SQL Server Integration Services (SSIS) with automation enhancements through BIML (Business Intelligence Markup Language).
- Create and maintain scalable PowerShell data pipeline jobs to support data processing across diverse environments, ensuring seamless integration and automation.
- Assess and improve operational feasibility by conducting comprehensive analyses, defining problems, gathering requirements, developing solutions, and presenting actionable recommendations.
- Design and architect data models for both reporting solutions and data exports, ensuring high performance and adaptability to evolving business requirements.
- Utilize Python to build data-driven applications, integrating with AWS services and leveraging Software Development Kits (SDKs) for cloud-based solutions.
Other
- Master’s degree (or foreign equivalent) in Computer Science or related field, plus 3 years of experience in a software development-related position.
- In the alternative, employer will accept a Bachelor’s degree (or foreign equivalent) in Computer Science or a related field, plus 5 years of experience in a software development-related position.
- Experience may be gained concurrently and must include:
- May telecommute from any location in the US.
- This position is part of HMH Education Company’s employee referral program and is eligible for an employee referral incentive bonus.
