ETL/BI Developer - Mississauga - ref. z8253819

You will also play a crucial role in supporting the data migration process related to M& A activities.

Responsibilities:

• Take charge of the development and maintenance of ETL processes to seamlessly integrate data from a variety of sources into data warehouses and BI systems
• Design and optimize data models for use in business intelligence and analytics applications
• Implement and maintain data transformation processes to ensure accurate reporting and analysis
• Collaborate effectively with stakeholders to gather requirements for data solutions
• Actively support the M& A data migration process, preparing and consolidating data to be imported into business applications
• Integrate data sourced from M& A activities into the data warehouse to facilitate consolidated analytics
• Utilize the Azure Data Factory framework to manage data integration and transformation
• Manage data lake and warehouse artifacts using TimeXtender or similar ETL toolsets
• Leverage Azure Synapse and/or Fabric Link to enable near real-time data integration and enhance the performance of analytics and reporting across cloud systems
• Troubleshoot, test, and resolve issues related to ETL jobs and BI reports
• Assist in the development of visualizations in Power BI as and when required.