Ferguson Enterprises, Inc.
Senior Business Analyst - Marketing Analytics
Ferguson Enterprises, Inc., Oregon, Illinois, United States, 61061
Senior Business Analyst - Marketing AnalyticsApply
Location:
This role is approved to be fully remote and can be based anywhere in the United States.
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. Ferguson operates with the shared purpose of building something meaningful.
The
Senior Business Analyst - Marketing Analytics
plays a crucial role in helping marketers improve the efficiency of their marketing strategies and supporting them in making better data-driven decisions.
This role will be responsible for deep dive analysis, experimentation, quantitative campaign support, and marketing efficiency measurement. You will craft media measurement frameworks, set up high-quality tests, create audience samples, and build reports and dashboards.
The successful candidate should be comfortable performing the following: gathering requirements from internal customers, writing queries in SQL, building Power BI dashboards, running A/B tests, developing analytical visualizations, educating partners on the findings, and providing concrete insights. The candidate will be passionate about data and possess a heightened level of attention to detail.
Responsibilities:
Conduct analytical experiments (including A/B tests and geo lift studies) for both online (paid and owned media) and offline/non-digital (traditional media, store/branch) Marketing initiatives.
Utilize your expertise in SQL programming language to extract, manipulate, and analyze data from various databases and data sources.
Build multifaceted reports and Power BI dashboards using data modeling and analysis techniques.
Work with partners to set up tests to measure the relationship between variables to better understand marketing tactics.
Scope out Business Analytics needs, define data structures needed for reporting, and identify solutions for data automation.
Analyze cross-channel, customer, and transactional data to determine the value of Marketing efforts.
Conduct quantitative campaign performance analysis and make optimization recommendations.
Leverage industry standard processes in the visual display of information to design and layout visual elements of reports and dashboards.
Qualifications:
Bachelor’s Degree in a quantitative field such as Analytics, Statistics, Computer Science, Mathematics or similar.
4+ years shown experience solving ambitious, high-impact problems with data.
Expert-level skills in writing complex SQL queries for data retrieval and analysis.
Proficiency with Power BI and strong knowledge of DAX.
Familiarity with database management systems (DBMS) and data warehousing concepts.
Expert knowledge of Excel.
Prior experience with Python and developing predictive models is a plus.
Prior experience with Google Analytics, UTM tracking, or other web analytics data is a plus.
Possess excellent organizational, writing, and analytical skills.
At Ferguson, we care for each other. We are committed to a holistic approach towards benefits plans and programs that support the well-being of our associates. Our competitive offering includes health, dental, vision, paid time off, life insurance, and a 401(k) with a company match.
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.
The Company is an equal opportunity employer and abides by the requirements of 41 CFR 60-300.5(a) and 41 CFR 60-741.5(A).
#J-18808-Ljbffr
Location:
This role is approved to be fully remote and can be based anywhere in the United States.
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. Ferguson operates with the shared purpose of building something meaningful.
The
Senior Business Analyst - Marketing Analytics
plays a crucial role in helping marketers improve the efficiency of their marketing strategies and supporting them in making better data-driven decisions.
This role will be responsible for deep dive analysis, experimentation, quantitative campaign support, and marketing efficiency measurement. You will craft media measurement frameworks, set up high-quality tests, create audience samples, and build reports and dashboards.
The successful candidate should be comfortable performing the following: gathering requirements from internal customers, writing queries in SQL, building Power BI dashboards, running A/B tests, developing analytical visualizations, educating partners on the findings, and providing concrete insights. The candidate will be passionate about data and possess a heightened level of attention to detail.
Responsibilities:
Conduct analytical experiments (including A/B tests and geo lift studies) for both online (paid and owned media) and offline/non-digital (traditional media, store/branch) Marketing initiatives.
Utilize your expertise in SQL programming language to extract, manipulate, and analyze data from various databases and data sources.
Build multifaceted reports and Power BI dashboards using data modeling and analysis techniques.
Work with partners to set up tests to measure the relationship between variables to better understand marketing tactics.
Scope out Business Analytics needs, define data structures needed for reporting, and identify solutions for data automation.
Analyze cross-channel, customer, and transactional data to determine the value of Marketing efforts.
Conduct quantitative campaign performance analysis and make optimization recommendations.
Leverage industry standard processes in the visual display of information to design and layout visual elements of reports and dashboards.
Qualifications:
Bachelor’s Degree in a quantitative field such as Analytics, Statistics, Computer Science, Mathematics or similar.
4+ years shown experience solving ambitious, high-impact problems with data.
Expert-level skills in writing complex SQL queries for data retrieval and analysis.
Proficiency with Power BI and strong knowledge of DAX.
Familiarity with database management systems (DBMS) and data warehousing concepts.
Expert knowledge of Excel.
Prior experience with Python and developing predictive models is a plus.
Prior experience with Google Analytics, UTM tracking, or other web analytics data is a plus.
Possess excellent organizational, writing, and analytical skills.
At Ferguson, we care for each other. We are committed to a holistic approach towards benefits plans and programs that support the well-being of our associates. Our competitive offering includes health, dental, vision, paid time off, life insurance, and a 401(k) with a company match.
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.
The Company is an equal opportunity employer and abides by the requirements of 41 CFR 60-300.5(a) and 41 CFR 60-741.5(A).
#J-18808-Ljbffr