Business Systems Analyst, BI & Reporting

About the role

Location: Miamisburg, OH. Work Arrangement: Fully Onsite. Job Type: Full-Time. Reports to: Chief Information Officer. We are seeking a technically hands-on Business Systems Analyst to support data, business intelligence, reporting, and process-improvement initiatives across the organization. This role will help improve decision-making, data quality, reporting consistency, and operational performance while aligning solutions with established IT standards, data governance, and enterprise technology direction. This hybrid role combines the technical capabilities of a Data and BI Analyst with the stakeholder engagement, requirements gathering, and process analysis skills of a Business Analyst. The ideal candidate can work directly with data, understand how it flows between enterprise systems, develop reports and dashboards, investigate data-quality issues, and clearly communicate findings to nontechnical business stakeholders. Success looks like delivering accurate, useful reports and dashboards on time, improving data quality and reporting consistency while reducing manual reporting processes, increasing adoption and effective use of approved dashboards and analytics solutions, and building strong partnerships between business and IT teams to support informed operational decisions. The position is primarily office‑based with occasional visits to active construction sites, requiring the ability to safely navigate uneven terrain, stairs, and other jobsite conditions, prolonged sitting, computer use, and effective communication, with occasional travel. The technology environment includes ERP, project management, document management, workflow, reporting, collaboration, and construction operations platforms such as Microsoft 365, SharePoint, Power Platform, Power BI, Microsoft Fabric, Snowflake, Azure Data Services, MS SQL Server, Vista by Viewpoint, OnBase, Autodesk Forma, Oracle P6, and related systems.

Responsibilities

• Partner with stakeholders across operations, finance, human resources, project management, executive leadership, and IT to understand reporting needs, workflows, challenges, and priorities.
• Translate business needs into clear data, reporting, workflow, and system requirements.
• Gather, validate, transform, and analyze data from multiple enterprise systems.
• Develop and maintain Power BI dashboards, scorecards, KPI reports, and recurring or ad hoc reporting.
• Write SQL queries and use appropriate analytical tools to retrieve, transform, analyze, and validate data.
• Work with data warehouses, data lakes, data models, and pipelines that support reporting and analytics.
• Investigate data discrepancies and conduct trend, variance, and root cause analyses to identify likely drivers, recommend practical solutions, and support informed business decisions.
• Develop current-state and future-state process maps, gap analyses, business requirements, user stories, and supporting documentation.
• Identify opportunities to replace manual processes with improved digital workflows, automation, or reporting solutions.
• Present technical findings and recommendations to nontechn