DataOps Engineer

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 SQLAzure StorageAzure Data FactoryMicrosoft FabricAzure SynapseAzure FunctionsAzure Event HubsAzure Key VaultAzure Monitor Databases: SQL ServerAzure SQLPostgreSQLSnowflakeDatabricks SQL Programming: PythonPowerShellC#SQLBash Automation: TerraformGitGitHub ActionsAzure DevOps Pipelines Containers: DockerKubernetesHelm Data Engineering: SparkDelta LakeParquetCDCEvent-driven architecture Monitoring: DatadogAzure MonitorOpenTelemetry (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 PermanentWork 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 vacancyArtificial Intelligence may be used as part of this recruitment initiativeCompensation 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 ProgramInternally curated Leadership Skills training programCommunity 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 hr@rpia.ca 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.