BI Developer & Data Analyst

GrizzlyTrek Group

Montreal

Hybrid

CAD 70,000 - 110,000

Full time

3 days ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

GrizzlyTrek Group in Lachine, Quebec, seeks a BI Developer & Data Analyst on a 6-month contract to drive data-driven decisions. You will design Snowflake data models, build Matillion pipelines, and deliver Power BI/Tableau dashboards using SAP data.

The role requires expert SQL and 3+ years in BI/Analytics, with on-site 3 days and remote 2 days weekly in a full-time contract.

Qualifications

  • Minimum 3 years full-time work in BI, data engineering or analytics engineering.
  • Expert-level SQL development with a proven track record of optimizing complex analytical queries.
  • Strong experience with Snowflake data warehousing.
  • Proficiency with AWS cloud services and data pipeline development.
  • Experience with ETL/ELT processes and tools, specifically Matillion.
  • Familiarity with Tableau and Power BI.
  • Hands-on experience modeling SAP ECC or S/4HANA data structures for analytics.
  • Experience with ASP.NET or web application development.
  • Excellent collaboration and communication in Agile Scrum environments.

Responsibilities

  • Design dimensional and analytical data models using star and snowflake schemas.
  • Build scalable data pipelines to support analytics and BI work.
  • Develop and optimize SQL queries and data models in Snowflake using Matillion.
  • Use AWS services for storage, computation, SQS queues, SNS notifications and Lambda functions.
  • Create and maintain dashboards in Tableau and Power BI.
  • Model SAP transactional data in Snowflake for analytics and reporting.
  • Collaborate with stakeholders to gather reporting requirements and KPIs.
  • Work in Agile Scrum with Jira/Confluence for planning and documentation.
  • Develop and maintain ASP.NET apps supporting data integration and reporting.

Skills

SQL
Power BI
Tableau
SAP ECC/S/4HANA
ASP.NET
Snowflake
Matillion
AWS

Tools

Matillion
AWS
Snowflake
Power BI
Tableau
SAP ECC/S/4HANA
ASP.NET

Job description

BI DEVELOPER & DATA ANALYST (CONTRACT) | LACHINE, QC

Lachine (Montreal), Quebec | 6 Month Contract, Extendable | 2 Openings

Hiring now.

A global energy sector organization is hiring two BI Developer & Data Analyst contractors for its digitalization team in Lachine, Quebec. If you write expert-level SQL and have built on Snowflake, Matillion, AWS and Power BI with SAP data underneath, we want to hear from you.

AT A GLANCE

Role BI Developer & Data Analyst (Contract)

Openings 2

Location Lachine (Montreal), Quebec

Position Type Full time contract, 6 months, extendable

Schedule On site 3 days a week, remote 2 days a week

Compensation Competitive, based on experience

Experience Minimum 3 years full time in Business Intelligence, Data Engineering or Analytics Engineering

Core Stack SQL, Snowflake, Matillion, AWS, Power BI, Tableau, SAP ECC or S/4HANA, ASP.NET

ELIGIBILITY REQUIREMENT
  • Must be eligible to access and work with Canadian Export-Controlled Goods, technical data and related systems, in accordance with applicable Canadian regulations and company policies
THE ROLE

You design and build scalable analytics that support manufacturing, engineering and business operations. You develop Snowflake data models, build pipelines in Matillion, integrate SAP data sources, and deliver business-critical dashboards in Power BI. The job takes strong SQL, time with business stakeholders, and the ability to turn complex operational data into insight people can act on.

WHAT YOU'LL DO
  • Design dimensional and analytical data models using star and snowflake schemas
  • Build scalable, reliable data pipelines to support analytics and business intelligence work
  • Develop and optimize advanced SQL queries, views, stored procedures and data models in Snowflake using Matillion
  • Use AWS cloud services for data storage, computation, SQS queues, SNS notifications and Lambda functions
  • Create and maintain interactive dashboards and reports in Tableau and Power BI
  • Model complex SAP transactional data in Snowflake for advanced analytics, reporting and cross-functional business insight
  • Work with business stakeholders to gather reporting requirements, define KPIs and turn business needs into technical builds
  • Use Jira and Confluence within an Agile Scrum framework for sprint planning, backlog grooming, task tracking and technical documentation
  • Develop and maintain ASP.NET applications that support data integration and reporting
  • Support corporate rebranding work
REQUIRED QUALIFICATIONS
  • Minimum 3 years of full time work experience in Business Intelligence, Data Engineering or Analytics Engineering
  • Expert-level SQL development skills with a proven track record of optimizing complex analytical queries
  • Strong experience with Snowflake data warehousing
  • Proficiency in AWS cloud services and data pipeline development
  • Experience with ETL/ELT processes and tools, specifically Matillion
  • Familiarity with data visualization tools such as Tableau and Power BI
  • Hands‑on experience analyzing and modeling SAP ECC or S/4HANA data structures, and turning transactional SAP data into business-friendly analytical models
  • Experience with ASP.NET or web application development
  • Excellent collaboration and communication skills, with experience in Agile Scrum environments
PREFERRED QUALIFICATIONS
  • Snowflake certification
  • AWS analytics services
  • Power BI data modeling (DAX)
  • Tableau
  • Python for automation and data processing
  • Git version control
  • Experience in manufacturing or energy industries
  • Knowledge of Machine Learning and LLM models, for the long term
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Développeur BI et analyste de données / BI Developer & Data Analyts Contractor
Développeur BI et analyste de données / BI Developer & Data Analyts Contractor

Raise - find a more meaningful working experience • Montreal

On-site
CAD 85,000 - 105,000
BI Developer & Data Analyst Contractor
BI Developer & Data Analyst Contractor

Dexian • Montreal

On-site
CAD 96,000 - 124,000
BI Developer & Data Engineer (Contract)
BI Developer & Data Engineer (Contract)

Altis • Montreal

Hybrid
CAD 83,000 - 124,000
Hybrid schedule
Exposure to enterprise-scale data平台
Digital transformation projects
+1
BI Developer
BI Developer

Globaldataandbi • Toronto

Hybrid
CAD 120,000 - 180,000
Professionnel(le) des opérations TI - BI Developer & data Engineer / BI Developer & data engineer - IT Operations Professional
Professionnel(le) des opérations TI - BI Developer & data Engineer / BI Developer & data engineer - IT Operations Professional

Expleo Group • Montreal

On-site
CAD 75,000 - 110,000
Assurance santé
Dentaire et vue
VIE et DMA et assurance voyage
+4
Business Analyst
Business Analyst

Altis • Montreal

Hybrid
CAD 90,000 - 130,000
Professionnel(le) des opérations TI - Approvisionnement / Procurement IT Operations Professional
Professionnel(le) des opérations TI - Approvisionnement / Procurement IT Operations Professional

Expleo Group • Montreal

On-site
CAD 75,000 - 110,000
Assurance santé, dentaire & vision
Soutien soins virtuels Dialogue
Assurance vie & DMA
+7
Professionnel(le) des opérations TI - Approvisionnement / Procurement IT Operations Professional
Professionnel(le) des opérations TI - Approvisionnement / Procurement IT Operations Professional

Expleo Group • Montreal

On-site
CAD 75,000 - 110,000
Assurance santé
Assurance dentaire
Assurance vue
+7
Developer, BI
Developer, BI

Dollarama • Mount Royal

On-site
CAD 110,000 - 140,000
Data & Reporting Analyst - SQL (Power BI and Tableau)
Data & Reporting Analyst - SQL (Power BI and Tableau)

Astra-North Infoteck Inc. • Toronto

Hybrid
CAD 70,000 - 90,000