Data AnalystTundra Talent Community • Ottawa, ON, Canada (Remote)

Data Analyst

Tundra Talent Community • Ottawa, ON, Canada (Remote)

30+ days ago

Job type

Full-time

Remote

Job description

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

Create a job alert for this search

Data Analyst • Ottawa, ON, Canada (Remote)

Similar jobs

Senior Data Engineer

Systematix • Greater Ottawa Metropolitan Area, Canada

Full-time

We are Systematix and we are looking for a.The ideal candidate must already possess a security clearance at the Reliability level (Level I) or higher. The expected start date for this 1-year contrac...Show more

Last updated: 18 days ago • Promoted

Senior BI Analyst

Targeted Talent • Ottawa, ON, Canada

Permanent

We are looking for an experienced.Our client is a global enterprise company with a product that you've likely used.This is a really exciting opportunity to work for a company whose product is u...Show more

Last updated: 30+ days ago • Promoted

Data Analytics Intern

SalesPilot 365 | CRM • ottawa, on, ca

Full-time

As part of our expansion into Data Analytics, we’re offering a structured internship program for motivated individuals eager to build a career in data-driven decision-making.Join our analytics team...Show more

Last updated: 19 days ago • Promoted

Business Analyst

Exposant 3 • Gatineau, Quebec, .CA

Full-time

Quick Apply

Join Exposant 3 (E3) : The Power of People at the Heart of Technology.Exposant 3 is a trusted digital transformation partner supporting numerous public sector organizations across Quebec and Canada....Show more

Last updated: 30+ days ago

Business Analyst

freelance.ca • Gatineau, Canada

Full-time

At the company, we believe in a human-centered and responsible approach to consulting.Trust, expertise, and collective success are at the core of our values. Joining E3 means more than securing a ma...Show more

Last updated: 30+ days ago • Promoted

Clinical Business Analyst - ottawa

Odyssey Global • ottawa, on, ca

Full-time

Role : CIS Clinical Business Analyst - Documentation(RQ00262 - DH).Client : Department of Health, New Brunswick.Work Model : Remote + monthly travel to New Brunswick (mandatory).The Department of Heal...Show more

Last updated: 1 day ago • Promoted

Data Architect

Talent To Hire Inc. • Ottawa, ON, Canada

Full-time

The ideal candidate will be responsible for designing, creating, and managing the organization’s data architecture and infrastructure to support data analytics and business intelligence initi...Show more

Last updated: 30+ days ago • Promoted

Data Analyst (Marketing)

CIRA • Ottawa, ON, Canada

Full-time

CA and Registry team at CIRA and help shape what it means to be Canadian in the digital world! Our.CA domain is more than a web addressit's a symbol of Canadian pride and a cornerstone of our n...Show more

Last updated: 30+ days ago • Promoted

Intelligence Mission Data Systems Analyst

ADGA Group Consultants Inc • Ottawa, ON, Canada

Full-time +1

ADGA is hiring an Intelligence Mission Data Systems Analyst to support the Options Analysis and Definition phase activities for our defence client on their Intelligence Mission Data (IMD) project.T...Show more

Last updated: 18 days ago • Promoted

Python ETL Developer / Data Engineer - Remote

ipvisibility • Ottawa, ON, Canada

Remote

Full-time

Reviewing, designing, developing ETL jobs to ingest data into Data Lake, load data to data marts;.Parse unstructured data, semi structured data such XML etc. Design and develop efficient Mapping and...Show more

Last updated: 30+ days ago • Promoted

Data Engineer

TULLOCH • Ottawa, ON, Canada

Full-time

We want to build an organization where everyone loves their job and their leaders care for them.Over the last 30 years, TULLOCH has built a robust multi-disciplinary consulting engineering firm rec...Show more

Last updated: 30+ days ago • Promoted

Senior Programmer Analyst

Hays • Ottawa, ON, Canada

Full-time

Programmer / Analyst – Level 3 • •.Reliability / Secret (as applicable).Programmer / Analyst – Level 3.Candidates must hold or be eligible to obtain a Government of Canada security clearance.The Prog...Show more

Last updated: 1 day ago • Promoted

Clinical Business Analyst

Odyssey Global • gatineau, qc, ca

Full-time

Last updated: 1 day ago • Promoted

ERP & Data Integration Specialist — Public Sector

FreeBalance Inc. • Ottawa

Full-time

A global technology firm located in Ottawa is seeking a Technical Services Consultant to support public financial management initiatives. The ideal candidate will have a strong background in ERP imp...Show more

Last updated: 15 days ago • Promoted

Data Analytics Intern - ottawa

SalesPilot 365 | CRM • ottawa, on, ca

Full-time

Last updated: 19 days ago • Promoted

Data Architect

TEEMA Solutions Group • Ottawa

Full-time

Responsibilities may include, but are not limited to : .Collaborate with internal and external stakeholders (Business, IITB, System Integrators) to understand data requirements and use cases for proj...Show more

Last updated: 15 days ago • Promoted

Senior Data Analytics & Governance Consultant

KPMG LLP Canada • Ottawa

Full-time

A leading consulting firm in Ottawa is seeking a Senior Consultant for Governance, Risk and Compliance Services (GRCS) focused on Data Analytics. The successful candidate will support cross-function...Show more

Last updated: 15 days ago • Promoted

GIS analyst - ottawa

TALENDICA • ottawa, on, ca

Full-time

Location : New Brunswick, Canada (Remote).Use world class software to prepare and deliver high quality spatial information products. Use maps and data sets for spatial analysis to support business de...Show more

Last updated: 4 days ago • Promoted