Business Intelligence (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.

Business Intelligence (BI) Developer

As an integral member of our Supply Chain Integrated Planning team, the Business Intelligence (BI) Application 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 in order 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 science, business analysis, and software development. You should have a proven track record of designing and coding functional programs and applications. You should be analytical and an excellent communicator. If you also have an intuition for business, problem-solving proficiency, and the ability to handle large scale projects end-to-end, we’d like to meet you.

Location: This is an onsite role based out of Newport News, VA, in accordance with the Ferguson Flex schedule; 3 days in 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
• Identify problems, analyze data, and develop solutions
• Structure and organize data for effective analysis and reporting
• Familiarity with Power Query for data transformation, cleaning, and merging data from various sources
• Create effective and informative visualizations, dashboards, and reports
• Interact and extract data from Data Warehouse using SQL and Azure Data Factory
• Create and maintain ETL processes for moving and transforming data
• Automating processes via scripts, e.g. PowerShell, Python
• Performing regression analysis using R
• Use machine learning techniques and algorithms to build predictive models and extract insights from that data
• Communicate findings and insights clearly and effectively to all levels in the organization (both technical and non-technical users)
• Translate high level requirements into interaction flows
• Define, develop, optimize, manipulate, and complete complex SQL database queries
• Conduct analyses from diverse data sets
• 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
• Design and implement technology best practices, guidelines and repeatable processes

Preferred Skills and Qualifications:

• Proven experience as a business intelligence developer
• Proven UI experience
• 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, Oracle BI, SSRS, Power Apps, Power Automate) preferred
• 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 proficiency
• BA in Computer Science, Information Systems, Engineering or related field
• Experience in Data Modeling preferred
• Desired interest in machine learning
• Adept at SQL programming using Oracle, Microsoft SQL-Server T-SQL, SSIS and SSRS 2012+
• Solid understanding of Azure cloud infrastructure, and Azure SAAS (software as a service).
• In depth knowledge of the following technical tools: SQL Server Management Studio, SQL Server Integrated Services, and Power Apps.
• Experience in MS Excel
• 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:

-

-

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