Analyst – Business Intelligence & Data Analytics

Sapling Financial Consultants•Toronto, ON

1d•CA$65,000 - CA$85,000•Hybrid

About The Position

Sapling Financial Consultants is seeking an ambitious Analyst with training and ideally some hands-on experience in Business Intelligence, Data Analytics, and Statistical Analytics. The role focuses on performing high-quality, impactful work that creates real value for clients. The ideal candidate strives for excellence and takes pride in doing great work. As an Analyst, 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. This is a role within a boutique consultancy that values best-in-class work, work ethic, attention to detail, and high quality. The company is looking for someone with a long-term outlook to join a team 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 clients, and contribute to business development. The company operates on a hybrid model, with team members in the office two days a week (Tuesdays and Wednesdays) in Toronto and the remaining days working from home.

Requirements

A Bachelor degree in a relevant discipline (i.e., computer science, mathematics, statistics, engineering, science) is required, though work experience or completed projects 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.)
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
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

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
0-2 years experience in analytical role with involvement in screening / manipulating / analyzing big data sets is a strong differentiator

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
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, snail mail, etc.)