Software Engineer - SQL, Data Engineer

Key Responsibilities:

• Design, build, and maintain ETL/ELT data pipelines from diverse data sources (databases, APIs, event streams, files).
• Develop and manage data warehouse/lake solutions (e.g., Snowflake, BigQuery, Redshift, Databricks, or similar).
• Implement and maintain data quality checks, validation, and monitoring to ensure high data reliability.
• Optimize queries and pipelines for performance, scalability, and cost efficiency.
• Collaborate with stakeholders to understand data needs and translate them into technical solutions.
• Maintain documentation of data models, pipelines, and systems.
• Implement and follow data governance, security, and privacy standards (e.g., access control, PII handling).
• Participate in code reviews, design discussions, and continuous improvement of data engineering standards and tooling.
• Troubleshoot and resolve data-related issues in production environments.

Required Qualifications:

• Bachelor’s degree in Computer Science, Engineering, Information Systems, Mathematics, or equivalent practical experience.
• Strong experience with SQL (complex joins, window functions, performance tuning).
• Professional experience with at least one programming language used for data engineering (e.g., Python, Scala, or Java), preferably Python.
• Hands-on experience with ETL/ELT tools or frameworks (e.g., Airflow, dbt, Luigi, Kafka Streams, Flink, custom pipelines).
• Experience with relational databases (e.g., PostgreSQL, MySQL, SQL Server) and working with large datasets.
• Experience on at least one cloud platform (AWS, GCP, or Azure) and its data services (e.g., S3/GCS/ADLS, Redshift/BigQuery/Synapse, EMR/Dataproc).
• Understanding of data modeling, warehousing, and orchestration concepts.
• Familiarity with version control (Git) and CI/CD practices for data code.
• Strong problem-solving skills and ability to work with incomplete or ambiguous requirements.
• Good communication skills and ability to work collaboratively in cross-functional teams.

Preferred Qualifications (Nice to Have):

• Experience with dbt or similar transformation frameworks.
• Familiarity with BI/analytics tools (e.g., Tableau, Power BI, Looker, Mode).
• Exposure to data governance and catalog tools (e.g., Collibra, Alation, Amundsen, DataHub).
• Experience working with data science / ML teams and supporting ML feature pipelines.
• Knowledge of software engineering best practices (testing, code quality, observability).

Tools & Technologies:

• Languages: SQL, Python, Javascript
• IAC: Terraform
• Orchestration: dbt
• Warehousing/Lake: Snowflake
• Storage: S3
• Streaming: Pub/Sub
• Infra/DevOps: Docker, GitHub/GitLab, CI/CD

What We Offer:

• Competitive salary and benefits package.
• Opportunity to shape and scale our data platform from the ground up.
• Collaboration with a skilled, cross-functional team focused on data-driven decisions.
• Continuous learning and development opportunities.

The Information Technology organization is transforming to realize our mission: Become a leader in HMH’s digital transformation, and as a strategic partner, innovate and deliver highest value, competitive advantage solutions across all corporate and business functions. Our ambition is to be a digital leader through innovation and develop and deliver leading edge technology such as robotic process automation and artificial intelligence to solve some of HMH’s greatest operational business challenges. Our professionals will have business relevant skills to connect our HMH partners to technologies that propel the businesses to deliver the greatest value for HMH and our customers.

We are building a team of IT professionals with an insatiable appetite to learn, a relentless focus on customer service, a technological curiosity toward future possibilities, and a creativity in solving business challenges with leading technologies. Our team will find ways to work together, create a sense of community where it’s safe to take risks and learn together, develop our careers, and all have an opportunity to work on new technologies. We will work together, learn together and have fun together. As a team, we will lead HMH’s digital transformation.