Technical Business Analyst

Raas Infotek; Mississauga; On-site; CAD 80,000 - 100,000; Full time

Job summary

A leading company in financial services is seeking a Technical Analyst in Mississauga. The role requires expertise in RDBMS, data analysis, and strong communication skills. Candidates must possess 7+ years of experience, ideally in the Financial Service sector, and demonstrate an understanding of agile methodologies and data handling practices.

Qualifications

• 7+ years of relevant experience, preferably in Financial Services.
• Strong analytical and communication skills.
• Experience with large data volumes in Banking.

Responsibilities

• Work on data analysis and transformation logic.
• Assess data quality and resolve related issues.
• Collaborate with global teams and stakeholders.

Skills

RDBMS experience

Big Data HDFS

Complex SQL

Data analysis

Analytical skills

Documentation

Communication

Agile / Scrum

Education

7+ years relevant experience

Experience in Financial Service industry

Tools

GIT

JIRA

Job description

• Must have - Strong RDBMS experience : Oracle; SQL (Advanced), mongoDB(basic)
• Must have - Strong experience in use of Big Data HDFS based platform for data analysis and investigations
• Must have - Ability to write complex SQL needed to investigate data issues, repair damaged data, and migrate data to new structures
• Development of transformation logic to support the data acquisition and consumption requirements
• Assess the quality of data during development and test phases of the projects, and own the resolution of the data quality issues by working with development teams
• Work with consumption technology / business teams to provide standards-based solution
• Develop or enhance standards for logical and physical model development.
• Develop mappings of sources to target databases, including documentation of transformation rules.
• Communicate regularly with architects and modelers working in parallel tracks to maintain consistency of models and other deliverable
• Interact with globally diversified team spread over many international locations and time-zones
• Ensuring high quality software development, with complete documentation and traceability
• Resolve variety of high impact problems / projects through in-depth evaluation of complex business processes, system processes, and industry standards
• Working with business partners and other stakeholders to understand and document requirements
• Working with project managers and support teams to meet delivery targets

Qualifications :

• 7+ years of relevant experience preferably in the Financial Service industry and / or regulatory environments.
• Experience as Sr Business Analyst with very strong analytical skills
• Strong knowledge of industry practices and standards.
• Consistently demonstrates clear and concise written and verbal communication
• Confident engineer with an authoritative knowledge of Capital Markets Products like Equities, Fixed Income, FX, Commodities etc. (good to have)
• Agile / Scrum methodology experience is required
• Experience in SCMs like GIT and tools like JIRA
• Comfortable working with large data volumes and be able to demonstrate a firm understanding of logical data structures and analysis techniques

Skills & Technologies :

• Must have - Strong RDBMS experience : Oracle; SQL (Advanced), mongoDB(basic)
• Must have - Strong experience in use of Big Data HDFS based platform for data analysis and investigations
• Must have - Ability to write complex SQL needed to investigate data issues, repair damaged data, and migrate data to new structures
• Experience in large Data Warehouses or Big Data Lakes (30+ TB) and Front / Middle / Back-office systems
• Domain knowledge in Finance, Risk Management and / or Regulatory Reporting in the Banking industry
• Excellent written and oral communication skills, including use of Excel for presentation of data and mappings
• Passion to deliver results in a complex enterprise application / environment
• Able to work with global teams across different regions

Thanks

Prashant Bansal

Raas infotek corporation

262 Chapman road, Suite 105A, Newark, DE-19702

Technical Analyst • Mississauga, ON, Canada