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 Power
BI reporting tool
• Experience with ETL Data Stage
Other
Skills Required:
• Experience with Azure Data Platform technologies or other public cloud offerings
• Experience with Info Sphere Data Stage
• 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
To Search, View & Apply for jobs on this site that accept applications from your location or country, tap here to make a Search: