Senior Business Intelligence & Data Analyst

The County Materials Family of Companies manufactures and delivers concrete construction products to meet the demand for growing communities. Since 1946, we've relied on our talented and dedicated team members to provide reliable products with personalized service. We're hiring a Senior Business Intelligence & Data Analyst to join County Materials in Marathon, Wisconsin. Job Summary The Senior Business Intelligence & Data Analyst transforms financial and operational data into accurate, governed, and actionable business intelligence. This role is responsible for contributing to development, management, and improvement of data solutions that support financial reporting, operational analytics, forecasting, KPI measurement, and executive dashboards. The position will serve as a technical and analytical expert for data modeling, advanced analytics, and reporting within the Microsoft data platform. In collaboration with Corporate IT Data Engineering Group, this position will assist with governance and standardization of data throughout the enterprise. Job Duties & Responsibilities Data Strategy, Management & Architecture Assist Data Engineering team in design and maintenance of scalable data architectures supporting financial and operational analytics. Develop enterprise data models based on Microsoft Fabric, Azure Synapse Analytics, Azure SQL, SQL Server, Microsoft Dataverse, and Azure Data Lake Storage technologies. Define and apply standards for data quality, data validation, metadata, lineage, stewardship, and governance. Partner with business leaders to identify opportunities where data can improve decision‑making, cost control, productivity, and business performance. Data Engineering & Integration Build, monitor, and maintain data pipelines using Microsoft Fabric, Azure Data Factory, Synapse Pipelines, Power Query, Power Platform, and related tools. Integrate data from ERP, finance, operations, manufacturing, banking, CRM, and third‑party systems. Develop ETL/ELT processes that ensure accurate, timely, and repeatable data movement across source systems and analytical repositories. Optimize data storage and retrieval performance for reporting, analytics, and self‑service consumption. Analytics, Forecasting & Data Science Perform statistical analysis, trend analysis, root‑cause analysis, and scenario modeling for business stakeholders. Develop predictive and prescriptive analytics supporting revenue forecasting, cost analysis, inventory optimization, production planning, and operational performance. Create standardized KPIs, metrics definitions, and analytical frameworks for Finance and Operations. Translate analytical findings into clear recommendations, business impact statements, and decision‑ready insights. Power BI Reporting & Business Intelligence Collaborate with Power BI developers to design, develop, publish, and support Power BI dashboards, reports, semantic models, scorecards, and executive views. Build certified datasets and reusable reporting models that support consistent reporting across business units. Write, optimize, and troubleshoot DAX, Power Query, SQL, and data model logic. Enable secure self‑service analytics while maintaining data governance, report accuracy, and performance standards. Security, Governance & Collaboration Work with Cybersecurity team to implement secure data access practices aligned with Microsoft Entra ID, role‑based access control, sensitivity labeling, and organizational security standards. Support Microsoft Purview or similar governance capabilities for cataloging, classification, lineage, and compliance. Collaborate with Finance, Operations, IT, and executive stakeholders to gather requirements, validate outputs, and drive adoption. Document data models, report logic, refresh schedules, data definitions, and operational support processes. COUNTY Core Competencies: The expected behaviors of all COUNTY team members that align with Our Values and Our Commitments Integrity & Organizational Awareness Customer First Focus Results Driven Orientation Teamwork, Safety & Collaboration Problem Solving & Decision Making Creativity & Innovation Job-Based Competencies Analytical Thinking Business Intelligence (BI) Consulting Data Collection & Preparation Data Modeling Data Quality & Governance Data Science Stakeholder Management Statistical Analysis Structured Query Language (SQL) Experience & Qualifications Education Bachelor’s degree in Data Science, Analytics, Statistics, Mathematics, or a related discipline. Master’s degree preferred. Experience 8+ years of progressive experience in enterprise data management, analytics, business intelligence, or data science preferred. 5+ years of experience in data science, business intelligence, analytics, enterprise data management, or a related function required 3+ years of hands‑on experience developing dashboards, semantic models, reports, measures, and enterprise reporting solutions required. Demonstrated experience: Working with financial and operational data, including reporting, KPI development, forecasting, or performance analysis. Designing, building, and maintaining data models, pipelines, datasets, and analytical repositories. Collaborating directly with business stakeholders to define requirements, validate data, and present analytical findings. Preferred Experience Supporting manufacturing, construction materials, logistics, supply chain, field operations, or multi‑site industrial environments. Integrating ERP systems such as Infor or similar enterprise platforms with modern analytical environments preferred. Developing near‑real‑time analytics, operational scorecards, or executive performance dashboards preferred. Leading or contributing to data modernization, reporting standardization, or enterprise analytics transformation initiatives preferred. Implementing data catalog, classification, governance, or lineage capabilities. Licenses/ Certifications Microsoft certifications such as Fabric Analytics Engineer Associate, Azure Data Engineer Associate, Power BI Data Analyst Associate, Azure AI Engineer Associate, or Azure Solutions Architect Expert preferred. Certifications or formal training in data governance, AI, machine learning, statistics, financial analytics, or business intelligence preferred. Work Environment Work is typically performed in an indoor/office environment. Travel required: 20-25% Typical work hours/shifts: Standard business hours Physical & Work Expectations An individual in this position must be able to successfully perform the essential duties and responsibilities listed above. Reasonable accommodation may be made to enable individuals with disabilities to perform the essential functions of this position. Frequent sitting, standing, walking, bending, reaching, or handling materials/equipment. Occasional climbing, kneeling, crawling, or lifting/moving up to 25 pounds. Ability to concentrate, follow detailed instructions, communicate effectively, and safely perform job duties. May require the operation of specific tools, equipment, or vehicles associated with the position. The County Materials Family of Companies connects candidates with rewarding careers in concrete manufacturing, an industry that’s growing faster than most. We work alongside individuals to leverage their skills and align them with diverse job opportunities in production, transportation, safety, finance, human resources, information technology, marketing, risk management, and more. Military service members and veterans are encouraged to apply. Benefits Overview Health, dental and vision insurance Paid Short-term & Long-term disability 401(k) match 8 Paid holidays Paid Time Off Referral rewards program Wellness program with rewards Flexible Savings Options Employee Assistance Program Paid Life Insurance $200 Boot Allowance Safety focused: GUARD for Life Voluntary critical illness & accident insurance Optional Uniform Program English: Spanish: County Materials Family of Companies is an EEO/Affirmative Action Employer; all qualified applicants will receive consideration for employment without regard to any characteristic prohibited by federal, state and/or local laws. We participate in E-Verify to confirm employment eligibility for all new hires. #J-18808-Ljbffr County Materials Family of Companies