Business Analyst

Role: Business Analyst

Location: Toronto, ON (Hybrid)

Contract

Job Description:

MUST HAVE skills/experience:

· Strong knowledge PL SQL/T-SQL

· Having experience in Data Modelling (Any designer tool), Gap analysis and MS Visio

· Good understanding in Data warehousing concepts and ETL Process

· Drive the requirement session/meetings with various stakeholders.

NICE TO HAVE skills/experience:

· Knowledge in Banking domains. Like regular account, customer data and transaction data in various banking business process

· Sybase Power designer for data modeling.

· Having knowledge in Cloud Technologies if any (like Amazon AWS)

Role and Responsibilities

· Determines operational objectives by studying business functions; gathering information; evaluating output requirements and formats.

· Designs, analyzing requirements and designing modifications.

· Defines project requirements by identifying project milestones, phases, and elements, forming project team.

· Monitors project progress by tracking activity; resolving problems; publishing progress reports; recommending actions.

· Provides references for users by writing and maintaining mapping documentation.

· Maintains user confidence and protects operations by keeping information confidential.

· Prepares technical Design and mapping by collecting, analyzing and data profiling.

· Maintains professional and technical knowledge by attending workshops.

· Working with business and technology teams to fulfill their data needs.

· Data Modelling, technical design documentation as per standard.

· Assess intake requests for new projects, change requests.

· Strong knowledge in SQL and analysis data from different product system.

Detailed breakdown:

Analyze of Legacy System:

For each Use Case, analyze the Mapping document of target table to determines operational objectives by studying business functions, gathering information and evaluating output requirements.

Track the target field mapping back to origin data element in the source system.

Having strong knowledge in SQL to perform data analysis and data profiling on different Legacy system.

Document the existing source to target data flow for each table, which includes.

Business transformation rule applied.

Key-Cutting implemented to identify surrogate key that is defined as a unique identifier in a table.

Reference data used to enhance the context and validity of target data elements.

For tables where mapping document is not available, TSBI and ETL leads jointly must go over the code to extract the business rules applied and capture them into the requirement document.

L2/L3 Model:

Business team would be responsible for the creation of L2 Model supported by Project Business Analyst, Solution Architect and TSBI

Collaborate with data scientists, business analysts, and IT teams to integrate advanced L2/L3 models into the data pipeline.

Mapping Design of New L2/L3:

· Prepares technical Design and mapping (Data Movement Model) for the new L2 Model by working with Project Business Analysts and Solution Architect.

· Review the Key Cutting process to be implement on the L2 model and get approval from L2 Schema Owners.

· Only BORT System data would be populated into L2 schema, other reference and tactical data would directly be consumed by L3 processes.

· L2 to L3 mapping would contain the Business transformation rules for each target table.

· Custom Surrogate Key process would be implemented on L3 tables, which would contain different keys than L2 tables.

· Any system having one-off tables holding business data would be loaded into L3 schema for target table processing.

· Spearheaded the implementation of robust data governance policies and procedures, ensuring compliance with industry regulations and standards, resulting in a 20% reduction in data security incidents.

· Collaborate with cross-functional teams to design and implement data quality frameworks, improving data accuracy and integrity, and reducing errors. Job type: Contract Division: eTeam - Canada Category: eTeam Canada Reference: 26-49155