Build data warehouses and data marts as a Senior ETL Developer, using Azure Data Factory, SQL, and Power BI for reporting solutions.

This senior role focuses on developing ETL solutions that populate warehouses and create business intelligence data extracts. Responsibilities include designing scalable architecture, debugging mappings and transformations, enhancing complex SQL queries, and supporting data quality. You will work with Oracle, SQL Server, Azure Blob, Azure SQL Database, and star schema models. Collaboration with business users, technical groups, and stakeholders supports integrated solutions and documented delivery.

Key Responsibilities:

- Develop ETL solutions for warehouses and business intelligence extracts
- Design scalable data warehouses, data marts, and star schemas
- Debug mappings, transformations, source qualifiers,



and queries
- Investigate pipeline data issues and propose adequate solutions
- Support business users across interdependent applications and data sources

Requirements:

- Seven or more years of experience
- Five to ten years designing Azure Data Factory ETL solutions
- Experience using Azure Data Factory and Power BI together
- Experience developing complex SQL queries and performance enhancements
- Experience with Oracle, SQL Server, Azure Blob, and Azure SQL Database

Use Azure Data Factory, SQL, Power BI, and dimensional modeling to deliver documented, reliable data warehouse solutions.

📌 Senior Data Warehouse ETL Developer (Toronto)
🏢 Rubicon Path
📍 Toronto