Sr Datawarehouse Developer | Optimisation and Upgrade

Summary about this job

Detail information about job Sr Datawarehouse Developer | Optimisation and Upgrade . Terms and conditions vacancy

We're on the hunt for a strong datawarehouse developer to work as a lead on a National Enterprise Data Warehouse Integration Project. 9+ month initial contract with 24 month pipeline of work.

Role Responsibilities:

• Design and implement ETL procedures for intake of data from both internal and outside sources; as well as ensure data is verified and quality is checked
• Requirements analysis, design and implement ETL processes and data architecture to ensure proper functioning of analytics, as well as client’s or third-party’s reporting environments and dashboard
• Collaborate with business and technology stakeholders in ensuring data warehouse architecture development and utilization
• Upgrade of SQL 2016 for compatability with upcoming Enterprise Integration
• Carry out monitoring, tuning, and database performance analysis
• Thorough documentation of all process and procedures associated with design and implementation
• Perform the design and extension of data marts, meta data, and data models

Essential Requirements:

• Minimum 6 years working in a Data Warehouse Development role
• Demonstrated SQL 2016 experience
• SQL Upgrade Experience essential
• Exceptional ETL experience - SSIS
• Demonstrated experience building ETL processes that map data from source systems to target systems utilizing SSIS in an automated manner.
• Strong data modelling experience - Data Vault preferable
• Experience translating database design and diagnosing database performance issues.
• Financial services industry experience an asset

Apply Now; we have already engaged our headhunt campaign!

To Your Success...!