Description
Responsibilities
- Design, implement, and support enterprise database solutions, data models, and data architecture frameworks.
- Develop and document enterprise database architectures, including legacy and "as-built" environments.
- Design and implement SQL databases, data warehouses, and data integration solutions.
- Perform threat and risk assessments and recommend mitigation strategies.
- Apply enterprise architecture principles, standards, and best practices.
- Provide technical leadership, solution planning, estimation, and stakeholder presentations.
- Support Agile application development projects and cloud-based data initiatives.
- Develop and optimize database queries using Transact-SQL (T-SQL).
- Utilize data modeling tools such as PowerDesigner, ER/Studio, ERwin, BPwin, or Rational Rose.
- Support Business Intelligence and reporting solutions using Cognos, Power BI, SQL Server Services, or MicroStrategy.
Qualifications
- Extensive experience as a Data Architect in large enterprise environments.
- Strong experience with SQL databases, data warehousing, and enterprise data architecture.
- Experience with cloud computing, big data platforms, and data governance.
- Knowledge of enterprise architecture frameworks and methodologies.
- TOGAF certification is an asset
Education
Bachelor's degree
Data Architect Job - Edmonton, AB, Canada (Pride Global)