Data Analyst cum Business Analyst

Salary : 140k CAD This is remote/ Toronto, ON Client is City National bank. Data Analyst cum Business Analyst for the SWP projects within the City National Bank CNR Wealth data program The role bridges business and engineering translating wealth management data requirements into clear buildable specifications and validating the data delivered through Azure Synapse pipelines into Salesforce You will work directly with client stakeholders and the offshore development and QA teams in a fast paced Agile release cycle Key Responsibilities Business Analysis • Elicit analyse and document business and data requirements from CNR wealth stakeholders convert them into clear user stories with well defined acceptance criteria • Own the product backlog hygiene in JIRA Azure DevOps grooming prioritisation story splitting and maintaining Definition of Ready DoR and Definition of Done DoD • Facilitate and actively participate in Scrum ceremonies sprint planning daily standups backlog refinement reviews and retrospectives • Act as the liaison between client business teams development and QA resolving requirement clarifications within agreed SLAs and managing scope change discussions Data Analysis • Write and optimise SQL to profile analyse and reconcile source to target data across DataHub Snowflake and Salesforce • Prepare and validate source to target mapping STTM documents and derivation business rules eg deriving Contact attributes from only active financial accounts • Perform data validation and reconciliation to support UAT for each release identify log and drive resolution of data defects • Analyse Synapse pipeline outputs and support enhancements such as file source and configuration changes ensuring data quality and completeness Delivery Governance • Support release planning and track deliverables through UAT and production deployment coordinating with onsite leads and the client delivery lead • Maintain requirement traceability documentation and status reporting flag risks blockers and dependencies early • Contribute to month on month productivity improvement and adherence to CNB delivery change management and quality processes Required Skills Experience • Strong SQL hands on querying data profiling reconciliation and analysis across relational and cloud data platforms • Scrum Agile BA expertise proven experience writing user stories acceptance criteria and managing backlogs in JIRA Azure DevOps • Dual DABA capability able to both analyse data directly and translate business needs into technical specifications • Data integration understanding exposure to ETLELT concepts source to target mapping and data validation Azure Synapse Data Factory familiarity is an advantage • Communication clear written and verbal skills to engage US based client stakeholders directly and confidently • Ownership a self driven quick learner who can lead analysis independently and mentor junior team members Preferred Good to Have • Wealth management capital markets domain understanding of financial advisors portfolios custodians brokers and financial account structures • Salesforce data model exposure Contact Account objects and CRM data flows • Cloud data platforms Snowflake Azure Synapse ADF Function Apps • Banking financial services delivery experience with an appreciation for data governance and compliance Skills Mandatory Skills : Cognos Analytics, MS Excel, PowerBI, Python for DATA, Tableau