Data & Analytics - (Senior) Analytics Engineer

Aritzia; Canada; On-site; CAD 95,000 - 170,000; Full time

Job summary

A growing retail company in Canada seeks a Senior Analytics Engineer to develop SQL transformations and design data models. You will collaborate across teams and become the domain expert in data analysis. The ideal candidate has strong SQL skills and experience with cloud platforms. The position offers a competitive annual salary ranging from $95,000 to $170,000 CAD, with additional bonuses and generous employee perks. This is an opportunity to thrive in a dynamic environment while contributing to data-driven decision-making.

Benefits

Product Discount

A-OK Commissary & Café

In-office fitness studio

Virtual Wellness resources

Dog-friendly workplace

Additional amenities like private parent’s room

Hotel and restaurant discounts

Qualifications

• Excellent SQL skills with the ability to create efficient & tune data models.
• Strong business modelling skills: going from expressed requirements to an actual data model.
• Experience with modern cloud data platforms such as GCP, MS, or AWS.

Responsibilities

• Develop complex SQL transformations to create data models.
• Design and recommend data model structure and flow.
• Review and approve model changes and serve as the technical owner for specific data sub-domains.

Skills

Excellent SQL skills

Strong business modeling skills

Design options for reshaping data tables

Experience with cloud data platforms

Familiarity with SAP HANA

Education

Proven skills and/or applicable certifications

Tools

Google Cloud Platform

Dataform

Job description

THE TEAM

The mission of the Data & Analytics Department is to maximize the value of Aritzia's data by making it available, insightful and actionable to foster a culture of data-driven decision making.

THE OPPORTUNITY

Aritzia is experiencing exponential growth, and the Data & Analytics team is growing with it. This is a unique opportunity to join the Analytics Data Models Department, where you will transform raw data in a modern platform and create models that empower self-serve analysis, reporting, and data science. As the (Senior) Analytics Engineer, you will support and enable the business, apply data modeling expertise, and become the data domain go-to person. And with the skills you gain in this role the opportunities are endless, from a rewarding career in Data & Analytics to continued growth at Aritzia.

THE ROLE

As the (Senior) Analytics Engineer, you will:

• Develop complex SQL transformations to create beautifully designed and widely used data models
• Embed and enrich business logic to unify the analysis of cross functional teams
• Design and recommend data model structure and flow
• Review and approve model changes and for Seniors, be the technical owner for specific data sub-domains
• Create in Google Cloud Platform and Dataform (Google's version of DBT)
• Contribute to and leverage the best practices and standards of analytics engineering

THE QUALIFICATIONS

• Proven skills, education, and/or applicable certifications in:
  • Excellent SQL skills with the ability to create efficient & tune data models
  • Strong business modelling skills: going from expressed requirements to an actual data model
  • Varied design options of reshaping data tables
  • Modern cloud data platforms such as GCP, MS, AWS
  • SAP HANA data environment is a plus
• An enthusiastic approach to taking on new opportunities and challenges
• The ability to collaborate fluently with cross-functional partners
• A commitment to learn and apply Aritzia's Business and People Leadership principles

THE COMPENSATION

The typical hiring range for this position is $95,000 - $170,000 CAD per year. The final agreed upon salary may vary based on factors such as job-related knowledge, skills and experience. Additionally, this position may be eligible for bonus.

We are always looking for top talent. If your qualifications differ from those listed above, the scope of work and final agreed upon salary may be adjusted to reflect your individual qualifications.

Aritzia's Everyday Luxury compensation package goes beyond the base salary with endless growth and recognition opportunities through our pay-for-performance philosophy. With comprehensive benefits, aspirational workspaces and elevated employee perks and experiences - we provide it all.

THE PERKS

• Product Discount - Maybe you've heard of our famous product discount? Or our exclusive private shopping events? You have now.
• A-OK Commissary & Café - Everyday Luxury dining, exclusive to Aritzia. Our in-house bistro and café is a private oasis where employees can enjoy curated, subsidized Everyday Luxury dining.
• The SET - Our in-office fitness studio and gym with state-of-the-art equipment, custom-created classes, and optional personal training. Open 7 days a week, works out well.
• Aritzia Virtual Wellness - Because your health, happiness, and safety matter - 24/7 resources to support you in your wellbeing goals, be it physical, mental, social, or financial.
• Aspirational Workplace - Our offices are specially designed to be spaces of creativity, productivity, and inspiration. They're also dog friendly. Woof.
• Amenities - Additional amenities include a private parent's room, shower facilities with elevated complementary conveniences, bike rooms, and more.
• The Extras - We also offer a multitude of other perks like dry-cleaning, hotel and restaurant discounts, self-care promos and on-site medical care.

ARITZIA

Aritzia is an Equal Employment Opportunity employer. Our goal is to be inclusive, diverse, and representative of the communities where we work while creating an environment where every person can enjoy a successful career. This commitment applies to all candidates and employees regardless of race, ethnicity, citizenship, creed, place of origin, religion, sex, gender identity, gender expression, sexual orientation, family status, marital status, disability, age, and any other protected characteristic.

Requests for accommodation due to a disability or any other protected characteristic can be made at any stage of the recruitment process and during employment by contacting our People & Culture Team.