Captain Private Dining Service

This is a remote position.

Job Title: Data Analyst

Job Type: Contract; Full-Time

Location: Canada (Remote)

About the Company:

Our client is a Crown corporation dedicated to helping and equipping Canadian companies with trade knowledge, financial solutions, equity, insurance, connections and to grow their business with confidence in global markets.

Position Summary:

The Data Analysis service provider leads the design and implementation of information management and technology solutions for the enterprise data platform. The selected candidate will be responsible for analyzing information requirements, recommending options for business and technology solutions, delivering conceptual, logical and physical blueprints for design, build and integration phases that are aligned with data governance standards and the company's information strategies. The individual is experienced in information requirements collection and analysis, data quality analysis, data modeling, metadata management, master data management, and data integration. The data analysis service provider needs to quickly come up to speed on current state information architecture and familiarize themselves with the company's information management context.

Responsibilities:

• Collecting, documenting, and analyzing information management requirements
  

• Developing a plan/approach for data quality analysis, and on-going data quality monitoring
  

• Conducting data quality analysis on an on-going basis, and identifying issues, and options for resolutions
  

• 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
  

• Designs, creates and optimizes data models and derives conversion and migration methods for existing data
  

• Maintains an enterprise view of data across various systems. Works collaboratively with information governance analysts to ensure that data models and structures are compliant with governance standards
  

• Works closely and collaboratively with management, stakeholders, team members, development team,
  

• DBA and infrastructure teams to optimize the overall data management delivery
  

• Works with members of the Enterprise Architecture team to provide technical leadership and communicate closely with management about deliverables, schedule, possible risk and appropriate contingencies
  

Requirements

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
  

• Knowledge and demonstrated experience of Oracle Enterprise Data Quality (OEDQ) tool is required
  

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

• Knowledge and demonstrated experience of IBM Infosphere Information Analyzer is an asset
  

• Understand systems data elements, and existing data structures
  

• Set up the data quality analysis framework (activities, process, requirements, and level of effort) to hand off to a business resource
  

• Import source data files and save 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 on a weekly basis, and liaison with Business Lead on data analysis results and reporting.
  

• Train business information analyst resource who will be performing this role once the project is completed
  

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, 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
  

Other Skills Required:

• Experience with Azure Data Platform technologies or other public cloud offerings
  

• Experience with IBM: Data Manager, InfoSphere DataStage
  

• Experience with Spark SQL
  

• Programming experience: SQL, R, Python
  

• Experience with Power BI report development
  

• Understanding of 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
  

• Experience working in an Agile environment/team
  

• Bilingualism in both official languages (English and French)
  

• 2-5 years and >5 years experience welcome