Data Analyst

At Compu Dynamics, we dont just build infrastructurewe create the backbone of the digital future. As North Americas premier technology infrastructure design-build partner, we design, construct, and maintain mission-critical data centers for some of the worlds most innovative companies. With roots in one of the fastest-growing data center markets in the world, our growth is as intentional as our impact.

Classification:
Exempt

Reports to:

Chief Financial Officer

Compensation Range: $90,000 - $120,000

Job Description Summary / Objective

The Data Analyst transforms operational, financial, and project data into actionable insights that drive decision-making across all operating divisions (Construction, Electrical, Service, Manufacturing). This role owns KPI development, dashboard creation, analytics automation, and reporting across Procore, Hub Spot, Net Suite, Paylocity, and internal systems.

This position supports AI-assisted analytics, automation of recurring reporting, and self-service BI tools to increase organizational efficiency. The Data Analyst reports directly to the Chief Financial Officer and works closely with the Chief Operating Officer, Executive Leadership, and Operations teams.

Essential Functions

Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

Analytics & Performance Reporting

Build and maintain automated dashboards in Procore Analytics and Power BI for project performance metrics including job profitability, labor productivity, EAC variance & cost-to-complete, RFI/Submittal cycle times, safety performance, and prefab/manufacturing throughput.

Implement AI-supported insights where appropriate (e.g., anomaly detection, pattern recognition, forecast suggestions) and ensure data accuracy through collaboration with Project Managers and Operations.

Produce weekly and monthly workforce forecasts using actual labor curves, schedule data, and backlog; automate labor forecasting reports and build models to support multi-state expansion planning.

Build Hub Spot dashboards for sales pipelines, win/loss trends, deal velocity, quoting performance, and recurring service revenue; leverage AI-driven forecasting and standardize CRM Procore Net Suite data flow.

Financial Analytics & Business Intelligence

Develop automated dashboards in Power BI and Net Suite for divisional profitability, customer-level profitability, job-level performance, AR/AP dashboards, and budget vs. actual reporting.

Support the CFO with financial models, scenario analysis, and trend insights for strategic decision-making.

Build scheduled refresh pipelines, CData connections, and API-based data feeds to automate financial reporting.

Provide field and office resource capacity analytics through Power BI and Net Suite.

Data Automation & Infrastructure

Create and maintain automated data pipelines using available connectors (CData, Power BI gateways, API integrations) and implement workflow automation for recurring reporting packages.

Develop self-service BI tools that allow Project Managers, Operations, Leadership, and Accounting to view real-time KPIs without manual reporting.

Build and enforce data models, naming conventions, and data dictionaries to ensure consistency across systems.

Leadership Support & Data Governance

Prepare high-quality, automated reporting packets for CFO monthly/quarterly/periodic reviews, monthly financial meetings, monthly WIP meetings, executive leadership sessions, and Board-level reporting.

Provide narrative insights and interpretations not just charts to support strategic decision-making.

Improve data hygiene across Procore, Hub Spot, Net Suite, and other systems; assist in mapping custom fields, segments, departments, and classifications for standardization.

Support system integrations, API-based data sharing, and multi-system alignment.

General Duties

Operates vehicles and other equipment safely; adheres to safety protocols; reports hazards and risks; behavior contributes to a safe and secure working environment.

Other duties as needed and assigned.

Competencies

Analytical and detail-oriented with strong problem-solving abilities

Excellent communication and presentation skills with ability to translate data into insights for non-technical audiences

Ownership mentality with the ability to improve processes and reporting structures

Proficient in Microsoft Office Suite with advanced Excel skills

Supervisory Responsibility

There are no supervisory responsibilities with this role.

Work Environment

This job operates in an office environment. This role routinely uses standard office equipment such as computers, phones, copiers, etc. This position may have the option to work remotely with supervisor authorization.

Physical Demands

While performing the duties of this job, the employee is occasionally required to stand; walk; sit; use hands to finger, handle, or feel objects, tools or controls; reach with hands and arms; climb stairs; talk or hear. The employee must occasionally lift or move…