Data Warehouse Architect
- Toronto, ON, Canada
Applications open in a new tab.
Job details
- Posting language
- English
- Posted
Original job description
Company Description
SCT resources have a broad range of skills in different technologies. The large skill-set has been made possible by a conscious focus on strengthening our skills base. Every person selected for our team brings something new, something that adds to our offerings. We learn continuously, both on the job and through formal training programs.
Job Description
Company: SystemCanada | www.systemcanada.com
World wide office: Canada - USA - Australia - UK - South Africa - New Zealand - Ireland - Japan
Job Description
- Develop and maintain logical database designs across multiple projects for a very large corporate EDW initiative using ERWin
- Be responsible for packing and release of all database changes across all environments
- Work with all development teams on performance issues and tuning
- Communicate frequently with both functional and technical team members to fully understand and validate requirements and resolve conflict
- Work with the business analyst, ETL and Cognos Development teams to fully understand the requirements and design / support the logical and physical data models
- Develop and maintain physical database design and implementation including tuning required for performance of query and data movement operations
More about this job
Responsibilities
The Data Warehouse Architect at SystemCanada will design and maintain database structures for a large data warehouse project, release database changes, and tune performance. The role works closely with business, ETL and reporting teams to clarify requirements.
Requirements
Candidates need experience designing logical and physical data models for data warehouses, using ERWin and understanding ETL and Cognos reporting. Strong communication skills for working with functional and technical teams are needed.
Skills
- ERWin
- Data Modeling
- Logical Database Design
- Physical Database Design
- Database Performance Tuning
- Query Optimization
- ETL
- Cognos
- Database Change Release Management
- Requirements Analysis
- Cross-team Communication
- Data Warehousing
Categories
- Technology
- Data & Analytics
- Software
Keywords
- Data Warehouse Architect
- Data Warehouse
- EDW
- Enterprise Data Warehouse
- ERWin
- Data Modeling
- Logical Data Model
- Physical Data Model
- ETL
- Cognos
- Database Design
- Database Performance Tuning
- Database Architect
- Database Administrator
- Data Architecture
- SQL
- Database Release Management
- Business Intelligence
Tools
- ERWin
- Cognos
Languages
- English