Hiring for Business System Analyst/TSBI!

• Data Concepts & Data Modelling
• Data Warehouse
• MySQL

6-8 years

• Strong knowledge of PL SQL/T-SQL
• Experience in Data Modelling (Any designer tool), Gap analysis, and MS Visio
• Good understanding of Data warehousing concepts and ETL Process
• Ability to drive requirement sessions/meetings with various stakeholders

• 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

• 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

• 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

• 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

• 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