Business Intelligence Analyst

Winsupply is in the business of creating and enabling entrepreneurs to achieve their dreams through wholesale distribution. Winsupply is a group of over 670 locally-owned companies that operate across a variety of industries, including HVAC, Plumbing, Electrical and more. The purpose of the support services campus is to eliminate obstacles and provide support to help our entrepreneurs succeed. Support service employees assist entrepreneurs in achieving their dreams through finance, accounting, IT, and other back-office operations.

Job Description

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.

Qualifications

Master’s in computer science & technology with 12 months or Bachelor of Technology in Computer Science & Engineering with 60 months of experience as Software Engineer or Web Developer, BI Analyst will be considered in lieu of Master’s Degree, foreign equivalent accepted, 40 hrs. a week, Send resume to Winsupply Inc., Attn: Michelle Derrickson, [email protected]

Additional Information

Physical Demands

The physical demands here are representative of those that must be met to successfully perform the essential job functions with or without reasonable accommodations:

• Employee is regularly required to sit, use hands, handle controls, talk and hear, reach with hands and arms, stand, walk and stoop.
• Vision requirements include close vision and ability to focus
  
  

We are committed to inclusion, diversity, and equal employment opportunity, regardless of race, color, ancestry, religion, sex, gender, national origin, sexual orientation, age, citizenship, marital status, disability, veteran status, or any other factor protected by applicable federal, state, or local laws.