Company:                        Harlequin Enterprises ULC

Date:                                March 27, 2025

Job Title:                         Database Marketing Specialist

Department:                   Direct to Consumer

Reporting To:                  Manager, Analysis

Status:                             Regular Full Time
Location:                         22 Adelaide Street West, Toronto (hybrid model)

We celebrate and support the differences that make each of us unique, striving to create a welcoming workplace that ensures everyone has a voice and is able to do their best work. We welcome all applicants, including those who identify with groups that are traditionally underrepresented in the publishing industry including, but not limited to, Black, Indigenous, people of colour, members of the LGBTQIA2S+ community, and persons with disabilities.

Join us, and share your story.

Job Summary:  

Reporting to the Manager, Analysis, the Database Marketing Specialist position will be a key member of the Direct-to-Consumer team.

In this role, you will be responsible to develop and maintain programs that are required to identify, categorize, select and suppress the customer data necessary to support DTC’s Direct Mail campaigns.

Mailing Lists (20%)

• Select mailing lists for the Direct-to-Consumer Department. These lists would be segmented by applying various conditions, scores, criterion and formatted to various specifications based on in-house and 3rd party vendor requirements.
• Ability to select data lists using Google Big query and apply analytical skills to ensure the selected data is cleansed by applying deduping rules, opt out as well as 3rd party processing rules which include National Change of Address (NCOA) which would eliminate duplicate mailings to the same household. Perform QC steps to verify the accuracy of the output data.

Testing (20%)

• Perform geographic or nth record selection to test creative ideas for in-house acquisition mailings, based on state regulations.
• Create parameter files for keying and splitting, which include assigning panel codes, promotion codes, indicator codes to each name/address record.
• Create name/address files for imaging and fulfillment purposes.
• Work with legacy marketing systems to seamlessly load new campaign data and produce and export data in the appropriate format for printing of mailing pieces.

Data & Reporting (20%)

• Work with Marketing and IT to ensure data from our reporting data base (Sales Hub) is accurately converted into selection criteria based on Marketing campaign plans using Google Data Studio and Google Big query SQL.
• Support DTC users reporting requirements assisting with List creation, Campaign Analysis, Profit & Loss reporting, and other financial and marketing reporting.

Third Party Relations (15%)

• Liaise with 3rd party vendors to transfer transactional data to data co-ops to maintain our membership.
• Liaise with 3rd party vendors to have our Lists scored using RFM (Recency, Frequency, Monetary) model and receive the scored classes and appropriately flag the data for further processing.
• Liaise with 3rd party vendors to extract and transfer our name and addresses data to them to ensure they are appropriately cleansed, and the updated data ingested into our system and the necessary certification received for subsequent campaign mailing.

Campaign Information System Maintenance (15%)

• Performing all tasks related to the Campaign Information System (CIS) to create Detail sheet reports
• Exporting List Split data for further campaign processing

Specific training or job experience required includes:

• College/University Degree in computer science or related discipline
• 3+ years’ experience in data processing in a Windows environment
• Ability to run/modify and create queries using Google data studio and big query SQL
• Working knowledge of Windows Office suite (Word, Excel, Power Point, Flow chart)

Competencies/Skills:

Competencies and skills required to perform this job include:

• Effective verbal and written communication skill
• Demonstrated ability to pay close attention to detail
• Problem solving and analytical abilities
• Strong ability to manage execution and knowledge of word processing

What's in It For You?

• The opportunity to be part of a company on the leading edge of publishing, working with a very talented team and exceptional books
• Hybrid work, flexible start/stop times
• Work from anywhere 4 weeks per year!
• Paid time off and vacation allotment, starting at three weeks (prorated based on start date)
• Flexible benefit plans to fit your needs and pension matching
• Various virtual social activities to keep you connected – we love trivia!
• Virtual author events and access to discounted books
• Working with passionate people!

About HarperCollins Canada and Harlequin

Harlequin is a leading publisher of commercial fiction and narrative nonfiction. We publish more than 100 titles a month that reach audiences globally. Encompassing highly recognizable imprints that span a broad number of genres, we are home to many award-winning New York Times and USA TODAY bestselling authors. Harlequin is a division of HarperCollins Publishers, the second-largest consumer book publisher

in the world. Through HarperCollins’s global publishing program, Harlequin titles are published in 17 countries and 16 languages.

Known worldwide for the quality of its list, HarperCollins Canada is the proud home of many bestselling and award-winning authors, including Esi Edugyan, Heather O’Neill, and Lawrence Hill. It is our vision to publish the best books of our generation and to work with authors over the length and breadth of their careers. Our authors are at the centre of everything we do. In addition to the Canadian publishing program, HarperCollins Canada is responsible for the sales, marketing, and publicity of HarperCollins titles from around the globe

HarperCollins Canada and Harlequin are Equal Opportunity Employers committed to equal employment opportunities. Employment decisions are based on job requirements and the skills, knowledge, and experience of the candidate, regardless of any other factors unrelated to job performance.

We are also committed to ensuring that the accessibility needs of candidates and employees are considered and accommodated during the recruitment process.

We thank all applicants for their interest, however, only those candidates selected for an interview will be contacted.