Pl sql developer • burlington on
Rebuild entire pipeline in Power Query (M language) on Power BI Fabric (gen2 dataflows, lakehouses).Implement resilient source switching (seamless failover if semi-automated exports fail).Simplify ... Show more
Location: Ontario, Canada (Onsite).IT, with a broad exposure to different platforms and technologies.SQL Coding and querying skills.UNIX scripting, FTP and basic network principles.Experience in pr... Show more
L3Harris is dedicated to recruiting and developing high-performing talent who are passionate about what they do.Our employees are unified in a shared dedication to our customers’ mission and quest ... Show more
Eramosa, a CIMA+ Company, is a vibrant, growing consulting engineering firm with offices in Guelph, Calgary, Toronto, and London dedicated to developing long-lasting relationships with our clients ... Show more
Note: This job posting is to fill an existing vacancy.Hamilton-Niagara's Top Employers.Canada's Top Employer for Young People.We’re looking for people who are driven by excellence to work with inno... Show more
Montreal, QC; Brossard, QC; Burlington, ON; Calgary, AB; Edmonton, AB; Fredericton, NB; Halifax, NS; Kitchener, ON; Laval, QC; Moncton, NB; Ottawa, ON; Quebec City, QC; Regina, SK; Saint John, NB; ... Show more
At Ornge, we believe that ordinary people can do extraordinary things.Each day, we connect communities with critical care across Ontario, Canada.In the air and by land, our teams deliver equity in ... Show more
Location: Burlington, Canada (Hybrid - 3 days per week in the office, 2 days remote).Work on ProjectWise, a leading infrastructure project delivery platform used on some of the world’s most complex... Show more
Trevor Frances Recruitment is supporting a client in the search for a Senior Full Stack Developer.This role is suited for an experienced developer who brings strong technical expertise across both ... Show more
For more than a century Ottobock has pursued the mission of helping people living with limb loss or mobility challenges regain or maintain their freedom of movement.We do this through the developme... Show more
This is a critical role for JSG and will support our US and Canadian operation.The System Engineer will report to our CIO and can be in our HQ in Westmont, IL or in Burlington, ON.System Engineer O... Show more
Location: Burlington, Canada (Hybrid - 3 days per week in the office, 2 days remote).Work on ProjectWise, a leading infrastructure project delivery platform used on some of the world’s most complex... Show more
Senior Full Stack Security Developer.Join our innovative PayEdge Technology team at RBC, where we're building the security foundation for accounts payable and accounts receivable solutions.As a Ful... Show more
Our client is in financial services industry.They are looking for a Senior IT Auditor to join their team!.IT team works in an agile fashion.Opportunity to work across IT, data analytics, AI, and b... Show more
Civil 3D BIM Content Developer.Aviation, Highways and Roads, Rail and Transit, Bridges and Tunnels, Ports and Harbours projects.This role is responsible for creating, managing, and maintaining a hi... Show more
At Deloitte, our Purpose is to make an impact that matters.We exist to inspire and help our people, organizations, communities, and countries to thrive by building a better future.Our work underpin... Show more
Senior Full Stack Security Developer.Join our innovative PayEdge Technology team at RBC, where we're building the security foundation for accounts payable and accounts receivable solutions.As a Ful... Show more
We are seeking a pragmatic and highly skilled HR Data Engineer to lead a critical technical migration within our People Analytics ecosystem.Reporting to the Location Operational Services (LOS) Mana... Show more
Rebuild entire pipeline in Power Query (M language) on Power BI Fabric (gen2 dataflows, lakehouses)
Implement resilient source switching (seamless failover if semi-automated exports fail)
Simplify and document logic for non-technical maintainers
Parallel development (current solution remains operational during migration)
Core Tasks
Reverse-engineer legacy Access macros, VBA, SQL, Python to extract business logic
Design and build Power Query dataflows replicating/improving existing transformations
Implement data quality validation ensuring migrated solution matches legacy outputs
Configure multi-source ingestion with upstream failure handling
Document transformations (data dictionaries, process maps, logic documentation)
What you must have:
SQL (Intermediate): Write/optimize joins, aggregations, subqueries, CTEs; reverse-engineer complex queries; translate SQL logic to Power Query.
Python (Intermediate): Read/understand pandas data manipulation scripts; interpret existing Python ETL workflows. Does not need to write production Python.
Power Query (M Language - Foundational): Minimum awareness with willingness to learn quickly under guidance. Strong SQL background enables effective on-the-job learning. Must commit to building exclusively in Power Query (no SQL/Python/Access) for long-term maintainability.
Data Modeling (Strong Dimensional Modeling): Deep star schema understanding; experience with slowly changing dimensions, bridge tables, role-playing dimensions; design models optimized for Power BI/DAX.
Power BI Fabric (Required): Hands-on experience with Fabric workspaces, gen2 dataflows, lakehouses. Understanding Fabric-specific features and differences from gen1 environments. Non-negotiable for 2-month delivery timeline.
Microsoft Access (Reverse-Engineering): Navigate/interpret Access databases (tables, queries, macros); understand Access design patterns; extract business logic for migration (no need to build new Access solutions).
SharePoint (Data Storage/File-Based ETL): Experience using SharePoint as analytics data layer; comfortable with file-based workflows (Excel export ingestion, file path dependencies, refresh schedules).
Data Quality & Documentation: Strong validation/reconciliation instincts; commitment to clear, accessible documentation for non-technical audiences.
Salary/Rate Range: $100 to $120/hr T4
Thank you for your interest in this opportunity. If you are selected to move forward in the process, we will contact you directly. If you do not hear from us, we encourage you to continue visiting our website for other roles that may be a good fit.
){kind=logo}
