DataOps Engineer

RPIA Capital Management; Toronto; On-site; CAD 110,000 - 135,000; Full time

Benefits offered by this job

Health, dental and vision insurance

Employee Assistance Program

Professional growth programs

Job summary

RPIA Capital Management in Toronto is seeking a DataOps Engineer to design, build, automate, and operate a modern cloud data platform. You will deliver secure, scalable data services supporting business intelligence, analytics, machine learning, and application development across the organization.

This full-time permanent role emphasizes platform engineering, observability, and DevOps practices, collaborating with software engineers and stakeholders to enable self-service data capabilities while

Qualifications

• 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.

Responsibilities

• Design, build, automate, and operate the firm's cloud data platform.
• Develop CI/CD pipelines for databases, data pipelines, and infrastructure.
• Automate provisioning, deployment, testing, and rollback.
• Build reliable ETL/ELT pipelines and integrate data from multiple sources.
• Design logical and physical data models; optimize SQL performance.
• Implement monitoring, alerting, and centralized logging; define SLAs.

Skills

Azure data services

SQL performance tuning

CI/CD

Infrastructure as Code

Git-based workflows

Production systems monitoring

Communication

Education

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

Tools

Azure Data Factory

Azure Synapse

Microsoft Fabric

Terraform

GitHub Actions

Azure DevOps Pipelines

Kubernetes

Job description

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 strong 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 [e-mail] 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.