Business Analyst with Big-Data HDFS, SQL

Date: 9 hours ago

City: Mississauga, Ontario

Contract type: Contractor

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

Responsibilities

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

Post a CV