Business Systems Analyst
Onsite 4 days week, Yonge street, Ontario Canada
Contract
required skills- Hadoop, Sql, ETL tools, Azure
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
