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