Location: Aurora, ON | HybridWork Type: Permanent | Full-TimeSalary: $90,000 – $110,000 + BenefitsVacancy: New PositionAre you a data-driven professional who enjoys transforming complex financial and operational data into meaningful business insights? Do you have strong Power BI expertise, financial acumen, and a passion for building dashboards and reporting tools that help leadership make better business decisions?We're partnering with a growing, multi-company organization in the construction industry to recruit a Data Analyst – Power BI & Financial Analytics. Reporting directly to the CFO, this opportunity offers the chance to develop executive dashboards, improve financial reporting, analyze business performance, and support the integration of newly acquired businesses.Why This RoleThis is more than a traditional data analyst position.As a key member of the Finance function, you'll combine financial analysis, business intelligence, and data integration to provide visibility into the performance of multiple operating companies. You'll work closely with the CFO and cross-functional teams to identify trends, explain financial results, improve reporting processes, and support strategic business decisions.You'll also have the opportunity to build scalable Power BI reporting solutions, standardize key performance indicators, reduce manual reporting, and contribute to the organization's continued growth and acquisition integration.If you're a technically strong analyst who understands the financial side of the business and enjoys turning data into actionable insights,



this is an exciting prospect to make a meaningful impact.The Role: Data Analyst – Power BI & Financial AnalyticsReporting to the CFO, you'll develop and maintain financial and operational reporting tools, analyze business performance, and support budgeting, forecasting, and strategic planning across multiple operating companies.Key responsibilities include:Designing, developing, testing, and maintaining Power BI dashboards and reports for executive, financial, operational, and workforce reportingAnalyzing income statements, balance sheets, cash flow, revenue, gross margins, operating expenses, and profitability trendsPreparing budget-to-actual and forecast-to-actual variance analysis, identifying key drivers and recommending areas for improvementSupporting annual budgeting, rolling forecasts, financial modelling, and scenario analysisAnalyzing project and job-cost performance, including labour, materials, equipment, subcontractor costs, and overhead allocationsIdentifying margin erosion, project cost overruns, and discrepancies between estimated and actual project performanceMonitoring working capital, accounts receivable aging, days sales outstanding, inventory, and cash flow metricsDeveloping and maintaining Power BI data models, DAX measures, calculated fields, financial KPIs, and interactive drill‑down reportingUsing Power Query, Excel, and SQL to extract, clean, validate, transform, and consolidate data from multiple systems and sourcesIntegrating data from ERP platforms, HRIS systems, spreadsheets, databases, and operational applicationsEstablishing consistent financial reporting definitions,

📌 Data Analyst - Power Bi (Aurora)
🏢 Drake International
📍 Aurora