Production Programmer SQL Developer

Salary Range: 65000 to 75000 (Currency: USD) (Pay period: per-year-salary)

Key Responsibilities

• Primary Responsibilities
•        Monitor existing process execution to ensure completion
•        Execute & review existing process QC reports
•        Review wiki and other documentation to understand existing processes purpose and steps
•        Update Wiki documentation to improve team documentation
•        Review ETL QC reports and identify any data quality issues
•        Run existing scripts to update DWH
•        Perform QC to ensure proper execution and completeness of DWH
•        Run existing scripts to generate client reports
•        QC & review report providing feedback to internal customers & stakeholders
•        Assist with minor modifications & enhancements to reports
•        Save all work with careful documentation (for QC and future use)
•        Run existing ETL data feeds and monitor for issues
 
• Responsibility Details
•        Troubleshoot automated production tasks issues
•        Automate existing production code
•        Assist with development of ad-hoc reports
•        Know all client file inputs for a campaign, understand which would be critical for campaign processing and how the fields within each file are used in the campaign and results reporting
•        Setup new ETL scripts & QC for new client data feeds
•        Know when client files are expected; notify team members if they do not come in
•        Responsible for the movement of files and assets from FTP sites and/or emails to appropriate folders and notify appropriate team members
•        Be able to use FTP, MoveIT, JIRA and navigate through Wiki
 

Required Skills & Qualifications

• Bachelor’s degree in Computer Science
• Work experience a plus
• Direct Marketing experience or knowledge a plus
• Certifications/Technical training are a plus
 
Job Skills
• Knowledge in SQL
• Microsoft Outlook, Word and Excel
 
Other Skills
• Strong attention to detail
• Ability to communicate clearly
• Self-motivated
• Strong interpersonal skills and ability to deal effectively in a team environment