Will be responsible for the project from inception to end using Power BI, SSDT, SSRS, SSAS, MSSQL, Visual Studio, JIRA. Will design and develop interactive dashboards and analytical reports using Microsoft Power BI to support data-driven decision-making. Will collaborated with data modeling teams to build and enhance SQL Server Analysis Services (SSAS) Tabular models for optimized reporting and analytics. Will work extensively with relational databases, including Microsoft SQL Server, to extract, transform, and load data for reporting purposes and develop complex calculations using Data Analysis Expressions (DAX), including measures, calculated columns, and KPIs within Power BI and SSAS models. Will write and optimize T-SQL queries, including views, stored procedures, CTEs, and functions, to improve data retrieval efficiency, overall system performance and create, maintain pixel-perfect and parameterized reports using SQL Server Reporting Services (SSRS) with enhanced visualization features for improved user experience. Will monitor, maintain SQL Server Agent jobs, troubleshooting ETL failures and ensuring timely data pipeline execution and perform root cause analysis on ETL job failures and implement corrective actions to ensure data integrity and reliability. Will utilize Jira to gather business requirements, manage tasks, track progress across reporting and development cycles and engage with stakeholders to understand existing business processes and translate requirements into technical reporting solutions. Will review, enhance existing reports, identifying opportunities for performance improvements and better visualization techniques. Will deliver reports in multiple formats (PDF, Excel, Power BI Service) to meet diverse business needs and accessibility requirements. Will manage end-to-end report lifecycle including requirement gathering, development, testing, deployment, and maintenance. Will ensure data accuracy and consistency by validating data sources and implementing quality checks across reports and dashboards.
3110 Kettering Blvd, Moraine, OH 45439, USA On-site Full-time
Winsupply is hiring a Business Intelligence Analyst
About company
Winsupply is a collection of more than 680 independent, locally owned and operated construction wholesaling companies across the United States. Collectively, Winsupply is known as The Winsupply Family of Companies.
Winsupply Inc. — in business to build entrepreneurs — owns a majority equity stake in these locally owned wholesaling companies. Collectively, Winsupply local companies are among America's leading suppliers of material for residential and commercial construction today.
The local owners of Winsupply's wholesaling companies earn their own success through the Spirit of Opportunity: the chance to risk a little money, run a wholesaling location and chase the American Dream, with help from Winsupply.