Associate Power BI Developer

Ferguson Enterprises, LLC.; United States; Remote; USD 54,000 - 87,000; Full time

Benefits offered by this job

Health benefits

401(k) with company match

Paid time off

Life insurance

Dental coverage

Vision coverage

Mental health coverage

Job summary

Ferguson Enterprises, LLC. is seeking a BI reporting professional to develop, publish, and optimize Power BI reports and dashboards, leveraging SQL and DAX in an Azure SDW environment.

The role supports business users, collaborates with the BI team, and can be fully remote within the United States or at Ferguson's Newport News, VA office; requires 2-4+ years in Power BI, Azure, and data analytics.

Qualifications

• Bachelor's degree in relevant fields or equivalent 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, metrics, and scorecards.
• 2-4+ years development experience in Data Analytics technologies such as Power BI or Tableau.
• Experience with Microsoft Azure platform is a plus.
• Strong requirement analysis, design, and prototyping skills.
• Solid organizational skills and teamwork with ability to work independently.

Responsibilities

• Develop, publish, and schedule interactive Power BI reports and dashboards to meet business requirements.
• Use Power BI as the catalyst for analytics and understanding trends.
• Use SQL and DAX to solve complex business logic and needs.
• Combine multiple data tables from an Azure SDW environment to create Power BI datasets and reporting.
• Assist with building Data Analytics enterprise models using Microsoft technologies including Power BI, SSAS, AAS and data flows.
• Collaborate with the BI Team to design and implement schemas for accurate Power BI rendering.
• Participate in business analysis to gather reporting and dashboard requirements.
• Assist business users on 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 Row Level Security.

Skills

DAX

SQL

Organizational skills

Teamwork

Communication

Education

Bachelor's degree in Accounting Info Systems, Business Administration, Finance, Accounting, Computer Science or Information Technology, or equivalent work experience preferred

Tools

Power BI

Tableau

Azure

Sage X3

Job description

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.

Location

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.

Responsibilities

• 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.

Qualifications

• 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 needs, including mental health coverage, gender affirming and family building benefits, paid parental leave, associate discounts, community involvement opportunities and more!

Pay Range

Actual pay rate may vary depending upon location. The estimated pay range for this position is below. The specific rate will depend on a candidate's qualifications and prior experience.

$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.

Ferguson complies with all wage regulations. The starting wage may be higher in certain locations based on local or state wage requirements.

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