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, a Fortune 500 company, 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.

An opportunity to join Ferguson's World Class BI reporting team. Come help improve the way our financial data is reported and consumed. Work alongside all levels of the organization in developing interactive and digestive reporting/dashboards that drive action and improve our bottom line.

This role is approved to be fully remote and can be based anywhere in the United States or out of Ferguson's corporate offices in Newport News, VA, according to company policy.

• Develop, publish, schedule interactive Power BI reports and dashboards to meet business requirements.
• Use Power BI as the catalyst for analytics and the understanding of trends.
• Use SQL and DAX to solve complex business logic and needs.
• Bring together multiple data tables from an Azure SDW environment to create Power BI datasets and reporting.
• Assist with building Data Analytics enterprise models using the Microsoft technologies including Power BI, SSAS, AAS and data flows.
• Collaborate with the BI Team to design and implement schemas which efficiently and accurately render data through Power BI.
• Participate in business analysis activities to gather required reporting and dashboard requirement.
• Assist business users on functional and data requirements to enhance data models.
• Use Microsoft Power Platform to automate reporting and processes.
• Design, implement, and support a platform providing ad-hoc access to large datasets.
• Create security roles and apply standard Row Level Security.

• Bachelor's degree in Accounting Info Systems, Business Administration, Finance, Accounting, Computer Science or Information Technology, or equivalent work experience preferred.
• Beginner to intermediate understanding of DAX and SQL.
• Experience with Sage X3 a plus.
• 2-4+ years in developing Power BI reports, dashboards, critical metrics, and scorecards.
• 2-4+ years development experience in Data Analytic technologies such as:
  Microsoft - Power BI or Tableau.
• Experience with Microsoft Azure platform is a plus.
• Experience in requirement analysis, design, and prototyping.
• Strong organizational skills required.
• Team oriented with an ability to also work independently, with minimal guidance.
• Solid attention to detail.
• Must be self-motivated.
• Professional written and oral communication skills.

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…