09 Nov
|
Houghton Mifflin Harcourt
|
Winnipeg
09 Nov
Houghton Mifflin Harcourt
Winnipeg
Title: Senior Software Developer - Spark & DatabaseLocation: Montreal, QC, CA, H2W 2R2 Senior Software Engineer – Spark and Database for the HMH Reporting Platform HMH Software Engineering HMH Software Engineering provides cutting edge, individualized learning experiences to millions of students across the United States. Our offices are high energy, collaborative beehives of activity where work is centered on small, autonomous teams that build great software. We are as passionate about new technologies and engineering craftsmanship as we are about transforming the EdTech industry itself.
Implement complex queries and stored procedures to support REST APIs and batch rollups of reports data for customer organizations. Writing, designing, testing, implementing, and maintaining database applications/procedures using SQL or other database programming languages. Resolve performance issues, performance tuning of database systems, queries, indexing.
Manage and create data import and export processes (ETL) into the databases and create and manage data integration scripts using file transfers, API calls, and/or other methods. Develop solutions using AWS database technologies like RDS Postgres and Aurora Postgres. Diagnose and troubleshoot database errors.
Create automation for repeating database tasks. DevOps knowledge to automate deployments using Jenkins or Concourse. 6+ years of experience as a DB Developer, preferably with Postgres, creating and supporting commercial data warehouses and data marts. 1+ years of experience working with Airflow Schedulers with Python development. Plus is experience working with Airflow Schedulers with Python development.
Strong hands-on working knowledge of managing databases on AWS Databases including: Robust command of SQL. SQL server tools, ETL jobs including stored procedures. Database technologies such as SQL, Aurora,
Redshift, Liquibase or Flyway Cloud technologies such as AWS and Azure Data Center Operating Technologies such as Apache Mesos, Apache Aurora, and TerraForm and container services such as Docker and Kubernetes Advanced knowledge of database security and performance monitoring standards.
Understanding of relational and dimensional data modeling. Knowledge of DataDog for setting up monitoring and alerting dashboards. Related AWS DBA Certification is a preferred. Knowledge of AWS Database Migration Service and Lambda is a plus.
A BS/MS in Computer Science, Computer Engineering, or a STEM field. The person in this position needs to move about inside office to access file cabinets, office machinery, etc Constantly operates a computer and other office productivity machinery, such as a calculator, copy machine, and computer printer Must be able to collaborate with colleagues via face to face, conference calls, and online meetings HMHC) is a global learning company dedicated to changing people's lives by fostering passionate, curious learners. As a leading provider of pre-K-12 education content, services, and cutting-edge technology solutions across a variety of media, HMH enables learning in a changing landscape.
HMH is uniquely positioned to create engaging and effective educational content and experiences from early childhood to beyond the classroom. HMH serves more than 50 million students in over 150 countries worldwide, while its award-winning children's books, novels, non-fiction, and reference titles are enjoyed by readers throughout the world. Follow HMH on Twitter, Facebook and YouTube.
All qualified applicants will receive consideration for employment and will not be discriminated against on the basis of gender, race/ethnicity, gender identity, sexual orientation, protected veteran status, disability, or other protected group status. #
📌 Senior Software Developer - Spark & Database (Winnipeg)
🏢 Houghton Mifflin Harcourt
📍 Winnipeg