Technology

Data Warehouse Developer

Adva IT Services, Inc..Madison, WI🇺🇸United States

Why this role stands out

Advance your career at Adva IT Services, Inc. as a Data Warehouse Developer, where you will tackle complex data challenges while enjoying the perfect balance of professional growth and hybrid work flexibility. This role is ideal for a collaborative expert who thrives on mentoring others and mastering advanced ETL processes within a high-impact, innovative team environment. Apply today to elevate your technical expertise and make a significant contribution to cutting-edge data solutions.

Quick overview

SeniorityMid Senior

Work modeHybrid

LocationMadison, WI, United States

SQLSQL ServerETL

Job description

Data Warehouse Developer

Introduction:

The Data Warehouse Developer will be responsible for gathering requirements, developing technical specifications, and designing ETL jobs using various tools. They will work on loading data warehouses, implementing change data capture, testing and debugging ETL processes, and managing multiple ETL tools.

Responsibilities:

Gathering requirements and developing technical specifications for ETL - 6 years
Designing ETL jobs using ETL tools (preferably with 2 years of experience with Alteryx)
Developing various types of data loads (e.g. incremental, history/full, survivorship rules) - 6 years
Implementing change data capture (CDC) - 4 years
Testing and debugging ETL processes - 6 years
Developing complex SQL - 6 years
ETL job scheduling - 2 years
Loading data warehouses using ETL tools (preferably with SQL Server) - 2 years
Data integration for invoicing, billing, or payment systems - 2 years preferred
Management of multiple ETL tools
Experience with data quality tools and frameworks
Using source code version control software (GitHub preferred)
Mentoring others on ETL development
Managing multiple, concurrent projects and tasks
Strong interpersonal skills including communication, mentoring, collaborating, and team building