Business Systems Analyst

Altis Technology; Vancouver; Hybrid; CAD 85,000 - 115,000; Full time

Job summary

Altis Technology in Canada is seeking an experienced Business Systems Analyst (Data/Reporting) for a 12-month contract. The role focuses on enterprise reporting, data initiatives, and a centralized data repository to support decision-making.

The successful candidate will contribute to ministry reporting initiatives and work within data-heavy environments using SQL, data mapping, and reporting platforms. A hybrid on-site schedule applies, with Tuesdays and Thursdays on-site.

Qualifications

• 5+ years of experience as a Business Systems Analyst supporting data reporting or data warehouse initiatives in Waterfall environments.
• Hands-on experience with SQL, data profiling, and enterprise data environments such as data warehouses or data lakes.
• Familiarity with cloud data platforms such as Azure Synapse, Snowflake, or AWS Redshift.
• Experience with data mapping, reporting systems, and enterprise data repositories.
• Strong analytical thinking, communication, and stakeholder collaboration skills.

Responsibilities

• Gather, analyze, and document business requirements for data reporting and enterprise data repository initiatives.
• Validate reporting requirements for ministry reporting initiatives and identify additional reporting needs.
• Perform current state and future state analysis, including gap analysis and documentation of business processes and data flows.
• Develop detailed data mapping documentation including business glossary, source systems, ETL logic, and target reporting structures.
• Collaborate with business and technical teams to translate business needs into clear functional and technical specifications.
• Support requirements lifecycle management including traceability, testing preparation, and documentation aligned with Waterfall methodologies.

Skills

Requirements elicitation

Process mapping

Structured documentation

SQL

Data profiling

Azure Synapse

Snowflake

AWS Redshift

Data mapping

Data reporting

Stakeholder collaboration

SharePoint

Microsoft Teams

Excel

Word

Visio

Tools

SharePoint

Microsoft Teams

Excel

Word

Visio

Job description

Location: Vancouver, BC (Hybrid, Tuesdays and Thursdays on-site)
Language: Strong written and verbal English communication required
Duration: 12-month contract
Schedule:35hoursperweek,8:30-4:30pmMondaytoFriday
BackgroundCheckRequirement:Criminalrecordcheckandprofessionalreferences

About the Opportunity

Our client in the post-secondary education sector is seeking an experienced Business Systems Analyst (Data / Reporting) to support key enterprise reporting and data initiatives. This role will contribute to important projects that improve how organizational data is structured, reported, and leveraged for decision-making.

The successful candidate will support a ministry reporting initiative focused on reporting student outcomes and performance metrics while a new system of record is being implemented. In parallel, you will contribute to the development of an enterprise data repository that will serve as a centralized reporting environment. This role requires strong experience working in data-heavy environments involving reporting systems, data mapping, and enterprise data platforms.

What’s In It for You

You’ll have the opportunity to work on meaningful initiatives that support transparency, compliance, and data-driven decision-making within a large public sector organization. This role offers exposure to enterprise data architecture and reporting modernization projects that have real impact across the organization.

You’ll collaborate with experienced project teams and stakeholders who value structured delivery, clear documentation, and strong analytical thinking.

Your Responsibilities

• You’ll gather, analyze, and document business requirements for data reporting and enterprise data repository initiatives.

• In this role, you’ll validate reporting requirements for ministry reporting initiatives and identify additional reporting needs.

• You’ll perform current state and future state analysis, including gap analysis and documentation of business processes and data flows.

• You’ll develop detailed data mapping documentation including business glossary, source systems, ETL logic, and target reporting structures.

• You’ll collaborate with business and technical teams to translate business needs into clear functional and technical specifications.

• You’ll support requirements lifecycle management including traceability, testing preparation, and documentation aligned with Waterfall methodologies.

Skills and Qualifications

• 5+ years of experience as a Business Systems Analyst supporting data reporting or data warehouse initiatives in Waterfall environments.

• Strong experience in requirements elicitation, process mapping, and structured documentation aligned with IIBA or BABOK frameworks.

• Hands-on experience working with SQL, data profiling, and enterprise data environments such as data warehouses or data lakes.

• Familiarity with cloud data platforms such as Azure Synapse, Snowflake, or AWS Redshift.

• Experience with data mapping, reporting systems, and enterprise data repositories.

• Strong analytical thinking, communication, and stakeholder collaboration skills.

• Experience working with tools such as SharePoint, Microsoft Teams, Excel, Word, Visio, and SQL-based databases.

All qualified applicants will receive fair consideration for employment. We welcome individuals of all backgrounds, experiences, and identities including those who identify as women, members of racialized groups, Indigenous Peoples, persons with disabilities, and 2SLGBTQIA+ communities. If you require an accommodation, please review our accessibility policy and reach out to our accessibility officer with any questions.