Business Analyst – Data, SQL, PowerBI

Job Description

Our client, a leading financial institution in Downtown Toronto, is looking for a Business Analyst - Data, SQL, PowerBI to analyze legacy reports in SQL Server and Power BI to document current data transformations, business logic, and source-to-target mappings. The candidate will work with one of the Top 5 Banks in Canada.

Location

Hybrid (Downtown, Toronto)

Duration

6 months

Typical Day in the role

• Migration & Mapping: Map legacy data transformations to new data products on the Azure Databricks platform to ensure a seamless transition and migration.
• Process Optimization: Identify duplication of logic across reports and find opportunities to simplify and streamline overall reporting processes.
• Data Profiling & Quality: Perform data analysis using SQL and Excel to profile data, identify inconsistencies, and conduct root-cause analysis on data quality issues (including CRM/Salesforce dat...