Consultant – Business Intelligence & Data Analytics

Sapling Financial Consultants•Toronto, ON

1d•CA$90,000 - CA$130,000•Hybrid

About The Position

Sapling Financial Consultants is seeking an ambitious Consultant with experience in Business Intelligence, Data Analytics, and Statistical Analytics. The role emphasizes high-quality, impactful work that creates real value for clients. The company culture is driven by a principle of striving for excellence and taking pride in doing great work. As a Consultant, you will collaborate with co-founders and senior consultants to conduct in-depth analyses using financial and business data, and build comprehensive management reporting for clients. Sapling differentiates itself from larger firms with best-in-class work and seeks a candidate who can maintain this standard through their work ethic, attention to detail, and quality of work. The ideal candidate will have a long-term outlook and a desire to contribute to building a successful company focused on creating high-impact value for clients. This role offers opportunities to deepen and widen data analytics and modeling skills, gain hands-on experience with client and business development, and play a significant role in a small, growing team with ambitious future plans. The company operates on a hybrid model, requiring in-office presence on Tuesdays and Wednesdays in Toronto, with the remaining days worked from home, reflecting the trust placed in team members to complete their work independently.

Requirements

A Bachelor or Master’s degree in a relevant discipline (i.e., computer science, mathematics, statistics, engineering, science ) is required, though work experience in a relevant field coupled with a non-related Bachelor’s degree (humanities, social sciences, etc.) can substitute
Experience using programming languages (C#, R, Python, or other languages,) to manipulate data and draw insights from large data sets
Deep understanding of relational databases and hands-on experience with MySQL and/or SQL
Hands-on experience with Excel Lookup functions, Pivots, VBA Macros
Experience with data analysis and machine learning techniques (clustering, decision tree learning, artificial neural networks, etc.)
2-4 years experience in analytical role with involvement in screening / manipulating / analyzing big data sets and/or building/maintaining KPI dashboards
Intellectual curiosity and passion for learning about new industries and new businesses
Ability to take ownership of responsibilities and see them through to completion
Ability to work independently and manage time and multiple tasks / deadlines / deliverables at once
Strong dedication to the team and excellent work ethic, as well as enthusiasm about going above and beyond to ensure our clients achieve their business goals

Nice To Haves

Experience or certification using Microsoft Azure services is welcomed, but not a must
Experience in data visualization tools such as Power BI or Tableau is a strong differentiator
Experience with coaching junior staff and providing feedback is considered an asset
Desire to contribute to the firm over the long haul, with the understanding that loyalty and hard work will be recognized in both compensation and responsibilities far more quickly than in a large “brand-name” firm

Responsibilities

Data extraction from various systems including accounting systems, operational systems, HR systems, web databases etc. using data extraction tools, custom coding, API connectors, and other extraction techniques
Mine, analyze, and model large datasets to help define the structure of the database. Develop custom data warehouses and algorithms to apply to data sets
Comprehensive data manipulations and transformations using SQL to clean the data of any discrepancies and re-organize data sets in desirable forms
Use predictive modeling to assist in estimating revenue generation and other business outcomes
Preparing outputs for clients including business reporting packages, financial dashboards, and operational performance trackers using data visualization tools
Coordinate with different client teams to implement models. Develop processes and tools to monitor and analyze system performance and data accuracy
Develop financial analyses / data analyses providing actionable insight to management through spreadsheets
Oversee and conduct quality control on the work of the Analysts on the team
Manage client relationships, ensuring overall satisfaction and looking for pertinent opportunities to provide additional services to existing clients
As required, and depending on available billable work, assist with proposals (“live” client leads, government bids, etc.), marketing material development, writing of white papers and blogs, and help in the process of disseminating marketing materials (emails, webinars, etc.)