Data Analyst

Tundra Talent Community
Ottawa, ON, Canada (Remote)
$56K-$60K a year (estimated)
Remote
Full-time

RequirementsContract Details Expected Start Date June 2024 Expected End Date June 2025 On-Site Requirement Remote Security Clearance Level Requirements : This work will require Reliability status.

Description of Service Data Analyst Services

The services of an experienced Data Analyst Services are required to support work for transformation of current data processes for IFRS9 models to a modernized and governed IT environment.

Primary 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.

Specific Project Requirements

  • 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.

Skills Top Skills Required :

  • Strong analytical skills with the ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy.
  • Well-rounded experience in the whole data lifecycle management and hands-on experience in the following data management domains : dimensional and relational data modeling, data quality, SQL programming (minimum 5 years), ETL development, metadata management and master data management, business intelligence and database administration.
  • Experience with reverse engineering the source to target mapping to gain data insights
  • Experience refactoring existing SQL code to new / alternate data sources.
  • Work experience with IFRS9 initiatives

Other Skills Required :

  • 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

Assets :

  • Experience working in an Agile environment / team
  • Experience with Moody’s Analytics or Moody’s data
  • Bilingualism in both official languages (English and French)
  • Greater than 5 years of SQL development and refactoring existing SQL

Job 70614

30+ days ago
Related jobs
Promoted
Canada Foundation for Innovation
Ottawa, Ontario

Reporting to the Director of Performance, Analytics and Evaluation (PAE) of the Canada Foundation for Innovation (CFI), the Data Analyst works closely with the Senior Evaluation Analysts to collect and validate data, conduct analyses and provide evidence-based reports to internal teams and external ...

Aritzia
Canada, Canada

Data Analyst, you will combine your deep understanding of who our clients are with your passion for data and masterful analytics skills to uncover opportunities that will enable Aritzia to create long lasting relationships with clients. The mission of the Data & Analytics Department is to provide th...

Empire Life
Any Canadian Location, CA

Data Analyst - Recent Graduate. Empire Life is looking to hire a recent graduate to join our team as a Data Analyst!. Working closely with cross-functional teams to understand data needs and contribute to data-driven strategies. Generating, evaluating and analyzing data and reports to ensure accurac...

hays-gcj-v4-pd-online
Ottawa, Ontario
Remote

...

Dentons
Canada

The Global Data Analyst is a crucial member of the Global Digital Data Services group, playing a pivotal role in leading the integration of data across all global business systems. Close collaboration with integration developers, solution designers, database administrators, and global/regional leade...

TELUS International
CA

A Day in the Life of an Online Data Analyst:. Completing research and evaluation tasks in a web-based environment such as verifying and comparing data, and determining the relevance and accuracy of information. ...

Peroptyx
Ottawa, Ontario

At Peroptyx, we are looking for Data Analysts who will review mapping data for digital mapping applications. ...

PlayStation
Canada
Remote

As a Senior Game Data Analyst, you will be working in our cross-disciplinary team to help game studios use data efficiently to improve games. We provide end-to-end analytics services for PlayStation Studios and use data to help them make their amazing games even better. Analysing data to deliver hig...

Treasury Board of Canada Secretariat
Ottawa, Ontario

You will leave the GC Jobs Web site.The job opportunity you have selected requires the Public Service Commission (PSC) to transfer you to the hiring organization's Web site or a service provider Web site they have selected to advertise this process.Select the link below to be transferred from the PS...

American Express Global Business Travel
Canada

Liaise with data development and business teams such as Revenue Management teams to enhance the understanding and use of data and analytics capabilities. Experienced in Insight/Data/MI Analyst. The position of Marketplace Optimization Analyst sits within the Air and Ground Transportation Team and is...