1 month ago
Delta, CanadaStaff+
Responsibilities
- Develop complex SQL transformations and efficient, widely used data models.
- Embed business logic to unify analysis across cross-functional teams.
- Design and recommend data model structure and flow.
- Review and approve model changes and serve as technical owner for specific data sub-domains.
- Build solutions in Google Cloud Platform and Dataform.
- Contribute to analytics engineering standards and best practices.
- Provide technical mentorship, conduct code reviews, and elevate engineering practices across teams.
Requirements
- Advanced SQL expertise with the ability to create efficient and tuned data models.
- Proficiency with modern data transformation frameworks such as dbt and/or Dataform.
- Proven ability to build scalable data models from business requirements.
- Strong understanding of modern data architecture and modeling methodologies, including medallion architecture, Kimball and Inmon approaches, star schemas, and One Big Table design.
- Deep expertise in incremental modeling patterns, partitioning and clustering strategies, and data quality testing frameworks.
- Experience optimizing enterprise data workloads on cloud platforms such as GCP, AWS, and Azure.
- Experience applying software engineering workflows to data platforms, including version control, testing, and deployment across environments.
- Experience with technical mentorship, code reviews, and engineering best practices.
- Ability to collaborate strategically with cross-functional partners and apply the company’s values and leadership principles.
Benefits
- Product discounts and access to exclusive private shopping events.
- Up to 16 weeks of paid baby leave.
- Access to the A-OK Commissary & Cafe with curated, subsidized dining.
- Access to the SET in-office fitness studio and gym, including classes and optional personal training.
- 24/7 virtual wellness resources supporting physical, mental, social, and financial wellbeing.
- Aspirational, dog-friendly office spaces.
- Additional amenities including a private parent’s room, showers, bike rooms, dry-cleaning, hotel and restaurant discounts, self-care promotions, and on-site medical care.
Tech Stack
Categories
Data Engineering
About Aritzia
Aritzia is a Canadian fashion retailer and design house that sells in-house apparel and accessories direct to consumers online and in boutiques. Founded in 1984 and headquartered in Vancouver, it operates an e-commerce site and more than 140 stores across North America. Aritzia is a public company listed on the Toronto Stock Exchange (TSX).