BI Developer & Data Analyst Contractor

Dexian; Montreal; On-site; CAD 96,000 - 124,000; Part time

Job summary

Dexian is seeking two experienced BI Developer & Data Analyst Contractors to design scalable analytics solutions for manufacturing, engineering and business ops from its Lachine, Montreal base. You will build Snowflake data models, pipelines with Matillion, and dashboards in Power BI/Tableau, translating SAP data into actionable insights.

Strong SQL, SAP data experience, and collaboration in Agile Scrum are required.

Qualifications

• 3+ years full-time BI/Data Engineering experience.
• Expert SQL development for complex queries.
• Snowflake data warehousing expertise.
• Proficiency in AWS cloud services and data pipelines.
• Matillion ETL/ELT experience.
• Tableau and Power BI visualization experience.
• Agile Scrum collaboration and communication.
• SAP ECC or S/4HANA data modeling experience.
• ASP.NET or web app development experience.
• Interest in ML/LLM for long-term opportunities.

Responsibilities

• Design dimensional and analytical data models (star/snowflake) and scalable data pipelines.
• Develop and optimize SQL queries and Snowflake data models using Matillion.
• Utilize AWS services for storage, SQS, SNS, and Lambda functions.
• Create interactive dashboards in Tableau and Power BI.
• Model SAP transactional data in Snowflake for analytics and insights.
• Collaborate with stakeholders to define KPIs and requirements.
• Use Jira/Confluence within an Agile Scrum framework for project delivery.
• Develop and maintain ASP.NET applications for data integration.

Skills

SQL development

Snowflake

AWS cloud

Matillion

Tableau

Power BI

Data modeling

ETL/ELT

ASP.NET

Agile Scrum

SAP data modeling

Python

Tools

Matillion

Tableau

Power BI

Job description

Job Title: BI Developer & Data Analyst Contractor

Period 6 months with possibility for extension

Work Location: Lachine CAN H8T 3H1

Job Description:

We are seeking for 2 experienced BI Developer & Data Engineer Contractor to design and implement scalable analytics solutions supporting manufacturing, engineering, and business operations. The successful candidate will develop Snowflake-based data models, build data pipelines using Matillion, integrate SAP data sources, and deliver business-critical dashboards using Power BI. This role requires strong SQL expertise, business engagement skills, and the ability to translate complex operational data into actionable insights.

Key Responsibilities:

• Design dimensional and analytical data models using star and snowflake schemas, and build scalable, reliable data pipelines to support analytics and business intelligence initiatives.
• Develop and optimize advanced SQL queries, views, stored procedures, and data models in Snowflake using Matillion for reporting and analytics solutions.
• Utilize AWS cloud services for data storage, computation, SQS queues, SNS notifications, and Lambda functions.
• Create and maintain interactive dashboards and reports in Tableau and PowerBI to provide actionable insights.
• Model complex SAP transactional data in Snowflake to enable advanced analytics, reporting, and cross-functional business insights.
• Collaborate with business stakeholders to gather reporting requirements, define KPIs, and translate business needs into technical solutions.
• Use Jira and Confluence within an Agile Scrum framework to manage sprint planning, backlog grooming, task tracking, and technical documentation, ensuring efficient project delivery and team collaboration.
• Develop and maintain applications using ASP.NET to support data integration and reporting needs.
• Support Rebranding efforts

Qualifications:

• Minimum 3 years full time work experience in Business Intelligence, Data Engineering, 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 PowerBI.
• Excellent collaboration and communication skills, with experience working in Agile Scrum environments.
• Hands-on experience analyzing and modeling SAP ECC or S/4HANA data structures, with the ability to transform transactional SAP data into business-friendly analytical models.
• Experience with ASP.NET or web application development.
• Knowledge of Machine Learning and LLM models would be preferrable for the long-term

Preferred Skills

• Snowflake certification
• AWS analytics services
• Power BI Data Modeling (DAX)
• Tableau
• SAP ECC or S/4HANA
• Python for automation and data processing
• Experience in manufacturing or energy industries
• Experience working with Agile Scrum teams

Dexian stands at the forefront of Talent + Technology solutions with a presence spanning more than 70 locations worldwide and a team exceeding 10,000 professionals. As one of the largest technology and professional staffing companies and one of the largest minority-owned staffing companies in the United States, Dexian combines over 30 years of industry expertise with cutting-edge technologies to deliver comprehensive global services and support.

Dexian connects the right talent and the right technology with the right organizations to deliver trajectory-changing results that help everyone achieve their ambitions and goals. To learn more, please visit https://dexian.com/.

Dexian is an Equal Opportunity Employer that recruits and hires qualified candidates without regard to race, religion, sex, sexual orientation, gender identity, age, national origin, ancestry, citizenship, disability, or veteran status.