Business System Analyst
- Toronto, ON, Canada
$45 to $50 CAD / hour · Contract
Applications open in a new tab.
Job details
- Pay
- $45 to $50 CAD / hour
- Job type
- Contract
- Apply by
- Posting language
- English
- Posted
Original job description
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.
More about this job
Responsibilities
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.
Skills
- 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
Visa sponsorship
Not detected in the job text
Categories
- Data & Analytics
- Technology
- Software
- Consulting
Keywords
- PL/SQL
- T-SQL
- Query Optimization
- Data Modeling
- Industry-Standard Modeling Tools
- Gap Analysis
- MS Visio
- Data Warehousing
- ETL Processes
- Source-to-Target Data Mapping
- Requirements Gathering
- Stakeholder Workshops
- Business Teams
- Technology Teams
- Data Analysis
- Data Profiling
- Legacy System Analysis
- Technical Documentation
- Banking Data
- Customer Data
- Account Data
- Transaction Data
- Sybase PowerDesigner
- Amazon AWS
- Data Governance
- Data Quality Frameworks
- L2/L3 Data Models
- Enterprise Data Warehouse