Business Consultant, Data Warehouse & BI Reporting

Job Description

<h3>Business Consultant, Data Warehouse & BI Reporting</h3><p>Adecco is currently recruiting for a <strong>Business Consultant, Data Warehouse & BI Reporting</strong> 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. <strong>This role is hybrid, requiring at least two days a week in the office at Dundas Street, Toronto.</strong></p><p><strong>Responsibilities include:</strong></p><ul><li>Managing SQL Server and Snowflake systems, including access management and maintenance</li><li>Supporting data modeling and integration between Snowflake and SimCorp Dimension</li><li>Developing and building tables on Snowflake based on business requirements</li><li>Automating data transformation, ingestion, and extraction through scripting</li><li>Creating data visualizations using Power BI and Snowflake Streamlit</li><li>Managing and maintaining the GitHub repository</li></ul><p><strong>Minimum requirements:</strong></p><ul><li>At least 3 years of experience in a similar role or related field</li><li>Experience with pension/investment data</li><li>Proficiency in ETL processes and tools</li><li>Strong skills in Python programming and SQL</li><li>Familiarity with investment applications such as Bloomberg, SimCorp, etc.</li><li>Experience with cloud solutions like Snowflake</li><li>Proficiency in data visualization tools, including Power BI and Python libraries</li><li>Expertise in data management and database administration</li><li>Knowledge of trading lifecycle and investment workflows</li><li>A CFA designation is a strong asset</li><li>Excellent communication, coordination, and problem-solving skills</li></ul><p>If interested, please submit your resume promptly.</p>
#J-18808-Ljbffr