Business Consultant, Data Warehouse & BI Reporting

Adecco; Toronto; On-site; CAD 80,000 - 100,000; Full time

Job summary

A leading company in Toronto is seeking a Business Consultant specializing in Data Warehouse and BI Reporting for a 6–9-month contract. The role involves managing SQL and Snowflake systems, automating data processes, and creating visualizations. Candidates should have strong Python and SQL skills, with a CFA designation as an asset. This hybrid position requires in-office presence at least two days a week.

Qualifications

• At least 3 years of experience in a similar role.
• Proficiency in ETL processes and tools.

Responsibilities

• Managing SQL Server and Snowflake systems.
• Creating data visualizations using Power BI.

Skills

Python

SQL

Communication

Problem-Solving

Education

CFA designation

Tools

Power BI

Snowflake

GitHub

Job description

Business Consultant, Data Warehouse & BI Reporting

Adecco is currently recruiting for a Business Consultant, Data Warehouse & BI Reporting for a 6–9-month contract (depending on workload). This role is with our Crown Corporation client in Toronto, ON. The successful candidate must hold a valid Reliability Security Clearance or be eligible for one. This role is hybrid, requiring at least two days a week in the office at Dundas Street, Toronto.

Responsibilities include:

• Managing SQL Server and Snowflake systems, including access management and maintenance
• Supporting data modeling and integration between Snowflake and SimCorp Dimension
• Developing and building tables on Snowflake based on business requirements
• Automating data transformation, ingestion, and extraction through scripting
• Creating data visualizations using Power BI and Snowflake Streamlit
• Managing and maintaining the GitHub repository

Minimum requirements:

• At least 3 years of experience in a similar role or related field
• Experience with pension/investment data
• Proficiency in ETL processes and tools
• Strong skills in Python programming and SQL
• Familiarity with investment applications such as Bloomberg, SimCorp, etc.
• Experience with cloud solutions like Snowflake
• Proficiency in data visualization tools, including Power BI and Python libraries
• Expertise in data management and database administration
• Knowledge of trading lifecycle and investment workflows
• A CFA designation is a strong asset
• Excellent communication, coordination, and problem-solving skills

If interested, please submit your resume promptly.