drjobs Data Warehouse Developer III

Data Warehouse Developer III

Employer Active

1 Vacancy
drjobs

Job Alert

You will be updated with latest job alerts via email
Valid email field required
Send jobs
Send me jobs like this
drjobs

Job Alert

You will be updated with latest job alerts via email

Valid email field required
Send jobs
Job Location drjobs

Madison, WI - USA

Monthly Salary drjobs

Not Disclosed

drjobs

Salary Not Disclosed

Vacancy

1 Vacancy

Job Description

Candidates MUST be WI residents or willing to relocate to WI at their own expense prior to starting. This position can work 100% remotely (within the state of WI).

Qualifications:

    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 UWMadison 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.

    Required:

    • Experience in multisystem 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:

    • Associates or Bachelors Degree preferred.

    Required Skills : ETLData Warehouse

    Basic Qualification :

    Additional Skills : Data ModelerData Warehouse Engineer

    This is a high PRIORITY requisition. This is a PROACTIVE requisition

    Background Check : No

    Drug Screen : No

    Employment Type

    Full Time

    Company Industry

    About Company

    Report This Job
    Disclaimer: Drjobpro.com is only a platform that connects job seekers and employers. Applicants are advised to conduct their own independent research into the credentials of the prospective employer.We always make certain that our clients do not endorse any request for money payments, thus we advise against sharing any personal or bank-related information with any third party. If you suspect fraud or malpractice, please contact us via contact us page.