Project Controls Administrator (Brock Head Office)

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

Project Controls Administrator (Brock Head Office)

A B O U T B RO CK :

T h e B r ock G r o u p i s a l e a d i n g pr o v i d e r of i n d u s t r i a l s p e c ialt y s e r v i c e s t o c l i e n t s a r o u n d t h e w o r l d , with he a d q u a r t e r s i n Ho u s t o n , T X, a nd o p e r a t i n g u n i t s i n C a n a d a , t h e U n i t e d S t a t e s , a n d L a t i n A m e r i c a . With the Ca n a d i a n h e a d o f f i c e i n N i s k u , the c o m p a n y s u p p o r t s r o u t i n e m a i n t e n a n c e , t u r n a r o u n d s , a n d i n d u s t r i a l c a p i t a l p r o j e c t s b y p r o v i d i n g s e r v i c e s i n c l u d i n g s c a f f o l d i n g a n d w o r k a c c e s s , i n s u l i t a t i o n , f i r e p r o v i n g , a n d a s b e s t o s a b a t e m e n t , f or g e n e r a l m a i n t e n a n c e , c o n s t r u c t i o n , t u r n a r o u n d s , a n d s h u t d o w n s t o w e s t e r n C a n a d i an p r o d u c e r s .

Summary

The Project C o n t r o l s A d m i n i s t r a t or i s r e s p o n s i b l e f or d a i l y time e n t r y , L E M s , a n d b i l l i n g. T h i s p o s i t i o n r e p o r t s t o t h e P r o j e c t C o n t r o l s L e a d.

Essential Functions

• Manage employee time entry for accurate and timely weekly payroll processing.
• Produce daily LEMs for customer approval, ensuring accurate tracking of labor, equipment, and materials.
• Oversee weekly, bi-weekly, and monthly billing for projects, ensuring alignment with client contracts and financial records.
• Prepare client/project-specific reports and perform data uploads, ensuring compliance with project and accounting requirements.
• Assist with accounts payable review, accruals, and month-end closing processes, ensuring proper reconciliation and financial reporting.
• Collaborate with accounting to monitor project budgets, track expenditures, and ensure accurate financial reporting
• Develop and maintain Power BI reports, dashboards, and visualizations to support project controls activities
• Utilizing SQL queries for data integration, transformation, and analysis
• Create automated data refresh schedules and ensure timely delivery of updated reports and dashboards to stakeholders
• Conduct ad-hoc data analysis and prepare customized reports as requested by Project Managers and stakeholders
• Collaborate with cross-functional teams to gather project data and ensure its accuracy, completeness, and consistency
• Provide expertise and guidance on Power BI best practices, data visualization techniques, and data governance standards
• Identify opportunities for process improvements and automation within Project Controls using Power BI

Minimum Requirements

• 5+ years of experience in an administrative role with a strong focus on bookkeeping and accounting, ideally within the construction or project management industries.
• Experience managing invoicing and billing for large-scale projects, with demonstrated accuracy in financial documentation.
• Solid understanding of basic accounting principles; experience with accounts payable/receivable, accruals, and general ledger entries.
• Proficiency in Microsoft Excel , including advanced skills with formulas, pivot tables, and financial reporting.
• Experience or training in SAP or similar ERP systems is highly desirable.
• Strong organizational and multi-tasking abilities, with excellent attention to detail and accuracy in financial tasks.
• Ability to thrive in a fast-paced work environment and collaborate with team members as needed.
• Strong communication and interpersonal skills, with a focus on client satisfaction and financial accuracy.
• Proficient in Power BI , including creating reports, dashboards, and visualizations
• Experience in data modeling and transformation techniques within Power BI
• Knowledge in SAP Business One is an asset
• Knowledge in SQL is an asset
• Excel VBA & process automation experience
• PowerShell is an asset

Other Functions / Success Factors

