Job Title

Adecco is currently recruiting for a Business Consultant, Data Warehouse & BI Reporting for 69-month contract (base 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, which requires at least twice a week in the office. ( Dundas Street, Toronto) The Business Consultant, Data Warehouse & BI Reporting will have the following responsibilities: Manage SQL server and Snowflake as system administrator, such as access management, system maintenance Support and investment data modelling and integration between snowflake and SimCorp Dimension Develop and build tables on Snowflake according to business requirements Develop scripts to automate data transformation, ingestion and extraction Develop data visualization on Power BI and Snowflake Streamlit. Manage and maintain Github repository The Business Consultant, Data Warehouse & BI Reporting must meet the following mandatory requirements: Must have 1-3 in similar or related role Proficiency in Extract, Transform, Load (ETL) processes and tools. Strong proficiency in Python programming and SQL. Familiarity with investment applications such as Bloomberg, SimCorp, and similar platforms. Experience with cloud solutions such as Snowflake Proficiency in data visualization tools, including Power BI and Python-based libraries Expertise in data management and database administration. In-depth knowledge of the trading lifecycle and investment workflow. A CFA designation is considered a strong asset. Excellent communication and coordination skills. Demonstrated self-initiative and strong problem-solving abilities If you are interested in applying to our Investment Accounting Consultant position, please submit your resume as soon as possible