Duties

- Design the data architecture, including the EDW structure, data marts, and conformed dimensions, to support reporting and analytical needs.
- Develop logical and physical data models for the EDW and data marts, ensuring they are optimized for performance and aligned with business processes.
- Plan and oversee the integration of data from various sources into the EDW, designing ETL processes that ensure data quality and consistency.
- Establish data governance policies and practices to manage data access, quality, and security throughout the project.
- Support the development, adoption, and implementation of best practices in data management, which includes data architecture, data sharing, data integration, data quality, common data, and standardized methodologies.
- Lead or assist in communicating activities surrounding the Data architecture.




- Document the data architecture, models, and processes, and ensure knowledge transfer to IT and business teams for ongoing operations and maintenance.
- Contribute to development of data sharing, data integration, data quality, common data and standardized methodologies.
- Participate in design reviews, regular or ad-hoc architectural reviews – ensuring correct interpretation of the data architecture.
- Respond to requests for extensions to the scope of the data architecture, as needed.
- Work with developers and supporting information technology (IT) resources to manage ongoing data assets and process changes, as needed.

📌 GOAPR406 - Data Architect - Intermediate (Canada)
🏢 Omega solutions
📍 Canada