Customer Data Analyst
TealBook
BigQueryETLPythonSQL
Data Analyst
Roofr
full-time
Posted on:
Location Type: Remote
Location: Remote • 🇨🇦 Canada
Visit company websiteJob Level
Mid-LevelSenior
Tech Stack
CloudPostgresSQLTableau
About the role
- 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.
Requirements
- 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.
Benefits
- 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
- 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!
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard skills
data analysisanalytics engineeringSQLDBTdata transformationdata modelingdata warehousingcloud data warehousesbusiness intelligencedata quality
Soft skills
analytical mindsetattention to detailcross-functional collaborationcommunicationpresentation skills
