Business System Analyst

Job summary

Conduct requirements-gathering sessions and stakeholder workshops across business and technology teams, and perform data analysis, profiling, and legacy system analysis. Support large-scale data initiatives through data modeling, gap analysis, source-to-target mapping, and technical documentation.

Job details

Pay Range: CAD 45-50/hr 5 Mandatory Must-Have Skills and Experience Strong PL/SQL and T-SQL development and query optimization skills. Experience in Data Modelling using industry-standard modeling tools, Gap Analysis, and MS Visio. Strong understanding of Data Warehousing concepts, ETL processes, and source-to-target data mapping. Proven experience conducting requirement-gathering sessions and stakeholder workshops across business and technology teams. Experience in data analysis, data profiling, legacy system analysis, and technical documentation within large-scale data initiatives. 5 Nice-to-Have Skills and Experience Knowledge of banking domain data, including customer, account, and transaction data. Experience with Sybase PowerDesigner for data modeling. Knowledge of cloud technologies such as Amazon AWS. Familiarity with data governance and data quality frameworks. Experience supporting L2/L3 data models and enterprise data warehouse environments.

What you’ll do

Conduct requirements-gathering sessions and stakeholder workshops across business and technology teams, and perform data analysis, profiling, and legacy system analysis. Support large-scale data initiatives through data modeling, gap analysis, source-to-target mapping, and technical documentation.

Requirements

Requires strong PL/SQL and T-SQL development and query optimization skills, along with experience in data modeling, data warehousing, ETL, and source-to-target mapping. Candidates must also have experience gathering requirements, facilitating stakeholder workshops, analyzing data and legacy systems, and producing technical documentation.

Listed skills

• Technical Documentation · Preferred
• Data analysis · Preferred
• Requirements gathering · Preferred

Other relevant skills

Identified from the job description. Confirm important requirements above.

• PL/SQL
• T-SQL
• Query Optimization
• Data Modeling
• Gap Analysis
• MS Visio
• Data Warehousing
• ETL
• Source-to-Target Data Mapping
• Requirements Gathering
• Stakeholder Workshops
• Data Analysis
• Data Profiling
• Legacy System Analysis
• Technical Documentation
• Sybase PowerDesigner

Job areas

• Data & Analytics
• Technology
• Software
• Consulting

More jobs from LanceSoft, Inc.