Data Analysis REMOTE

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