Senior Solution Analyst (Data and Analytics)
$82,500–$121,000 year
On-siteToronto, Ontario, Canada
Job Summary
Conduct front-end analysis of complex work spanning business functions, reporting needs, and the firm's data platforms, covering feasibility, data quality, source-to-target mapping, and readiness. Translate business requirements into clear solution intent by querying data directly, reviewing source system behavior, and profiling data quality yourself. Define and document critical data elements, including definitions, business rules, mappings, and system contracts to ensure consistency. Represent technical limitations to business stakeholders and business intent to engineers while identifying risks such as data gaps, downstream impacts, and regulatory implications. Support the delivery of analytics and reporting that provide stakeholders with trustworthy operational and financial information, including adoption readiness through communications, training, and data clean-up. Create and maintain supporting product documentation, including data flow overviews, functional narratives, and use cases.
Required Qualifications
- 8+ years of experience as a Business, Data, or Solution Analyst in financial services, asset servicing, data and analytics, or a comparable environment
- Strong data analysis skills, with the ability to query, profile, and interpret data directly using SQL, and to reason about data quality and lineage
- Demonstrable experience gathering, analysing, and documenting business requirements and translating them into clear solution intent and acceptance criteria
- Experience working with operational, analytical, or financial data, and an understanding of how that data supports reporting, analysis, and decision-making
- Experience with source-to-target mapping, data definitions, and the rules that keep data consistent as it moves between systems
- Strong analytical judgement, knowing what to look at, what to ignore, and when analysis is good enough to act on
- Credibility with both business and technical stakeholders, with the ability to hold a view under questioning
- Expert proficiency in Excel
- Strong proficiency across the Microsoft Office suite
Desired Qualifications
- Experience with a modern data platform such as Databricks, or comparable lakehouse or cloud data platforms, and an understanding of how data pipelines are designed and documented
- Hands-on experience building reports and dashboards in Power BI or a comparable business intelligence tool
- Exposure to Workday, particularly where it integrates with finance data flows
- Experience supporting data platform migration, integration, or master data management work
- Understanding of fund administration or fund accounting data
- Exposure to AI-assisted analysis and discovery tooling
- Experience with agile delivery, and knowledge of process improvement approaches such as Lean or Six Sigma
Hiring someone like this?
Get your role in front of qualified candidates on Sorce.