Data Analyst

Tundra Talent Community
Ottawa, ON, Canada (On-site)
$28 an hour (estimated)
Full-time

Requirements Contract Details Expected Start Date June 2024 Expected End Date December 2024 On-Site Requirement Remote Security Clearance Level Requirements : This work will require Reliability statusDescription of ServiceThe marketing department has a need for a data analyst to support the migration of 3rd party data (company and individual level data) and other internal data sources into the Enterprise data platform (data lake) to be leveraged for various marketing analysis.

Primary ResponsibilitiesWorking closely with the customer analytics team in marketing, the data analyst would be responsible for analysis of external and internal data sources and mapping to data in the Enterprise Data Platform (EDP).

The individual will work closely with marketing analysts, as well as other data roles, such as data architects and data engineers to deep dive into the business rules and data transformation rules requirements, as well as analyze and document new requirements and to be able to help the design of the new data integration stream or update the existing data pipeline.

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.
  • Strong knowledge and demonstrated experience in current and future state data mapping.
  • Identify qualified / approved records for system upload.
  • Identify and resolve discrepancies (format, content, values).
  • Work with business team members on resolving quality issues.

SkillsTop 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, business intelligence and database administration.
  • 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
  • Experience with Databricks
  • Programming experience : SQL, R, Python
  • 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

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

Job 70307

30+ days ago
Related jobs
American Express Global Business Travel
Canada

Liaise with data development and business teams such as Revenue Management teams to enhance the understanding and use of data and analytics capabilities. Experienced in Insight/Data/MI Analyst. The position of Marketplace Optimization Analyst sits within the Air and Ground Transportation Team and is...

PlayStation
Canada
Remote

As a Senior Game Data Analyst, you will be working in our cross-disciplinary team to help game studios use data efficiently to improve games. We provide end-to-end analytics services for PlayStation Studios and use data to help them make their amazing games even better. Analysing data to deliver hig...

data.ai
Canada
Remote

We are looking for an outstanding Junior Data Analyst interested in working in the hot space of app store data and analytics to join our phenomenal Data Science team at data. I work closely with Product Managers to help understand the efficacy of released product features and collaborate with Data A...

Aritzia
Canada, Canada

As a Senior Data Analyst, Digital at Aritzia, you will combine your deep understanding of digital customer experiences with your passion for data and masterful analytics skills to drive decisions that will create long lasting relationships with our customers and enhance outcomes for our eCommerce bu...

Coast Capital Savings
Canada, Canada

Coaches and supports the business and technical data stewards in clarifying data definitions, outlining the appropriate uses for data, organizing and classifying data and managing metadata to recommend proper data usage and compliance. They coach and work closely with business data stewards to devel...

Phoenix Labs
REMOTE - CANADA
Remote

Prior experience in a Data Analyst role directly supporting a video game product, ideally GaaS. Collect and analyze complex data to more deeply understand our audience and their behaviours and desires. Minimum of five years of professional work experience analyzing large data sets and informing comp...

CAPCO
Canada

Assist the strategy architect, business architect, data architect, data steward, and data owner in defining the data management strategy and data architecture. Work with the customer, users, application architect, technical architect, data architect, data modeler, business analysts, and application ...

ITREB
Canada

The data analysis and Quality assurance program team ensures appropriate data collection, compliance to privacy protection and reporting to allow program improvement. Analyze and provide data on requested metrics to national and regional teams, ensuring data accuracy and relevance. Ensure continuous...

Charter
Anywhere - Canada

Cloud & Data Center Systems Support Analyst (Intermediate). Cloud & Data Center Systems Support Analyst. The Cloud & Data Center Systems Support Analyst is responsible for daily operations, proactive management, technology recommendations, implementing best practices and managing incidents/requests ...

Tundra Talent Community
Ottawa, ON, Canada (On-site)

This work will require Reliability statusDescription of ServiceThe marketing department has a need for a data analyst to support the migration of 3rd party data (company and individual level data) and other internal data sources into the Enterprise data platform (data lake) to be leveraged for vario...