Business Systems Analyst (Data Warehouse & Data Modelling)
Temporary
Astra North Infoteck Inc.
Job Title: TSBI / Business Systems Analyst (Data Warehouse & Data Modelling)
Location: Toronto, ON – Hybrid (2 Days/Week Onsite)
Experience Required: 6–8 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.
Vacancy posted 1 day ago
Similar jobs that could be interesting for youBased on the Business Systems Analyst (Data Warehouse & Data Modelling) in Toronto, ON vacancy
$80k - $85k per year
About the role: Do you love diving into data, solving problems with tech, and learning how fintechs get funded by lenders... ...growing organization, we want to hear from you! As the Analyst, Business Analytics & Modeling, you’ll work under the direction of the VP – FP&A to deliver...SuggestedFull timeInternshipWork at officeFlexible hours$75.9k - $141.9k per year
...Technology About the team Data and AI Technology (DAT)... ...Capital Markets, Personal and Business Banking, Global Asset Management... ...and output data Create data models and mapping documents Provide... ...coaching, and guidance junior analysts Strengthen development capability...SuggestedFull timeContract workPart time- ...through delivery • Gather requirements from multiple non-technical business and operations stakeholders • Create process maps (as-is and to-... ...pain points and converting them into requirements AI & Model Tools • Hands-on experience in using AI tools (GitHub,...Suggested
- ...Job Responsibility: CGI is looking for Business Systems Analyst to work on a range of challenging assignments related to the evolution of a variety... ...estimates Document Product Knowledge artefacts Product Data structure analysis and recommendations Review Test cases...SuggestedFull timeWork at office2 days per week
$105.24k - $146.19k per year
...reporting to the Senior Enterprise Technical Lead, the Senior Business & Systems Analyst will provide aid to the Business in determining the... ...divisional operating budget based on the divisional system uploaded data and integrates variance reporting with the divisional...SuggestedPermanent employmentFull timeContract workMonday to fridayShift work- ...years We are looking for a Senior Business Analyst with Project Management experience to lead... ..., datasets, dashboards) Perform data validation, reconciliation, and UAT coordination... ...experience in Power BI (DAX, data modeling, reporting) Good understanding of Tableau...
- ...in developing the technical, business and professional skills needed... ...requirements, business rules and data sources. Pro-actively... ...engineers and other business analysts, to ensure that projects are delivered... ...analysis and requirements modeling tools, such as data flow diagrams...Full timeFlexible hours
$95k - $145k per year
Sr. Payments Business Systems Analyst Position Description This role is hybrid and requires you to be at a Client office at a minimum 4 days... ...including system components, . functionality, interfaces, data flows, and business rules . Advanced to Expert knowledge of...Work at office- ...Business System Analyst with experience in Faster Payments or Retail Payments, focusing on API and microservices-based applications. Required... ...stakeholder communication skills * Experience in Agile delivery model * Knowledge of ISO 20022 / real-time payments *...Contract work
- ...Procurement Tech seeks an experienced Senior Business Analyst to support the business analysis... ...Analyze and document detailed business and system solution requirements using enterprise standard... ...SQL to query and analyze business data to support requirements validation and business...Full timeFlexible hours
- ...shape your future at Questrade. What's it like working as a Business Systems Analyst at Questrade? At Questrade, we bring digital solutions into our... ...Develop acceptance criteria, assist in testing, and provide data analysis on proposed and ongoing initiatives. Communicate...Full timeWork at officeFlexible hours
$81 - $95 per hour
...global entity, is currently looking for a Senior Business Analyst to work in their Finance Transformation and Systems team. This is a 6 month opportunity and pays approximately... ...into clear documentation. You will also perform data queries, data analyses, challenge requirements,...$80k - $130k per year
...managers and recruitment teams. Your role, your impact As a Business System Analyst, Capital Markets, you’ll work closely with various... ...; Proven experience working with SQL, including querying, data analysis, and troubleshooting; Experience with regulatory...Flexible hours$114k - $143k per year
...About The Team Turo is looking for a Senior Data Analyst to join our Business Intelligence team in Canada. You will be the technical lead for our BI... ...Curiosity: You are naturally curious with a knack for technical systems. You proactively use AI to accelerate development and are...Long term contractFull timeFixed term contractWork at officeLocal area3 days per week- ...Your Role in Supporting Our Members: As a Systems Analyst, you will act as a key liaison between business stakeholders and technology teams, translating business... ...a focus on Payments & Compliance Technology • Data driven mindset, with an ability to analyze transaction...Full timeContract workWork at officeShift work
- ...Description We are seeking an experienced Enterprise Data Modeler with strong expertise in Insurance Data Modeling and ACORD... ..., normalization, scalability, and integration across systems Map business requirements to ACORD-compliant data structures Apply and...
$72k - $138k per year
...Job Type: Permanent Work Model: Hybrid Reference code: 133349 Primary Location... ...opportunity. It builds consumer and business confidence, empowers organizations to... ...Consultant to join our team as a Data Scientist / Power Systems Analyst. This role is ideal for a professional...Permanent employmentFull timeFlexible hours- ...Job Summary: We are seeking a highly skilled Business Systems Analyst to join our team, focusing on designing and implementing technical integrations... ..., mitigating financial and reputational risk to firms · Data analysis and Data Mapping – Must have good experience working...Contract work
$80k - $130k per year
Senior Business Systems Analyst (AML) Position Description This role is hybrid and requires you to be at our downtown Toronto and/or Client office... .... AML, Fraud, Transactions screening, detection . Data Management – Data Quality, Data completeness and...Work at office- ...Integration, e-Transfer upgrade Job Description Business System Analyst / Analyst Digital Platform Are you someone who thrives... ...Identify, analyze and interpret patterns and trends in complex data sets to diagnose data quality and integrity issues and...Flexible hours
$80k - $130k per year
Senior Business System Analyst (Lending-Mortgage) Position Description This role is hybrid and requires you to be at our downtown Toronto and... ...system integration planning. o Support API requirements, data mapping, and downstream/upstream system alignment. 3. Stakeholder...Work at office3 days per week$58.74 - $65.44 per hour
We are seeking an experienced Business Systems Analyst to lead the requirements and analysis phase for a web-based modernization project. This initiative involves migrating legacy data management systems to a new digital solution to improve the collection, storage and distribution...Remplacement$80k - $130k per year
Business Systems Analyst (Contact Center) Position Description This role is hybrid and requires you to be at our downtown Toronto and/or Client... ...(BRDs), functional specs, and user stories • Develop data mapping sheets for system integrations and transformations...Work at office2 days per week$75 per hour
Our client is looking for a Business System Analyst to join a major system migration initiative, transitioning a Fixed Income trading platform from... ...Business Systems Analyst to support system the migration, data flows, testing, and implementation while working directly with...Contract workWork at office2 days per week3 days per week- ...Role: Business System Analyst (DWH) – PL/SQL, ETL Key Skills: Data Modeling, Banking Domain MUST HAVE Skills: • Strong knowledge of PL SQL / T-SQL • Experience in Data Modelling (any designer tool), Gap analysis, and MS Visio • Good understanding of...Contract work
- ...be based in North York, Ontario, M3J 2W3** The WMS Analyst II role has a national salary range of $62,000 - $75... ...-savvy problem solver with a passion for optimizing warehouse management systems? Do you love analyzing data and collaborating with cross-functional teams to...
$50 per hour
Are you a Business Systems Analyst "BSA" looking for your next gig and enjoy going into the office vs. working from home? If so let us know as we have a client that is looking to add to their team, a Business Systems Analyst for an initial term of 6 months. There is a strong...Contract workWork at officeWork from home- ...Chequeing registered product Systems Analyst specializing in Non-Functional Requirements... ..., acting as a technical bridge between business stakeholders, development teams, and IT... ...regulatory, and organizational standards for data integrity, security, and accessibility....
$80k - $130k per year
Business System Analyst - Payments (Host to Cloud) Position Description We are looking for a Business Systems Analyst with strong experience... ...requirements across payments systems (SWIFT, EFT, etc.) - Perform data mapping, integration analysis, and support system design -...Work at office$119k per year
...The Opportunity The Senior Specialist, Data Modeler (Microsoft) is responsible for designing... ...plays a critical role in enabling business intelligence, operational efficiency, and... ...closely with data scientists, developers, analysts, and business stakeholders, the Senior Specialist...Permanent employmentFull timeWork at office
Do you want to receive more vacancies?
Subscribe and receive similar vacancies to Business Systems Analyst (Data Warehouse & Data Modelling). Be the first to apply!
Related searches
- business systems analyst Toronto, ON
- analyste d’affaire Toronto, ON
- junior business system analyst Toronto, ON
- data analyst excel Toronto, ON
- entry level data analyst no experience Toronto, ON
- stage data analyst Toronto, ON
- clinical data analyst Toronto, ON
- remote data analyst Toronto, ON
- data analyst part time Toronto, ON
- data analyst remote working Toronto, ON