Job Title:Software Engineer (Boston, MA)
Job Site: Boston - 125 High Street, Suite 900, Boston, MA 02110 (Full-time)
Who We Are
HMH is a learning technology company committed to delivering connected solutions that engage learners, empower educators, and improve student outcomes. As a leading provider of K–12 core curriculum, supplemental and intervention solutions and professional learning services, HMH partners with educators and school districts to uncover solutions that unlock students' potential and extend teachers' capabilities. HMH serves more than 50 million students and 4 million educators in 150 countries.
What You’ll Do
Job Duties:
- 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, Transform, Load) 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.
- With extensive experience in the Software Development Life Cycle (SDLC), employing Agile methodologies such as Scrum and adhering to test-driven development (TDD) principles for efficient software delivery.
- Design and architect data models for both reporting solutions and data exports, ensuring high performance and adaptability to evolving business requirements.
- Enhance operational efficiency by performing in-depth systems analyses and proposing strategic changes to policies and procedures to optimize workflows.
- Utilize Python to build data-driven applications, integrating with AWS services and leveraging Software Development Kits (SDKs) for cloud-based solutions.
May telecommute from any location in the US.
What You’ll Need
Position Requirements: 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:
- 3 years of object-oriented design & programming skills, including the application of design patterns and avoidance of anti-patterns. 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).
- Familiarity with containerization tools like Docker, Kubernetes.
- Knowledge of API design, development and integration.
- This position is part of HMH Education Company’s employee referral program and is eligible for an employee referral incentive bonus.
HMH is fully committed to Equal Employment Opportunity and to attracting, retaining, developing and promoting the most qualified employees without regard to race, gender, color, religion, sexual orientation, family status, marital status, pregnancy, gender identity, ethnic/national origin, ancestry, age, disability, military status, genetic predisposition, citizenship status, status as a disabled veteran, recently separated veteran, Armed Forces service medal veteran, other covered veteran, or any other characteristic protected by federal, state or local law. We are dedicated to providing a work environment free from discrimination and harassment, and where employees are treated with respect and dignity. We actively participate in E-Verify.
#LI-DNI