Data Warehouse Architect (Remote, Americas)

Job post summary
Location Americas
Team Data Science & Engineering

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.

Qualifications

  • 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

#LI-REMOTE 

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: https://www.shopify.com/careers/work-anywhere

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 

Not what you’re looking for?Check out these similar roles.

Job postings for similar
Position Team Location
Data Science Manager (Remote, United States) Data Science & Engineering Americas
Senior Data Engineer (Remote, United States) Data Science & Engineering Americas
Senior Data Engineer (Remote, Canada) Data Science & Engineering Americas
Data Science Manager (Remote, Canada) Data Science & Engineering Americas
Staff (Lead) Data Scientist (Remote, United States) Data Science & Engineering Americas
Senior Data Scientist - SHOP (Remote, Canada) Data Science & Engineering Americas
Staff (Lead) Data Scientist (Remote, Canada) Data Science & Engineering Americas
Senior Data Scientist - SHOP (Remote, United States) Data Science & Engineering Americas
Senior Data Scientist (Remote, Canada) Data Science & Engineering Americas
Senior Data Scientist (Remote, United States) Data Science & Engineering Americas
Staff (Lead) Data Engineer (Remote, United States) Data Science & Engineering Americas
Senior Data Science Manager - Merchant Services, Retail Growth (Remote, United States) Data Science & Engineering Americas
Senior Data Science Manager - Merchant Services, Retail Growth (Remote, Canada) Data Science & Engineering Americas
Data Development Manager (Remote, Canada) Data Science & Engineering Americas
Staff (Lead) Data Engineer (Remote, Canada) Data Science & Engineering Americas
Data Development Manager (Remote, United States) Data Science & Engineering Americas
Data Development Manager, Site Reliability (Remote, United States) Data Science & Engineering Americas
Pottery store wall with products

Don’t see the right role?

Join our Engineering community, or sign up be alerted when relevant roles are available.

Join our community