Job Type: Contract (Hourly Billing)

Work Model: Remote / Flexible (As-needed basis / Part-time)

Location: Canada (Preference for candidates able to work within Canadian data compliance requirements)

Data Solutions Consultant to provide on-demand expertise across data architecture, integration, and data quality initiatives. This role will focus on making enterprise data structured, connected, and ready for analytics and AI use cases, supporting multiple business units and evolving priorities.

Key Responsibilities

Data Architecture & Modelling

• Design conceptual, logical, and physical data models
• Normalize and optimize existing data structures
• Align data models with business and regulatory requirements

Data Integration & Systems

• Develop and support ETL/ELT pipelines and API integrations
• Enable system-to-system data connectivity
• Support data virtualization and interoperability initiatives

Data Flow & Mapping

• Document end-to-end data flows across systems
• Identify upstream/downstream dependencies
• Improve data lineage and traceability

Data Quality & Governance

• Identify root causes of data quality issues
• Define data quality rules, metrics, and monitoring frameworks
• Support enterprise data governance initiatives

Data Enablement for Analytics & AI

• Prepare and structure datasets for reporting and AI
• Identify data readiness gaps
• Support advanced analytics initiatives

Deliverables

• Regular status reports (as defined by BCER)
• Monthly invoices with detailed hours worked

Work Model & Engagement

• Flexible, remote engagement
• Work assigned on an as-needed basis
• Planning cycles typically 2-4 weeks in advance

Required Qualifications

• Proven experience in:
• Data Architecture & Data Modelling
• Data Integration (ETL, APIs, system integration)
• Data Quality & Governance
• Strong hands-on experience with:
• Relational Databases (RDBMS)
• Advanced SQL, query optimization, and performance tuning
• Experience delivering end-to-end data solutions
• Strong communication skills to explain technical concepts to stakeholders

Preferred Qualifications

• Experience with Oracle databases (PL/SQL, performance tuning)
• Knowledge of:
• Data virtualization tools
• Version control (Git-based systems)
• Certifications such as:
• TOGAF
• CDMP
• Experience supporting AI/Analytics data pipelines

Core Skills

• Data Architecture
• Data Modelling
• ETL / ELT / API Integration
• Data Quality & Governance
• SQL / RDBMS (Oracle preferred)
• Data Flow Mapping
• Analytics & AI Data Preparation

Recruiter Submission Template

Full Name:

Degree Major with University and Completion Year:

Certifications (TOGAF, CDMP, etc.):

Total experience as Data Solutions Consultant:

Strong Data Architecture & Modelling experience:

ETL / API / Integration expertise:

Data Quality & Governance experience:

Advanced SQL / RDBMS skills:

Experience delivering end-to-end data solutions:

Ability to work on flexible / on-demand basis:

Available for part-time / on-demand work (Y/N):

Availability for 2-4 week planning cycles:

Motivation / Reason for Relocation (if not local):

Motivation / Reason for interest in this position:

Contact Number:

Email ID:

LinkedIn Profile URL:

Full Address (Street, City, State, Zip Code):

Notice Period (in weeks):

Current Work Authorization Status:

Expected Hourly Rates CAD:

Is it Incorporated/Corp-to-Corp or T4/Contract? If Corp, Corporation Name: