Business System Analyst

Job summary

Collaborate with project teams, business stakeholders, technical subject matter experts, and data insights teams to develop datasets and interactive dashboards across product teams. Analyze data and business processes across applications and domains, and promote development best practices.

Job details

Business Systems Analyst Onsite 4 days week, Yonge street, Ontario, Canada Mandatory 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

What you’ll do

Collaborate with project teams, business stakeholders, technical subject matter experts, and data insights teams to develop datasets and interactive dashboards across product teams. Analyze data and business processes across applications and domains, and promote development best practices.

Requirements

Requires strong expertise in SQL, Hadoop, Big Data, Hive, NiFi, Azure Data Services, BI analysis, and data warehousing, including ETL and DataStage. Candidates should have retail domain knowledge, experience reverse-engineering reports and data relationships, and strong communication, requirements analysis, organization, and multitasking skills.

Listed skills

• SQL · Preferred
• Data analysis · Preferred
• Business Requirements Gathering · Preferred
• Business analysis · Preferred

Other relevant skills

Identified from the job description. Confirm important requirements above.

• SQL
• Hadoop
• Big Data
• Hive
• NiFi
• Azure Data Services
• ETL
• DataStage
• Data Warehousing
• Data Analysis
• Business Analysis
• Business Requirements Gathering
• Dashboard Development
• Retail Domain Knowledge
• HDFS
• Sqoop

Job areas

• Data & Analytics
• Technology
• Retail
• Consulting

More jobs from Entellux