Project Controls Analyst: Power BI & Automation

Brock Canada; Nisku; On-site; CAD 65,000 - 90,000; Full time

Job summary

Brock Canada is seeking a Project Controls Administrator at the head office to manage daily time entry, LEMs, and billing for diverse projects. You will produce client reports, maintain data accuracy, and support project managers with financial analytics.

The role requires 5+ years in administrative/accounting roles, strong Excel, Power BI, and SQL skills, plus experience with SAP Business One. A fast-paced construction or PM context is preferred and the position offers growth opportunities.

Qualifications

• 5+ years of experience in an administrative role with bookkeeping and accounting focus.
• Experience invoicing and billing for large-scale projects with accuracy.
• Solid understanding of basic accounting principles; experience with accounts payable/receivable, accruals, and general ledger entries.
• Proficiency in Microsoft Excel with formulas, pivot tables, and financial reporting.
• Experience or training in SAP or similar ERP systems is desirable.
• Strong organizational and multi-tasking abilities with attention to detail and accuracy in financial tasks.
• Proficiency in Power BI for reports, dashboards, and visualizations.
• Experience with data modeling and transformation techniques in Power BI.
• Knowledge in SAP Business One is an asset; knowledge in SQL is an asset.
• Excel VBA and process automation experience; PowerShell is an asset.

Responsibilities

• Manage employee time entry for accurate and timely weekly payroll processing.
• Produce daily LEMs for customer approval, tracking labor, equipment, and materials.
• Oversee weekly, bi-weekly, and monthly billing for projects, aligning with client contracts.
• Prepare client/project reports and perform data uploads.
• Assist with accounts payable review, accruals, and month-end closing processes.
• Collaborate with accounting to monitor project budgets and expenditures.
• Develop and maintain Power BI reports, dashboards, and visualizations for project controls.
• Use SQL queries for data integration, transformation, and analysis.
• Create automated data refresh schedules and deliver updated reports timely.
• Conduct ad-hoc data analysis and prepare customized reports for PMs and stakeholders.
• Collaborate with cross-functional teams to ensure data accuracy and completeness.
• Provide guidance on Power BI best practices and data governance.

Skills

Time entry

Billing

Power BI

SQL

Data modeling

Excel

PowerShell

Excel VBA

Communication

Organization

Tools

Power BI

SQL

Excel

SAP Business One

VBA

PowerShell

Job description

Brock Canada is seeking a Project Controls Administrator at the head office to manage daily time entry, LEMs, and billing for diverse projects. You will produce client reports, maintain data accuracy, and support project managers with financial analytics.

The role requires 5+ years in administrative/accounting roles, strong Excel, Power BI, and SQL skills, plus experience with SAP Business One. A fast-paced construction or PM context is preferred and the position offers growth opportunities.