Ferguson Enterprises
Business Intelligence (BI) Developer
Ferguson Enterprises, Newport News, Virginia, United States, 23600
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:
$6,000.30 - $9,716.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 (https://www.ferguson.com/content/careers/reasonable-accommodation)
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:
$6,000.30 - $9,716.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 (https://www.ferguson.com/content/careers/reasonable-accommodation)