Previous Job
Data Programmer 2 (IL)
Ref No.: 20-01491
Location: West Chicago, Illinois
Title: Data Programmer II
Location: 1240 W North Ave, West Chicago, IL 60185
Timeline: 6-month W2 contract with extension/FTE conversion based on performance
Starting Pay Rate: $60/hour + optional benefits

About the Opportunity: The Data Programmer's role is to manage and process client data across the full production lifecycle, while ensuring high levels of data quality and availability and meeting project deadlines. Essential functions include:
  • Generates adhoc reports and regular datasets or report information for end-users using system tools and database or data warehouse queries and scripts
  • Integrates data from multiple sources to produce requested or required data elements
  • Programs and maintains report forms and formats, information dashboards, data generators, canned reports, and other end-user information portals or resources
  • Receives and process input feeds
  • Verifies input data quality, including identification and communication of file variances and potential issues
  • Performs file transfers and backup procedures
  • Performs US Government Client hygiene on data files to include CASS/NCOA and presort
  • Manages the quality and timeliness of updates and output deliverables
  • Ensures compliance with production standards and tests/Quality Controls the solution(s)
  • Takes specifications and uses them to design/code a solution
  • Uses and fully understands established appropriate processes to meet customer requirements, and be able to customize if required
  • Verifies program execution is successful
  • Proactively identifies areas for improving processes and client service
  • Focus on meeting and exceeding client expectations
  • May create specifications for reports based on business requests

Required Expertise:
  • Experience with Microsoft T-SQL, data access methods, and stored procedures a must
  • Must be familiar with MS Office, with particular emphasis on Word and Excel
  • Experience with US Government Client processing, address standardization, merge/purge, COA Ability to work in a fast-paced, high traffic environment
  • Intermediate scripting and programming skills
  • Management of quality assurance of input feeds
  • Ability to maintain documentation of processes, file layouts, and/or schedules
  • Experience in batching/processing large amounts of data through a custom database system for Direct Mail programs
  • Ability to apply marketing data translations and suppressions when requested, running QC checks to ensure accuracy
  • Requires a minimum of 2 years of related experience
  • Associate's or Bachelor's degree or equivalent experience