Data Analyst (2 positions)

Location: Ontario (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 current 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

- 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

Desired:

- 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.

📌 Data Analyst (Ontario)
🏢 Gala Solutions
📍 Ontario