• • Adm i n i s t r ati on a nd M a n a g e m e n t -- K no w l e d g e o f bu s i n e s s a n d m a n a g e m e n t p r i n c i p l e s i n v o l v e d i n s t r a t e g i c p l a n n i g , r e s o u r c e a l l o c a t i o n , h u m a n r e s o u r c e s m o d e l i n g , l e a d e r s h i p t e c h n i q u e , p r o d u c t i o n m e t h o d s , a n d c o o r d i n a t i o n o f p e o p l e a n d r e s o u r c e s .
• • P u b l i c S a fe t y a n d Se c u r it y -- K no w l e d g e o f r e l e v a n t e q u i p m e n t, p o l i c i e s , p r o c e d u r e s , a n d s t r a t e g i e s t o p r o m o t e e f f e c t i v e l o c a l , s t a t e , or n a t i o n a l se c u r it y o p e r a t i o n s f or t h e p r o t e c t i o n of p e o p l e , d a t a , p r o p e r t y , a n d i n s tintu t i o n s .
• • C o o r d i n a t i o n -- A d j u s t i n g a c t i o n s i n r e l a t o n t o o t h e r s ' a c t i o n s .
• • J u d g m e n t a n d D e c i s i o n M a k i ng -- C o n s i d e r i n g t h e r e l a t i v e c o s t s a n d b e n e f i t s o f p o t e n i a l a c t i o n s t o c h o o s e t h e m o s t a p r o p r i a t e o n e .
• • C r i t i c a l T h i n k i n g -- U s i n g l o g i c a n d r e a s o n i n g t o i d e n t i f y t h e s t r e n g t h s a n d w e a k n e s s e s o f a l t e r n a t i v e s o l u t i o n s , c o n c l u s i o n s o r a p p r o a c h e s t o p r o b l e m s .
• • T i m e M a n a g e m e n t -- M a n a g i n g o n e ' s o w n t i m e a n d t h e t i m e o f o t h e r s .
• • M a t h e m a t i c s -- U s i n g m a t h e m a t i c s t o s o l v e p r o b e m s .
• • A c t i v e L e a r n i n g -- U n d e r s t a n d i n g t h e i m p l i c a t i o n s o f n e w i n f o r m a t i o n f o r b o t h c u r r e n t a n d f u t u r e p r o b l e m - s o l v i n g a n d d e c i s i o n - m a k i n g.
• • M o n i t o r i n g -- M o n i t o r i n g / A s s e s s i n g p e r f o r m a n c e o f y o u r s e l f , o t h e r i n d i v i a l s , o r o r g a n i z a t i o n s to m a k e i m p r o v e m e n t s or tak e c o r r e c t i v e a c t i o n .
• • R e a d i n g C o m p r e h e n s i o n -- U n d e r s t a n d i n g w r i t t e n s e n t e n c e s a n d p a r a g r a p h s i n w o r k r e l a t e d d o c u m e n t s .
• • O r a l E x p r e s s i o n -- T h e a b i l i t y t o c o m mu n i c a t e i n f o r m a t i o n a n d i d e a s i n s p e a k i n g s o o t h e r s .
• • O r a l C o m p r e h e n s i o n -- T h e a b i l i t y t o l i s t e n t o a n d u n d e r s t a n d i n f o r m a t i o n .
• • W r i t t e n C o m p r e h e n s i o n -- T h e a b i l i t y t o r e a d a n d u n d e r s t a n d i n f o r m a t i o n.
• • W r i t t e n E x p r e s s i o n -- T h e a b i l i t y t o c o m m u n i c a t e i n f o r m a t i o n a n d i d e a s i n s w i t h r i n g e n g e l e .
• • R e a d i n g C o m p r e h e n s i o n -- U n d e r s t a n d i n g w r i t t e n s e n t e n c e s a n d p a r a g r a p h s i n w o r k r e l a t e d d o c u m e n t s .

Department: Project Controls
This is a full time position