Jobs

    Staff Data Engineer, Multiple Teams - Canada - Shopify

    Shopify
    Shopify Canada

    3 weeks ago

    Shopify background
    Full time
    Description

    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.



  • Shopify Canada Full time

    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 Senior Data Engineer at Shopify ...


  • Shopify Canada Full time

    About the role · NOTE: Only applicants who submit a portfolio of design work alongside application will be considered. By applying to this posting, you will be considered for a number of different UX teams across Shopify. · We're looking for Senior & Staff Product Designers to l ...


  • NTT Data Services Canada

    Chez NTT DATA, nous savons, qu'avec les bonnes personnes à bord de notre équipe, tout est possible. La qualité, l'intégrité et l'engagement de nos employés sont des facteurs clés qui permettent la croissance et la présence sur le marché de notre entreprise. En embauchant les meil ...

  • Clinique MDCM

    Medical Receptionist

    4 hours ago


    Clinique MDCM Canada

    Job description · Nous sommes une clinique médicale située à NDG. · Nous sommes à la recherche d'une personne dynamique et passionnée pour combler le poste de réceptionniste à temps pleine · **TÂCHES ET RESPONSABILITÉS**: · - Accueil des patients et répondre aux différentes deman ...


  • Matthew House Ottawa Kanata, Canada

    **About Matthew House Ottawa** · Since 2010, Matthew House Ottawa has housed hundreds of refugee claimants and provided quality furniture to more than 17,000 people through our furniture bank program. We have done this with a large, dedicated team of volunteers and a handful of e ...


  • Upper Room Home Furnishings Kanata, Canada Part time

    Upper Room Home Furnishings, is one of the top Ottawa furniture stores in the National capital region. We are a dynamic company with endless career opportunities, quickly expanding, and ready to grow our team · We are looking for a part-time receptionist with exceptional communic ...


  • Bridgit Canada

    **About us**: · Bridgit is a community of hard-working people who want to make a difference in the construction industry. Some of us have been here since the early days, while some joined more recently. Our average tenure is 3+ years and every employee survey tells us that our te ...


  • Novolex Canada

    **Why Choose Us?** · Novolex is a leader in packaging innovation, choice and sustainability. We manufacture products in paper, plastic and sustainable materials for the food, retail, health and industrial markets. · Novolex's **De Luxe Packaging** brand, has over 70 years of expe ...

  • Fujitsu

    Finance Manager

    4 hours ago


    Fujitsu Canada

    **Finance Manager** · **Objectives and Purpose of Position** · As a member of the Fujitsu North American Finance team, provide accurate financial reporting and successful financial management to optimize project contract performance and profitability. · Position Summary · This po ...

  • McGill University

    Buyer

    4 hours ago


    McGill University Canada

    Please refer to the · job aid for instructions on how to apply. · - Execute procurement activities to assist the Lead Buyers in the acquisition of goods, services and construction works for the University community, in accordance with established legislation and policies: · - Per ...

  • Collicut Energy

    Parts Technician

    4 hours ago


    Collicut Energy Canada

    **Parts Technician** · Collicutt Energy Services Corp, a leader in power generation and all things engines, is currently seeking a Parts · Technician to join our team in Red Deer. We are looking for someone who is ready for the opportunity to grow with the · company and challenge ...


  • KPMG-Canada Canada

    **Overview** · When you join KPMG you'll be one of over 207,000 professionals providing audit, tax, advisory and business enablement services across 153 countries. · With the support to do things differently, grow personally and professionally and bring your whole self to work, t ...

  • Inside

    Content Studio Writer

    4 hours ago


    Inside Canada

    **100% remote, full-time, USA or Canada-Based** · We are a fully remote team of passionate builders, entrepreneurs, and news enthusiasts. In this position, you will learn quickly and have ample opportunity to grow and try new things. · We are searching for a driven, detail-orient ...


  • TCAT Div of Toromont Industries Ltd Kanata, Canada

    The Field Service Technicians, Power Systems will work on our customer sites to safely and effectively diagnose and repair Caterpillar Power Systems in a timely manner while maintaining extremely high standards and ensuring positive customer experiences. · **As a Field Service Te ...


  • Assiniboine Park Conservancy Canada

    **Conservation Assistants - Seasonal** · **Wage**:$17.00 per hour · 16 week term, May - August · 8:00AM to 4:00 PM (Occasional overtime, evenings, weekend, and field work will be required) · **About Assiniboine Park Conservancy** · Creating the future vision for one of Winnipeg, ...


  • Lockheed Martin Corporation Canada

    Business Development · - Montreal, QC · - 12892BR · **About the role** · **Responsibilities**: · - Support the Business Development Team marketing projects and initiatives · - Maintain strong communication between Business Development Team and internal and external stakeholders a ...


  • YMCA of Three Rivers Canada Full time

    **Coordinator, Youth Recreation & Wellness · **FULL TIME PERMANENT** · **START DATE: Immediate** · **REGION: Serving all regions of the YMCA of Three Rivers** · **APPLICATIONS DUE**: · **March 29, 2023** · **Hours of work: Must be available to work flexible hours, including eveni ...


  • Reckitt Kanata, Canada

    Reckitt is more than a company. We're a growing community of over 40,000 diverse, talented entrepreneurs - driven by our purpose to protect, heal and nurture in the relentless pursuit of a cleaner healthier world. We work each day to ensure that access to high quality hygiene, we ...


  • CIBC Canada

    We're building a relationship-oriented bank for the modern world. We need talented, passionate professionals who are dedicated to doing what's right for our clients. · At CIBC, we embrace your strengths and your ambitions, so you are empowered at work. Our team members have what ...


  • Terlin Construction Ltd. Kanata, Canada

    **Senior Project Manager - ICI and Retail Construction** · Established in 1989, Terlin has become a leader and innovator in full-service construction for retail, commercial, and institutional clients. Distinguished by their end-to-end approach and unparalleled reputation for qual ...