Senior Business Analyst - Marketing Analytics

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 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. In addition, you will have the opportunity to work with partners across Marketing on data-driven campaign design, execution, and optimization in support of the continual improvement of our Marketing efforts. You will craft media measurement frameworks, set up high-quality tests, create audience samples, and build reports and dashboards. You will be responsible for extracting data from multiple sources, analyzing, and communicating findings. 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. Location: This role is approved to be fully remote and can be based anywhere in the United States. 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. Your proficiency in writing efficient SQL queries will be essential in handling large datasets while ensuring data accuracy and reliability. Build multifaceted reports and Power BI dashboards using data modeling and analysis techniques to uncover insights that will guide strategic decisions and reveal optimization opportunities. Work with partners to set up tests to measure the relationship between variables to better understand what website interactions, journeys and marketing tactics are most or least influential to business objectives. Scope out Business Analytics needs, define data structures needed for reporting, locate data sources, and identify solutions for data automation. For more sophisticated ETL collaborate closely with our Data Engineering team. Analyze cross-channel, customer, and transactional data to determine the value of Marketing efforts across all trackable customer touchpoints, both online and offline. 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, making them easily consumable and interpretable by non-technical audiences. Qualifications: Bachelors 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. Strong knowledge of DAX. Prior experience creating data models, visualizations, and dashboards using Power BI. Familiarity with database management systems (DBMS) and data warehousing concepts. Expert knowledge of Excel. Prior experience with Python is a plus. Experience developing predictive models is a plus. Prior experience with Google Analytics, UTM tracking, or other web analytics data is a plus. Possess a heightened level of attention to detail. Possess excellent organizational, writing, and analytical skills. 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)