Hire Intellect Company logo on Dataaxy
Hire Intellect

Data Analyst

πŸ“
Canada
πŸ§ͺ
Mid-Senior level

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.


About the Role:

The services of an experienced Data Analyst Services are required to support work for

decommissioning the client's mainframe system(s). This work involves using new and existing applications to create a future state that does not rely on mainframe application(s) to support the underwriting, risk management and account receivable processes.


Responsibilities:

  • The Data Analyst Services will be supporting mainframe decommissioning by retargeting the business process into existing or new underwriting and finance applications. The Data Analyst Services is required to carry out data analysis activities by evaluating current state, performing data gap analysis and support development of future state data needs. The Data Analyst Services will work closely with key business stakeholders to document current state and requirements, examine data, and evaluate patterns and troubleshoot issues, and provide recommendations on solutions based on data management best practices.


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.
  • Demonstrated experience in SQL programming is required.
  • Demonstrated experience in ETL is required.
  • Strong knowledge and demonstrated experience in current and future state data mapping.
  • Carry out data validation and identify and resolve discrepancies (format, content, values).
  • Work with business team members on troubleshooting


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 (minimum 5 years), ETL development, metadata management and master data management, and business intelligence.
  • Experience with reverse engineering the source to target mapping to gain data insights
  • Experience refactoring existing SQL code to new/alternate data sources.


Other Skills Required:

  • Experience with Azure Data Platform technologies or other public cloud offerings
  • Programming experience: SQL
  • Experience with Databricks
  • 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
  • Demonstrated experience working with key business stakeholders in areas of Finance, Risk
  • Management and Insurance


Assets:

  • Experience working in an Agile environment/team
  • Bilingualism in both official languages (English and French)
  • Greater than 5 years of SQL development and refactoring existing SQL

Key informations

🧳
Contract
πŸ“…
Posted 4 months ago

Don’t miss out on new
Data & AI Jobs

Get curated job alerts weekly.

Other jobs at Hire Intellect

Hire Intellect does not currently have any open job positions in Data & Ai.
© 2023 | All Rights Reserved | Built with 🀍 in MontrealAll our data is gathered from publicly available sources or contributed by users