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: 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.