Data Analyst - Kanata, Canada - BP & M Government IM & IT Consulting Inc.

BP & M Government IM & IT Consulting Inc.
BP & M Government IM & IT Consulting Inc.
Verified Company
Kanata, Canada

6 days ago

Sophia Lee

Posted by:

Sophia Lee

beBee Recruiter
Description

Position
Data Analyst


We are looking for Data Analyst Services to support work for transformation of current data processes for International Financial Reporting Standard (IFRS) 9 models to a modernized and governed Information Technology (IT) environment.


Roles and Responsibilities
The Data Analyst Services will be analyzing various data sources that currently feed the IFRS9 model.

The bulk of the work will involve tracing source data, reverse engineering, examining current ETL jobs and reviewing SAS EG transformation rules that are in use to support data flow to the IFRS9 model.

The Data Analyst provider will work closely with a Data Architect to re-design automated processes for the collection, cleansing and transformation of data to generate a csv file that will be used by a replacement model.


  • Strong analytical skills with the ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy.
  • Demonstrated experience in SQL programming is required.
  • Demonstrated experience in SAS EG programming
  • Strong knowledge and demonstrated experience in current and future state data mapping.
  • Identify qualified/approved records for system upload.
  • Identify and resolve discrepancies (format, content, values).
  • Work with business team members on resolving quality issues.

Qualifications and Skills

  • Experience with Azure Data Platform technologies or other public cloud offerings
  • Programming experience: SQL, R, Python
  • Experience with Databricks
  • Excellent verbal and written communication, critical thinking, time management, priority planning and interpersonal skills.
  • Ability to understand and interpret requirements and design documents
  • Ability to write and maintain documentation
  • Experience working in an Agile environment/team
  • Experience with Moody's Analytics or Moody's data
  • Greater than 5 years of SQL development and refactoring existing SQL

Job Requirement

  • Must have security Clearance: Reliability or Secret
  • Bilingualism in both official languages (English and French) would be an asset

Location:


  • National Capital Region (NCR): Ottawa-Gatineau Region
  • This role may include a hybrid depending on the client's requirements

Schedule:

  • 8 hour shift
  • Monday to Friday

Work Location:
Hybrid remote in Kanata, ON K2K 3E7
More jobs from BP & M Government IM & IT Consulting Inc.
See all jobs of BP & M Government IM & IT Consulting Inc.