Title: Business System Analyst/TSBI Location: Toronto, ON Duration: 06-12 months Work Arrangement: Hybrid: 2 days per week in office Job Description: Skills Data Concepts & Data Modelling Data Warehouse MySQL Experience Required 6-8 years Must-Have Skills/Experience Strong knowledge of PL SQL/T-SQL Experience in Data Modelling (Any designer tool), Gap analysis, and MS Visio Valuable understanding of Data warehousing concepts and ETL Process Ability to drive requirement sessions/meetings with various stakeholders Nice-to-Have Skills/Experience Knowledge in Banking domains, including regular account, customer data, and transaction data in various banking business processes Experience with Sybase Power Designer for data modeling Knowledge of Cloud Technologies, such as Amazon AWS Role and Responsibilities Determine operational objectives by studying business functions, gathering information, and evaluating output requirements and formats Design and analyze requirements and design modifications Define project requirements by identifying project milestones, phases, and elements, and forming project teams Monitor project progress by tracking activity, resolving problems, publishing progress reports, and recommending actions Provide references for users by writing and maintaining mapping documentation Maintain user confidence and protect operations by keeping information confidential Prepare technical design and mapping by collecting, analyzing, and data profiling Maintain professional and technical knowledge by attending workshops Work with business and technology teams to fulfill their data needs Conduct data modeling and create technical design documentation as per standards Assess intake requests for new projects and change requests Possess strong knowledge in SQL and analyze data from different product systems Detailed Breakdown Analyze of Legacy System For each Use Case, analyze the Mapping document of the target table to determine operational objectives by studying business functions,



gathering information, and evaluating output requirements Track the target field mapping back to the origin data element in the source system Possess strong knowledge in SQL to perform data analysis and data profiling on different Legacy systems Document the existing source to target data flow for each table, including: Business transformation rules 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 a mapping document is not available, TSBI and ETL leads must jointly review the code to extract the business rules applied and capture them into the requirement document L2/L3 Model The business team is responsible for the creation of the L2 Model, supported by the 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 Prepare 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 implemented 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 Implement a custom Surrogate Key process on L3 tables, which would contain different keys than L2 tables Load any system having one-off tables holding business data into L3 schema for target table processing Spearhead 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

📌 Hiring for Business System Analyst/TSBI! (Toronto)
🏢 Artech
📍 Toronto