Solution Architect - Client Reporting (Sigma)

Role overview

A senior consulting position focused on designing and delivering Sigma-based client reporting solutions for asset and wealth management firms. The role leads end-to-end implementations, from discovery workshops through knowledge transfer, working with blue-chip investment clients across North America and contributing to a boutique consulting practice inside a larger financial services advisory group.

Responsibilities

- Lead end-to-end Sigma analytics implementations, including discovery workshops, technical architecture design, data source integration, user acceptance testing, and comprehensive knowledge transfer to client teams. - Create semantic layers and data models within Sigma that enable self-service analytics while preserving data governance, consistency, and query performance. - Define and lead project planning, producing detailed statements of work and task plans for successful delivery. - Design intuitive, interactive dashboards and reports that translate complex business requirements into user-friendly outputs. - Collaborate with cross-functional consulting teams and clients to deliver robust data platforms, pipelines, and integrations aligned to industry best practice.

Requirements

- Significant experience as a Sigma or comparable BI architect or senior implementation lead. - Strong front office technology background with familiarity across front, middle, and back office functions of investment organizations. - Hands-on knowledge of asset and wealth management reporting components such as factsheets, holdings, performance, characteristics, disclosures, and commentaries. - Proven ability to lead cross-functional delivery and translate business needs into scalable, secure, high-performance data and reporting solutions. - Entrepreneurial approach and comfort operating in a meritocratic consulting culture.

Benefits and work setup

- Hybrid and flexible working model with autonomy to balance client delivery and personal commitments. - Base salary structured by location: Toronto candidates paid CAD 170,000–CAD 205,675, with US zones ranging from $125,000 to $186,200 depending on metropolitan area. - Discretionary bonus eligibility on top of base salary, plus a comprehensive benefits package. - 25 days of paid time off and up to 7 sick days annually. - 401k/RRSP matching and supplemented medical, dental, and vision coverage. - Reimbursement for commuting, mobile phone, and home internet expenses. - Up to 5 paid training days annually and sponsorship toward professional certifications. - Family-friendly benefits including comprehensive parental leave for all parents, return-to-work support, child sickness leave, and menstrual care support.