The Cornerstone brands deliver inspirations that help customers enjoy, enhance and celebrate life. Cornerstone comprises four interactive, aspirational home and apparel lifestyle brands: Ballard Designs®, Frontgate®, Grandin Road® and Garnet Hill®.
Your Opportunity, Your Team
The Analyst Marketing Services supports Cornerstone Brands (Ballard Designs, Frontgate, Grandin Road, Garnet Hill), and is responsible for producing accurate and timely mailings. This role is heavily hands-on and technical, with the majority of work performed in SQL Server 2020. The Analyst develops, maintains, and executes programming code used to cleanse, standardize, merge, and purge customer mailing lists to meet business and postal requirements. You will report to the Director of Marketing Services.
Where You'll Work
This role is hybrid and will require you to be onsite at our West Chester, OH office several days per month. Relocation assistance is not available for this role.
What You’ll Do
Ensure merges (catalogs and specialty mailings) are completed on time and with 100% accuracy.
Monitor quality of data imported/exported in the merge process.
Ensure new processes are coded and executed properly.
Maintain scripts in a way that support departmental best practices.
Understand and run existing stored procedures, scripts.
Write new SQL code for each mailing using instructions from the business users.
Use SSIS and FTP to import/export and send/receive files.
Become proficient in the third-party postal software we use to standardize mailing addresses and remove duplicates.
What You’ll Bring
Bachelor's Degree in Computer Science or related fields, or equivalent combination of education and experience
3+ years of experience working with SQL
Ability to write SQL Server T-SQL code to execute complex merge instructions from the circulation team. The code must be completed in a short amount of time under deadlines.
Strong programming ability, with great attention to detail and design.
Understand and run existing stored procedures, scripts.
Knowledge of Direct Marketing/Circulation is a plus
Experience working in a production IT environment
Experience using postal software like Verimove, Code-1, Merge/Purge, Spectrum preferred
#LI-JM1
Our Total Rewards package includes benefits you’ll love such as competitive compensation, paid time off, an employee assistance program, parental leave, paid volunteer hours, and amazing company discounts! In our US market, you can also expect health care benefits starting on day 1, 401(k), and tuition reimbursement benefits.
QVC Group is committed to inclusion and belonging for all and ensuring that our workplace provides equal employment opportunities for all team members and candidates and complies with all applicable federal, state, and local laws and regulations. As an equal opportunity employer, QVC Group is committed to a barrier-free employment process. If you need reasonable accommodations/support throughout, please contact us at [email protected] for assistance.
If provided, salary ranges are a general guideline only, and actual salaries will vary and are based on factors such as a candidate's qualifications, skills, experience, and geographic location as well as business and market conditions.
Skills Required
- Bachelor's Degree in Computer Science or related fields
- 3+ years of experience working with SQL
- Ability to write SQL Server T-SQL code
- Experience using postal software like Verimove or Code-1
QVC Group Compensation & Benefits Highlights
The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about QVC Group and has not been reviewed or approved by QVC Group.
-
Healthcare Strength — Healthcare coverage is positioned as broad, including medical, dental, vision, prescription coverage, and company-paid life insurance and AD&D. Additional wellness supports like confidential counseling and condition-management programs are also part of the offering.
-
Flexible Benefits — Flexible work arrangements such as remote work, flextime, and compressed schedules are available in parts of the organization. Spending-account options like HSA and FSA are included within the benefits mix.
-
Retirement Support — Retirement support includes access to a 401(k) plan with company matching, and some sources also reference a pension plan. Performance bonuses are also described as available for some employees.
QVC Group Insights
What We Do
Curated Experiences. Infinite Possibilities.® We believe in a Third Way to Shop® – beyond transactional ecommerce or traditional brick-and-mortar stores – for customers who crave engaging shopping experiences. We're a select group of diverse businesses that provide customers with curated collections of unique products, made personal and relevant by the power of storytelling. We combine the best of retail, media, and social to curate experiences, conversations, and communities for millions of highly discerning shoppers. We bring joy, inspiration, and humanity to shopping. We also curate large audiences, across our many platforms, for our thousands of brand vendors. Qurate Retail Group comprises seven leading retail brands – QVC®, HSN®, Zulily®, Ballard Designs®, Frontgate®, Garnet Hill®, and Grandin Road®. We reach approximately 218 million homes worldwide via 14 television networks and reach millions more via multiple streaming services, social pages, mobile apps, websites, print catalogs, and in-store destinations. We're a world leader in video commerce globally, among the top ecommerce retailers in North America (according to Digital Commerce 360), and a leader in mobile commerce and social commerce.
