Production Programmer - Entry level SQL Developer

$50,000 - $70,000/Yr

Datalab USA - Broomfield, CO

Full-time - Entry Level

Broomfield, CO

Publishing Industries

About the position

The Production Programmer is an entry-level position within the Marketing Technology department at DataLab USA, focusing on learning fundamental skills and applying them to existing processes. The role involves executing, monitoring, and quality checking existing ETL, reporting, and campaign processes, contributing to the team's success while developing an understanding of DataLab's solutions and their impact on client goals.

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
• 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

Requirements

• Bachelor's degree in a STEM field required
• Ability to learn SQL
• Familiar with Microsoft Outlook, Word and Excel

Nice-to-haves

• Direct Marketing experience or knowledge
• Certifications/Technical training are a plus

Benefits

• Hybrid work consideration after 6 months
• Equal opportunity employer
• Background check and drug test required for employment