Business Analyst/Data Visualization
- Mississauga, ON, Canada
Full-time
Applications open in a new tab.
Job details
- Job type
- Full-time
- Apply by
- Experience
- Over 8+ years of strong Business Analysis experience, analytical skills and Database experience
- Posting language
- English
- Posted
Original job description
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.
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.
10-15Years
More about this job
Responsibilities
Lead investigation and root cause analysis of complex transaction and financial exceptions across front-to-back systems, and design remediation workflows for trade, cash, position, and intercompany reconciliation breaks. Partner with Operations and Engineering to implement lasting structural fixes and reduce recurring manual workarounds and tactical journal adjustments.
Requirements
Requires 8+ years of business analysis experience, strong analytical and database skills, and advanced SQL expertise for investigating large datasets across multiple database platforms. Candidates should have experience with data quality and reconciliation tools, source-to-target mapping, data lineage, and BI dashboards; the posting also lists 10–15 years of work experience.
Skills
- Business Analysis
- Advanced SQL
- Data Quality
- Data Reconciliation
- Root Cause Analysis
- Exception Resolution
- Break Management
- Data Lineage
- Source-to-Target Mapping
- Data Visualization
- Tableau
- Power BI
- Looker
- Database Analysis
- Financial Reconciliation
- SEBI Compliance
Visa sponsorship
Not detected in the job text
Categories
- Data & Analytics
- Finance & Accounting
- Technology
- Consulting
Keywords
- Business Analysis
- Advanced SQL
- Window Functions
- Multi-Table Joins
- Aggregations
- Common Table Expressions
- Snowflake
- Oracle
- PostgreSQL
- BigQuery
- CollibraDQ
- Informatica IDQ
- Monte Carlo
- Great Expectations
- SmartStream TLM
- Duco
- Gresham
- Source-to-Target Mapping
- Data Dictionary
- Schema Validation
- Data Lineage
- Tableau
- Power BI
- Looker
- Root Cause Analysis
- Transaction Reconciliation
- Financial Break Management
- Trade Capture
- Settlement
- Corporate Actions