Noramtec Consultants
Montreal, Quebec
Must be a 5-year permanent resident in Canada and undergo a security background check.Communicating requirements, issues, and options for resolutions to various stakeholders and tailoring messages ...Show more
OCPA
Fredericton, New Brunswick, CA
Product Testers are wanted to work from home nationwide in the US to fulfill upcoming contracts with national and international companies.We guarantee 15-25 hours per week with an hourly pay of bet...Show more
Audacity Capital
Canada
As a Remote Team Manager, you will oversee a dynamic team of professionals, ensuring effective collaboration and productivity in a remote environment.You will be responsible for guiding team member...Show more
Horizon North
Gogama, Ontario, Canada
With over 25 years of experience in the remote camp business, Outland is a leader in remote camp catering.Many of our applicants have been referred by existing employees who recommended Outland to ...Show more
Systems & Software, Inc.
Manitoba, Canada
Systems and Software is seeking an Implementation Consultant to join our Professional Services team! The ideal candidate is an enthusiastic, team-oriented individual that is dedicated to providing ...Show more
OCPA
Beloeil, Quebec, CA
Product Testers are wanted to work from home nationwide in the US to fulfill upcoming contracts with national and international companies.We guarantee 15-25 hours per week with an hourly pay of bet...Show more
AO Globe Life
Etobicoke, ON, CA
Remote Sales Supervisor – Fast-Track to Leadership!.Want a flexible career with unlimited growth ?.We’re looking for ambitious individuals to join our customer service leadership team (life insuran...Show more
Randstad Canada
Victoria, British Columbia, CA
Are you an Automation Expert with a strong background in Kubernetes based platforms (i.Do you have experience working in complex organization environments (ideally within the Public Sector).We're l...Show more
Dexterra Group
Sudbury, Ontario, CA
With over 25 years of experience in the remote camp business, Outland is a leader in remote camp catering.Many of our applicants have been referred by existing employees who recommended Outland to ...Show more
OCPA
Hamilton, Ontario, CA
Product Testers are wanted to work from home nationwide in the US to fulfill upcoming contracts with national and international companies.We guarantee 15-25 hours per week with an hourly pay of bet...Show more
VetWise
Prince Edward Island, Prince Edward Island, CA
While our name has changed, our mission and team remain the same.We're still the trusted company you know, just with a fresh new look and name that better reflects who we are and where we're headed...Show more
Noramtec Consultants
Montreal, Quebec
This position will make key contributions to the design, development, and implementation of secure, reliable, scalable, and high performing web applications.This position will require experience wi...Show more
Autodesk
Remote, British Columbia, Canada
The Database Architect will serve as the subject matter expert for databases within ACS.They will proactively form and drive a council consisting of database experts and interested parties from acr...Show more
American Income Life AO - Keerat Grewal
Vancouver, BC, CA
Are you ready to embark on a transformative journey where your location knows no bounds?.Join AO, a trailblazing company that empowers you to work from anywhere, learn from industry titans, and eme...Show more
OCPA
Brantford, Ontario, CA
Product Testers are wanted to work from home nationwide in the US to fulfill upcoming contracts with national and international companies.We guarantee 15-25 hours per week with an hourly pay of bet...Show more
OCPA
Calgary, Alberta, CA
Product Testers are wanted to work from home nationwide in the US to fulfill upcoming contracts with national and international companies.We guarantee 15-25 hours per week with an hourly pay of bet...Show more
OCPA
Prince George, British Columbia, CA
Product Testers are wanted to work from home nationwide in the US to fulfill upcoming contracts with national and international companies.We guarantee 15-25 hours per week with an hourly pay of bet...Show more
EDUopinions
Toronto, Ontario, Canada
EDUopinions is an independent platform that helps future students pick the right studies for them.Prospective students can read unbiased reviews about universities and other institutions, and benef...Show more
OCPA
Regina, Saskatchewan, CA
Product Testers are wanted to work from home nationwide in the US to fulfill upcoming contracts with national and international companies.We guarantee 15-25 hours per week with an hourly pay of bet...Show more
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
