Job Description

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