Affinity Group is hiring a Senior Solution Architect for a major BC public sector client. You'll join a finance business planning team that owns an in-house Financial Planning & Analytics web application used across the organization and partner agencies. You'll design, build, host, test and support the application yourself, and lead its move to current server infrastructure over the next year.

Complete and launch a standalone instance of the application for a partner organization, building enhancements from user feedback

Build automated API testing into the CI/CD pipeline to improve quality and release reliability

Assess the current architecture and recommend improvements for scalability, performance and maintainability

Plan and lead a server migration: dependency mapping, risk and capacity analysis, security, and implementation, testing, rollback and cutover plans with minimal downtime and no data loss

Senior-level experience designing and supporting enterprise solutions on the Microsoft stack: .NET Framework, ASP.NET, Web API, SQL Server

Full-stack development with React, Node.js, JavaScript and CSS, with a strong eye for modern UX/UI

Advanced SQL Server skills: database design, T-SQL,



stored procedures, performance tuning, data modelling and ETL

Deep IIS experience: configuration, deployment, authentication, security, performance tuning and troubleshooting

DevOps practice: Git, CI/CD pipeline design and automation, release management and automated API testing

Business analysis and project planning skills

Clear communicator who can work with both business users and technical teams

Power BI governance: workspace management, deployment pipelines, row-level security and data access controls

SSAS or broader Microsoft BI experience

Experience in BC public sector or healthcare

Data quality, reconciliation and security model experience

Hybrid, with on-site attendance in the Burnaby area as needed

Agile, iterative setting with frequent user check-ins

You can also earn up to $50,000 for helping us find new clients. We believe in creating long term relationships between clients and consultants that foster a mutually beneficial partnership. We celebrate diversity and are committed to creating an inclusive environment for all employees.

📌 Senior Solutions Architect, Financial Services - Public Sector (Burnaby)
🏢 Affinity
📍 Burnaby