Avatar for Method Hub
IT consulting for cloud, data, security and ERP/CRM solutions

Data analyst with Hadoop/Datastage

  • Old Toronto
  • |Contract
Posted: 1 month ago
Job Location
Old Toronto
Remote Work Policy

In office - WFH flexibility

Visa Sponsorship

Not Available

RelocationAllowed
Skills
Hadoop
SQL
DataStage
Hive
BigData
HDFS
Yarn
Sqoop
Nifi
BI Analysis
Mainframe ESP
Azure Data Services Analysis

About the job

Job Title: Data Analyst SQL, Hadoop, BigData, Hive, Nifi/Datastage

Location: Toronto, ON (3 days a week hybrid)

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 applicaitons, all data domains
  • Advocate best practises for development across our teams

What you’ll bring

Must Have

  • Expert in SQL, Hadoop, BigData, Hive, Nifi
  • Strong experience in Azure Data Services analysis, BI Analysis
  • 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
  • An organized and self-starter approach to accomplish responsible work items
  • Strong communication skills with the ability to present complex messages and stories both IT and Business
  • Business and data analysis skills to gather requirements and translate to technical requirements
  • Be self driven and can multi-task and work on multiple projects at the same time under tight deadlines
  • Ability to navigate ambiguity and simplify complex scenarios with keen business acumen

Desired:

  • Experience of analyzing Lobs, data bases, writing scripts.
  • Experience of connecting to additional sources such as Azure, MySql
  • CI/CD experience