Job Specifications
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.
This open role is currently being featured by Thorek/Scott and Partners! We highlight a variety of open roles every week. If you save this position to apply to later, it may appear closed when you revisit it. For a full list of all open positions, please visit www.thorekscott.com.
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.
This open role is currently being featured by Thorek/Scott and Partners! We highlight a variety of open roles every week. If you save this position to apply to later, it may appear closed when you revisit it. For a full list of all open positions, please visit www.thorekscott.co
About the Company
Exceptional investment management, real estate and financial services firms have been choosing us to recruit their next great leaders for over 40 years. We place investment, finance, and corporate leaders who exceed expectations and elevate culture - and then grow their teams in areas in which we are proven experts. Our process has been honed and tested over decades. Our dedicated clients trust us to get it right and not stop until the work is done. We don't stop and we don't compromise. At Thorek/Scott and Partners we reali...
Know more