Marketing Services Analyst
Ohio, United States of America
Full Time
3 weeks ago
No Visa Sponsorship
Key skills
SQLSSISSQL Server
About this role
Role Overview
- 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
Requirements
- 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
- Strong programming ability, with great attention to detail and design
- 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
Tech Stack
- SQL
- SSIS
Benefits
- competitive compensation
- paid time off
- an employee assistance program
- parental leave
- paid volunteer hours
- amazing company discounts
- health care benefits starting on day 1
- 401(k)
- tuition reimbursement benefits