Hello Partners,
Data Warehouse Developer III
Madison, WI
6 months
Project Details: We are looking to pursue a short-term engagement (6 months for 30-40 hours a week) to have someone help us with the initial setup, configuration and modeling of a data warehouse in Redshift or Snowflake and work with our internal team to do some initial data transfers to that environment.
Top Skills & Years of Experience:
5+ years of experience in the following
– Experience in multi-system data integration
– Experience with data integration through extract, transform, load (ETL) & ELT patterns
– Experience with data modeling and relational database design
– Experience with data warehouse architecture, maintenance, and auditing/logging
Nice to Have:
– Experience with enterprise data integration tools (e.g., Informatica Intelligent Cloud Services (IICS) Data Integration, Informatica PowerCenter, dbt) preferably IICS Data Integration
– Experience with structured and unstructured data
– Experience with cloud data storage (e.g., Redshift, Snowflake)
– Experience with data virtualization platforms (e.g., Denodo)
– Clear & effective written and verbal communication
Onsite or Remote? Candidate must be a CURRENT WI resident or willing to relocate. 100% remote allowed in the State of Wisconsin.
Full job description:
Job Summary:
The Data Warehouse Developer will assist in the initial setup, configuration and modeling of a new data warehouse in Redshift or Snowflake for the School of Medicine and Public Health. The person in this role will work closely with our data warehouse team, BI developers, software engineers and external partners to build our new academic and administrative data warehouse (AADW) as part of the UW-Madison transition to Workday in July 2025.
The Data Warehouse Developer will report to the Director for Data Analytics.
Responsibilities:
– 50% Perform data warehouse design and testing, including data design, database architecture, metadata, and repository creation
– 30% Design, develop, and maintain relational databases for data storage and data mining.
– 15% Assist internal database team with initial data transfers into new warehouse.
– 5% Seek continuous improvement in performance of data warehouse and ensure security of data.
Education:
Associate’s or Bachelor's Degree preferred.
Submission process format
|
First Name |
|
|
Middle Name |
|
|
Last Name |
|
|
|
|
|
Contact Number |
|
|
Email Address |
|
|
Skype Id / Zoom ID |
|
|
Available Start Date |
|
|
Best time to call you in Working hours |
|
|
Your preferred Interview time Slot |
|
|
Work Authorization |
|
|
Visa expire date |
|
|
Highest Qualification |
|
|
Year of Passing |
|
|
University |
|
|
Comfortable working on Dayone onsite role Yes / No :- |
|
|
Last 4 Digits of SSN |
|
|
Total Years of Experience |
|
|
Total U.S.A. Years of Experience |
|
|
Current Location |
|
|
Willing to Relocate (Yes/No) |
|
|
Passport Number |
|
|
Pay Rate (W2/1099/C2C) |
|
|
Profile Sourced from Vendor/Partner company |
|
|
is Consultant on there W2/1099/H1b |