30 Oct
|
Virtusa
|
Mississauga
30 Oct
Virtusa
Mississauga
Job Requirements
Over 8+ years of robust 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 breaksacross front-to-back systems (e.g., trade capture failures, settlement fails, corporate action breaks, paymentSTP fallouts, and sub-ledger-to-GL out-of-balance exceptions).
- Design robust operational and technical remediation workflows for trade, cash, position, and intercompanyreconciliation breaks.
- Classify exceptions into systematic errors (logic/schema mismatches), upstream data errors (missing/corruptreference data), operational misbookings, and platform timing/latency discrepancies.
- Partner with Operations and Engineering to drive long-term structural fixes, eliminating recurring manualworkarounds and tactical journal adjustments.
Work Experience 10-15Years
📌 Business Analyst/Data Visualization (Mississauga)
🏢 Virtusa
📍 Mississauga