Business Data analyst

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