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 Analystto 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 dashboar...