- Location
- Toronto, ON, Canada · Onsite
- Compensation
- No equity
- Employment
- Contract
- Experience level
- MID (2–5 years exp)
- Specialization
- Data Analyst, Data
- Source
- Wellfound
**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
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
Desired:
- Experience of analyzing Lobs, data bases, writing scripts.
- Experience of connecting to additional sources such as Azure, MySql
- CI/CD experience