Marketing Analyst - Analytics and Insights

Ferguson Enterprises; United States; Remote; USD 60,000 - 80,000; Full time

Job summary

Ferguson Enterprises is seeking a Marketing Analyst who will develop reporting and analyses to improve marketing strategies. This remote/hybrid role involves data extraction, validation, and the creation of impactful dashboards. The ideal candidate will have strong SQL skills and a background in Business Intelligence to analyze and visualize data for various marketing strategies.

Benefits

Health insurance

Paid time off

401(k) with company match

Mental health coverage

Paid parental leave

Qualifications

• 3+ years of relevant analyst work experience.
• Expertise in SQL/Advanced Querying.
• Strong working knowledge of Excel and BI tools.

Responsibilities

• Work with partners to understand business problems.
• Create reports and dashboards to address reporting needs.
• Statistical modeling and A/B testing to measure impact on business objectives.

Skills

SQL

Excel

Business Intelligence tools

Statistical Modeling

Data Visualization

Communication

Education

Bachelor’s Degree

Tools

Power BI

Tableau

Google Data Studio

Adobe Analytics

Google Analytics

Job description

Marketing Analyst - Analytics and Insights

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.

The Marketing Analyst plays an essential role in helping marketers improve the effectiveness of their strategies and supports them in making data-driven decisions. This position will independently develop reporting and analyses that provide actionable, high-impact insights to partners in Marketing, Business Strategy, Digital Commerce, Merchandising and Product.

The Marketing Analyst will work with collaborators to understand their business challenges and make proactive recommendations to solve them. They are responsible for extracting data from multiple sources, validating and manipulating data, conducting analysis, and building out the associated reporting/dashboards. They will work on projects across varying subject matter to support Ferguson’s 8 lines of business.

The ideal candidate should be comfortable gathering requirements for analysis, writing complex SQL queries, collaborating with other analysts, conducting advanced analyses, developing analytical visualizations, educating collaborators on their interpretation of the data, and providing actionable insights. They should look for opportunities to leverage past experiences to improve existing processes and to develop new ones.

Location:

This role is approved to be either Remote within the United States or Hybrid for associate s in Newport News, VA , in accordance with company policy. Candidates must be open to working, as needed, east coast hours.

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

Scoping out Business Analytics needs, defining data structures needed for reporting, locating data sources, and identifying solutions for data automation. For more advanced ETL processes, collaborating closely with our Data Engineering team

Statistical modeling and A/B testing - Working with partners to set up tests measuring the relationship between variables to better understand what website interactions, journeys and marketing tactics are most or least influential to business objectives

Creation of marketing activation audiences, including defining treatment and holdout groups

Write the code to pull and model the data in an efficient, automated manner

Leverage industry standard methodologies in the visual display of information to design and layout visual elements of reports and dashboards, making them easily consumable and interpretable by non-technical audiences

Analyze data, provide insights, and make actionable recommendations to improve Marketing effectiveness

Clearly explain Marketing Attribution and testing logic back to partners.

Find opportunities to improve the partner experience with our reports/dashboards through improved visualization and interface design as well as back-end performance improvement

Provide mentorship to junior analysts

Formalize and adhere to strong Quality Assurance processes to ensure the integrity of analytical outputs

Required Qualifications:

Bachelor’s Degree or equivalent work experience.

3+ years of relevant analyst work experience.

Expertise in SQL/Advanced Querying.

Strong working knowledge of Excel.

Strong knowledge of at least one Business Intelligence tool (Power BI, Tableau, Google Data Studio, Looker, etc.).

Strong written and verbal communication skills.

Preferred Qualifications (*the highest priority preferences):

Masters or Advanced Degree.

5+ years of relevant analyst work experience, within Marketing preferred.*

Working knowledge of Python and/or R.*

Working knowledge of: Segmentation, Attribution and Incrementality testing.*

Working knowledge of Site Analytics (Adobe or Google Analytics).

Experience with the Microsoft Azure suite of tools.

Databricks, Data Factory preferred.

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!

#LI-REMOTE

-

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.

-

$5,175.00 - $9,716.30

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.

The Marketing Analyst plays an essential role in helping marketers improve the effectiveness of their strategies and supports them in making data-driven decisions. This position will independently develop reporting and analyses that provide actionable, high-impact insights to partners in Marketing, Business Strategy, Digital Commerce, Merchandising and Product.

The Marketing Analyst will work with collaborators to understand their business challenges and make proactive recommendations to solve them. They are responsible for extracting data from multiple sources, validating and manipulating data, conducting analysis, and building out the associated reporting/dashboards. They will work on projects across varying subject matter to support Ferguson’s 8 lines of business.

The ideal candidate should be comfortable gathering requirements for analysis, writing complex SQL queries, collaborating with other analysts, conducting advanced analyses, developing analytical visualizations, educating collaborators on their interpretation of the data, and providing actionable insights. They should look for opportunities to leverage past experiences to improve existing processes and to develop new ones.

Location:

This role is approved to be either Remote within the United States or Hybrid for associate s in Newport News, VA , in accordance with company policy. Candidates must be open to working, as needed, east coast hours.

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

• Scoping out Business Analytics needs, defining data structures needed for reporting, locating data sources, and identifying solutions for data automation. For more advanced ETL processes, collaborating closely with our Data Engineering team

• Statistical modeling and A/B testing - Working with partners to set up tests measuring the relationship between variables to better understand what website interactions, journeys and marketing tactics are most or least influential to business objectives

• Creation of marketing activation audiences, including defining treatment and holdout groups

• Write the code to pull and model the data in an efficient, automated manner

• Leverage industry standard methodologies in the visual display of information to design and layout visual elements of reports and dashboards, making them easily consumable and interpretable by non-technical audiences

• Analyze data, provide insights, and make actionable recommendations to improve Marketing effectiveness

• Clearly explain Marketing Attribution and testing logic back to partners.

• Find opportunities to improve the partner experience with our reports/dashboards through improved visualization and interface design as well as back-end performance improvement

• Provide mentorship to junior analysts

• Formalize and adhere to strong Quality Assurance processes to ensure the integrity of analytical outputs

Required Qualifications:

• Bachelor’s Degree or equivalent work experience.

• 3+ years of relevant analyst work experience.

• Expertise in SQL/Advanced Querying.

• Strong working knowledge of Excel.

• Strong knowledge of at least one Business Intelligence tool (Power BI, Tableau, Google Data Studio, Looker, etc.).

• Strong written and verbal communication skills.

Preferred Qualifications (*the highest priority preferences):

• Masters or Advanced Degree.

• 5+ years of relevant analyst work experience, within Marketing preferred.*

• Working knowledge of Python and/or R.*

• Working knowledge of: Segmentation, Attribution and Incrementality testing.*

• Working knowledge of Site Analytics (Adobe or Google Analytics).

• Experience with the Microsoft Azure suite of tools.

• Databricks, Data Factory preferred.

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!

#LI-REMOTE

-

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.

-

$5,175.00 - $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

S distributor of plumbing supplies, PVF, waterworks and fire and fabrication products.

Notice

Talentify is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or protected veteran status.

Talentify provides reasonable accommodations to qualified applicants with disabilities, including disabled veterans. Request assistance at [e-mail] or 407-000-0000.

Federal law requires every new hire to complete Form I-9 and present proof of identity and U.S. work eligibility.

An Automated Employment Decision Tool (AEDT) will score your job-related skills and responses. Bias-audit & data-use details: www.talentify.io/bias-audit-report . NYC applicants may request an alternative process or accommodation at [e-mail] or 407-000-0000.