Business Analyst/Data Visualization
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
#J-18808-Ljbffr