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
Intermediate Systems Analyst
MaxSys Staffing and ConsultingOttawa, ON
Full-time
MaxSys is looking for an Intermediate Systems Analyst for their client in the west end of Ottawa.Assists in the evaluation of client area applications systems / programming requirements (e.New, enhan...Show moreLast updated: 30+ days 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: 26 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: 2 days ago
Administrateur base de données SQL Server Senior
Exposant 3Gatineau, Quebec, .CA
Full-time
Quick Apply
Rejoignez Exposant 3 (E3) : La puissance de l’humain au cœur de la technologie !.Exposant 3 est une firme de services-conseils en gestion des affaires et technologies de l'information, dédiée à acc...Show moreLast updated: 19 days ago
Circuit Analyst
TechInsightsOttawa, ON, CA
Permanent
Quick Apply
OUR STORY TechInsights is the information Platform for the semiconductor industry.Regarded as the most trusted source of actionable, in-depth intelligence related to semiconductor innovation and su...Show moreLast updated: 30+ days ago
Business Analyst
BGISNepean, ON, Canada
Full-time
BGIS is a leading provider of customized facility management and real estate services.With our combined team of over 6, 500 globally, we relentlessly focus on enabling innovation through the servic...Show moreLast updated: 30+ days ago
Financial Analyst
Modern NiagaraOttawa, ON KMG, CA
Full-time
The Financial Analyst supports the Accounting & Finance department in Ottawa by managing financial reporting, analyzing project performance, and collaborating with operations teams to achieve key b...Show moreLast updated: 30+ days ago
Remote Senior SQL Engineer - AI Trainer
SuperAnnotateNepean, Ontario, CA
Remote
Full-time
As a Senior SQL Engineer, you will work remotely on an hourly paid basis to review AI-generated SQL queries, database designs, and data-processing logic, as well as generate high-quality reference ...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: 23 days ago
Threat Hunting & Detection Content Analyst
CGIOttawa
Full-time
The Global Security Operations Center (GSOC) Threat Hunting & Detection Content Engineering Analyst contribute to strengthening our security posture on multiple facets by developing and maintaining...Show moreLast updated: 30+ days ago
Software / Systems Analyst
John Clements Consultants, IncNATIONAL CAPITAL REGION
Full-time
We are looking for someone with strong analytical and solid collaborative skills to support the enhancement requirements, non-production and production processes and fixes of the application.The ca...Show moreLast updated: 30+ 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: 10 days ago
People also ask
The cities near Ottawa, ON that boast the highest number of sql 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