Data Analyst – SQL, Power BI, Salesforce

Finance Professionals Inc.; Toronto; On-site; CAD 69,000 - 87,000; Part time

Job summary

Finance Professionals Inc. in Downtown Toronto is seeking a Data Analyst to document legacy SQL Server reports and Power BI data models, map data transformations to new products, and ensure source-to-target mappings are clearly defined.

The role focuses on data profiling, quality, and governance, collaborating with data engineers, IT, and Salesforce stakeholders to support Azure Databricks migration and a successful modernization effort.

Qualifications

• Bachelor's degree required.
• 5+ years as a Data/Business Analyst.
• Experience with SQL Server and Power BI.
• Experience with data migration projects and data lineage.
• Knowledge of CRM data (Salesforce) and Azure Databricks.
• Excellent communication and stakeholder management.

Responsibilities

• Map legacy data transformations to new data products on Azure Databricks.
• Document end-to-end data lineage and source-to-target mappings.
• Profile data quality and perform root-cause analysis.
• Collaborate with business, data engineers, and IT to translate requirements.
• Produce reports on progress and remediation efforts.

Skills

Data analysis

Communication

Stakeholder management

Documentation

Problem solving

Education

Bachelor’s degree

Databricks certification

Tools

SQL Server

Power BI

Azure Databricks

Salesforce

Excel

Job description

JOB DESCRIPTION

Location: Hybrid (Downtown, Toronto)

Duration: 4 months

Our client, a leading financial institution in Downtown Toronto, is looking for a Data Analyst - SQL, Power BI, Salesforce to analyze existing legacy reports in SQL Server (stored procedures, complex queries) and Power BI (DAX, data models, dataflows) to thoroughly document current data transformations, business logic, and source-to-target mappings. The successful candidate will have the opportunity to work with one of Canada's Top 5 Banks.

Typical Day in 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 data hygiene).


• Collaboration & Liaison: Serve as a key liaison between business stakeholders, data engineers, and IT teams to translate legacy reporting logic into requirements for the new modernized data architecture.


• Issue Resolution: Collaborate with application owners to resolve identified data discrepancies and implement permanent data governance solutions.


• Root Cause Analysis: Analyzes and investigates the root cause of data hygiene issues with the business and source team to create remediation action plan and roadmap.


• Tools used: CRM platforms such as Salesforce, Creating, managing, and analyzing surveys, Performing data analysis using SQL and Excel to profile data and identify data inconsistencies, Using PowerBI for visualizing insights


• Reporting: Reports on the workstream progress and remediation efforts to stakeholders.

Must-Have Skills:

• 5+ years as a Data/Business Analyst with proven experience in data migration projects, documenting end-to-end data lineage, and creating source-to-target mappings.


• 3-5 years of strong SQL experience (specifically SQL Server) writing and analyzing complex queries and stored procedures to profile data and identify inconsistencies.


• 3-5 years of experience with Power BI, with a specific focus on analyzing existing Power BI reports, DAX, queries, and dataflows to extract and document business logic.


• Demonstrated experience in Data Quality & Governance, including conducting root-cause analysis for data issues and working with CRM platforms (e.g., Salesforce) for data hygiene.


• Familiarity with modern cloud data platforms, ideally Azure Databricks, to facilitate the mapping of legacy data to new cloud-based data products.


• 1-2 years hands-on experience with this CRM platform strongly preferred: Salesforce


• Excellent communication skills and Presentation skills including, summarizing findings in a PPT format and presenting to varying levels of stakeholders are critical for the role.

Nice-To-Have Skills:

• Working across multiple teams and stakeholders (business, data and IT)


• Experience with MDM (master data management) tools


• Experience with building data solutions and gathering requirements for those types of projects


• Previous experience with Top Banks / FI

Soft Skills Required:

• Excellent communication skills


• Presentation skills – summarizing findings in a PPT format and presenting to varying levels of stakeholders

Education:

• Bachelor’s degree


• Data Bricks certification

FP Inc. is committed to creating an inclusive environment where all team members and clients feel like they belong. In accordance with the requirements set out in the Employment Standards Act, FP Inc. hereby declares that AI is utilized in the screening process for this position. The hourly compensation range for this role is C$50 - C$63. We seek applicants with a wide range of abilities, and we provide an accessible candidate experience. We advocate for you and welcome anyone regardless of race, colour, religion, national origin, sex, physical or mental disability, or age.