Data Solutions Architect

Carbon60; Toronto; Remote; CAD 170,000 - 180,000; Full time

Benefits offered by this job

Remote-first work environment

Flexible work hours and locations

Employer-paid health & dental premiums

$500 Health Care Spending Account (CAD

Job summary

OpsGuru, a Carbon60 Company, is a global engineering and consulting group delivering data-driven digital transformations. We assemble small, highly skilled virtual teams to guide clients and deliver trusted data platforms.

As a Data Solutions Architect, you will lead deep technical guidance for Data Engineers and uphold project goals with senior consultants. You will architect end-to-end data solutions on Microsoft Fabric, manage governance with Purview, and drive CI/CD practices in the Azure

Qualifications

• 7+ years of experience in data/solutions architecture with hands-on delivery (Azure preferred).
• Deep, practical expertise in Microsoft Fabric—Lakehouse, Warehouse, Pipelines, Notebooks, OneLake.
• Strong proficiency across the Azure data stack: ADF, Synapse, Databricks, ADLS Gen2, Azure SQL.
• Proficient in Python and/or Spark (PySpark) for data transformation and SQL for analytics.
• Hands-on experience with Microsoft Purview for data cataloguing, lineage, governance enforcement.
• Experience building data pipelines and ETL/ELT tasks, with data quality practices.

Responsibilities

• Architect end-to-end data solutions on Microsoft Fabric, including Lakehouse, Data Warehouse, Real-Time Intelligence, and Data Factory components.
• Lead design sessions and produce architecture artefacts: designs, data flow diagrams, runbooks.
• Build and optimize data pipelines using Azure Data Factory and Fabric workloads.
• Define and enforce data governance policies, lineage, and access controls with Purview.
• Implement data lineage, quality rules, monitoring, and remediation across data layers.
• Collaborate with product owners and engineers to translate requirements into scalable designs.
• Mentor engineering teams and contribute to internal standards and accelerators.

Skills

Data architecture

Azure data stack

Microsoft Fabric

Python/PySpark

SQL

Data governance

CI/CD & DevOps in data space

Tools

Microsoft Fabric

Azure Data Factory

Azure Synapse Analytics

Databricks

Purview

OneLake

SQL databases

Job description

OpsGuru, a Carbon60 Company, is a global engineering and consulting group that helps organizations accelerate digital transformation through cutting-edge technology, deep engineering expertise, and outcome-driven solutions.

About the role:

OpsGuru's value to our customers centres around our ability to provide deep technical guidance based on their business needs. We achieve this by assigning small, virtual teams of highly skilled individuals to each client.

Within these teams, the Data Solutions Architect is responsible for providing technical expertise and leadership to Data Engineers, while also maintaining a systems view that is able to reconcile technical decisions with broader project goals.

Data Solutions Architects work alongside our Principal Consultants to ensure our project deliverables meet stakeholders' needs while upholding OpsGuru's quality and operational maturity standards.

What you'll be doing:

Project Delivery

• Provide deep technical expertise and leadership across a range of cloud data technologies. You will be the go-to person for driving tool selection, resolving complex engineering issues, and guiding best practices during engagements.

• Lead the design and implementation of data platforms to meet customers' business requirements.

• Lead whiteboard design sessions with internal and external team members.

• Identify and communicate technical risks as they emerge over the course of a project.

• Work closely with Principal Consultants to extract project requirements during technical discovery sessions, define deliverables to meet those requirements, and break down those deliverables into a technical roadmap.

• Lead teams of data engineers to execute project roadmaps. Provide guidance on technical tasks, priorities, and technical assistance when needed.

• Manage scope within customer engagements. Identify changing requirements as they arise, determine their impact on scope, and ensure all stakeholders are aware and agree with the changes.

• Maintain a close working relationship with the customer, as a "Trusted Advisor". Set clear expectations, challenge assumptions, solicit feedback, and take ownership of project deliverables.

• Establishing credibility and building impactful relationships with our customers

Design and Delivery

• • Architect end-to-end data solutions on Microsoft Fabric, including Lakehouse, Data Warehouse, Real-Time Intelligence, and Data Factory components

• • Lead technical design sessions and produce architecture artefacts: solution designs, data flow diagrams, and runbooks

• • Build and optimize data pipelines using Azure Data Factory and Fabric Data Engineering workloads

• • Define and enforce data governance frameworks — policies, stewardship models, and access controls — leveraging Microsoft Purview

• • Implement data lineage tracking end-to-end, ensuring full auditability across ingestion, transformation, and consumption layers

• • Establish data quality rules, monitoring, and remediation processes across OneLake and downstream analytics layers

• • Collaborate with data product owners, engineers, and business stakeholders to translate requirements into scalable platform designs

• • Champion best practices for CI/CD, infrastructure-as-code (Bicep / Terraform), and DevOps within the Azure data space

• • Provide technical mentorship to engineering teams and contribute to internal standards and reusable accelerators

Your skills & experience:

Technical:

• 7+ years of experience in data or solutions architecture roles with hands-on delivery (not purely advisory) (Azure preferred).

• Deep, practical expertise in Microsoft Fabric — Lakehouse, Warehouse, Pipelines, Notebooks, and OneLake

• Strong proficiency across the Azure data stack: ADF, Synapse Analytics, Azure Databricks, ADLS Gen2, Azure SQL

• Proficiency in Python and/or Spark (PySpark) for data transformation, and SQL for analytical workloads

• Hands-on experience with Microsoft Purview for data cataloguing, lineage, classification, and governance policy enforcement

• Proven ability to implement data quality frameworks (expectations, anomaly detection, lineage-aware testing)

• Experience building complex data engineering pipelines and ETL/ELT tasks

• Experience with relational databases (for example Oracle, SQL Server, MySQL, Postgres, MariaDB) or managed cloud RDBMS services (such as Amazon Aurora)

• Experience with NoSQL databases such as MongoDB, Cassandra, CouchDB, ElasticSearch, Neo4j, DynamoDB, BigTable, etc.

• Experience building batch processing and real-time processing systems.

• Experience building Data Warehouses, Data Lakes, and unified analytics platforms (leveraging tools like Microsoft Fabric, Snowflake, or Databricks).

• Nice to Have: Purview, Foundry

Experience with 3+ of the following:

• - Building real-time streaming solutions leveraging technologies such as: Kafka, Kinesis, Pub/Sub messaging, event buses, or Spark Streaming

• - Designing and implementing analytics and BI solutions such as MicroStrategy, Tibco, Qlikview, or Tableau

• - Building AI/ML solutions, including operations such as ongoing training, optimizations, and model deployments.

• - Designing, implementing, training, and optimizing ML and AI models

• - Building solutions leveraging caching systems (for example Redis) and object stores (for example Amazon S3, Amazon Glacier, etc.)

Consulting:

• Proven ability to discuss and design solutions using concepts such as data lineage, data quality gates, data anonymization, data governance, data security, data replication, data caching, data lifecycle management, data catalogs, and networking

• Understanding of requirements and impacts from compliance frameworks such as HIPAA, PCI, GDPR, PIPEDA, etc.

• Strong communication and presentation skills, written and verbal

• Experience writing technical documentation

• Experience in technical mentoring

• Experience working in a customer-facing delivery role in a consulting or professional services environment

What's in it for you:

Compensation & Perks

• Competitive compensation package (CAD 170K-180K / year)

• Retirement Savings Matching Program (RRSP)

• Partnership with Perkopolis Discounts

Flexibility & Time Off

• Remote first work environment

• Flexible work hours & location

• Paid parental leave options

Health & Wellness

• Employer-paid health & dental premiums

• GreenShield+ Counselling Mental Health

• $500 in Health Care Spending Account annually

Growth & Development

• Training reimbursement (e.g courses on Udemy, Coursera, a-cloud-guru etc.)

• Peer recognition rewards

At OpsGuru, a Carbon60 Company, we encourage employees to bring their whole, authentic selves to work. By sharing and embracing unique backgrounds, experiences, and perspectives, we learn from each other, innovate, and create a dynamic environment where we can be and achieve our best.

We're dedicated to ensuring each member feels a sense of belonging, safety, and respect. At OpsGuru, your unique voice is heard and embraced, and you meaningfully contribute to decision-making and the organization's growth.

OpsGuru is committed to an equitable employee experience, opportunity, and support.

If you require accommodations or support during the recruitment process, please email us at [e-mail].

We thank all applicants for their interest in this exciting opportunity. Only candidates that meet the qualifications will be contacted for an interview.