SQL & Data Warehouse Developer

Datalab USA; Town of Germantown (WI); On-site; USD 80,000 - 100,000; Full time

Benefits offered by this job

Health, Dental, and Vision Plans

Employee Assistance Program (EAP)

401(k) Retirement Savings Plan

Paid Time Off

Company Holidays

Job summary

DataLab USA is seeking a data systems professional to develop database solutions supporting client objectives through data analysis, modeling, and management. You will build production scripts, data warehousing metadata, ETL feeds, and automated reporting within DataLab’s Marketing Technology team.

The ideal candidate has a STEM bachelor’s, 2–3 years of experience, strong SQL, and proficiency with Microsoft Office, plus the ability to translate high-level instructions into executable processes

Qualifications

• Bachelor’s degree in a STEM field.
• 2–3 years of relevant work experience.
• Strong SQL skills.
• Proficiency with Microsoft Office (Excel, Word, Outlook).
• Ability to translate high-level instructions into an executable process flow.
• Structured programming skills, including object-oriented design knowledge (C++ or Python).
• Direct marketing experience or knowledge is a plus.
• Strong attention to detail with solid documentation and organizational skills.
• Self-motivated with strong interpersonal skills and ability to work in a team.

Responsibilities

• Develop production scripts, tables, stored procedures, views and functions.
• Develop quality control for production/campaign tasks.
• Develop automated reporting.
• Set up data warehousing metadata.
• Set up new ETL feeds and QC as needed.
• Build initial data utilization routines.
• Execute and maintain campaign universe preparation and suppression update, campaign selection, and campaign creative assignment scripts.
• Understand the technical environment and data available within DataLab.
• Understand account’s business objectives, terminology and business requirements.
• Understand DataLab’s hygiene and matching process for data.
• Ad hoc code review, DB data audit, log audit, process replication, report generation, data extracts.
• Create process overviews, process flows, run notes and code notes.
• Proactively identify owned production processes that need enhancement.
• Troubleshoot production processes.

Skills

SQL

Interpersonal skills

Documentation

Teamwork

Problem solving

Education

Bachelor’s degree in STEM

Tools

Microsoft Office

C++/Python

Job description

DataLab USA is seeking a data systems professional to develop database solutions supporting client objectives through data analysis, modeling, and management. You will build production scripts, data warehousing metadata, ETL feeds, and automated reporting within DataLab’s Marketing Technology team.

The ideal candidate has a STEM bachelor’s, 2–3 years of experience, strong SQL, and proficiency with Microsoft Office, plus the ability to translate high-level instructions into executable processes