Project Controls Administrator

Project Controls Administrator

The Brock Group is a leading provider of industrial specialty services to clients around the world, with headquarters in Houston, TX, and operating units in Canada, the United States, and Latin America. With the Canadian head office in Nisku, the company supports routine maintenance, turnarounds, and industrial capital projects by providing services including scaffolding and work access, insulation, fireproofing, and asbestos abatement, for general maintenance, construction, turnarounds, and shutdowns to western Canadian producers.

Summary: The Project Controls Administrator is responsible for daily time entry, LEMs, and billing. This position reports to the Project Controls Lead. 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:

• Administration and Management -- Knowledge of business and management principles involved in strategic planning, resource allocation, human resources modeling, leadership technique, production methods, and coordination of people and resources.
• Public Safety and Security -- Knowledge of relevant equipment, policies, procedures, and strategies to promote effective local, state, or national security operations for the protection of people, data, property, and institutions.
• Coordination -- Adjusting actions in relation to others.
• Judgment and Decision Making -- Considering the relative costs and benefits of potential actions to choose the most appropriate one.
• Critical Thinking -- Using logic and reasoning to identify the strengths and weaknesses of alternative solutions, conclusions, or approaches to problems.
• Time Management -- Managing one’s own time and the time of others.
• Mathematics -- Using mathematics to solve problems.
• Active Learning -- Understanding the implications of new information for both current and future problem-solving and decision-making.
• Monitoring -- Monitoring/Assessing performance of yourself, other individuals, or organizations to make improvements or take corrective action.
• Reading Comprehension -- Understanding written sentences and paragraphs in work-related documents.
• Oral Expression -- The ability to communicate information and ideas in speaking so others will understand.
• Oral Comprehension -- The ability to listen to and understand information and ideas presented through spoken words and sentences.
• Written Comprehension -- The ability to read and understand information and ideas presented in writing.
• Written Expression -- The ability to communicate information and ideas in writing so others will understand.