Data Analyst

Job summary

The role involves creating datasets and sophisticated dashboards to provide data insights across various product teams. The analyst will collaborate with stakeholders and technical SMEs to advocate for development best practices.

Job details

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

What you’ll do

The role involves creating datasets and sophisticated dashboards to provide data insights across various product teams. The analyst will collaborate with stakeholders and technical SMEs to advocate for development best practices.

Requirements

Candidates must be experts in SQL and the Hadoop ecosystem with strong experience in the Retail domain and DataStage components. A Bachelor's degree in Computer Science or equivalent professional experience is required.

Listed skills

• Microsoft Azure · Preferred
• MySQL · Preferred
• SQL · Preferred

Other relevant skills

Identified from the job description. Confirm important requirements above.

• SQL
• Hadoop
• BigData
• Hive
• NiFi
• DataStage
• Data Warehousing
• DDL
• DML
• HDFS
• Sqoop
• YARN
• Mainframe ESP
• Retail Domain
• Azure
• MySQL

Job areas

• Data & Analytics
• Technology
• Software
• Retail
• Consulting