ABOUT WUNDERMAN DATA PRODUCTS

Wunderman Data Products, a member of the Wunderman network and WPP Group companies, is a strategic marketing partner dedicated to radically improving our clients' businesses by providing expertise in combining data intelligence with one to one marketing innovation. We gather intelligence, create a business-driven strategy and create dialogue to drive conversations and results.

SUMMARY OF THE ROLE

As a Programmer/Analyst, you will be responsible for the loading, summarization, quality control, analysis, and reporting of all data being ingested by database systems across the organization.

This position requires data and technical expertise supporting client data input streams beginning with reviewing the client’s raw data, new client setup, loading and transforming data files, and prepping data to be included in the database system.  Internally, this position interacts with multiple departments fulfilling the technical tasks of data management.

This position is also responsible for the report validation, metrics reporting, testing, and QA of the data for multiple production database systems.

JOB DUTIES

• Complete custom projects related to the production database systems.
• Write application programs for Quality Assurance and Summarization Reports.
• Manage, schedule, and deployment of weekly database builds.
• Develop and execute data conversion programs, using regular expressions and programs for flat file transformation, development and maintenance, ad hoc data extract, variable edit, and report generation, in a PC/Server environment.
• Take responsibility for data integrity; deliver on programming requirements and meet required deadlines.
• Continuously enhance program efficiency, reducing production time and resource requirements.
• Develop an understanding of data processing issues related to KBMG’s evolving business strategy, and provide possible solutions.
• Document new processes and communicate/publish to operations staff.
• Work with Operations and Engineering teams to document and execute test plans for production releases.
• Manage code deployment.
• Develop, execute, and adhere to Quality Assurance (QA) processes and procedures.

SKILLS & EXPERIENCE REQUIREMENTS

• Technical aptitude and problem solving skills
• 2+ years Linux/Unix
• 2+ years using SQL in Oracle environment
• 2+ years of Perl programming experience
• Shell scripting
• Regular expressions
• PL/SQL experience preferred
• Experience and proven performance in direct marketing and support of direct channel sales, along with use of targeting tools in implementation.
• Proficient in Microsoft Outlook, Word, Excel, and PowerPoint
• Extreme attention to detail and data quality
• Ability to work in fast paced and highly dynamic work environment
• Excellent interpersonal, communications, and customer service skills
• Ability to prioritize, self-manage, and seek help or direction when necessary
• Manage multiple tasks and high volume workload