Senior 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. There are 2 roles open and split between Finance and Marketing Analytics. Come help improve the way our marketing and 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.

Location:

This role is approved to be fully remote and can be based anywhere in the United States.

Responsibilities:

• Work with key partners to understand the business problems they face, identify reporting needs, and define the reporting/dashboard requirements to address those problems.
• Scope out Business Analytics needs, defining data structures needed for reporting, locating data sources and identifying solutions for data automation. For more advanced ETL collaborating closely with our Data Engineering team.
• Develop, publish, schedule advanced 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.
• Build Advanced Data Analytics 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.
• Provide technical guidance to junior and associate developers.
• Help lead 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.
• Ability to diagnose report issues and performance tune reports and dashboards.
• Design, implement, and support a platform providing ad-hoc access to large datasets.
• Help answer complex business questions and reporting needs.

Qualifications:

• Bachelor’s degree in Accounting, Info Systems, Business Administration, Finance, Accounting, Statistics, Computer Science or Information Technology, or equivalent work experience preferred.
• Expert understanding of DAX and SQL.
• Python experience preferred.
• Ambition to learn new technologies and incorporate AI into Analytics workflows.
• 6+ years in developing Power BI reports, dashboards, indicators, and scorecards.
• 6+ years development experience in Data Analytic technologies such as: Microsoft – Power BI.
• Experience with Microsoft Azure platform.
• Strong experience with SSRS/Paginated Reports.
• Ability to interpret data to inform business decisions.
• Ability to gather and understand request requirements, design and prototyping.
• Strong organizational skills required.
• Team oriented with an ability to also work independently, with minimal guidance.
• Strong attention to detail.
• Must be self-motivated.
• Professional written and oral communication skills.

Marketing Role (Specific):

• Marketing Analytics Experiences preferred with working knowledge of: Attribution, Segmentation, Activation and Incrementality testing.
• Marketing Channel Knowledge: SEM, Digital, Catalog, Email, SMS, Traditional Media, etc.
• Strong working knowledge of Site Analytics (Adobe or Google Analytics).
• Consult with stakeholders on Marketing Analytics and testing best practice to help them quantify their strategies impact on the business.

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