Business Intelligence Architect

About the job
Title: Intermediate Application / Software Architect (Business Intelligence)

Duration: 2 years

Location: Ottawa, onsite

Domain: Federal Government Services

Salary: $90 to $95/hr per hour (based on experience)

MUST have an active and validSECRET level security clearance.

Overview:

The Application/Software Architect(Business Intelligence) will focus on the design and integration of applications that support analytical and decision-support capabilities. The role involves developing technical architectures, evaluating and selecting software platforms, defining system interfaces, integrating multiple data sources and applications, and ensuring solutions align with business, security, and operational requirements. The architect will work across the SAST environment to improve business intelligence capabilities and support the creation of new analytical solutions used by Defence leadership.

This position will also contribute to process and data analysis, workflow development, application design reviews, technology assessments, and the implementation of new BI and data discovery capabilities. Working directly with stakeholders and program teams, the architect will help transform business requirements into scalable, secure, and maintainable technical solutions while producing technical documentation, system proposals, architecture artifacts, and training materials.

Job Description

Core Skills

Application Architecture
Software Design
System Integration
API/Middleware Architecture
Data Integration
BI Solutions
Must Have

5+ years as Application Architect
5+ years designing BI solutions
5+ years evaluating technology platforms
5+ years integration experience
Preferred

Public sector
Defence
Research environments
Analytics applications
Project Overview

Business Area

The Strategic Analysis Support (SAS) team supports:

Force Capability Planning
Structure Design
Capability Investments
Defence Workforce Planning
NATO Planning
Wargaming
Strategic Force Development
Existing Technology Environment

The current SAST ecosystem includes:

BI Platforms

Tableau
Power BI
Qlik
Database Technologies

SQL Server
MySQL
ETL Platforms

Clover ETL / CloverDX
Development Platforms

PHP
Python
Power Apps

Note: AI-enabled tools may be used to sort applications based on job-related criteria. All AI generated results are vetted by our team and the decision of which candidates move forward is always made by a human

Requirements added by the job poster

• 5+ years of work experience with Business Intelligence (BI)