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.

Business Intelligence (BI) Engineer / Developer

Job Description

As an integral member of our Supply Chain Integrated Planning team, the Business Intelligence (BI) Engineer Developer is responsible for the design, development, implementation, and support of critically important enterprise Business Intelligence (BI) solutions. Working with multi-functional teams, you will participate to gather and document reporting requirements to meet business needs. You will then transform those needs into technical specifications to design, develop, test, and implement BI and analytic solutions that turn data into knowledge.

In this mid-level role, you should have at least 5 years of experience in data engineering and business analysis. You should be analytical and an excellent communicator. If you also have an intuition for business, problem-solving skill, and the ability to handle large projects end-to-end, we’d like to meet you!

This is a Hybrid role based out of our Newport News, VA Headquarters location, in accordance with the Ferguson's Flex schedule; 3 days office / 2 days remote.

Responsibilities:

• Gather user requirements and translate business needs to technical specifications.

• Design, build and deploy BI solutions as they relate to SQL development projects.

• Define, develop, optimize, manipulate, and implement complex SQL database queries.

• Conduct analyses from diverse data sets.

• Create dashboards, visualizations, and reports for requested projects.

• Develop and update technical documentation.

• Act as domain expert in all areas of SQL report development and data integration.

• Provide support as required to ensure the availability and performance of developed processes, reports, and dashboards for both external and internal users.

• Pilot and provide proof-of-concept solutions around next-generation business intelligence and analytics tools.

• Create, modify, read, and understand stored procedures.

• Write, test, and deploy scripts for process automation.

• Design and implement technology standard methodologies, guidelines, and repeatable processes.

Preferred Qualifications:

• Excellent communicator with strong written and verbal communication, including technical writing skills.

• Solid understanding of database concepts.

• Experience with BI technologies (e.g. Microsoft Power BI, SSRS, Power Apps, Power Automate).

• Creative, flexible, and quick to learn.

• Proven abilities to take initiative and be innovative.

• Proven track record of success including understanding project requirements and delivering on them.

• Analytical mind with a problem-solving skill.

• Bachelor's in Computer Science, Data Science, Information Systems, Engineering, or related field.

• Experience developing with .NET framework preferred.

• Adept at SQL programming using Microsoft SQL-Server T-SQL.

• Solid understanding of Azure cloud infrastructure.

• Experience writing and maintaining scripts in PowerShell.

• Experience using Microsoft Graph API.

• In depth knowledge of the following technical tools: Azure Portal (Data Factory, Storage Accounts, SAAS, and Logic Apps), Azure Data Studio, SQL Server Management Studio, and Visual Studio (SQL Server Integrated Services and ASP.NET Web Apps).

• Experience using code repositories, e.g. GitHub, DevOps.

• Desire to learn a vast array of on-premises and cloud technologies.

• Curiosity to investigate sources of data and ability to match that data to its related business function.

• Solid attention to detail and high-quality work.

• Great teammate who is also able to work well independently.

• Able to work under stress, meet deadlines and handle multiple projects simultaneously.

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:

-

$5,444.76 - $9,537.00

-

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 (https://www.ferguson.com/content/careers/reasonable-accommodation)