Job Location : Madison,WI, USA
data warehouse developer iii.
madison , wisconsin
posted today
job details
summary
$63 - $68 per hour
contract
bachelor degree
category computer and mathematical occupations
reference1075311
job details
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.
location: MADISON, Wisconsin
job type: Contract
salary: $63 - 68 per hour
work hours: 8am to 5pm
education: Bachelors
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.
Required:
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 development, maintenance, and auditing/logging
Preferred:
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., Snowflake, Redshift)
Experience with data virtualization platform (e.g., Denodo)
Clear & effective written and verbal communication
Education:
qualifications:
Experience level: Experienced
Minimum 5 years of experience
Education: Bachelors
skills:
Data Warehouse
ETL
Data WarehouseEqual Opportunity Employer: Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other legally protected group status.At Randstad Digital, we welcome people of all abilities and want to ensure that our hiring and interview process meets the needs of all applicants. If you require a reasonable accommodation to make your application or interview experience a great one, please contact [email protected] offered to a successful candidate will be based on several factors including the candidate's education, work experience, work location, specific job duties, certifications, etc. In addition, Randstad Digital offers a comprehensive benefits package, including health, an incentive and recognition program, and 401K contribution (all benefits are based on eligibility).This posting is open for thirty (30) days.