Senior Data Engineer

Who We Are

PLATO is Canada’s largest Indigenous-owned software testing and technology services company. For nearly 30 years, our expert teams have helped our clients deliver reliable products that users enjoy interacting with.

Our 100% Canada‑based team brings deep experience in QA, software testing, and IT services, along with a shared commitment to collaboration, mentorship, and continuous improvement. We’re a team that shows up for each other, whether that’s tackling complex client challenges or helping colleagues grow through coaching and knowledge‑sharing.

As Canada’s largest Indigenous‑owned software testing company, we’re proud of our roots and our mission to build a stronger, more inclusive technology workforce. At the same time, we warmly welcome applicants of all backgrounds and experiences who are passionate about quality, teamwork, and making an impact.

Summary

The Senior Data Engineer is responsible for designing, developing, and maintaining enterprise data solutions with a focus on Oracle technologies. This role leads the development of data pipelines, ETL processes, and database solutions, while providing technical leadership in Oracle SQL, PL/SQL, and data architecture.

** This role is a contract to Dec 2026 with the possibility of extension. A current Government of Canada Reliability clearance or higher is required.

Work can be done remotely in Canada in the Eastern time zone.

Responsibilities

• Design and deliver scalable Oracle-based data solutions, including XMLType and schema-based structures.

• Develop and maintain ETL processes and data pipelines for data integration, migration, and deployment.

• Create and support Oracle PL/SQL packages, stored procedures, functions, and triggers.

• Collaborate with stakeholders to define data requirements, design relational schemas, and optimize data flows.

• Analyze and optimize Oracle SQL performance through query tuning, execution plan analysis, and indexing strategies.

• Establish and enforce data governance, security, data quality, and validation standards.

• Provide technical leadership, mentorship, and guidance on complex data engineering challenges.

• Evaluate new Oracle features, ETL technologies, and data engineering best practices to support continuous improvement.

Requirements

• Active Reliability Security Clearance or higher.

• 10+ years of experience in data engineering, database development, and data integration.

• Extensive expertise in Oracle SQL, PL/SQL, ETL development, and ETL pipelines, with expert level proficiency .

• Experience with Oracle XMLType, schema-based database structures, and database performance optimization .

• Strong experience developing Oracle PL/SQL packages, procedures, functions, and triggers.

• Experience with SQL tuning, execution plan analysis, and database optimization.

• Strong understanding of data governance, security, data integrity, and data validation practices.

• Strong analytical, problem-solving, communication, and leadership skills.

Work With Us

At PLATO, we believe that great work happens when people feel supported, connected, and challenged in the right ways. You’ll be part of a collaborative environment where experienced professionals share knowledge, mentor others, and contribute to solving complex, real‑world client projects.

We are committed to inclusive hiring practices and encourage applications from individuals of all backgrounds, including women, persons with disabilities, visible minorities, and Indigenous peoples. If you require accommodation at any stage of the recruitment process, we’re here to support you.

PLATO respectfully acknowledges that we operate on treaty territories, unceded First Nations and Inuit territories, and within Métis homelands. We honour the long history of these lands and actively work toward reconciliation between Indigenous and non‑Indigenous peoples on Turtle Island.