Senior Data Architect

Compunnel, Inc.; Edmonton; On-site; CAD 120,000 - 180,000; Full time

Job summary

Compunnel, Inc. is seeking an experienced Sr. Data Architect with 12+ years of experience in enterprise data architecture, data modeling, ETL, and governance. The ideal candidate will guide data architecture, develop data models, and support data quality initiatives.

You will review data marts, design and maintain data models, address data profiling, and develop Power BI reports for testing and validation. Strong analytical, communication, and collaboration skills are essential.

Qualifications

• 12+ years of relevant enterprise data architecture experience.
• Experience designing and implementing enterprise data architectures.
• Strong data modeling knowledge (facts, dimensions, data marts).
• Experience with data profiling and data quality issues.
• Hands-on ETL development and data integration testing.
• Ability to translate models and architecture docs.
• Experience guiding governance and architecture reviews.
• Strong analytical and collaborative problem-solving skills.

Responsibilities

• Review data marts and profile tables supporting facts and dimensions.
• Develop and maintain data models, specifications, mapping specs.
• Identify dimensions for facts and update JOIN data models.
• Develop, test, and troubleshoot ETL processes and data marts.
• Develop Power BI reports to validate dimensions, facts and data quality.
• Define and communicate data architecture principles and standards.
• Provide architectural guidance and document lessons learned.

Skills

Data architecture

Data modeling

ETL development

Data governance

Data integration

Data profiling

Analytical skills

Communication

Tools

Power BI

Job description

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.