Business Systems Analyst
- ON, Canada
- Ontario, Canada, Canada
Full-time
Applications open in a new tab.
Job details
- Job type
- Full-time
- Apply by
- Experience
- Experience: 12+ years
- Posting language
- English
- Posted
Original job description
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 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
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
More about this job
Responsibilities
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, reverse-engineer existing reports and table relationships, and promote development best practices.
Requirements
Requires 12+ years of experience, expert SQL and Hadoop ecosystem knowledge, strong Azure data services and BI analysis experience, and hands-on experience with DataStage and data warehouse projects. Candidates should understand the retail domain and bring strong analytical, communication, organization, and multitasking skills; experience with Azure or MySQL data sources and CI/CD is desired.
Skills
- SQL
- Hadoop
- Big Data
- Hive
- NiFi
- Azure Data Services
- Business Intelligence Analysis
- DataStage
- Data Warehousing
- Data Extraction And Transformation
- Database DDL And DML
- HDFS
- Sqoop
- YARN
- Retail Domain Knowledge
- Requirements Gathering
Visa sponsorship
Not detected in the job text
Categories
- Data & Analytics
- Technology
- Software
- Retail
Keywords
- SQL
- Hadoop
- Big Data
- Hive
- NiFi
- Azure Data Services
- Business Intelligence
- Interactive Dashboards
- Data Analysis
- DataStage
- Data Warehousing
- Data Extraction
- Data Cleansing
- Data Aggregation
- Data Validation
- Data Transformation
- Data Loading
- HDFS
- Sqoop
- YARN
- Mainframe ESP
- Job Scheduling
- Database DDL And DML
- Retail Domain
- CI/CD
- MySQL
- Requirements Gathering
- Reverse Engineering
- Branched Development