Get new data jobs every week
Back to all jobs

Data Warehouse Architect (Remote, Americas)

Remote in Americas
Apply now

Data Warehouse Architect (Remote, Americas)

About the role

Data is a crucial part of Shopify’s mission to make commerce better for everyone. We organize and interpret petabytes of data to provide solutions for our merchants and stakeholders across the organization. From pipelines and schema design to machine learning products and decision support, data science at Shopify is a diverse role with many opportunities to positively impact our success. 


Our Data Warehouse Architect will focus on the foundations of our data. By providing data scientists and business users with a holistic and integrated view of the business, they will increase both the speed and accuracy of all our decisions. We are looking for someone with broad and deep experience in large scale data integration, with a track record of delivering practical large system designs.


  • Extensive experience (10+ years) Kimball & Ross dimensional warehouse methods. This should include multiple of the following:

    • Requirements gathering and stakeholder communication

    • Developing deployment strategy

    • Migrating large data integration systems between platforms

    • Designing dimensional models

    • Implementing ETL pipelines

    • Developing dashboard / reporting solutions using a data warehouse

    • Developing data mining and machine learning applications using a data warehouse

    • Developing documentation and training programs 

    • Developing Data quality programs

  • Experienced in technical leadership and developing technical strategy

  • Exceptional communication skills and ability to translate technical concepts into easy to understand language for our stakeholders

  • Experience with SQL and python


Shopify is now permanently remote, and we’re working towards a future that is digital by design. That location you see above? Consider it merely an example of hundreds of potential locations Shopify is hiring. Learn more here:

Our belief is that a strong commitment to diversity & inclusion enables us to truly make commerce better for everyone. We encourage applications from Indigenous peoples, racialized people, people with disabilities, people from gender and sexually diverse communities, and/or people with intersectional identities. Please take a look at our Sustainability Reports to learn more about Shopify’s commitments to our communities, and our planet.

At Shopify, we understand that experience comes in many forms. We’re dedicated to adding new perspectives to the team - so if your experience is this close to what we’re looking for, please consider applying.

How we hire

At Shopify, we put a lot of care and time into who we hire. We believe that in order to build the best products, we need to build high impact teams. Our recruitment process centres around what we call the Life Story interview, a conversational-style interview where we get to learn more about you.
Learn more about our hiring process