Opens LinkedIn
- Employment type
- Full-time
- Experience level
- Senior · 5+ years
- Posting language
- English
- Working hours
- 40 hours per week
- Seniority
- Mid-Senior level
- Application method
- Direct apply is available
Job summary
Build and maintain Power BI models, reports, dashboards, SQL queries, and data processes, while investigating data quality and reporting issues. Partner with Finance and Operations to deliver financial, operational, and KPI reporting that supports planning and business decisions.
Job details
BI & Data Specialist | Power BI, SQL & FP&A Location: Aurora, ON (onsite/remote) Work Arrangement: Onsite for the first 1–2 weeks, then remote/hybrid flexibility Compensation: $100K CAD + discretionary bonus, flexible based on experience Employment Type: Full-Time, Direct Hire About the Opportunity Our client is a rapidly growing organization operating across multiple business units within the specialty construction and infrastructure services sector. The company has experienced significant organic growth and expansion through acquisitions and is continuing to scale its operations. We are seeking a BI & Data Specialist to take ownership of business intelligence, reporting, data quality, and analytics while working closely with Finance and Operations leadership. This is a hands-on, build-and-own role for someone who can bridge the technical side of BI with the financial side of the business. The ideal candidate will have strong Power BI and SQL capabilities along with corporate FP&A experience and an understanding of how reporting supports financial planning and business decisions. Key Responsibilities Build, maintain, and enhance production Power BI models, reports, and dashboards Develop and maintain SQL queries to extract, transform, validate, and analyze data Own data models and reporting processes from source systems through SQL/ETL into Power BI Develop and maintain DAX measures and Power Query/M transformations Identify and resolve data quality, reconciliation, and reporting issues at the source Partner with Finance and Operations to develop reporting that supports FP&A, financial reporting, and business decision-making Support company-wide and business-unit KPI reporting Analyze financial and operational data to identify trends, variances, and opportunities Work with stakeholders to understand reporting requirements and translate business needs into technical solutions Help improve reporting processes, data structures, and overall data quality Manage changing priorities and proactively communicate issues, risks, and blockers Work independently while collaborating with Finance, Operations, and IT Required Qualifications 4+ years of hands-on Power BI experience, including building production models and reports 1 to 2 years of corporate FP&A experience Strong T-SQL / SQL Server experience, including the ability to write and debug queries independently Strong understanding of data modeling, ETL, reconciliation, and data quality Strong DAX and Power Query/M experience Ability to investigate reporting issues and trace problems back to the underlying data source Understanding of financial reporting and how data supports FP&A and business decisions Strong communication skills with the ability to work independently Comfortable working in a fast-paced environment with changing priorities Preferred Qualifications Experience with DataRails Python or SSIS experience SharePoint / Power Automate experience Power BI administration, including workspaces, RLS, refreshes, or deployments Experience within PE, financial services, construction, manufacturing, or distribution Experience supporting multi-entity organizations Additional financial reporting or corporate finance experience
What you’ll do
Build and maintain Power BI models, reports, dashboards, SQL queries, and data processes, while investigating data quality and reporting issues. Partner with Finance and Operations to deliver financial, operational, and KPI reporting that supports planning and business decisions.
Requirements
Requires 4+ years of hands-on Power BI experience, 1–2 years of corporate FP&A experience, and strong SQL Server, DAX, and Power Query/M skills. Candidates should understand data modeling, ETL, reconciliation, data quality, and financial reporting, and be able to communicate effectively and work independently in a changing environment.
Listed skills
- Power BI · Preferred
- SQL · Preferred
- Financial Reporting · Preferred
- Python · Preferred
Other relevant skills
Identified from the job description. Confirm important requirements above.
- Power BI
- SQL
- T-SQL
- SQL Server
- Financial Planning And Analysis
- Data Modeling
- ETL
- Data Quality
- DAX
- Power Query
- Financial Reporting
- KPI Reporting
- Data Reconciliation
- Stakeholder Communication
- Python
- SSIS
Job areas
- Data & Analytics
- Finance & Accounting
- Technology
- Construction