Business Data Analyst

Thorek/Scott and Partners; Markham; On-site; CAD 65,000 - 85,000; Full time

Job summary

A leading recruitment firm is seeking a Business Data Analyst to join its corporate finance team in Markham, Canada. The successful candidate will perform data-driven analysis to support financial decision-making and collaborate with various business units. Ideal candidates have strong analytical skills, experience in Python and SQL, and proficiency in data visualization tools. Applicants must have legal eligibility to work in Canada.

Qualifications

• At least 2 years of experience in Python and SQL for data analysis and automation.
• Strong attention to detail and analytical thinking.
• Hands-on experience with data visualization platforms is an asset.

Responsibilities

• Use data-driven analysis to understand and explain financial results.
• Assist in gathering, validating, and organizing data.
• Design and maintain interactive dashboards.

Skills

Python

SQL

Data visualization

Analytical thinking

Attention to detail

Education

Post-secondary education in Business, Finance, Data Analytics, Computer Science

Tools

Power BI

Tableau

Looker

Excel

Job description

Overview

Your Partners in Recruitment!

Thorek/Scott and Partners (TSP) has been connecting accomplished organizations with talented individuals for almost four decades. At TSP, our track record of successfully completing challenging searches across the professional spectrum has earned us an exceptional reputation at the forefront of the recruitment industry. Our Canadian and International clients include: global banks and non-bank financial institutions, private equity and investment funds, professional service firms, and entrepreneurial businesses in a variety of industries. We value the human connection and distinguish ourselves through an unwavering dedication to understanding the goals and motivations of our clients and candidates alike.

Our Client

Enercare is one of Canada’s largest renewable energy companies, providing leading products and services in heating, cooling, plumbing, electrical, water heating and water purification. Enercare is wholly owned by Brookfield Infrastructure Partners LP ("Brookfield"), a global leader in the management of alternative assets across real estate, infrastructure, renewable power, and private equity.

Position Overview

Currently, Enercare is seeking an analytical and innovative Business Data Analyst to join its growing corporate finance team. The Business Data Analyst will perform data-driven analysis and provide insights that are critical to informed decisions regarding the management and allocation of financial resources. This role will also provide the opportunity to support other areas of finance by collecting, analyzing, and visualizing data to uncover valuable insights. You will regularly interact with other stakeholders across the business, including Product and Marketing, Business Development, and Customer Experience and Operations. The ideal candidate will have at least 2 years of experience working in a data analyst capacity focused on equipping management with analysis that links business performance to financial metrics and cash flow analysis.

Role Responsibilities

Business & Financial Support

• Use data-driven analysis to understand and explain company-wide financial results with reference to underlying business drivers
• Leverage analytics to explain performance to key stakeholders and inform future forecasts
• Contribute to the development and maintenance of financial models
• Participate in evaluating business needs and identifying opportunities for data-driven improvements

Data Collection & Analysis

• Assist in gathering, validating, and organizing data from various sources, including Azure SQL databases and Excel
• Conduct data analysis to identify trends, patterns, and anomalies in business operations
• Ensure data accuracy and completeness in reports and dashboards
• Develop and maintain SQL and Python automations to support monthly reporting requirements

Process Improvement & Optimization

• Document current workflows and identify inefficiencies through data and stakeholder input
• Support process improvement initiatives and automation efforts
• Design and maintain interactive dashboards that provide a centralized and real-time view of key financial metrics, streamlining monthly reporting and enhancing decision-making across the organization

Stakeholder Collaboration

• Work closely with business teams to understand reporting and data needs
• Communicate findings clearly to both technical and non-technical stakeholders

Desired Qualifications

• Post-secondary education in Business, Finance, Data Analytics, Computer Science, or a related field
• At least 2 years of experience in Python and SQL for data analysis and automation
• Strong attention to detail and analytical thinking – you always seek out the “why” behind the data, and not only the “what”
• Hands-on experience with data visualization platforms such as Power BI, Tableau, and Looker is an asset
• Working knowledge of SQL and experience working with databases, warehouses, and data lakes in Azure SQL DB
• Understanding of ETL processes, including data extraction, transformation, and loading across cloud and on-prem environments
• Proficiency in Microsoft Excel (pivot tables, formulas, charts, graphs, Power Query)
• Ability to interpret financial data to understand and identify trends, assess commercial impacts, and communicate results with reference to broader corporate strategy

Please note that at present, legal eligibility to work in Canada is a prerequisite for this role.

We appreciate your interest in this role. In sharing your resume, you place your trust in us to treat you with integrity and respect and act in your best interests. All resumes will be held in the strictest of confidence. Those who most closely meet our client’s requirements will be contacted for an interview. Please pass this opportunity forward. We welcome all referrals should someone in your network benefit from this opportunity.