Overview We are seeking a highly skilled Fabric Architect to design, implement, and optimize data architecture and pipelines across the Microsoft Fabric ecosystem. This role requires a strategic thinker with deep technical expertise in data modeling, ingestion frameworks, and environment configuration. You will play a key role in building a robust data platform from source ingestion through to curated, high-value datasets, enabling actionable insights and scalable analytics. This is a hands-on architecture role that balances technical design with implementation, governance, and performance optimization.

Location: Across Canada & USA

Status: Contract or Full-Time

Responsibilities

• Workspace Design & Governance

• Define and implement workspace design and naming standards in Microsoft Fabric

• Set up and manage separate Fabric workspaces for Development, QA/Test, and Production environments

• Infrastructure & Integration

• Support the installation and configuration of the Fabric Gateway on on-premise virtual machines to enable secure hybrid data connectivity

• Data Architecture

• Design and implement the Gold Layer data model within Microsoft Fabric, including:

• 1 comprehensive Data Mart

• 1 Fact Table (up to 15 attributes)

• Up to 5 related Dimension Tables

• Develop and maintain a Source-to-Target Mapping Document to ensure traceability and lineage

• Data Engineering & Pipelines

• Implement a reusable, scalable data ingestion framework for the Bronze Layer

• Ingest data from up to 15 diverse source tables (average 15 attributes each) into the Bronze Layer

• Design and implement Bronze-to-Silver pipelines using primary key-based merging for consistency across all 15 tables

• Build transformation logic to process Silver Layer data into the Gold Layer, optimizing for analytics consumption

Qualifications, Skills & Experience

• Proven experience architecting and implementing solutions on Microsoft Fabric
• Strong understanding of data lakehouse architecture principles (Bronze/Silver/Gold layers)
• Proficiency in Data Factory, Dataflows, Pipelines, and Power Query (M) and T-SQL/DAX
• Hands-on experience with data modeling, including fact and dimension design
• Demonstrated expertise in building source-to-target mappings, ETL/ELT processes, and pipeline orchestration
• Familiarity with hybrid connectivity setups, including on-premise gateway installation and configuration
• Experience in setting up and managing multi-environment workspaces with deployment and naming standards
• Strong problem-solving skills with attention to data quality, performance, and reusability
• Excellent communication and documentation abilities

Nice To Have

• Experience with DevOps practices in Fabric or Azure Data tools (CI/CD, workspace deployment pipelines)
• Familiarity with Row-Level Security (RLS) and other data governance practices
• Exposure to Dataverse, Azure Data Lake, or other cloud-native data sources
• Previous experience working in regulated or enterprise environments with strict data handling policies

About Adastra For more than 25 years, Adastra Corporation has been hyper-focused on data and the infrastructures to support it. We are an international consulting company working with businesses and IT Leaders to extract value through data and analytic solutions in the domains of Cloud, Data Management, Analytics, AI and ML, Governance, Hyper Automation, and Enterprise Application Development. Our team of experts, combined with our worldclass data management platform, helps provide trusted insights, establish frameworks, enforce best practices, and streamline processes for around-the-clock global coverage. Adastra has a proven track record of helping organizations of all sizes – from SMEs to Fortune 1000s – achieve their data transformation goals, whether that be accelerating innovation, improving operational excellence, or creating unforgettable customer experiences.

What We Offer

• Opportunity for advancement and career progression
• Competitive compensation package
• Comprehensive benefits plan
• Successful referral program
• Satisfaction of working for a reputable company
• A flexible, dynamic, and diverse workplace

Equal Opportunity Employer In our commitment to promote fair and equitable treatment of all employees and applicants, Adastra Corporation provides equal employment opportunities for all individuals regardless of age, sex, disability, race, ethnic origin, citizenship, creed, sexual orientation, marital status, or any other ground as described in the Ontario Human Rights Code. In addition, accommodation will be provided during the hiring process. Adastra Corporation’s implementation and support of employment initiatives, encourage diversified labour force participation and equal access to opportunities based on merit and performance

There has been an increased instance of fraudulent job offers coming from people posing as Adastra HR employees. Please note that Adastra will never request fees as part of our recruiting process and any emails sent to you that are not from ‘@adastragrp.com’ or ‘@talent.icims.com’ are fraudulent. All employment offers are sent via DocuSign and if you receive an employment offer from a suspicious email and not via DocuSign, it is fraudulent.

Contact careers@adastragrp.com to inquire about jobs at Adastra, to report a suspicious request for money or personal information from external websites or suspicious employment offers.