Senior BI Developer/ Data Analyst - Power BI, SQL

Job Description

Senior BI Developer/ Data Analyst:
On behalf of our Banking client, Procom is searching for a Senior BI Developer/ Data Analyst for a 6-month role. This position is a hybrid position with 1 day onsite at our client’s Toronto office.

Senior BI Developer/ Data Analyst - Job Description:
The Senior BI Developer/ Data Analyst will support the MPL Strategic project, which involves changes to back-end data sources and structures affecting existing reports. The role includes updating and developing Power BI reporting solutions, writing data transformation mappings, validating data through advanced SQL, and integrating information into the central reporting platform, RDAL.

Senior BI Developer/ Data Analyst - Responsibilities:
• Design and develop complex static and paginated reports using Power BI Report Builder.
• Develop interactive Power BI dashboards using advanced Power BI functionality.
• Implement cascading report parameters mapped to source SQL queries.
• Use advanced SQL for data extraction, transformation, validation, reconciliation, and reporting support.
• Develop advanced DAX calculations and Power Query transformations.
• Collaborate with technology partners to integrate information from multiple sources into the central reporting platform, RDAL.
• Create and maintain mapping documents that define data transformation logic, source-to-target relationships, calculations, and reporting definitions.

Senior BI Developer/ Data Analyst - Mandatory Skills:
• 7-10 years of hands-on BI development experience.
• Advanced Power BI development experience, including interactive dashboards and reports.
• Advanced experience with Power BI Report Builder and paginated reports.
• Advanced SQL skills for complex querying, data extraction, transformation validation, and reporting.
• Advanced DAX and Power Query experience.
• Experience deploying and managing reports in Power BI Service.
• Demonstrated understanding of data models, ETL concepts, and data transformation logic.

Senior BI Developer/ Data Analyst – Nice-to-Have Skills:
• Previous experience supporting enterprise-scale data or reporting transformation initiatives.
• Experience integrating reporting data from multiple source systems.
• Experience working with centralized reporting or analytical data platforms such as RDAL.
• Experience in financial services or another highly governed enterprise environment.
• Familiarity with data governance, controls, reconciliation, and reporting-quality practices.

Senior BI Developer/ Data Analyst – Assignment Length:
This is a 6-month contract with a possibility of extension.

Senior BI Developer/ Data Analyst - Start Date:
ASAP.

Senior BI Developer/ Data Analyst - Assignment Location:
Toronto, Ontario, Canada - Hybrid, with 1 day in office.

This employer uses both human and technology-assisted tools to support candidate screening and assessment. Final hiring decisions are made by people.