Data Architect

Insight Global; City of Langley; On-site; CAD 120,000 - 160,000; Full time

Job summary

Insight Global seeks a Data Architect to modernize its BI and analytics environment, moving from a legacy Microsoft ecosystem toward a scalable architecture leveraging Microsoft Fabric. The role will assess the current state, define the future-state data architecture, and guide data quality, governance, integration, reporting and analytics.

The ideal candidate is hands-on yet strategic, partnering with business stakeholders, technical teams, and external vendors to build a future-ready data

Qualifications

• 7+ years of experience across Data Architecture, Data Engineering, BI, or Analytics.
• Strong experience with SQL Server, ETL/ELT, SSRS/SSIS, and data warehousing.
• Understanding of data architecture and modeling including star schemas and data lineage.
• Experience designing future-state data architectures and modernizing legacy Microsoft BI environments.
• Experience with Microsoft Fabric and cloud or hybrid analytics architectures.
• Knowledge of data quality, governance, reconciliation and KPI standardization.

Responsibilities

• Assess current data environment and define a future-state data architecture.
• Provide guidance across data quality, governance, integration, reporting and analytics.
• Partner with business, technical teams and external vendors to build a scalable data platform.

Skills

Data Architecture

Data Modeling

SQL Server

ETL/ELT

SSRS/SSIS

Data Warehousing

Data Governance

Tableau

Power BI

Microsoft Fabric

Cloud/Hyrid analytics

Vendor management

Tools

Microsoft Fabric

Tableau

Power BI

Job description

Job Description

Insight Global is looking for a Data Architect to help modernize their BI and analytics environment, moving from a legacy Microsoft ecosystem toward a scalable architecture leveraging Microsoft Fabric. This individual will assess the current environment, help define the future-state data architecture, and provide guidance across data quality, governance, integration, reporting, and analytics. The ideal candidate is a hands-on architect who can operate strategically while partnering with business stakeholders, technical teams, and external vendors to build a future-ready data platform.

Skills and Requirements

• 7+ years of experience across Data Architecture, Data Engineering, BI, or Analytics
• Strong experience within the Microsoft data ecosystem, including SQL Server, ETL/ELT, SSRS/SSIS, and data warehousing
• Strong understanding of data architecture and modeling, including star schemas, semantic layers, data lineage, and multiple data layers
• Experience assessing current-state environments and designing scalable future-state data architectures
• Microsoft Fabric experience
• Strong understanding of data quality, governance, reconciliation, KPI standardization, and data integrity
• Experience modernizing legacy Microsoft BI environments
• Experience with cloud or hybrid analytics architecturesTableau or Power BI experience
• Experience working with third-party technology or ERP vendors

We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal employment opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment without regard to race, color, ethnicity, religion, sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military or uniformed service member status, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or the recruiting process, please send a request to [e-mail].