Data Analyst/Programmer

Data Analyst/Programmer

Direct Hire

Data Analyst / Programmer works with project managers to produce variable data print production using various scripting and programming languages to successfully execute customer-required deliverables.

Essential Duties and Responsibilities

 

§ Work with customer supplied data

§ Produce Variable Data Production files for Client Products

§ Presort client data per USPS requirements using presort software.

§ Understand USPS requirements for mail automation.

§ Modify database including creating tables, finding the proper indexes and primary keys based on their entities and relations (normalization)

§ Participate in the testing of programs and systems to ensure proper functionality

§ Pulling and updating data using Excel and SQL

§ Required to work in a team environment and help verify teammates work.

§ Pre-flight and data cleansing

§ Provide counts on raw data to CSR's as needed

§ Postal processing of data using BCC software

§ Modify database including creating tables and maintaining tables

§ Create waterfalls and run lists on mailing projects

§ Keep track of and enter customer PAF's

§ Process drop ship lists and provided reports, packing slips or key import labels to fulfillment

§ Format and create data for shipping to produce UPS/FedEx/Endicia.com labels

§ Work on various projects as needed for the department

§ Crete client data dumps as requested

§ Append tracking numbers to customer original data as requested

§ Create special reports for clients or other departments as needed

§ Follow job assignments, review instruction, plan work and responsibilities for the job or project to ensure customer specification compliance

§ Follow and execute production schedule

§ Comply with company and department SOP's, job descriptions and safety requirements

§ All other duties as assigned

Qualifications

§ Computer Science or equivalent degree required

§ Proficiency in MS Office, emphasis on MS Excel a must

§ MS SQL and Access experience a plus

§ Knowledge of UPS and FedEx systems a plus

§ Become familiar with basic creative design and layout as it relates to project and processes

§ Ability to take initiative and need little supervision

§ Ability to be proactive in anticipating and communicating project issues with internal departments

§ Ensure tasks are completed on time

§ Must pay high attention to details and maintain accuracy and quality

§ Adapt to a fast paced changing environment

§ Understanding of USPS requirements for mail automation is a must

§ Ability to read, comprehend and interpret specification and work instructions

§ Ability to work well with others

§ C# .Net programming skills a plus