Share this Job

Staff Software Engineer - Enterprise Data Warehouse

Apply now »

Date: Mar 15, 2019

Location: Dublin, L, IE, D02 R590

Company: Houghton Mifflin Harcourt

Location: Trinity Central, 152-160 Pearse St., Dublin 2.

Our city centre offices are right beside the back entrance to Pearse St Dart station. We’re close to all major transport links, coffee shops/restaurants/gyms and minutes from Stephen’s Green and the city centre.


The role:

At HMH we’re a learning company. Our learning platforms serve millions of learners and educators. We have interesting problems to solve, including how students interact with content from our learning platforms, how it impacts learning outcomes, and how to provide data driven guidance to maximize learner’s potential. How we use data is at the heart of driving great learning experiences.


About the team you’re joining:

  • You'll join the HMH data team and here we get data into our Enterprise Data Warehouse (EDW) and perform interesting data modelling.
  • You will be taking data from different sources, using big data tools (such as AWS Glue and Athena)  to build data pipelines and load them into Redshift. We have many differnt consumers of our data from data scientists to BI analysts.


More specifically you’ll be:

  • Working closely with our data science, learning science and product teams to develop our data warehouse and analytics capabilities.
  • Building an enterprise data warehouse (Redshift) from the ground up. This will include being involved in designing and implementing an appropriate EDW schema.
  • Working with ETL to populate the data (using AWS glue).
  • What’s great about our team is you get to be involved in the full end to end data process. You’ll see where the data is collected and turn that into models to improve outcomes for our learners (We gather events from Kafka, using Spark for both batch and streaming computations. We also use AWS glue for ETL and population of an S3 data lake and Redshift Enterprise Data Warehouse).
  • Guiding and coaching team mates to make the right EDW decisions.
  • Continuously looking to improve. We a want you to seek out and actively apply best practices. We empower you to bring your ideas to the table and help us continually improve technology practices, standards and methodologies.
  • As a small and focused team, there’s a lot of flexibility. We give you the opportunity to work across many areas, to hone your data skills to where your passions lie.


Knowledge & Experience

Here’s what you’ll need to be successful in this role;

  • If you have designed, implemented and run a Redshift Enterprise Data Warehouse schema, in production we want to talk to you.
  • You will also have experience working with business problems, to design appropriate EDW schemas.
  • Experience populating data using ETL tools such as AWS Glue. (or similar).
  • Experience with AWS and Redshift security models in the context of running a multi-tenant AWS Redshift cluster.
  • Several years working with Data Warehousing concepts and best practices.





Houghton Mifflin Harcourt (NASDAQ: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.

For more information, visit  

Houghton Mifflin Harcourt is committed to a comprehensive policy of Equal Opportunities and we aim to create a workplace which provides for equal opportunities for all employees and potential employees.

Job Segment: Publishing