Apply

Ready to go for it?

AI Apply speeds things up—apply directly if you prefer.

FREE ACCESS
5,000–10,000 jobs/day
Scoutfield Logo

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.
Go RH

Database and BI Programmer-Analyst

Go RH

. Participate in the design, modeling, and evolution of information architectures, dimensional models, and a data warehouse on Azure .

Posted 10/14/2026full-timeDrummondville • CanadaMid-LevelSeniorWebsite

Core Competencies

Role fit
Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates expertise in designing and optimizing data architectures and pipelines, with a strong focus on Azure Data Factory, SQL, and Power BI. Proven ability to collaborate with cross-functional teams while ensuring data integrity and quality through rigorous documentation and adherence to best practices.

Highest-signal resume keywords
Azure Data FactorySQL DevelopmentData WarehousingPower BI Dashboard CreationETL Data Integration

ATS Keywords

Tailor your resume
Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills
T-SQL DevelopmentData ModelingDimensional ModelingData VaultSSISSSRSAdvanced Query WritingData Pipeline OptimizationCloud DatabasesConceptual Modeling
Soft Skills
Team-OrientedSelf-MotivatedAttention to DetailAnalytical MindsetIntellectual Curiosity
Tools & Technologies
Azure SQLJiraConfluenceGitBitbucket
Certifications & Qualifications
Bachelor’s Degree in Computer ScienceDiploma of College Studies in Computer Science
Industry Keywords
Information ArchitectureData WarehouseScrum MethodologyData FlowsContinuous Monitoring

Tech Stack

Tools & technologies
AzureETLFluxSQLSSISVault

About the role

Key responsibilities & impact
  • Participate in the design, modeling, and evolution of information architectures, dimensional models, and a data warehouse on Azure
  • Design, develop, optimize, and maintain high-performance data pipelines using Azure Data Factory and SSIS
  • Write and optimize advanced queries, complex stored procedures, and Transact-SQL (T-SQL) scripts
  • Create and enhance interactive dashboards and analytical reports in Power BI
  • Work using the Scrum methodology with three-week sprints
  • Participate in peer code reviews
  • Rigorously document solutions in Jira and Confluence
  • Ensure the security, reliability, integrity, and continuous monitoring of data flows and databases
  • Collaborate closely with business analysts and the quality assurance team
  • Report to the Database Team Lead within the Strategy and Innovation department

Requirements

What you’ll need
  • Bachelor’s degree in Computer Science or Mathematics, or a Diploma of College Studies (DEC) in Computer Science combined with relevant experience
  • Minimum of 5 years of experience in data warehousing and data modeling
  • Excellent knowledge of SQL and T-SQL development
  • Good understanding of ETL data integration pipelines
  • Hands-on experience with Azure Data Factory and cloud databases (Azure SQL)
  • Experience with Power BI, including data modeling and dashboard creation
  • Knowledge of SSIS and SSRS
  • Experience with conceptual modeling, dimensional modeling, or Data Vault
  • Familiarity with Git (Bitbucket), Jira, and Confluence
  • Team-oriented and considerate
  • Self-motivated and thorough
  • Strong attention to detail, code quality, and clear documentation
  • Analytical mindset and intellectual curiosity

Benefits

Comp & perks
  • Healthy Enterprise certified organization
  • Access to the head office gym
  • Instructor-led classes
  • Health and wellness program
  • Telemedicine
  • Employee Assistance Program (EAP)
  • Flexible schedule
  • Hybrid work model with a minimum of one day per week on-site
  • Cell phone reimbursement allowance
  • Defined benefit pension plan
  • Comprehensive group insurance
  • Generous annual vacation policy
  • Personal days allowance
  • Ongoing training encouraged and reimbursed
  • Inclusive and equitable work environment
  • Accommodations available upon request during the hiring process