Data Analysis REMOTE

Noramtec Consultants; Montreal; Remote; CAD 70,000 - 90,000; Full time

Job summary

A data consultancy firm is looking for a Data Analyst to conduct thorough data analysis and quality checks. Candidates must have over 5 years of experience in SQL programming and demonstrate expertise in data lifecycle management. The position offers a remote work option, allowing the successful candidate to communicate effectively with business stakeholders and deliver comprehensive reports. Familiarity with tools like Power BI and DataStage is essential for this role.

Qualifications

• Minimum 5 years experience in SQL programming.
• Strong knowledge of Data Quality Analysis required.
• Experience with two projects refactoring SQL code.

Responsibilities

• Communicate requirements and issues to stakeholders.
• Create and validate data models for compatibility.
• Deliver data analysis reports articulating quality dimensions.

Skills

SQL programming

Data Quality Analysis

Data modeling

ETL development

Power BI

R programming

Python programming

Spark SQL

Azure Data Platform

Information architecture

Tools

Power BI

DataStage

Job description

Overview

Data Analysis

REMOTE

Must be a 5-year permanent resident in Canada and undergo a security background check.

Ottawa, Ontario

Primary Responsibilities

Communicating requirements, issues, and options for resolutions to various stakeholders and tailoring messages to the audience.

Creates reviews and validates conceptual, logical, and physical data models of applications to determine compatibility and fit with architectural principles and optimal solution design.

Proposes standards, rules, guidelines, and principles for information analysis for the enterprise.

Other duties as required.

Specific Project Requirements

Over 7 years of demonstrated experience in SQL programming and refactoring

Strong knowledge and demonstrated experience in Data Quality Analysis is required.

Import source data files and save them to an internal file location for review, analysis, and auditing purposes.

Validate source files for completeness and quality of format, content location, and values.

Identify qualified / approved records for system upload.

Identify and resolve discrepancies (format, content, values).

Work with business team members on resolving quality issues.

Deliver data analysis reports that clearly articulate the data quality dimensions.

Generate status reports to stakeholders every week, and liaison with the Business Lead on data analysis results and reporting.

Skills

Top Skills Required

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.

• Must be able to demonstrate work experience (2 projects) refactoring existing SQL code to migrate to a new platform
• Data modeler with hands-on SQL development
• Experience with the PowerBI reporting tool
• Experience with ETL DataStage

Other Skills Required

• Experience with Azure Data Platform technologies or other public cloud offerings
• Experience with InfoSphere DataStage
• Experience with Spark SQL
• Programming experience : SQL, R, Python
• Experience with Power BI report development
• Understanding of the Denodo platform
• 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
• Ability to work independently on a medium-sized project with little technical oversite

Please send your technical resume to