Business Systems Analyst (Data Warehouse & Data Modelling)
Job Location:
Monthly Salary:
Experience Required:
Posted on:
Vacancies:
Job Summary
Job Title: TSBI / Business Systems Analyst (Data Warehouse & Data Modelling)
Location: Toronto ON Hybrid (2 Days/Week Onsite)
Experience Required: 68 Years
Domain: Banking / Capital Markets
Role Summary
We are seeking an experienced TSBI / Business Systems Analyst with strong expertise in Data Modelling Data Warehousing SQL ETL Processes and Banking Data Systems.
The ideal candidate will work closely with business and technology teams to analyze legacy systems create mapping documents support L2/L3 data model design and drive data integration initiatives across enterprise banking platforms.
Must Have Skills
- Strong expertise in:
- PL/SQL
- T-SQL
- SQL Data Analysis
- Experience with:
- Data Modelling
- Gap Analysis
- MS Visio
- ETL Processes
- Data Warehousing Concepts
- Ability to:
- Conduct requirement gathering sessions
- Drive stakeholder meetings
- Create technical mapping documentation
- Perform data profiling and analysis
Nice to Have Skills
- Banking domain knowledge including:
- Customer Data
- Account Data
- Transaction Data
- Experience with:
- Sybase PowerDesigner
- AWS / Cloud Technologies
Key Responsibilities
- Analyze legacy systems and source-to-target mappings for enterprise data platforms.
- Perform data analysis and profiling using SQL across multiple source systems.
- Design conceptual logical and physical data models.
- Prepare technical design documents and mapping specifications.
- Support L2/L3 data model creation and integration processes.
- Identify business transformation rules and surrogate key implementation strategies.
- Collaborate with Business Analysts Architects ETL teams and stakeholders.
- Develop and maintain mapping documentation data flow diagrams and governance artifacts.
- Support enterprise data governance and data quality initiatives.
- Monitor project milestones risks and progress reporting.
- Drive data integration and optimization initiatives across banking systems.
- Ensure confidentiality and integrity of enterprise data assets.
Required Skills:
60-70
Required Education:
Backend Engineer Kotlin Microservices & AKSRole Overview:We are seeking a highly skilled backend developer with strong experience in modern programming languages and frameworks with primary expertise in Kotlin and exposure to Java microservices and cloud Skills:Proficiency in Kotlin with additional experience in Java (Spring Boot Spring Security) and JavaScript () 5 years of backend development experience including: oUnit testing frameworks (e.g.
