Jobs.ca
Jobs.ca
Language
W3Global logo

Business Analyst with Big-Data HDFS, SQL

W3Global17 days ago
Mississauga, Ontario
Mid Level
contract

About the role

  • 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

About W3Global

Staffing and Recruiting
501-1000

W3Global is a leading provider of end-to-end consulting services, empowering businesses to achieve their strategic goals and optimize their operations. With over 15 years of experience, we have a proven track record of delivering innovative and effective solutions across a wide range of industries.

Our Mission

At W3Global, we are committed to helping businesses of all sizes achieve their full potential. We believe that by combining our deep industry expertise with our innovative approach, we can deliver exceptional results that exceed our clients' expectations.

Our Services

We offer a comprehensive suite of consulting services designed to address the specific needs of our clients. Our services include:

Strategy Consulting: We help businesses develop and implement winning strategies to achieve their long-term goals.

Business Process Improvement: We identify and optimize business processes to enhance efficiency, reduce costs, and improve customer satisfaction.

Technology Consulting: We provide expert guidance on technology selection, implementation, and integration to support business objectives.

Talent Acquisition: We help businesses find and hire the right talent to support their growth and success.

Human Capital Management: We provide comprehensive HR solutions to help businesses manage their workforce effectively.