The duties and responsibilities of the DataOps Engineer include but are not limited to:

We are currently seeking a full-time permanent DataOps Engineer to join our Technology team.

As a DataOps Engineer, you will design, build, automate, and operate the firm's modern cloud data platform. You will be responsible for delivering secure, scalable, and reliable data services that enable business intelligence, advanced analytics, machine learning, and application development across the organization.

Rather than focusing solely on database administration, this role emphasizes platform engineering, observability, and DevOps practices. You will work closely with software engineers, DevOps engineers, and business stakeholders to deliver self-service data capabilities while ensuring high standards of security, governance, and operational excellence.

The duties and responsibilities of the DataOps Engineer include but are not limited to:

Cloud Data Platform Engineering

Design, implement, and maintain cloud-native data platforms supporting structured, semi-structured, and streaming data.

Build scalable Lakehouse and data warehouse architectures.

Develop reusable platform services for ingestion, transformation, storage, and consumption.

Standardize data infrastructure across development, QA, and production environments.

DataOps & Platform Automation

Build CI/CD pipelines for databases, data pipelines, and infrastructure.

Automate provisioning, deployment, testing, and rollback.

Automate non-production database seeding with sanitized production data.

Develop automated validation and quality checks.

Data Engineering

Build reliable ETL/ELT pipelines.

Integrate data from databases, APIs, SaaS platforms, event streams, and cloud storage.

Design CDC and incremental loading strategies.

Optimize data movement for performance, reliability, and cost.

Database Engineering

Design logical and physical data models.

Optimize SQL performance and indexing.

Configure high availability and disaster recovery.

Monitor platform health and resolve bottlenecks.

Observability & Reliability

Implement monitoring, alerting, and centralized logging.

Define SLAs and reliability metrics.

Perform root cause analysis and continuous improvement.

Platform Enablement

Build reusable templates and engineering standards.

Create documentation and operational runbooks.

Mentor engineers and analysts on platform best practices.

Research & Innovation

Evaluate Microsoft Fabric,



Azure data services, Lakehouse architecture, streaming platforms, vector databases, and AI-ready platforms.

Cloud
Desired Technical Skills

Azure SQL

Azure Storage

Azure Data Factory

Microsoft Fabric

Azure Synapse

Azure Functions

Azure Event Hubs

Azure Key Vault

Azure Monitor

Databases

SQL Server

Azure SQL

PostgreSQL

Snowflake

Databricks SQL

Programming

Python

PowerShell

C#

SQL

Bash

Automation

Terraform

Git

GitHub Actions

Azure DevOps Pipelines

Containers

Docker

Kubernetes

Helm

Data Engineering

Spark

Delta Lake

Parquet

CDC

Event-driven architecture

Monitoring

Datadog

Azure Monitor

OpenTelemetry (OTel)

Azure Log Analytics

Critical Competencies

Service Excellence – Delivers reliable, scalable data platforms through strong engineering standards, automation, observability, and continuous improvement.

Attention to Detail – Maintains accuracy across data models, pipelines, infrastructure, workflows, validations, documentation, and runbooks.

Organization & Time Management – Balances platform, pipeline, database, support, and research priorities while coordinating dependencies and meeting timelines.

Technical Proficiency – Applies robust knowledge of cloud data platforms, Lakehouse architectures, ETL/ELT, CDC, database engineering, CI/CD, infrastructure, monitoring, and Azure data services to improve systems and processes.

Problem-Solving & Initiative – Identifies quality issues, bottlenecks, risks, and automation opportunities; resolves root causes with sustainable solutions.

Communication – Clearly communicates requirements, decisions, risks, findings, and recommendations to technical and business stakeholders.

Accountability – Owns platforms, pipelines, databases, deployments, and deliverables through resolution while maintaining reliability, security, performance, cost efficiency, and quality.

Requirements

Bachelor’s degree in computer science, Engineering, Information Systems, or related discipline.

Experience building cloud-native Azure data solutions.





Strong SQL and database performance tuning experience.

Experience implementing Infrastructure as Code and CI/CD.

Experience with Git-based development workflows.

Experience operating production systems with monitoring and alerting.

Excellent troubleshooting and communication skills.

Additional Information

Position Type: Full-Time Permanent

Work Location: Toronto

To learn more about life at RPIA, visit https://rpia.ca/

Read our firm’s magazine, Voices of RPIA: https://online.flippingbook.com/view/859829658/

This is to fill an open vacancy

Artificial Intelligence may be used as part of this recruitment initiative

Compensation Range: $110,000 – $135,000 base salary, additional compensation may be available

RPIA is proud to be Great Place to Work Certified™. What sets us apart?

Exceptional single and family benefits package that includes health, dental and vision insurance plus additional Health Care Spending and Wellness credits.

Employee and Family Assistance Program to support mental wellbeing extended to all family members in your household.

Opportunities for professional and personal growth through:

Cross-functional Mentorship Program

Internally curated Leadership Skills training program

Community outreach and monthly social events organized through our volunteer-led committees.

RPIA is an Equal Opportunity Employer
We believe in the power of diversity of thought, and we aspire to have an inclusive workplace that mirrors the fabric of our community. We strongly encourage applications regardless of race, religion, colour, national origin, gender, sexual orientation, age, marital status, or disability status. We are committed to providing an accessible and equitable application and hiring process and will make accommodations should you require it at any point. We encourage you to connect with us at [email protected] if you require accommodation during the recruitment process.

Our culture is defined by our six core values: Client-First, Innovation, Excellence, Partnership, Integrity, and Giving back. Our clients often say the outstanding service we deliver is as important to them as the returns we achieve for them. With over 135 employees and approximately $21 billion in assets under management for a broad investor base of institutions and private clients, we proudly remain privately owned by employees who invest alongside our clients.

#J-18808-Ljbffr

📌 DataOps Engineer (Ontario)
🏢 RPIA Capital Management
📍 Ontario