06 Nov
|
Virtusa
|
Winnipeg
Job RequirementsOver 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.
CollibraDQ, Informatica IDQ, Monte Carlo, Outstanding 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. Lead the triage, investigation, and root cause analysis (RCA) for complex transaction and financial breaks across front-to-back systems (e.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.
📌 Business Analyst/Data Visualization (Winnipeg)
🏢 Virtusa
📍 Winnipeg