Construction Data & Automation Specialist

At J.R. & Co., Inc., we're not just building roofs - we're building careers. We specialize across a full range of building envelope services, including commercial roofing, architectural cladding (sheet metal), glass and glazing, solar panel installation, rooftop maintenance, and disaster relief. Established in 1986 and proudly veteran-owned, we're an energetic, optimistic, and family-oriented construction company based out of Kansas City.

With a reputation for excellence in workmanship and customer service, we've earned recognition from top industry manufacturers and an A+ rating from the Better Business Bureau. If you're looking for a place to grow, thrive, and make a real impact while working in a safety-focused, supportive environment, J.R. & Co., Inc. is the place for you. Join our team today and be a part of building something great!

Job Title:

Construction Data & Automation Specialist

Job Type: Full Time

Start Date:

Immediately

Salary Range: $65,000 - $85,000 Annual Salary

Position Overview:

Build and operate no-code and low-code data pipelines, automation, and analytics that turn construction operational data into clear, trusted dashboards for project teams and leadership. This role focuses on data structure, consistency, and insight-not app development-while supporting a distributed, job-based construction environment.

Core Outcomes

* A single, trusted view of job, cost, and production performance

* Consistent KPIs across projects, regions, and time periods

* Decision-ready dashboards used weekly by PMs and executives

Essential Functions:

* Design, maintain, and automate data pipelines using no‑code/low‑code tools.

* Integrate data from ERP, project management, timekeeping, and scheduling systems.

* Normalize job-level data (jobs, phases, cost codes, labor, materials, production) into analytics‑ready models.

* Build and maintain dashboards (Power BI, Metabase, Tableau, or Excel) that track job health, WIP, cost variance, and productivity.

* Translate business questions into clear KPIs, metrics, and visualizations used across operations, finance, and leadership.

* Implement automated data refreshes, quality checks, alerts, and exception handling to reduce manual reporting.

* Partner with project managers, finance, and operations leaders to define metric standards and support ad‑hoc analysis.

* Establish governance standards, documentation, and access controls to ensure accuracy, consistency, and data security.

Education and Experience:

* Experience with construction ERPs and job-cost systems
· Exposure to light scripting (Python or JavaScript) to extend no-code tools

* Experience supporting multi-project or regional construction operations

* Familiarity with WIP, EAC, labor productivity, and margin analysis

Required Skills & Abilities

* Strong ability to build dashboards and analytics using modern BI tools, supported by solid SQL and relational data‑modeling skills.

* Experienced in creating data pipelines using no‑code/low‑code platforms and working with APIs, flat files, and structured formats like JSON/CSV.

* Skilled at turning operational questions into clear metrics, KPIs, and actionable insights that support decision‑making.

* Maintains high standards for data accuracy, consistency, and repeatable reporting-even when working with imperfect or evolving data.

* Communicates clearly with both technical and non‑technical stakeholders, providing explanations that go beyond dashboards to real insight.

* Demonstrates strong documentation habits, defining metrics and data logic clearly to ensure clarity, alignment, and long‑term maintainability.

Work Environment/

Physical Requirements:

* Primarily office-based work environment

* Pass initial drug test and participate in random drug test program

* Overtime and weekends may be required based on workload demands

* Must comply with OSHA regulations, safety requirements, and company safety policies

Benefits:

* Health, dental, vision, life insurance

* Paid time off

* 401(k) with company match

* HSA/FSA

Work Location/Schedule

* In person:
Kansas City, MO

* Regular Office hours:
Mon-Fri

J.R. & Co., Inc. is proud to be an equal opportunity employer, committed to building a diverse and inclusive workforce. JR & Co. Inc. participates in E-Verify. To learn more visit (Use the "Apply for this Job" box below). All individuals who accept an offer of employment are required to complete a pre-employment drug screening and background check.