Business Data analyst

MethodHub; Toronto; Hybrid; CAD 85,000 - 120,000; Full time

Job summary

MethodHub in Toronto, ON is seeking a Business Data Analyst to transform data into actionable insights. You will work with project teams, stakeholders, SMEs and Data Insights to build interactive dashboards across product teams.

Key responsibilities include creating new datasets, designing sophisticated dashboards, and understanding data processes across applications and data domains. The role demands expert SQL, Hadoop, Hive and NiFi expertise with strong business-IT communication.

Qualifications

• Expert in SQL, Hadoop, Hive and NiFi with hands-on data integration experience.
• Strong knowledge of data warehousing concepts and ETL processes.
• Experience with Azure Data Services and BI analysis.
• Retail domain understanding and ability to translate business needs into requirements.

Responsibilities

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

Skills

SQL

Hadoop

BigData

Hive

NiFi

Azure Data Services

BI Analysis

Data warehouse concepts

Data analysis

Retail domain knowledge

Tools

DataStage

Mainframe ESP

MySQL

Azure

Job description

Job Title: Business 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

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
• Experience of analyzing Lobs, data bases, writing scripts.
• Experience of connecting to additional sources such as Azure, MySql