Business Analyst/Data Visualization

Virtusa; Mississauga; On-site; CAD 90,000 - 120,000; Full time

Job summary

Virtusa Corporation in Mississauga is seeking a senior Business Analyst with 8+ years of experience, strong analytical skills, and extensive SQL/database know-how to lead data quality initiatives and onboarding processes.

You will define timelines, support data governance milestones, and partner with Operations and Engineering to resolve multi-system breaks while building robust reconciliation workflows.

Qualifications

• 8+ years of Business Analysis experience with strong analytical skills.
• Proficient SQL skills and experience with databases.
• Experience with data quality and reconciliation tooling.

Responsibilities

• Lead triage, investigation, and RCA for complex transaction and financial breaks.
• Design remediation workflows for trade, cash, position, and intercompany reconciliation breaks.
• Classify exceptions into data errors, system issues, and timing discrepancies.
• Collaborate with Operations and Engineering to implement long-term fixes.

Skills

Business Analysis

SQL

Data Quality

Tools

Tableau

Power BI

Looker

Job description

Job Requirements

Over 8+ years of strong Business Analysis experience, analytical skills and Database experience

Over 8+ years of strong Business Analysis experience, analytical skills and Database experience

Knowledge in App onboarding, Timelines setting, SEBI compliance, Milestone modification, Project milestones creation

Advanced SQL: Proven ability to write complex queries (window functions, multi-table joins, aggregations,CTEs) to investigate multi-million row datasets, identify outliers, and diagnose root causes of datamismatches across databases (Snowflake, Oracle, PostgreSQL, BigQuery).Data Quality & Reconciliation Tools: Hands-on experience with DQ and reconciliation platforms (e.g., CollibraDQ, Informatica IDQ, Monte Carlo, Great Expectations, SmartStream TLM, Duco, Gresham, or bespoke recengines). Data Lineage & Mapping: Strong proficiency in Source-to-Target Mappings (STTM), Data Dictionarygeneration, schema validation, and data lineage tracing.

• BI & Data Visualization: Experience building data quality dashboards in Tableau, Power BI, or Looker to reportSLA adherence and break trends.

Responsibilities

End-to-End Exception Resolution & Break Management

• Lead the triage, investigation, and root cause analysis (RCA) for complex transaction and financial breaks across front-to-back systems (e.g., trade capture failures, settlement fails, corporate action breaks, payment STP fallouts, and sub-ledger-to-GL out-of-balance exceptions).
• Design robust operational and technical remediation workflows for trade, cash, position, and intercompany reconciliation breaks.
• Classify exceptions into systematic errors (logic/schema mismatches), upstream data errors (missing/corrupt reference data), operational misbookings, and platform timing/latency discrepancies.
• Partner with Operations and Engineering to drive long-term structural fixes, eliminating recurring manual workarounds and tactical journal adjustments.

Work Experience

10-15Years