cover image
Avanciers Inc.

Data Architect/Modeler – Senior

On site

Toronto, Canada

Senior

Freelance

22-01-2026

Share this job:

Skills

SQL SAP DevOps Azure DevOps Decision-making Architecture Data Architecture Enterprise Architecture power bi SQL Server Azure Analytics PL/SQL Artificial Intelligence Databricks Microsoft Azure

Job Specifications

Avanciers Incorporated is hiring a Data Architect/Modeler – Senior for one of our clients.

Job Title: Data Architect/Modeler - Senior

Job Location: Toronto, ON - Onsite

Employment Type: Contract

Duration: 6 months

This is an active job and application deadline is January 30, 2026

(This posting may close earlier if a suitable candidate is found)

Job description:

Data Architecture & Modeling: 10+ years of experience designing enterprise data warehouse and data lake solutions using dimensional and Delta Lake concepts, with strong expertise in data modeling, enterprise data models, data dictionaries, and performance optimization on the Microsoft Azure stack (Azure Data Lake, Databricks, SQL, ADF, Power BI).
Business & Analytical Enablement: Partner with business stakeholders to translate business questions into scalable data models and analytics solutions, expanding documentation of business processes and data assets to enable reporting, insights, and operational decision-making.
Technical Delivery & Optimization: Design and communicate complex technical solutions into executable development work packages; develop and tune SQL (stored procedures, datamarts, reporting) across MS SQL Server and Oracle (PL/SQL), ensuring performance, security, and scalability of BI applications.
Tools, Platforms & Collaboration: Hands-on experience with BI and data modeling tools (Power BI, SAP PowerDesigner, Visio), Azure DevOps, ETL concepts, and collaboration with integration and architecture teams; familiarity with enterprise architecture frameworks and COTS solutions (e.g., Curam) is a plus.

Artificial Intelligence (AI) Disclosure

We use AI-enabled tools to assist in screening applications based on job-related criteria.

Our Commitment to Diversity and Inclusion

Avanciers Incorporated is an equal opportunity employer committed to creating an inclusive and accessible workplace. We welcome applications from all qualified individuals regardless of race, color, religion, sex, sexual orientation, gender identity, national origin, disability, age, or any other protected characteristic. We are committed to providing accessible employment practices that comply with the Accessibility for Ontarians with Disabilities Act (AODA).

Important Information for Applicants

Only candidates selected for an interview will be contacted
Proof of qualifications may be requested
Background checks may be conducted as part of the hiring process
Avanciers Incorporated does not use Canadian Social Insurance Numbers (SIN) during the application process

Avanciers Incorporated thanks all applicants for their interest; however, only those selected for an interview will be contacted.

Avanciers Incorporated

www.avanciers.com

About the Company

At Avanciers, we drive business transformation by delivering exceptional talent solutions and cutting-edge technology services. Since 2015, we've been a trusted partner to enterprises across North America and beyond, offering impactful services in Staffing, Salesforce Consulting, Google Cloud Solutions, UI/UX Design, and Web Development. As a woman-owned, diversity-driven organization and a certified Salesforce and Google Cloud Partner, our mission is to empower companies to scale, innovate, and deliver results faster. We d... Know more