Analyze business and technical requirements, assess data quality and flows, and define reporting and dashboard improvements. Use SQL, Azure Synapse, and MicroStrategy to produce actionable insights, identify process automation opportunities, and communicate findings to stakeholders. The role requires independent work, strong analytical problem-solving, and confidence leading discussions.
5-8+ years of experience, ability to work independently with
both business and technical stakeholders
Skillset required:
- The
ideal candidate should have strong experience in SQL, Azure Synapse,
MicroStrategy
- Additional
skills considered an asset Databricks, Power BI
- Beyond
technical expertise, the consultant should demonstrate:
- Strong
analytical and problem-solving capabilities
- Experience
gathering and analyzing business requirements and identifying
opportunities for process improvement and automation
- Ability
to assess data quality, data flows, reporting needs, and recommend and
define new reporting/dashboard requirements
- Strong
communication skills and confidence leading discussions, asking probing
questions, and translating business needs into actionable insights
Similar Jobs
Fintech • Machine Learning • Payments • Software • Financial Services
Build and maintain data structures, pipelines, reporting, visualizations, and data processes using data lake and Snowflake technologies. Ensure data quality, documentation, and usability while performing investigative analysis on large datasets. Collaborate cross-functionally to identify business problems, recommend solutions, and support end-to-end deployment. The role requires a quantitative bachelor’s degree, coding experience, SQL or dbt familiarity, and data pipeline experience.
Top Skills:
AWSData LakeData PipelinesDbtGitLinuxPythonSnowflakeSQL
Design • Manufacturing
Build and maintain Power BI dashboards, data models, SQL queries, and Crystal Reports. Administer reporting infrastructure, validate data, document reporting processes, gather management requirements, and provide user training and support. The role also includes light HTML, CSS, and Bootstrap work, report embedding, presentation materials, version control with Git and GitHub, and collaboration with software developers on manufacturing and business systems.
Top Skills:
BootstrapCrystal ReportsCSSDaxGitGitHTMLPower BIPower QuerySQLWindows Server
Fintech • Insurance
Supports ALM Portfolio Management and Execution Data by troubleshooting hedging activities, automating work products, analyzing hedge performance, investigating balance-sheet risk metrics, and developing expertise in risk measurement and simulation. The role requires finance or quantitative studies, prior finance co-op experience, coding skills, and knowledge of financial products and derivatives. This is a four-month, full-time student co-op position in Toronto.
Top Skills:
HiveExcelPythonSQLTableauVBA
What you need to know about the Toronto Tech Scene
Although home to some of the biggest names in tech, including Google, Microsoft and Amazon, Toronto has established itself as one of the largest startup ecosystems in the world. And with over 2,000 startups — more than 30 percent of the country's total startups — Toronto continues to attract new businesses. Be it helping entrepreneurs manage their finances, simplifying business operations by automating payroll or assisting pharmaceutical companies in launching new drugs, the city's tech scene is just getting started.
