Staff Data Engineer, Multiple Teams

TELECOMMUTEAmericas
Engineering & Data

About Shopify

Opportunity is not evenly distributed. Shopify puts independence within reach for anyone with a dream to start a business. We propel entrepreneurs and enterprises to scale the heights of their potential. Since 2006, we’ve grown to 10,000 employees and generated over $496 billion in sales for millions of merchants in 175 countries.

This is life-defining work that directly impacts people’s lives as much as it transforms your own. This is putting the power of the few in the hands of the many, is a future with more voices rather than fewer, and is creating more choices instead of an elite option.

About you

Moving at our pace brings a lot of change, complexity, and ambiguity—and a little bit of chaos. Shopifolk thrive on that and are comfortable being uncomfortable. That means Shopify is not the right place for everyone.

Before you apply, consider if you can:

Care deeply about what you do and about making commerce better for everyone
Excel by seeking professional and personal hypergrowth
Keep up with an unrelenting pace (the week, not the quarter)
Be resilient and resourceful in face of ambiguity and thrive on (rather than endure) change
Bring critical thought and opinion
Embrace differences and disagreement to get shit done and move forward
Work digital-first for your daily work

About the role

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.

As a Data Engineer at Shopify, your primary responsibility will be to contribute to Shopify’s Data Warehouse, while unlocking powerful insights to guide the development and improvement of Shopify’s products. You'll operate as either an either an embedded capacity or on a central Data Engineering team at Shopify as part of the Data Insights organization (exclusive of Data Platform Engineering which is part of our Infrastructure organization).

As an embedded Data Engineer, you will work directly on building foundations for products that transform merchants' lives. You'll collaborate with a multidisciplinary team of professionals that can include Product Data Scientists, Machine Learning Engineers, Business Analysts, and Product Management. The data you shape will be used to power product analysis, dashboards, and reports, as well as your own product analysis, dashboard and report creation from time to time. Our product is designed to empower entrepreneurs and thus your work creates value for users, and contributes to global entrepreneurship.

As a central Data Engineer, you will sit amongst a team of Data Engineers focused on defining and up-leveling the craft and product of Data Engineering across all of Shopify. Your impact is seen at scale when you ship high quality data assets to Shopify’s Data Warehouse, which is used by thousands of people to perform product analysis, make decisions to support our merchants, and steer strategic decisions of the business. You also achieve with others as you partner with Data Engineers embedded in product teams to share and gather standards and best practices, and perform data architecture duties to up-level and maintain the high quality of Data Engineering at Shopify.

To thrive in either role, you need to be dedicated to your craft and committed to constant development. You should be an independent thinker who can solve complex problems and handle a bit of chaos without breaking a sweat.

Example day-to-day responsibilities include:

Designing, building, implementing, and documenting data models
Working with business partners to understand business and product objectives, identify the data needed to support them, while influencing product and program decisions
Writing data transformations using dbt or Spark
Shipping data pipelines including real-time streaming and batch processing
Optimizing data transformation pipelines to increase freshness or reduce computational time/cost
Collaborating with other data engineers on tooling for automated tasks around consuming, validating raw/modeled data, updating modeled data
Collaborating with sister disciplines (Engineering, Data Science) to establish best practices and evangelize the values and priorities of the Data Engineering craft
Building production-quality dashboards and scalable data products
Debating whether leading or trailing commas are better
Fixing jobs that are broken in production (wrong data types returned, granularity not as expected, resourcing issues)

Qualifications

Proven ability to provide leadership and guidance beyond one-on-one mentorship, and the ability to improve data engineering practices across teams
Expert in data architecture and modeling concepts, and able to influence others to up-level the craft of Data Engineering
Experience forging alignment with senior stakeholders on technical direction for ambiguous problem areas
Commercial experience in Data Engineering, and/or Analytics Engineering, building scalable data warehouses
Dimensional Modeling (Star Schema, Kimball, Inmon)
Advanced SQL skills (ease with window functions, defining UDFs)
Exposure to Data Engineering tooling: ingesting, testing transformations, lineage, orchestration, publishing data, metric layers
Hands-on experience implementing real-time and batch data pipelines with tight SLOs and complex transformation requirements
Fantastic collaboration and communication skills, demonstrated by successful large-scale projects spanning multiple teams
High proficiency for product analysis, dashboarding, and reporting

