Consultant – Business Intelligence & Data Analytics
$90,000–$130,000 year
HybridToronto, Ontario, Canada
Job Summary
Conduct in-depth analyses for management using financial and business data, build comprehensive management reporting for clients, and coordinate with client teams to implement models. Extract data from accounting, operational, and HR systems using custom coding and API connectors, then mine, analyze, and model large datasets to define database structures and develop custom data warehouses. Perform comprehensive data manipulations and transformations using SQL to clean discrepancies, apply predictive modeling for revenue estimation, and prepare client-facing outputs including financial dashboards and operational performance trackers. Develop financial analyses providing actionable insights to management and oversee quality control on team analysts. Manage client relationships to ensure satisfaction and identify opportunities for additional services.
Required Qualifications
- A Bachelor or Master's degree in a relevant discipline (i.e., computer science, mathematics, statistics, engineering, science )
- 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
- 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
- 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
- Must be available for in-office Tuesdays and Wednesdays (2 days/week at 100 Sheppard Avenue East, Suite 870, Toronto)
Desired Qualifications
- Experience or certification using Microsoft Azure services
- Experience in data analysis and machine learning techniques (clustering, decision tree learning, artificial neural networks, etc.)
- Experience with data visualization tools such as Power BI or Tableau
- Experience with coaching junior staff and providing feedback
- Work experience in a relevant field coupled with a non-related Bachelor's degree (humanities, social sciences, etc.)
Hiring someone like this?
Get your role in front of qualified candidates on Sorce.