Job Summary:
We are seeking an experienced Sr. Data Architect with 12+ years of relevant experience in enterprise data architecture, data modeling, data marts, ETL processes, data integration, and data governance. The ideal candidate will have strong analytical and architectural skills, with experience providing data architecture guidance, developing data models, and supporting data quality and validation initiatives.
Key Responsibilities:
• Review existing data marts and perform detailed profiling of tables supporting facts and dimensions.
• Analyze, develop, and maintain data models, design specifications, and mapping specifications.
• Identify required dimensions for facts, stage data, and update as-is JOIN data models with new fact attributes.
• Develop, test, and troubleshoot ETL processes and address minor fixes in delivered data marts.
• Develop Power BI reports to support testing and validate dimensions, facts, and overall data quality.
• Define, manage, and communicate data architecture principles, strategies, standards, models, and guidelines.
• Provide architectural guidance, lead design reviews and transition planning, support enterprise architecture initiatives, and document lessons learned at project closeout.
Required Qualifications:
• 12+ years of relevant experience.
• Experience designing, managing, and implementing enterprise data architectures.
• Strong knowledge of data modeling, including facts, dimensions, data marts, and relational data structures.
• Experience performing detailed data profiling and identifying data quality issues.
• Hands-on experience developing and testing ETL processes and data integration solutions.
• Ability to create and interpret data models, mapping specifications, and architecture documentation.
• Experience providing data architecture guidance, consulting, and governance support to projects and initiatives.
• Strong analytical, communication, collaboration, and problem-solving skills.
Preferred Qualifications:
• Experience developing Power BI reports for data validation, testing, and analysis.
• Knowledge of enterprise architecture frameworks, information management strategies, and data governance practices.
• Experience working with Government of Alberta Enterprise Architecture or similarly structured public-sector environments.
