Data Analyst I

Quartermaster inc.; Richmond; Hybrid; CAD 70,000 - 85,000; Full time

Job summary

A leading tech company in Canada is seeking a Data Team member to join their new data warehousing initiative. This role involves developing SQL queries, working with Tableau for data visualization, and collaborating with team members to drive data-driven decision-making while engaging in a hybrid work environment. Ideal candidates should have a strong background in SQL and an eagerness to solve complex problems.

Benefits

30 days of PTO annually

Health, dental and wellness benefits

Tech allowance benefit

Pregnancy and parental leave policies

Qualifications

• Minimum of 1 year of experience with SQL required.
• Experience with Business Intelligence tools (particularly Tableau) would be ideal.
• Experience with Python is a bonus but not required.

Responsibilities

• Building complex SQL queries to pull, clean, and aggregate data.
• Working with stakeholders to define clear metrics and translate business questions into data-driven insights.
• Cleaning, manipulating, and modeling data from multiple sources.

Skills

SQL

Critical Thinking

Problem Solving

Attention to Detail

Education

Degree or certificate in Mathematics, Computer Science, Statistics, Social Sciences, Engineering or related field

Tools

Tableau

Python

Job description

BUILD SOMETHING YOUR NEIGHBOURS WILL LOVE

We’re building Toronto’s dedicated platform for home management to empower the city’s homeowners and to better connect our neighbours and the local Pros they trust.

Our focus is purely on the GTA market right now. We build our property base one street at a time, and our marketplaces one neighbourhood at a time. We’re a local tech company in every sense of the word. We start with integrity, neighbourhood values, and competitive craftsmanship, and we build our business on neighbourhood trust.

We believe in holistic solutions to consumer problems. We believe in high-trust hyperlocal communities. We believe in low commission marketplaces that the best Pros can actually say yes to. And we believe that tech companies should go to work for the locally loved Pros of the GTA rather than trying to get those Pros to effectively work for the tech company. We believe that it’s good business to care. We believe that this problem space deserves a form of digital transformation that the people and Pros of Toronto can trust and invest in.

If this resonates with you and you’re at a point in your career and your life where you want to do something uniquely difficult for a meaningful outcome, you’ve found your next home.

ROLE SALARY BAND

$70,000-85,000/year

ROLE OVERVIEW

We’re looking for an eager, team-player to join the Data Team at Quartermaster, reporting to the Technical Product Manager. As we kick-off data warehousing and Tableau team-wide, we’re looking for a self-starter in the data space to help us model data from various sources, and publish it in the cloud for non-technical team members to understand and analyze. This team member will be responsible for working alongside data engineers, Product Managers and Team Leads to ensure we have the right data to clearly understand business problems, and ensure that translates in the datasets and dashboards in Tableau. This role will kick off with Snowflake and Tableau data cleaning and modelling,, and down the road will transform into maintenance of existing data models, running analyses and facilitating team requests for visualizations and dashboards within Tableau. The perfect candidate will come in with strong SQL and critical thinking skills, as well as an eagerness to learn, own, solve problems, and drive data-forward decision making across the company. This role is a minimum of 50% in-person.

WHAT YOU WILL BE DOING

• Building complex SQL queries to pull, clean, and aggregate data from multiple sources
• QAing and troubleshooting datasets to ensure accuracy, reliability and consistency
• Working with stakeholders (Product Managers and Team Leads) to define clear metrics, and translate business questions into data-driven insights
• Cleaning, manipulating, and modelling data from multiple sources, then publishing in Tableau for team-driven analysis
• Partnering with team members to understand KPIs and build Tableau dashboards to monitor progress towards these KPIs
• Working with non-technical team members to use and interpret data and dashboards
• Helping to inform data modelling and transformation in the ETL process of data warehousing initiatives

WHAT YOU BRING

• Degree or certificate in Mathematics, Computer Science, Statistics, Social Sciences, Engineering or related field
• Minimum of 1 year of experience with SQL required (any flavour)
• Experience with Python is a bonus but not required
• Experience with Business Intelligence tools (particularly Tableau) would be ideal, but not required
• Strong attention to detail and eagerness to problem solve is a must

THIS IS A GOOD FIT FOR YOU IF…

• You’re mission-driven and looking to solve the mission’s hardest problems.
• You’re at a point in your life and your career where you want to tackle a uniquely demanding job to produce meaningful impact.
• You’re keen to work in-person with a team.
• You show up like an owner.
• You want to value the equity and solve for others.

TEAM VALUES

Integrity – We prioritize integrity over comfort, convenience, and the short-cuts of success that drive metrics but undermine trust.

Trust – We cannot win unless we win on trust. Trust is hard to earn and easy to lose. We need to be built for it in our DNA.

Competitiveness – We believe that competitiveness is a critical complement to integrity and trust. If we’re not our customer’s best choice, then we’re wasting their time. We believe in the power of healthy competitive markets, and we believe we need to be uniquely competitive to win in this space. We have too much respect for the other players in this space to expect things to be easy. That’s a good thing.

Empowerment – Any win we achieve needs to be first and foremost a win that we deliver to others, starting with our customers, and their long term best interests.

VACATION AND BENEFITS

We know the power it takes to be successful in a challenging mission and we want to ensure our team is rested and ready to go.

• We offer 30 days of PTO annually, which can be used for vacation, personal days, or illness. Five of these days are designated as company-wide closures around the start and end of the year.
• In addition, our benefits plan covers health, dental and wellness to add that extra pep in our step, and help us sleep at night.
• We have a tech allowance benefit to help set you up for work.
• We have pregnancy and parental leave policies, and we’re ready to support your family’s next stage of growth.

EMPLOYEE OWNERSHIP

We’re a team on a mission. We expect a high degree of ownership from each other and we pair that with higher than usual employee ownership in the company.

LOCATION

Hybrid #LI-HYBRID