Business Systems & Project Controls Analyst

Key Responsibilities

• Project Controls & Business Systems Support internal systems used for crew scheduling, equipment scheduling, progress reporting, consumables ordering, NDE reporting, project documentation, and job closeout processes.
• Learn and troubleshoot existing Microsoft Power Apps, Power Automate workflows, SharePoint tools, and Power BI reports.
• Help identify and resolve bugs, broken workflows, incorrect calculations, missing data, and reporting inconsistencies.
• Validate data connections between Power Apps, SharePoint, Microsoft Dynamics, Salesforce, Excel, and Power BI.
• Work with operations, project managers, estimators, field users, and leadership to improve system reliability and reporting accuracy.

Reporting, Analytics & Data Validation

• Build, maintain, and improve Power BI reports, dashboards, and recurring business reports.
• Aid in Power Query, DAX, data modeling, report cleanup, and data quality checks.
• Investigate discrepancies between reports and source systems.
• Support analysis of Salesforce, bid history, customer data, project data, and financial outcomes.
• Aid in reporting related to win rates, bid volume, pricing trends, margin performance, regional performance, deal history, and customer activity.
• Create practical tools and reports that improve visibility, reduce manual work, and support better decision-making.

AI Workflow & Process Automation

• Support Assist with the development, testing, and improvement of AI-assisted workflows across estimating, project controls, documentation, reporting, and operations.
• Help evaluate practical uses of AI for RFQ review, bid document analysis, scope extraction, bid review preparation, meeting transcript summaries, job closeout books, project documentation, and lessons-learned analysis.
• Work with estimators, project managers, operations personnel, and leadership to understand current workflows and identify where AI or automation can reduce manual effort, improve consistency, and reduce missed information.
• Support the organization and cleanup of historical bid, estimate, project, and closeout data so it can be used more effectively in AI-assisted workflows.
• Help test and validate AI outputs to ensure they are accurate, useful, repeatable, and appropriate for business use.
• Aid in documenting AI-enabled workflows, standard prompts, review steps, and quality-control processes.