Business Systems Analyst (Data Mapping & Expert SQL)
About the role
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
About Atlantis IT Group
"Atlantis IT Group" is an IT venture that offers end-to-end services and products. The focus of "the Company" is to cater one-stop solutions to small and medium-sized businesses.
"Atlantis" had its first branch in Toronto, Canada, and was established in 1990. The Company has emerged from a small farm to a medium company providing all sorts of solutions, headquartered in Toronto, Canada The Company has had its branches and offices in different countries such as the USA, Canada, and India for the last 32 years.
Atlantis is enlarging its global footprint by offering complementary product and service lines by partnering and strategically working with businesses. The primary specialized area of the Company includes ERP solutions, with cloud-based and on-premise solutions available to meet the requirements of all Industries.
OUR PRODUCTS:
"WORKSWARE ERP" The emergence of WORKSWARE ERP is noticed from a ground level to an upgraded form because of the integrated ERP system, dedicated towards forward-thinking discrete manufacturing enterprises.
"BM-Cloud" BM-Cloud is One of the key offerings of Atlantis consulting as a Cloud-based business management ERP software since 2013. The significant feature of BM-Cloud includes easy usage with the enhancement of simplicity and usability as a complete integrated ERP system. The fundamental modules covered by BM-Cloud are accounting, inventory management, purchasing, sales, and HR/payroll systems. In other words, it is designed primarily to support businesses in the trading and retail sectors and includes all the essential components required for a firm to assist in decision-making.
"BM-POS"
We provide a cloud-based retail solution with all the tools required to manage a retail business, including a sales screen, inventory management, real-time dashboard, employee administration, and other functions that keep retailers in charge of their operations.
Business Systems Analyst (Data Mapping & Expert SQL)
About the role
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
About Atlantis IT Group
"Atlantis IT Group" is an IT venture that offers end-to-end services and products. The focus of "the Company" is to cater one-stop solutions to small and medium-sized businesses.
"Atlantis" had its first branch in Toronto, Canada, and was established in 1990. The Company has emerged from a small farm to a medium company providing all sorts of solutions, headquartered in Toronto, Canada The Company has had its branches and offices in different countries such as the USA, Canada, and India for the last 32 years.
Atlantis is enlarging its global footprint by offering complementary product and service lines by partnering and strategically working with businesses. The primary specialized area of the Company includes ERP solutions, with cloud-based and on-premise solutions available to meet the requirements of all Industries.
OUR PRODUCTS:
"WORKSWARE ERP" The emergence of WORKSWARE ERP is noticed from a ground level to an upgraded form because of the integrated ERP system, dedicated towards forward-thinking discrete manufacturing enterprises.
"BM-Cloud" BM-Cloud is One of the key offerings of Atlantis consulting as a Cloud-based business management ERP software since 2013. The significant feature of BM-Cloud includes easy usage with the enhancement of simplicity and usability as a complete integrated ERP system. The fundamental modules covered by BM-Cloud are accounting, inventory management, purchasing, sales, and HR/payroll systems. In other words, it is designed primarily to support businesses in the trading and retail sectors and includes all the essential components required for a firm to assist in decision-making.
"BM-POS"
We provide a cloud-based retail solution with all the tools required to manage a retail business, including a sales screen, inventory management, real-time dashboard, employee administration, and other functions that keep retailers in charge of their operations.