Senior Data Analyst

Roofr; Remote; CAD 80,000 - 100,000; Full time

Job summary

A growing technology company in Canada is seeking a Senior Data Analyst to transform data into valuable insights that shape product strategy and enhance customer experiences. The successful candidate will have over 4 years of experience, strong SQL skills, and proficiency in BI tools. This role involves building dashboards, analyzing trends, and collaborating with various teams. The company offers a remote-first culture, generous PTO, and ample development opportunities.

Benefits

Flexible time off

Home office setup stipend

Internet and phone allowance

Retreats and team activities

Generous parental leave policy

Qualifications

• Proven experience in data analysis and analytics engineering.
• Strong SQL skills with experience in cloud data warehouses.
• Hands-on experience with DBT for managing ELT pipelines.

Responsibilities

• Build and maintain dashboards and reports for insights.
• Identify trends and opportunities through data exploration.
• Transform and model raw data to create analytics-ready datasets.
• Maintain the data warehouse structure for efficiency.
• Present analytical findings to stakeholders.

Skills

Data analysis

SQL

Communication skills

Attention to detail

Education

4+ years of experience in data analysis or analytics engineering

Tools

Snowflake

Metabase

Tableau

DBT

Job description

At Roofr, we’re obsessed with our customers. We constantly gather feedback to shape, prioritize, and launch the products they truly need. That’s what makes Roofr’s CRM special. We started by building essential sales tools like aerial roof measurements and digital sales proposals. But when our customers asked for a simple, affordable way to manage and scale their entire businesses, we listened. So, we created a CRM that connects these solutions—along with payments, material ordering, and more—into a seamless, powerful platform. With a clear roadmap ahead, we’re excited to continue expanding and leading the market with innovative products.

We have an amazing culture, strong financials, and best-in-class company metrics. It’s an exciting time to be part of an extraordinary startup that is already successful, yet still early enough to offer its team significant growth, equity, and the opportunity to make a real impact.

Senior Data Analyst

At Roofr, building a powerful user experience starts with data. As a Senior Data Analyst at an early‑stage, high‑growth company, you’ll play a critical role in turning raw data into insights that shape product decisions, drive strategy, and improve the customer experience. You’ll have a direct impact on how we use data to grow, and help influence the roadmap for how analytics evolves at Roofr.

This role sits at the intersection of data analytics and data modeling, ideal for someone comfortable moving between building dashboards and transforming data in the warehouse.

What You'll Get to Do:

• Build and maintain dashboards and reports to deliver clear, actionable business insights.
• Identify trends and uncover business opportunities through deep data exploration.
• Transform, clean, and model raw data using DBT to create reliable, analytics‑ready datasets.
• Maintain and improve the data warehouse structure (e.g., Snowflake) with efficient, scalable models (e.g., star/snowflake schemas).
• Present analytical findings in clear, compelling formats to stakeholders across the organization, including sales & marketing, finance, and product teams.

What You'll Bring to the Role:

• 4+ years of experience in data analysis and/or analytics engineering.
• Proficient in BI tools like Metabase, Sigma, Tableau, or Looker.
• Strong SQL skills and experience with cloud data warehouses (e.g., Snowflake, PostgreSQL).
• Hands‑on experience with DBT for managing the Transform layer of ELT pipelines.
• Ability to work cross‑functionally to define metrics, create dashboards, and ensure data quality.
• A strong analytical mindset with a keen eye for detail and accuracy.

Who You Are:

• A strong communicator with great presentation skills.
• Analytical with a demonstrated ability to utilize data to make informed decisions.
• Highly organized and able to prioritize and juggle multiple projects at once.
• You are a critical thinker who doesn’t settle for the status quo.
• You are driven by a desire to improve the customer experience through data.

🏠 What we offer (US + Canada)

When you join our team, you’re not just accepting a job. You’re making a career move. Here’s how we’ll support you in doing some of the most impactful work of your career:

🏝️ Vacation/Paid Time Off:

• 1st week of employment is mandatory PTO! Start your journey with Roofr by decompressing and recharging - we will see you in week 2!
• 1 Friday off per month (we call those our laundry days!)
• Company wide paid shutdown for the week between Christmas and New Years.
• Flexible time off.
• 80% employer paid benefits.
• RRSP/401k match.
• Generous parental leave policy.

🤝 Perks:

• We host 2 retreats per year and great team building activities.
• Ample learning and development opportunities to continue growing your career.
• Home office setup stipend.
• Internet and phone allowance.
• Remote first culture.
• Weekly Friday paydays!

🤖 AI Notice

At Roofr, we’re big fans of AI. It helps us write job descriptions that don’t put you to sleep, takes notes during interviews so we can actually listen, and even helps us track down awesome humans like you.

Feel free to use AI to prep, research, or get pumped up for your interview (we see you, ChatGPT power users 👀). But when it’s time to chat, we’d love to meet you, not your AI alter ego. Bring your real, unfiltered self, we promise we will too.

And don’t worry, a real, live human is behind every part of our process. Every application is reviewed by a real person, and you’ll always speak with real humans throughout the interview process. No bots, just good people ☺️.

⚠️ Important Notice

We’ve been made aware of an individual impersonating Roofr using a fraudulent domain: roofrr.com (note the extra “r”). Our company takes the security and privacy of job applicants very seriously. We will never ask for payment, bank details, or personal financial information as part of the application process. All our legitimate job postings can be found on our official career site. Please be cautious of job offers that come from non‑company email addresses, instant messaging platforms, or unsolicited calls.

To ensure your application is legitimate, please apply directly through our official careers page: https://roofr.com/careers.

If you receive any suspicious messages or have questions, reach out to us at [e-mail].

Roofr is proud to be an equal opportunity employer. We are committed to equal employment opportunity in the workplace regardless of race, color, ancestry, religion, sex, national origin, sexual orientation, age, citizenship, marital status, disability, gender identity or veteran status.