FREE ACCESS
5,000–10,000 jobs/day
See all jobs on Scoutfield
Search thousands of fresh jobs every day.
Discover
- Fresh listings
- Fast filters
- No subscription required
Create a free account and start exploring right away.
Core Competencies
Role fitCore Competencies
Use this summary to align your resume positioning with the role.
Demonstrates expertise in data architecture, dimensional modeling, and SQL programming, with a strong focus on developing scalable data models and optimizing data pipelines. Proficient in data governance and championing data literacy across business functions.
Highest-signal resume keywords
Data ArchitectureDimensional ModelingSQL ProgrammingData Pipeline DevelopmentTableau Dashboard Design
ATS Keywords
Tailor your resumeApplicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard Skills
Data ModelingSQL ProgrammingDimensional ModelingData Pipeline DevelopmentData GovernanceMetric StandardizationData Quality EnforcementDBTTableauCloud Data Platforms
Soft Skills
Proactive Problem-SolvingStrong CommunicationStakeholder ConsultationAbility to Work IndependentlyComfort in Ambiguous Environments
Tools & Technologies
DBTTableauSnowflakeBusiness Intelligence Platforms
Certifications & Qualifications
DBT CertificationTableau CertificationData Engineering Certification
Industry Keywords
Data GovernanceSelf-Service AnalyticsPerformance TuningData TransformationEnterprise Reporting
Tech Stack
Tools & technologiesCloudSQLTableau
About the role
Key responsibilities & impact- Design and develop scalable, efficient data models and governed semantic layers
- Translate complex SQL queries into scalable and reusable semantic models
- Optimize pipeline performance and queries
- Collaborate with the Analytics team to model key business metrics
- Create and maintain enterprise reports and dashboards with actionable insights
- Develop and maintain reliable data transformation and loading pipelines
- Manage and configure the BI platform, including user access, data governance, performance tuning, and security
- Champion data literacy, governance, and adoption across the business
- Support strategic decisions and operational performance monitoring across Marketing, Sales, Customer Growth & Retention, Product, and other functional areas
- Report to the Manager, Business Intelligence
Requirements
What you’ll need- Extensive experience in data architecture and dimensional modeling, including star and snowflake schemas
- Practical experience or strong familiarity implementing semantic layers for self-service analytics
- Expert-level SQL programming skills
- Experience building and maintaining data pipelines using DBT
- Understanding or experience in data governance, metric standardization, data quality enforcement, and access control
- Advanced proficiency designing and constructing dashboards with Tableau or equivalent data visualization tools
- Solid understanding of complex relational data structures and modern cloud data platforms such as Snowflake
- Ability to champion data literacy and drive adoption of governed self-service analytics
- Proactive problem-solving approach and ability to work independently
- Strong communication and stakeholder consultation skills
- Comfort working in an ambiguous and fast-paced environment
- DBT certifications, Tableau certifications, and Data Engineering certifications are highly desired but not dealbreakers
- Legally entitled to work in Canada
- Successful completion of a background check, including identity verification
- Based in Edmonton, Toronto, Vancouver, or Kitchener-Waterloo
- Able to attend the office at least 1 day per week according to the department schedule
Benefits
Comp & perks- Equity rewards and stock options
- Annual stipends for health and wellness
- Retirement savings matching in RRSP, TFSA or FHSA
- Extended health package with fully paid premiums for body and mind
- Dedicated talent development program
- Career coaching
- Career development opportunities
- Coaching, learning, and leadership programs
- Fully covered pre-approved travel expenses for one in-person interview
- Inclusive work environment and equal opportunity employment
- Accommodation support during the hiring process