ETL Data Warehouse Developer
ETL Data Warehouse Developer
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
Job Description
Description:
Our client is looking for an ETL Data Warehouse Developer. The Data Warehouse Developer will assist in the initial setup configuration and modeling of a new data warehouse in Redshift or Snowflake. The person in this role will work closely with the clients data warehouse team BI developers software engineers and external partners to build a new academic and administrative data warehouse (AADW). The Data Warehouse Developer will report to the Director for Data Analytics.
Tasks
- 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.
Knowledge Skills and Abilities Required:
- Clear & effective written and verbal communication
Skills Required
- 5 years Experience in multisystem data integration
- 5 years Experience with data integration through extract transform load (ETL) & ELT patterns
- 5 years Experience with data modeling and relational database design
- 5 years Experience with data warehouse architecture maintenance and auditing/logging
Skills Desired
- 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 platform (e.g. Denodo)
- Associates or Bachelors Degree (Please include on your resume)
Employment Type
Full Time
