Business Systems Analyst

Role: Business Systems Analyst (Data Mapping & Expert SQL)

Location: Toronto

Position Overview

We are seeking a highly analytical Business Systems Analyst with strong data mapping expertise and advanced SQL proficiency to bridge business requirements with technical data solutions. This role requires a detail-oriented professional who can analyze complex data structures, design effective data mapping strategies, and translate business needs into actionable technical specifications.

Core Responsibilities

Data Analysis & Mapping

Lead end-to-end data mapping initiatives for system integrations, migrations, and ETL processes

Analyze source and target data structures to identify relationships, dependencies, and transformation requirements

Create comprehensive data mapping documentation including field-level specifications, transformation rules, and business logic

Develop data lineage diagrams and data flow documentation to ensure traceability

Conduct data profiling and quality assessment to identify anomalies, gaps, and inconsistencies

Define data validation rules and acceptance criteria for data migration and integration projects

Collaborate with data engineers and developers to ensure accurate implementation of mapping specifications

SQL Development & Analysis

Write complex SQL queries to extract, transform, and validate data across multiple databases

Develop stored procedures, views, and scripts to support data analysis and reporting needs

Perform data reconciliation and validation using SQL to ensure data integrity post-migration

Optimize SQL queries for performance and efficiency

Conduct root cause analysis using SQL to troubleshoot data issues and discrepancies

Create ad-hoc reports and data extracts to support business intelligence and decision-making

Support database design reviews and provide input on data model optimization

Business Analysis

Elicit, document, and validate business requirements through interviews, workshops, and process analysis

Translate business requirements into functional specifications and technical user stories

Create detailed process flow diagrams, use cases, and business requirement documents (BRDs)

Facilitate requirements review sessions with stakeholders and technical teams

Conduct gap analysis between current state and future state data architectures

Support UAT planning, test case development, and defect triage

Serve as liaison between business stakeholders and technical development teams

Stakeholder Collaboration

Partner with cross-functional teams including IT, data engineering, business operations, and vendors

Present findings, recommendations, and project updates to stakeholders at all levels

Manage stakeholder expectations and ensure alignment on project scope and deliverables

Facilitate workshops and collaborative sessions to gather requirements and resolve issues

Provide training and documentation to end-users on new systems and data processes

Required Qualifications

Technical Skills

Advanced SQL proficiency including:

Complex joins (inner, outer, cross, self-joins)

Subqueries, CTEs (Common Table Expressions), and window functions

Aggregate functions, grouping, and pivoting data

Query optimization and performance tuning

Stored procedures, triggers, and views

Data mapping expertise including:

Source-to-target mapping documentation

Data transformation logic definition

ETL (Extract, Transform, Load) process design

Data quality and validation rules

Master data management concepts

Database knowledge:

Relational database concepts and normalization

Experience with SQL Server, Oracle, PostgreSQL, or MySQL

Understanding of data warehousing and dimensional modeling

Familiarity with NoSQL databases is a plus

Business Analysis Skills

5-7 years of experience as a Business Analyst or Business Systems Analyst

Strong requirements elicitation and documentation skills

Experience with Agile/Scrum methodologies and tools (Jira, Confluence)

Proven ability to create process flows, data flow diagrams, and technical specifications

Experience with UAT coordination, test case development, and defect management

Knowledge of SDLC (Software Development Life Cycle) best practices

Tools & Technologies

Data Mapping Tools: Erwin, ER/Studio, Visio, Lucidchart, or similar

SQL IDEs: SQL Server Management Studio (SSMS), Toad, DBeaver, or similar

ETL Tools: Informatica, Talend, SSIS (SQL Server Integration Services), or similar (preferred)

Version Control: Git, SVN, or similar

Collaboration Tools: Confluence, SharePoint, MS Teams

Project Management: Jira, Azure DevOps, MS Project

Domain Experience (Preferred)

Experience in one or more of the following domains:

Healthcare (EMR/EHR systems, HL7, FHIR standards)

Financial Services (banking systems, regulatory reporting)

Retail/E-commerce (customer data platforms, order management)

SaaS platforms and cloud-based systems

Experience with CRM platforms (Salesforce, Dynamics) or ERP systems (SAP, Oracle) is a plus

Key Competencies

Analytical Thinking

Strong problem-solving skills with ability to break down complex data challenges

Data-driven decision making and root cause analysis expertise

Attention to detail and commitment to data accuracy

Communication

Excellent written and verbal communication skills

Ability to explain technical concepts to non-technical audiences

Strong documentation and presentation skills

Collaboration

Team player with ability to work across functional boundaries

Experience managing multiple stakeholder priorities

Conflict resolution and negotiation skills

Adaptability

Comfortable working in fast-paced, dynamic environments

Quick learner with ability to understand new business domains and systems

Flexible and open to changing priorities

Education & Certifications

Required

Bachelor's degree in Computer Science, Information Systems, Business Administration, or related field

Equivalent work experience may be considered in lieu of degree

Preferred Certifications

CBAP (Certified Business Analysis Professional)

PMI-PBA (Professional in Business Analysis)

Microsoft Certified: Azure Data Fundamentals or similar

SQL certification (Microsoft, Oracle, or vendor-specific)

Agile/Scrum certifications (CSM, CSPO, PSM)

Example Projects You'll Work On

System Migration: Lead data mapping for legacy system migration to cloud-based platform, including 50+ tables and complex business rules

API Integration: Design data mapping specifications for third-party API integrations with existing enterprise systems

Data Warehouse Enhancement: Analyze source systems and create ETL mapping documentation for new data warehouse dimensions

Master Data Management: Develop data mapping standards and governance processes for customer master data consolidation

Reporting & Analytics: Build SQL-based reporting solutions and data extracts to support business intelligence initiatives