Senior Etl Software Developer Onsite Toronto

Senior ETL Software Developer – Join the Office of the Public Guardian and Trustee to work onsite on ETL processes, data integration, and PowerBI reporting.

Leverage your expertise in ETL and more than five years of experience to migrate data to an OpenText document management solution. Your strong knowledge of Azure Synapse, SQL Server, Dynamics 365, and Python will ensure successful data transformation, while you also facilitate data security and governance and meet project milestones.

Key Responsibilities

• Design data warehouse architecture for Azure solutions
• Identify data for extraction and migration to storage solutions
• Develop and automate ETL processes for data integration
• Create physical data models for reporting needs
• Produce PowerBI reports and visualizations ensuring accuracy

Requirements

• 5+ years ETL experience with Azure Synapse
• Proficiency in SQL Server, Oracle, and Python
• Robust understanding of Dynamics 365 data
• Experience in data migration tasks
• Knowledge of data security and governance tools

Utilize your ETL expertise to advance data solutions at the Office of the Public Guardian and Trustee.