Data Analyst

MethodHub; Toronto; On-site; CAD 90,000 - 130,000; Full time

Job summary

MethodHub in Toronto, Canada, is seeking an experienced data analytics specialist for a 12+ months contract to support a growing portfolio of dashboards. You will work with project teams, business stakeholders and data SMEs to create datasets and sophisticated dashboards, understand data domains, and optimize reporting architectures across multiple product teams.

The ideal candidate brings deep SQL, Hadoop, DataStage, and data warehousing expertise, with experience integrating Azure and MySQL

Qualifications

• Expert in SQL, Hadoop, BigData, Hive, NiFi.
• Ability to analyse the construction of existing reports and reverse engineer table relationships.
• Strong knowledge of the Retail Domain and data warehousing projects.
• Experienced with DataStage components and ETL workflows.
• Strong at database commands (DDL/DML) and data warehousing models.
• Hands-on with Hadoop ecosystem (HDFS, Hive, Sqoop, NiFi, YARN).
• Familiar with Mainframe ESP for job scheduling.
• Understanding of branched development (dev, qa, prod).
• Passionate about data and its potential.
• Experience analyzing LOBs, databases, and scripting.
• Experience connecting to Azure and MySQL sources.
• CI/CD experience.

Responsibilities

• Working with project teams, business stakeholders, SMEs, and Data Insights on dashboards.
• Create new datasets and sophisticated dashboards.
• Understand data and business processes across applications and data domains.

Skills

SQL

Hadoop

BigData

Hive

NiFi

DataStage

DDL/DML

Azure

MySQL

Sqoop

HDFS

YARN

Mainframe ESP

Scripting

CI/CD

Education

Bachelor’s degree in Computer Science or equivalent

Tools

DataStage

Azure

MySQL

Mainframe ESP

Hadoop ecosystem tools

Job description

12+ Months Contract

Requirements and responsibilities

What you’ll do

• Working with the Project teams, business stakeholders, technical SMEs, , Data Insights on a growing portfolio of interactive dashboards across many product teams
• Create new datasets and sophisticated dashboards
• Understand the data and business processes across all applications, all data domains

What you’ll bring

Must Have

• Expert in SQL, Hadoop, BigData, Hive, Nifi
• Ability to analyse the construction of existing reports and reverse engineer table relationships etc
• Strong knowledge of the Retail Domain and experience with various stages of data warehouse projects, including data extraction, cleansing, aggregation, validation, transformation, and loading.
• Exp in using DataStage components such as Sequential File, Join, Sort, Merge, Lookup, Transformer, Remove Duplicates, Copy, Filter, Funnel, Dataset, Change Data Capture, and Aggregator.
• Strong at database commands (DDL and DML) and data warehousing implementations models.
• Hands on exp with the Hadoop ecosystem, including HDFS, Hive, Sqoop, NiFi, and YARN.
• Familiar with Mainframe ESP for job scheduling.
• Understanding of branched development – dev, qa, prod etc
• Passionate about data and it’s potential
• Experience of analyzing Lobs, data bases, writing scripts.
• Experience of connecting to additional sources such as Azure, MySql
• CI/CD experience

Education:

• Bachelor’s degree in Computer Science or equivalent.
• Candidates without Computer Science or Information Technology degree should have significant work experience.