Data Analyst, Client Data

FP Inc.; Toronto; On-site; CAD 60,000 - 70,000; Full time

Job summary

FP Inc. is seeking a data quality and profiling specialist to join a 6-month engagement with potential for full-time conversion in Canada. You will use Python and SQL to profile and fix large enterprise datasets, and drive data migration readiness and validation.

You will collaborate with business, operations and technology teams to triage issues, implement fixes, and document root causes and preventive controls. FenX experience is a strong advantage.

Qualifications

• Strong, hands-on Python and SQL, plus advanced Excel to profile and modify large datasets.
• Ability to diagnose data issues, find root causes, and fix through to completion.
• Deep understanding of remediation lifecycle: gaps, bulk and targeted updates, verification.
• Experience with large enterprise datasets across multiple source systems.
• Experience on large, cross-functional enterprise data or technology initiatives in financial services.
• Independent contributor who can own tasks with minimal oversight.
• Clear written and verbal communication to business and technical stakeholders.

Responsibilities

• Investigate data quality issues across client and reference data, tracing problems to the source system, transformation logic or the mapping.
• Write and optimize Python and SQL to profile, validate and fix large enterprise datasets.
• Build repeatable scripts and checks for bulk and targeted data fixes, including verification after each fix.
• Support FenX configuration with data mapping, data migration readiness and data validation.
• Work with business, operations and technology teams to triage issues, agree on fixes and keep work moving.
• Document the cause of each issue, how it was fixed and the controls put in place, so the same problems don't come back.

Skills

Python & SQL

Advanced Excel

Problem solving

Data quality

Large datasets

Enterprise programs

Independent contributor

Communication

Tools

Jira

VS Code

Jupyter

Git

Marimo

FenX

Job description

An Initial AI Screening will be conducted for this role.

Duration

6 months to FTE

Daily Responsibilities:

• Investigate data quality issues across client and reference data, tracing problems back to the source system, the
• transformation logic or the mapping.
• Write and optimize Python and SQL to profile, validate and fix large enterprise datasets.
• Build repeatable scripts and checks for bulk and targeted data fixes, including verification after each fix.
• Support FenX configuration with data mapping, data migration readiness and data validation.
• Work with business, operations and technology teams to triage issues, agree on fixes and keep work moving.
• Document the cause of each issue, how it was fixed and the controls put in place, so the same problems don't come back

Must-Have Skills:

• Technical core: strong, hands-on Python and SQL, plus advanced Excel, used to query, profil and change large, complex datasets.
• Problem solving: a proven ability to diagnose data issues on your own, find the root cause and carry the fix through to completion.
• Data quality and remediation: deep understanding of the remediation lifecycle: finding gaps, making bulk and targeted updates, and checking the results afterwards.
• Large datasets: experience working with large enterprise datasets across multiple source systems.
• Enterprise programs: experience on large, cross-functional enterprise data or technology initiatives in financial services.
• Individual contributor: comfortable taking ownership, prioritizing your own work and delivering with minimal oversight.
• Communication: clear written and verbal communication. You can explain technical findings to business and technical stakeholders alike.

Nice-to-Have Skills:

• Fenergo FenX: experience with FenX configuration, data model, data migration or integration (a strong advantage).
• Domain knowledge: client onboarding, KYC or client lifecycle management in Capital Markets.
• Data tooling: experience with VS Code, Marimo or Jupyter, and with version control such as Git.
• Jira: experience using Jira for ticket management and tracking.
• Data migration: experience moving data between source systems and a new platform, including reconciling the data

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 yearly compensation range for this role is $60k - 70k. 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.