Tundra Talent CommunityOttawa, ON, Canada (Remote)
Remote
Full-time
This work will require Reliability status.The services of an experienced Data Analyst Services are required to support work for transformation of current data processes for IFRS9 models to a modern...Show moreLast updated: 30+ days ago
Senior Systems Analyst
Brookfield RenewableGatineau, QC J8XA1, CA
Full-time
The System Analyst will be a Digital Insights team member, responsible for responsible for designing and implementing cloud-based data solutions using various technologies such as Fabric, Fabric Da...Show moreLast updated: 30+ days ago
Data Engineering Lead and Data Engineers
Alltech Consulting ServicesOttawa
Full-time
This position is for a Cloud Data engineer with a background in Python, Pyspark, SQL and data warehousing for enterprise level systems.
The position calls for someone that is comfortable working wit...Show moreLast updated: 30+ days ago
SAP Senior Data Governance Analyst
Curtiss-WrightOttawa, Canada
Full-time
Senior Data Governance Analyst (SAP) - Onsite.We are looking for a highly skilled and experienced.Ottawa, ON! You will have expertise in SAP master data management, and a deep understanding of data...Show moreLast updated: 1 day ago
Senior Systems Analyst (SQL)
Recruiting In MotionGatineau, QC
Full-time
Hybrid - 4 days per week onsite.Our client is seeking is seeking two.Digital Insights team to play a critical role in designing, building, and optimizing cloud-based data solutions that enable high...Show moreLast updated: 25 days ago
Data Analyst
E-SolutionsOttawa, ON
Full-time
Role : Senior Site Reliability Engineer.Location : Richmond, BC, VX G, Canada (Hybrid).Senior Site Reliability Engineering Job Requirements.
The Sr Cloud Engineer / Sr Site Reliability Engineer is a m...Show moreLast updated: 30+ days ago
Intermediate Investment Performance Analyst to gather investment data and commentary from across the organization and report on industry trends for our investment client.
S.i. SystemsOttawa
Full-time
Intermediate Investment Performance Analyst to gather investment data and commentary from across the organization and report on industry trends for our investment client.
As an Investment Performanc...Show moreLast updated: 1 day ago
Senior, Data Analyst
CMHCOttawa, ON, CA
Full-time +1
Ottawa (ON); Calgary (AB); Halifax (NS); Montreal (QC); Toronto (ON); Vancouver (BC).Language Skill Levels (Read / Write / Speak) : .
Our salaries generally range from $ 71761.The work you do and the work...Show moreLast updated: 30+ days ago
Geophysicist / Data Analyst
Sander Geophysics LimitedOttawa, ON
Full-time
Sander Geophysics is currently seeking early career geophysicists to join the growing team to work at the head office location in Ottawa, Ontario, Canada, and also at our global field project locat...Show moreLast updated: 30+ days ago
Intelligence Mission Data Systems Analyst
ADGA Group Consultants IncOttawa, 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 moreLast updated: 2 days ago
Senior Data Analyst
LumentumOttawa, Canada
Full-time
It's fun to work in a company where people truly BELIEVE in what they're doing!.Lumentum Canada was awarded the 2022 National Capital Region’s Top Employers and the 2022 Career Directory Canada’s B...Show moreLast updated: 30+ days ago
Accounting Analyst
American Iron and MetalOttawa, Ontario, Canada
Full-time
Your work will enhance reporting quality and support operational decision‑making.Preparing, reviewing, and reconciling financial statements, bank accounts, and complex balance sheet accounts to ens...Show moreLast updated: 21 days ago
Senior Technology Architect - SAP BusinessObjects and Power BI
Randstad CanadaGloucester, Ontario, CA
Temporary
Quick Apply
We are seeking a Senior BI Architect / Programmer Analyst with extensive experience in Power BI and SAP BusinessObjects to lead enterprise reporting and analytics initiatives.The role includes desi...Show moreLast updated: 8 days ago
business data analyst
Ontario InternationalNepean, ON, CA
Full-time
Heures de travail : 70 hours bi-weekly.Research and development institution.Information technology (IT) infrastructure.Document technical requirements to ensure that products, processes and solution...Show moreLast updated: 7 days ago
People also ask
The cities near Ottawa, ON that boast the highest number of sql data analyst jobs are:
Tundra Talent CommunityOttawa, 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