Business System Analyst

Job summary

Gather and document business and data requirements, translating them into functional specifications, data mappings, and design documentation for Databricks-based platforms. Collaborate with business and technical teams on data analysis, validation, testing, issue resolution, and business sign-off.

Job details

Job Description – Data Designer Data Designer / Data Business Systems Analyst – Databricks & Financial Services Location: Downtown Toronto, Canada Experience: 5–7 years Finance experience: Mandatory Position Overview We are seeking an experienced Data Designer / Business Systems Analyst (BSA) with 5–7 years of relevant experience, hands-on exposure to Databricks, and a strong background in the financial services domain. The successful candidate will work closely with business stakeholders, data teams, and technology teams to understand business requirements and translate them into clear data and functional specifications. The candidate should be comfortable analyzing data requirements, documenting data flows, supporting data design activities, and ensuring that proposed data solutions align with business objectives. Prior finance or financial services experience is mandatory, along with practical experience working with Databricks. Key Responsibilities Engage with business stakeholders to gather, analyze, and document business and data requirements. Translate business requirements into functional specifications, data requirements, and design documentation. Work with Databricks-based data platforms to understand data structures, data flows, and processing requirements. Analyze source systems, data elements, data dependencies, and data transformation requirements. Support the design and documentation of data models, mappings, and data integration workflows, as required. Collaborate with data engineers, architects, developers, and QA teams to ensure requirements are clearly understood and implemented. Perform data analysis and support data validation, reconciliation, and issue resolution. Identify gaps, dependencies, and inconsistencies in data requirements and work with stakeholders to resolve them. Support functional testing, user acceptance testing (UAT), and business sign-off. Maintain clear documentation of requirements, data definitions, business rules, and design decisions. Required Qualifications and Skills 5–7 years of experience in a Business Systems Analyst (BSA) or similar business and data analysis role. Hands-on experience with Databricks. Mandatory experience in finance or financial services. Strong skills in business requirements gathering, analysis, and documentation. Ability to translate business needs into functional and data-related specifications. Experience working with data structures, data mapping, data flows, and data validation. Strong analytical, problem-solving, communication, and stakeholder management skills. Ability to work effectively with both business and technical teams. Preferred Qualifications Experience supporting data transformation, data integration, or data platform initiatives. Familiarity with SQL and relational database concepts. Experience with data modelling, data mapping, and data quality activities. Experience preparing functional specifications, process flows, and UAT documentation. Ideal Candidate A business-focused Data Designer/BSA who understands financial services processes, has practical Databricks experience, and can bridge the gap between business requirements and technical data implementation. Recommended screening criteria  Requirement Data Engineer Data Designer / BSA Experience 5–7 years development 5–7 years BSA Databricks Mandatory Mandatory Azure databases Mandatory Not specified Oracle Mandatory Not specified Python Mandatory Not specified Finance experience Not specified Mandatory AI experience Preferred Not specified Core focus Coding, pipelines, data processing Requirements, data design, business-technology alignment

What you’ll do

Gather and document business and data requirements, translating them into functional specifications, data mappings, and design documentation for Databricks-based platforms. Collaborate with business and technical teams on data analysis, validation, testing, issue resolution, and business sign-off.

Requirements

Requires 5–7 years of experience in a Business Systems Analyst or similar role, hands-on Databricks experience, and mandatory finance or financial services experience. Candidates should be skilled in requirements documentation, data structures and flows, data mapping and validation, and stakeholder collaboration; SQL and data integration experience are preferred.

Listed skills

• SQL · Preferred
• Data Validation · Preferred
• Business Requirements Gathering · Preferred
• Stakeholder Management · Preferred

Other relevant skills

Identified from the job description. Confirm important requirements above.

• Business Requirements Gathering
• Requirements Analysis
• Functional Specifications
• Data Requirements
• Databricks
• Financial Services
• Data Structures
• Data Mapping
• Data Flows
• Data Validation
• Data Modeling
• Data Integration
• SQL
• Stakeholder Management
• User Acceptance Testing
• Data Quality

Job areas

• Data & Analytics
• Technology
• Finance & Accounting
• Consulting