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
...Anesthesiology Physician for a permanent opportunity in South Dakota M - TH Full time with Call Willing to license Excellent compensation and benefits For more information email, call or text: ****@*****.*** or (***) ***-****. JETT Medical...
POSITION SUMMARY Complete opening and closing duties including setting up necessary supplies and tools, cleaning all equipment and areas, locking doors, etc. Set up and maintain cleanliness and condition of counter, tables, and other tools. Set up, stock, and maintain...
...This is a remote position. Job Title: World Travel Consultant Remote About the Role Are you passionate about travel and inspired to help others see the world? As a World Travel Consultant, youll plan and book a wide range of vacationsfrom cruises...
...This role participates in outreach events to communities served by My Ombudsman and also serves to investigate, mediate, and resolve issues reported by MassHealth members. The Outreach Ombudsman devotes approximately 65% of their time to community engagement efforts (in...
At Aspen Dental, we put You First, offering the security and job stability that comes with working with a world-class dental service... ...you thrive in your career. When you join our team as a Dental Office Manager, which at Aspen Dental we call an Operations Manager, you will...