Job Title: Business Systems Analyst

Location: Yonge Street, Ontario, Canada – Onsite 4 days per week

Experience: 12+ years

Requirements and responsibilities
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

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




Solid 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

📌 Business Systems Analyst Front Of Yonge
🏢 Cyber Space Technologies
📍 Front of Yonge