BSA/Data Analyst (3 positions)

Toronto, ON (3 days a week hybrid)

6+ months contract

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

What you’ll bring:

Must Have 

• Expert in SQL, Hadoop, Big Data, 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