Data Engineer

The Data Engineer is responsible for designing, building, and maintaining scalable data platforms and pipelines for RPRA. The position will provide a broad range of data engineering functions including data modeling, data quality, data profiling, data acquisition and ingestion, extract transform load (ETL), metadata enrichment and management, data provenance and lineage, and other specialized data management functions. Practically speaking, you will: Data Solution Development: Design and implement data platforms and warehouses using Microsoft Fabric, ensuring seamless integration with AI functionalities provided by Copilot ETL/ELT Processes: Develop and optimize data pipelines using Azure tools such as Fabrics, and Power BI to support data transformation and integration AI Integration: Leverage Copilot's AI capabilities to automate data preparation, transformation, and analysis tasks, enhancing data engineering workflows Data Governance: Ensure data integrity, quality, and compliance within Microsoft Fabric environments, implementing best practices for data management Performance Optimization: Monitor and enhance the performance of data models, queries, and ETL processes to ensure scalability and efficiency Azure Ecosystem Knowledge: Proficient in Azure services, including Data Factory, Synapse Analytics, and Azure SQL Database, with a solid understanding of data warehousing and modeling concepts AI and Machine Learning Familiarity: Understanding of AI workflows and experience integrating data science capabilities within Microsoft Fabric, utilizing tools like Copilot to enhance data engineering tasks Optimize data workflows, ensuring reliability, scalability, and performance Collaborate with internal stakeholders to understand data needs and deliver tailored solutions Ensure data security and compliance with industry standards and best practices

We are the Resource Productivity and Recovery Authority (RPRA), Ontario's circular economy regulator. Our vision is a circular economy today for a waste-free tomorrow. Our mission is to support compliance with individual producer responsibility through education and enforcement to foster Ontario's circular economy, spur innovation, and protect the environment.