Deerfield Beach, FL 33442
2+ years of SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS).
2+ years of postal presort software (Satori, BCC, First Logic or Group One).
Retrieve data from various sources and prepares data for hygiene and postal presort. Working on data manipulation and extraction using Microsoft SQL.
Quality Assurance Verify accuracy of data pulled and revises methods of data retrieval by following a standard process. Perform internal audits: gather data from various sources/applications and databases to validate audit steps performed; evaluate quality assurance.
Develop complex SQL queries against various data and computer sources.
Compiles and prepares reports, graphs and charts of data developed by analyzing situations and/or data from which answers can be obtained.
Supports business area projects by applying general knowledge of the business area processes including best practices.
Intermediate MS Office skills including the ability to create, manipulate and formulate spreadsheets. Knowledge of spreadsheet functionality including v-look-up, pivot tables, charts and graphing.
Must be well organized, extremely detail oriented and have great communication skills, both oral and written.
Must be flexible and have the ability to adapt quickly as external environment and organizational changes occur.
Write queries and stored procedures in SQL, exports data into excel or csv files, reviews them for quality and data integrity, and sends them to internal clients or external agencies.
Combining of data files for use of suppression or enrichment (Combining of different outputs format to aid in targeting).
Basic understanding of the direct marketing project process flow and execution a plus.