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 maintenanceSupport and investment data modelling and integration between snowflake and SimCorp DimensionDevelop and build tables on Snowflake according to business requirementsDevelop scripts to automate data transformation, ingestion and extractionDevelop data visualization on Power BI and Snowflake Streamlit.Manage and maintain Github repositoryThe 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 SnowflakeProficiency in data visualization tools, including Power BI and Python-based librariesExpertise 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 abilitiesIf you are interested in applying to our Investment Accounting Consultant position, please submit your resume as soon as possible