Senior Solutions Architect

Job summary

Design, build, host, test, and support a financial planning and analytics application, including a standalone partner instance, integrations, automated API testing, and production support. Lead the application’s server migration, improve its architecture, coordinate with business and technical stakeholders, and document designs and project status.

Job details

Job Description 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. This is a hands-on, end-to-end role. You'll design, build, host, test and support the application yourself, and lead its move to new server infrastructure over the next year. What You'll Do Complete and launch a standalone instance of the application for a partner organization, building enhancements from user feedback Design and configure IIS hosting, working with infrastructure teams to give external users secure, reliable access 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 Work with the reporting team to build and maintain integrations between the application and SSAS-based reporting Provide production support: troubleshoot issues, find root causes and deliver fixes Demo new features to finance stakeholders, gather feedback and turn it into future improvements 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 Submit weekly status reports and document designs, models and solutions What You Bring 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 Experience leading application or server migrations Business analysis and project planning skills Clear communicator who can work with both business users and technical teams Nice to have Power BI governance: workspace management, deployment pipelines, row-level security and data access controls SSAS or broader Microsoft BI experience Finance, FP&A or budgeting application background Experience in BC public sector or healthcare Data quality, reconciliation and security model experience Working arrangements Hybrid, with on-site attendance in the Burnaby area as needed Core hours 9:00 to 5:00 Pacific Agile, iterative environment with frequent user check-ins Must be legally entitled to work in Canada Affinity Earn Know someone who’s great for this, or any of our open roles? Earn up to $4,000/year for each successful referral through Affinity Earn. You can also earn up to $50,000 for helping us find new clients. Learn about our referral program at https://affinity-group.ca/earn/ or browse our jobs & follow us at https://www.linkedin.com/company/affinity-staffing/jobs/ About Affinity Affinity Group is a technology and business consulting and services company. We believe in creating long term relationships between clients and consultants that foster a mutually beneficial partnership. Affinity is an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all employees. All employment is decided on the basis of qualifications, merit and business need. For more information on Affinity, please visit www.affinity-group.ca Job Number: 14047

What you’ll do

Design, build, host, test, and support a financial planning and analytics application, including a standalone partner instance, integrations, automated API testing, and production support. Lead the application’s server migration, improve its architecture, coordinate with business and technical stakeholders, and document designs and project status.

Requirements

Requires senior-level experience designing and supporting enterprise solutions on the Microsoft stack, full-stack development with React and Node.js, advanced SQL Server skills, and deep IIS expertise. Candidates should also have DevOps and migration experience, strong business analysis and project planning skills, and clear communication abilities.

Listed skills

• React · Preferred
• Node.js · Preferred
• JavaScript · Preferred
• CSS · Preferred
• CI/CD · Preferred

Other relevant skills

Identified from the job description. Confirm important requirements above.

• Solution Architecture
• .NET Framework
• ASP.NET
• Web API
• SQL Server
• React
• Node.js
• JavaScript
• CSS
• IIS
• T-SQL
• Database Design
• Performance Tuning
• CI/CD
• Automated API Testing
• Application Migration

Job areas

• Technology
• Software
• Data & Analytics
• Finance & Accounting
• Government & Public Sector

More jobs from Affinity