Job specializations:
-
IT/Tech
Job Description & How to Apply Below
We are seeking a talented and proactive BI Developer for a full-time contract opportunity based in Montreal, Canada. In this role, you will take on a vital business intelligence, data engineering, and analytics visualization capacity, specializing in designing scalable data models, engineering robust cloud data pipelines, and delivering actionable decision-support reporting solutions.
Operating within a hybrid work model in Montreal, you will bridge the gap between enterprise operational data stores, modern cloud data platforms, and cross-functional business stakeholders. You will model complex enterprise transactional data including SAP data structures within Snowflake using Matillion ETL/ELT pipelines and AWS cloud services. Additionally, you will build intuitive visual dashboards in Tableau and Power BI and develop supporting ASP.NET
application components to enable seamless data integration. This position demands an analytics practitioner with strong SQL proficiency, modern cloud data warehousing expertise, dimensional modeling capabilities, and effective communication skills to translate business requirements into impactful BI solutions.
Location:
Montreal, Canada
Assignment Type:
Hybrid (3 days onsite, 2 days remote per week)
Contract Duration: 6-month contract (with extension potential)
Avantages
Modern Cloud Analytics:
Build high-performance data models and pipelines utilizing Snowflake, Matillion, and AWS cloud services.
Dual Visualization Stack:
Create interactive, executive-ready dashboards across both Tableau and Microsoft Power BI.
Enterprise Data Scope:
Gain hands-on exposure modeling complex enterprise data structures from SAP ECC and S/4
HANA systems.
Balanced Hybrid Model:
Enjoy flexibility with a structured schedule requiring 3 days onsite and 2 days work from home.
Responsabilités
Design dimensional and analytical data models utilizing star and snowflake schemas to establish scalable, reliable business intelligence architectures.
Develop, tune, and maintain advanced SQL queries, views, stored procedures, and analytical data transformations in Snowflake.
Build, schedule, and optimize enterprise ETL and ELT data pipelines utilizing Matillion.
Utilize AWS cloud services—including S3 data storage, compute instances, SQS message queues, SNS notifications, and Lambda functions—to support data ingestion and processing workflows.
Create, optimize, and maintain interactive visual dashboards and operational reports in Tableau and Microsoft Power BI to deliver actionable insights.
Model and transform complex transactional data from enterprise systems like SAP ECC and S/4
HANA into standardized, business-friendly analytical structures.
Collaborate closely with business stakeholders to elicit reporting requirements, define key performance indicators (KPIs), and deliver scalable data-driven solutions.
Develop, enhance, and support applications using ASP.NET to facilitate reporting needs and custom data integration workflows.
Support ongoing organizational rebranding initiatives, system transitions, and reporting updates.
Utilize Jira and Confluence to manage Agile sprint planning, backlog refinement, task execution, and technical documentation.
Conduct data validation, reconciliation checks, and quality assurance testing across data pipelines and reporting outputs.
Qualifications
Core Technical & Business Intelligence Requirements
Professional
Experience:
Minimum 3+ years of full-time professional experience in Business Intelligence, Data Engineering, or Analytics Engineering.
Advanced SQL & Modeling:
Expert-level SQL querying and optimization skills, with demonstrated experience designing dimensional star and snowflake data models.
Cloud Data Warehousing:
Solid hands-on experience developing and managing data models within the Snowflake data platform.
ETL/ELT Tools:
Proven practical experience building and optimizing data transformation pipelines using Matillion.
AWS Cloud Services:
Practical proficiency utilizing core AWS cloud services, including storage, compute, SQS, SNS, and AWS Lambda.
Data Visualization:
Hands-on experience developing reports and interactive dashboards in Tableau and Microsoft Power BI.
SAP Data Structures:
Hands-on experience analyzing and modeling transactional data from SAP ECC or SAP S/4
HANA systems.
Application Development:
Practical experience with ASP.NET or general web application development supporting data integration.
Preferred Technical Assets & Methodologies
Certifications:
Snowflake certification or AWS…
To View & Apply for jobs on this site that accept applications from your location or country, tap the button below to make a Search.
(If this job is in fact in your jurisdiction, then you may be using a Proxy or VPN to access this site, and to progress further, you should change your connectivity to another mobile device or PC).
View / Apply for Jobs
Matching My Jurisdiction
(If this job is in fact in your jurisdiction, then you may be using a Proxy or VPN to access this site, and to progress further, you should change your connectivity to another mobile device or PC).
View / Apply for Jobs
Matching My Jurisdiction