We know that looking for a new role can be both exciting and time-consuming, and we truly appreciate your effort. We look forward to hearing your response to the prompt associated with your application!

#LI-KO3 #LI-REMOTE #LI-AH1

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.

We hire people, not resumes. If you think you’re right for the role, apply now.

No matching Engineering or Data role? Leave us your contact information and we'll be in touch if a role comes up which matches your skillset.

First things first

We want to ensure you’re the type of person who will thrive here so we can move you quickly through our hiring process. Before completing the job application, please check all the statements that apply to you below:

I am always seeking (often uncomfortable) growth and deepening my craft expertise

I thrive on change in an ambiguous environment and can keep pace to ship weekly

I want to work remotely for my daily work

Application

Personal Information

First name
Last name
Email
City
Country

Experience

Resume (Max. 2MB)
LinkedIn
Website
Message to Hiring Manager

Are you currently based in the US or Canada and plan to work from one of these two countries?
YesNo
Which statement best fits your experience on projects: a) I haven't led a project yet, but I've been part of a team where I observed how the lead managed the project. I contributed to the tasks assigned to me and learned from the process. b) I've led a small project or a part of a larger project. I was responsible for coordinating with a few team members, ensuring tasks were completed on time, and communicating progress to the project lead. c) I've led several projects, coordinating with multiple team members and stakeholders. I was responsible for the project's success, making key decisions, and ensuring the team was working effectively towards our goals. d) I've led complex, high-stakes projects involving multiple teams or departments. I was responsible for strategic decision-making, managing risks, and ensuring alignment with the organization's goals.
Please select the answer that best describes your approach to mentorship: a) I'm still learning the ropes, so I tend to focus more on absorbing knowledge from my seniors rather than mentoring others. b) I'm comfortable with my skills and can help others with similar or less experience, but I still rely on more experienced engineers for complex problems. c) I actively mentor less experienced engineers like interns & mid-level engineers, sharing my knowledge and providing guidance on a regular basis. I'm confident in my ability to solve complex problems and often lead team discussions. d) I not only mentor individuals on my team, but I also promote a culture of learning and growth within the organization. I'm often consulted on high-level decisions due to my extensive experience and knowledge.
Please select the statement that best describes your experience with data architecture and modeling concepts in your current or previous roles. a) I have contributed to building data models within a data warehouse, working on specific aspects with a clear and defined scope. While I haven't participated in direct technical decisions, I have gained valuable experience by implementing these models and collaborating with team members on data architecture tasks. b) I've actively contributed to and led data modeling and design within a data warehouse. I have demonstrated critical thinking and opinion in data engineering endeavors, evaluating trade-offs of various technical decisions and collaborating effectively with stakeholders to achieve project objectives. c) I have taken the lead in the data modeling and design for complex concepts within a data warehouse framework, leveraging my skills to enhance data structures and ensure scalability, while considering trade-offs in technical decisions and engaging with stakeholders to align project goals. d) I regularly take the lead in the design and modeling of complex, large-scale data warehouse systems, demonstrating expertise in data modeling, as well as various Data Engineering tooling for ingestion, transformation, and orchestration. I have mentored team members on data architecture concepts, influencing them to excel in the field of Data Engineering while fostering
As a Data Engineer, please select which area would you prioritize for your main focus, aligning with your expertise and interest. a) I'd like to spend the majority of my time as a data engineer working on tasks such as bringing data onto or from a data platform (ETL/ELT), managing API interactions, and monitoring pipelines. b) I'd like to spend the majority of my time as a data engineer building tooling and frameworks crucial for data processing and exposure, creating custom software to enhance developer experience within data warehouses. c) I'd like to spend the majority of my time as a data engineer focusing on data modeling, incorporating intricate business logic, and constructing a robust data warehouse. d) I’d like to spend the majority of my time as a data engineer focused on building streaming data pipelines, delivering real-time data transport solutions. e) I'd like to spend the majority of my time as a data engineer focusing on data science and analytics, constructing data marts for in-depth data analysis, and collaborating closely with business users to communicate actionable insights. "

By checking this box, you will declare that you read and understand the privacy policy of Shopify.