Data Warehouse Developer - Remote

Title: Data Warehouse Developer - Remote

Description:

The client is looking for a Data Warehouse Developer III.

We have an immediate opening for a strong Data Engineer to participate in our Data Management Program.
Data is one of our most valuable assets and we strive to become a more data-literate and data-driven organization.
This position will work on a small, collaborative team that uses agile practices to deliver value to our business partners.

Desired Experience

Using ETL tools to design ETL jobs (ETL 6 years, preferably 2 years of with Alteryx)
Developing various types of data loads (e.g. incremental, history/full, survivorship rules) 6 years
Implementing change data capture (CDC) 4 years
Developing complex SQL - 6 years
Experience with data quality tools and frameworks
Using source code version control software
Mentoring to others on ETL development
Managing multiple, concurrent projects and tasks
Having strong interpersonal skills including communication, mentoring, collaborating, and team building

ETL Technologies :

Alteryx
SSIS
SSRS
SQL Server
Tableau
Semarchy
Git & github

Top Skills & Years of Experience:

Gathering requirements and developing technical specifications for ETL 6 years
Using ETL tools to design ETL jobs (ETL 6 years, MINIMUM 2 years of ETL 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 6 years
Developing complex SQL - 6 years (should be recent experience)
ETL job scheduling 2 years
Loading data warehouses using ETL tools 2 years

Nice to Have:

Management of multiple ETL tools
Experience with data quality tools and frameworks - preferred
Using source code version control software - preferred

Note :

Candidates MUST have Alteryx experience related to ETL, not just Alteryx experience based in data prep.
The client is also looking for candidates with strong and recent SQL skills.
Candidates will be required to complete an SQL exercise when they interview and will need to answer very detailed questions regarding their background with Alteryx.
Open to nationwide candidates.
This position can work 100% remote or in the office.
8:00 AM - 5:00 PM

Mandatory skills:

Data Warehouse,
Data Management Program,
ETL, ETL tools, ETL development,
agile practices, source code version control, change data capture, CDC,
data literate, data driven, data loads, data quality tools, data quality framework,
SQL, SQL Server, Alteryx, SSIS, SSRS, Tableau, Semarchy, Git, github,
Data modeling, Data governance, Data visualization, Data analysis, Data architecture, Data integration, Data transformation,
Develop, Implement, collaboration, communication, testing, debugging, technical specifications

VIVA USA is an equal opportunity employer and is committed to maintaining a professional working environment that is free from discrimination and unlawful harassment. The Management, contractors, and staff of VIVA USA shall respect others without regard to race, sex, religion, age, color, creed, national or ethnic origin, physical, mental or sensory disability, marital status, sexual orientation, or status as a Vietnam-era, recently separated veteran, Active war time or campaign badge veteran, Armed forces service medal veteran, or disabled veteran. Please contact us at for any complaints, comments and suggestions.

Contact Details :

Account co-ordinator: Binodh Thankappan

VIVA USA INC.
3601 Algonquin Road, Suite 425
Rolling Meadows, IL 60008
| ;/p>