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 www.e-verify.gov.  All individuals who accept an offer of employment are required to complete a pre-employment drug screening and background check.