Senior Marketing Data Analyst

Position Overview:

The Senior Marketing Data Analyst is responsible for managing data requirements for multi-channel campaigns at HomeServe and for producing key reports and analysis used within the marketing department. This position supports the marketing department by providing accurate, clean data to maximize campaign response rates, and is a strong point of contact for other teams within the organization when they need information about data relationships with affinity partners.

The position also serves as the single point of contact for HomeServe's third-party data campaign processor (Direct Options) which is utilized when data privacy rules restrict HomeServe from handling affinity partner customer data.

The position reports into the Director, Marketing Data Services.

Responsibilities:

• Timely and accurate production of counts and data files for acquisition, cross-sell and retention campaigns using SAS programming.
• Cleansing and standardizing partner files for use in marketing campaigns using specialized data cleansing software (SAS DataFlux)
• Producing data matrices in collaboration with the strategy and campaign management teams.
• Producing regular marketing campaign response reporting to provide timely insight into HomeServe's marketing effectiveness and making recommendations for improvements/opportunities.
• Managing HomeServe's outsourced data processing vendor Direct Options.
• Supporting the digital marketing team with production of audience lists for email marketing campaigns.
• Supporting the responses to customer and partner complaints about data use through data mining and investigations.
• Managing mailing return files and their upload to the Prospect Database and transmission to Exela, to aid enrollment processing.
• Responding to ad-hoc analysis and reporting requests to provide insight into HomeServe USA's marketing effectiveness.
• Seeking and implementing ways to automate the production of data and counts for campaign activity.
• Writing complex SAS/SQL procedures, functions, scripts and queries as well as creating and implementing customized databases for various business needs.
• Managing all data work with due skill, care and diligence, including effective quality controls and risk management/mitigation.

Essential Functions

Essential Job Function

% of Time on Function

Run Direct Mail Marketing campaigns in an accurate and timely manner

60%

Managing partner provided data files to ensure data quality and timely delivery

30%

Ad hoc analysis

10%

Total

100%

Job Requirements:

• Bachelor's degree (mathematics/statistics/economics/computing or other numerical-based degree) or five years relevant work experience
• Highly numerate and analytical
• Four year's work experience in a commercially data driven/analysis role
• Extensive SAS/SQL or other programming language experience (ideally 3 years+ in a commercial environment)
• Proficiency in data visualization tools, ideally Tableau (ideally 2 years+ in a commercial environment) is a plus
• Experience working with and maintaining large databases
• Strong Microsoft Excel ability
• Strong written communication skills
• Strong troubleshooting skills
• Attention to detail and accuracy
• Direct Marketing data processing experience

Minimum Physical Requirements:

The physical demands described represent those that must be met by an employee to successfully perform the essential functions of this position. Reasonable accommodations may be made to enable individuals with disabilities to perform the functions of the position for which they work. While performing the duties of this position, the employee is regularly required to listen, talk and hear. The employee frequently is required to use hands or fingers, handle or feel objects, tools, or controls while executing tasks like working on a computer or talking on the telephone. The employee is occasionally required to stand; walk; sit; and reach with hands and arms. The employee must occasionally lift and/or move up to 15 pounds. Specific vision abilities required by this position include close vision, distance vision, and the ability to adjust focus. The noise level in the work environment is usually moderate to low.

This job description is intended to provide guidelines for job expectations and the employee's ability to perform the position described. It is not intended to be construed as an exhaustive list of all functions, responsibilities, skills and abilities. Additional functions and requirements may be assigned by supervisors as deemed appropriate.

Salary Range: $98,683.60 - $131,578.13

Annual Bonus Potential: 10%

HomeServe USA is an equal opportunity employer.

#HUSA #LI-NM1 #LI-ONSITE