Construction Data & Automation Specialist
19 days ago
Kansas City
Job DescriptionSalary: $65,000 - $85,000 annual salary 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, weve 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 insightnot app developmentwhile 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 nocode/lowcode tools., • Integrate data from ERP, project management, timekeeping, and scheduling systems., • Normalize job-level data (jobs, phases, cost codes, labor, materials, production) into analyticsready 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 adhoc 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 datamodeling skills., • Experienced in creating data pipelines using nocode/lowcode 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 decisionmaking., • Maintains high standards for data accuracy, consistency, and repeatable reportingeven when working with imperfect or evolving data., • Communicates clearly with both technical and nontechnical 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 longterm 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 . All individuals who accept an offer of employment are required to complete a pre-employment drug screening and background check.