Associate Power BI Developer

Job Posting:

Since 1953, Ferguson has been a source of quality supplies for a variety of industries. Together We Build Better infrastructure, better homes and better businesses. We exist to make our customers' complex projects simple, successful, and sustainable. We proactively solve problems, adapt and grow to continuously serve our customers, communities and each other. Ferguson is proud to provide best-in-class products, service and capabilities across the following industries: Commercial/Mechanical, Facilities Supply, Fire and Fabrication, HVAC, Industrial, Residential Trade, Residential Building and Remodel, Waterworks and Residential Digital Commerce. Ferguson has approximately 36,000 associates across 1,700 locations. Ferguson is a community of proud associates who operate with the shared purpose of building something meaningful. You will build a career that you are proud of, at a company you can believe in.

Ferguson is a dynamic and rapidly growing organization committed to providing innovative solutions. We are seeking a talented Associate Power BI Developer who can drive data-driven decision-making across our sales and finance departments. With a commitment to excellence and a passion for technology, we leverage cutting-edge tools and methodologies to solve complex business challenges.

Our mission is to empower businesses with the insights and tools they need to succeed in an increasingly driven market. By harnessing data, we help our clients make informed decisions, optimize operations, and achieve their strategic objectives. Investing in our people and technology to drive continuous improvement and deliver outstanding results.

Our team is a diverse group of talented professionals dedicated to fostering a collaborative and inclusive environment. As we continue to grow, we strive to maintain our core values of integrity, innovation, and customer satisfaction, making Ferguson a phenomenal place to work and thrive.

Position Summary:

The Associate Power BI Developer (Commissions Specialist) will play a critical role in our Decision Support Center team, focusing on transforming commission-related data into actionable insights that support our sales and finance operations. This position is integral to ensuring that our commission structures are transparent, accurate, and optimized for performance.

As a Power BI Developer specializing in commissions, you will be responsible for designing and implementing data solutions that streamline commission calculations and reporting processes. You will work closely with stakeholders across sales, finance, and human resources to gather requirements, develop robust data models, and create compelling visualizations that drive business decisions.

In this role, you will have the opportunity to use your technical expertise and analytical skills to improve the efficiency and accuracy of our commission systems. You will be tasked with automating complex processes, enhancing existing reports, and providing insightful analysis that helps our teams understand and maximize their performance. Your contributions will directly impact our ability to reward and incentivize our sales force effectively, ultimately driving growth and profitability for the company.

Location:

This role is approved to be either Remote within the United States or Hybrid our of our corporate offices in Newport News, VA, in accordance with company policy.

Responsibilities:

• Design, develop, maintain, and schedule interactive PowerBI reports and dashboards, ensuring consistency and accuracy with the commission plans.

• Use Power BI, SQL, DAX, PowerApps, Power Automate and statistical techniques to analyze data, uncover trends, correlations, root causes, performance metrics, and opportunities for improvement.

• Collaborate with multi-functional teams, across all levels of the business, to gather and analyze business requirements and provide insights.

• Troubleshoot and resolve data and performance issues, and continuously improve BI solutions and processes.

• Suggest and recommend optimizations to data schemas and database structures for statistical analysis purposes.

Qualifications:

• Bachelor's degree in: Accounting, Info Systems, Business Administration, Finance, Computer Science, Information Technology, or equivalent experience.

• Intermediate to expert understanding and utilization of DAX.

• Strong SQL skills for writing sophisticated queries and performance optimization.

• 1-5 years of experience developing Power BI reports, dashboards, critical metrics, and scorecards, with expertise in Microsoft Power BI or Tableau.

• Experience in requirement analysis, design, and prototyping, with the ability to build data analytics models using Power BI, SSAS, AAS, Databricks 00and data flows.

• Strong organizational, analytical, and problem-solving skills, with attention to detail and self-motivation.

• Proficiency in using Microsoft Power Platform to automate reporting and processes and diagnosing and optimizing report performance.

• Ability to work independently and cross-functionally, provide technical guidance to junior developers, and support ad-hoc access to large datasets.

• Excellent written and oral communication skills, with a focus on teamwork.

Preferred Qualifications:

• Certification in PowerBI, SQL, Power Apps, Power Automate, or related technologies.

• Experience with Python for data manipulation and analysis, and familiarity with Azure Data Factory and Databricks for data integration and analytics.

• Business knowledge of Operations, Sales, Sales Commission structures and methods.

At Ferguson, we care for each other. We value our well-being just as much as our hard work. We are committed to a holistic approach towards benefits plans and programs that support the mental, physical and financial well-being of our associates. Our competitive offering not only includes benefits like health, dental, vision, paid time off, life insurance and a 401(k) with a company match, but our associates also enjoy additional meaningful and inclusive enhancements that are adaptable to their diverse situations and needs, including mental health coverage, gender affirming and family building benefits, paid parental leave, associate discounts, community involvement opportunities and more!

• Pay Range:

• $4,799.70 - $7,791.30

• Estimated Ranges displayed are Monthly for Salaried roles OR Hourly for all other roles.

• This role is Bonus or Incentive Plan eligible.

• The Company is an equal opportunity employer as well as a government contractor that shall abide by the requirements of 41 CFR 60-300.5(a), which prohibits discrimination against qualified protected Veterans and the requirements of 41 CFR 60-741.5(A), which prohibits discrimination against qualified individuals on the basis of disability.

Ferguson Enterprises, LLC. is an equal employment employer F/M/Disability/Vet/Sexual Orientation/Gender Identity.

Equal Employment Opportunity and Reasonable Accommodation Information