• Data Quality & Analytics Specialist

    Patten CAT (Bartonville, IL)


    Working Hours/Days

     

    Monday - Friday 7:30 - 4:00

     

    Overview

     

    TheData Quality & Analytics Specialistwill play a key role in ensuring the integrity, accessibility, and usability of business data across our Caterpillar Power Systems dealership operations. Our business focuses on selling, packaging, and servicing power generation equipment and associated products for data centers, industrial facilities, and other critical applications. This position combines analytical expertise with a strong focus on data quality management and data collection tools, like CAT Inspect form design. The ideal candidate will drive business insights from the silver data layer, maintain high data accuracy standards, and optimize data collection processes through effective CAT Inspect form governance. This role operates across two enterprise systems — Microsoft NAXT ERP (Dynamics 365) and Global Shop ERP — both integrated into Microsoft Fabric, ensuring consistency, accuracy, and harmonization of business data across systems.

    Basic Duties

    Key Initial Responsibilities

     

    + Business Insight Generation

    + Consolidate and normalize data across multiple ERP and data lake environments to provide unified business insights.

    + Analyze data from thesilver layerto identify trends, patterns, and anomalies that inform business strategy.

    + Apply advanced analytical techniques and data visualization to present insights that drive decision-making at all levels.

    + Generate strategic insights that support long-term business planning and growth initiatives.

    + Data Quality, Cleansing, and Governance

    + Establish data quality standards across NAXT and Global Shop ERP systems, ensuring alignment in master data (customers, equipment, parts, projects, and inventory).

    + Own data quality processesacross key systems and ensure that silver layer data is accurate, complete, and reliable.

    + Collaborate with ERP administrators and key team members to synchronize data tables and prevent duplicate or mismatched records.

    + Develop and implementdata validation, deduplication, and cleanup routinesto maintain trusted data sources.

    + Partner with IT and data engineering teams to define and enforcedata quality standards, metrics, and controls.

    + Investigate and resolve data discrepancies and anomalies proactively.

    + Data Collection Tools & CAT Inspect Form Management

    + Serve as thesubject matter expert (SME) for CAT Inspectand other data collection tools such as Microsoft Power Apps, Microsoft Forms, and SharePoint Lists.

    + Design, configure, test, and deploy digital forms that improve the accuracy, usability, and timeliness of field and shop data capture.

    + Collaborate with operational teams to ensure collected data integrates cleanly into Fabric and ERP systems.

    + Train and support users on form functionality, promoting consistency and standardization across business units.

    + Strategic Reporting and Visualization

    + Design and developinteractive Power BI dashboards and reportsthat serve as critical tools for business decision-making.

    + Ensure reports areaccurate, user-friendly, and alignedwith strategic business objectives.

    + Regularly update and refine dashboards to reflect the latest data and evolving business priorities.

    + Develop cross-functional dashboards (e.g., equipment uptime, job costing, quality metrics, production throughput) by combining data from NAXT, Global Shop, and CAT Inspect.

    + Advanced Analytics and AI Integration

    + UtilizeAI agents and machine learning modelsto predict future business trends and outcomes.

    + Integrate AI-driven insights into business processes to enable proactive and data-informed decisions.

    + Developpredictive and prescriptive modelsthat support strategic planning and risk management.

    + Apply AI and machine learning to predict equipment failure trends, production throughput, or supply-chain risk, leveraging Microsoft Fabric AI models and Copilot capabilities.

    + Logistics and Operational Data Integration

    + Integrate logistics, transportation, and material movement data from NAXT and Global Shop ERP systems to provide full visibility of inbound and outbound equipment and components.

    + Develop dashboards that track shipments, delivery timelines, and yard or warehouse activity to improve operational planning and resource utilization.

    + Monitor and ensure data accuracy in freight, inventory transfers, and transportation cost tracking.

    + Collaborate with the Logistics and Packaging teams to align data capture with operational workflows.

    + Real-Time Analytics and Transalytic Reporting

    + LeverageTransalytic capabilitiesto provide real-time insights that enable immediate business actions.

    + Ensure seamless integration ofreal-time datainto operational workflows for enhanced agility and responsiveness.

    + Implement Power BI DirectLake and Synapse Real-Time Hub features for near-instant reporting from Fabric’s silver and gold layers.

    + Performance Tracking and Strategy Refinement

    + Monitor and evaluate the impact of business actions and strategies based on data insights.

    + Analyze performance metrics to refine analytical models, reports, and strategies.

    + Establish feedback loops to ensure insights lead to measurable improvements in business outcomes.

    + Stakeholder Engagement and Communication

    + Collaborate closely withbusiness stakeholdersin all Power Systems departments to understand strategic data needs and ensure insights are actionable.

    + Present complex data insights and recommendations to executive and non-technical audiences in aclear, compelling manner.

    + Collaborate with Sales, Power Rental, Packaging, Engineering, Quality, and Product Support teams to ensure analytics outputs reflect ground-truth operational realities.

    Qualifications

    + Bachelor’s degree in Data Analytics, Information Systems, Business Intelligence, or related field.

    + Proven experience indata quality management, analytics, or reportingroles.

    + Hands-on experience withCAT Inspect,Power BI,SQL, anddata pipeline tools.

    + Strong understanding ofmedallion data architectures(bronze/silver/gold).

    + Excellent communication and collaboration skills with both technical and non-technical stakeholders.

    + Experience with Microsoft Fabric, Synapse, or Power Query Dataflows.

    + Familiarity with ERP data structures (preferably Microsoft Dynamics 365 Finance & Operations / NAXT, and Global Shop ERP).

    + Understanding of data integration patterns (ETL/ELT, medallion architecture, API, or OData connections).

    + Preferred: Exposure to manufacturing, service, or heavy equipment industries.

     

    Altorfer Inc. offers an industry leading compensation and benefit package:

     

    + Health, Dental, Vision, Disability, and Life Insurance

    + 401(k)

    + Paid Holidays

    + Paid Parental Leave and Funeral Leave

    + Paid Time Off: Prorated 80 hours of PTO

    + Education Assistance

    + Personal Tool Insurance, and Safety Equipment Reimbursement

    + Voluntary Benefits: Supplemental Insurance, Accident, Critical and Hospital Indemnity Insurance, Legal Assistance and Identity & Fraud Protection

     

    Payrate: $70,000-$90,000 annually

     

    Posted Min

     

    USD $70,000.00/Yr.

     

    Posted Max

     

    USD $90,000.00/Yr.

     

    Physical Requirements/Working Conditions

     

    This position works in an office environment. May, on a continuous basis, sit at desk for a long period of time; intermittently answer telephone and write or use a keyboard to communicate through written means. Some walking and lifting up to 20 lbs. may be required. There may be times when you may need to go out into the service shop or warehouse area and will be required to wear appropriate safety equipment (IE- Safety glasses or side shields). The physical demands described above are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

     

    All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.

     

    Why Work for Altorfer?At Altorfer, our iron is just the beginning. Our people make our company successful, and we would not be who we are without them. As a third generation, family-owned company created in 1957, we bring our values into how we do business. Everyone from technicians, sales representatives, administrative professionals, or somewhere in between is part of the “A-Team” and is critical to our success. Here at Altorfer, we have over 35 locations and 1300 employees with long tenure for you to learn from. We have a collaborative, family valued culture, with a great reputation in the industry. A company that offers competitive pay, excellent benefits, and the opportunity to work with a remarkable team of people.

     

    Need help finding the right job?

     

    We can recommend jobs specifically for you!

     

    Req No.2025-5454

     

    CategoryCustomer Service/Support

     

    LocationUS-IL-Bartonville

     

    Additional LocationsUS-IA-Cedar Rapids | US-IL-Addison

     

    TypeRegular Full-Time

     

    Union or Non-UnionNon-Union

     

    DivisionPower Systems

     

    CompanyAltorfer Inc