Closed listing
Business Data Analyst
- Toronto, ON, Canada
Contract
This opening has closed.
The original listing is kept below for reference.
Job details
- Job type
- Contract
- Closing date
- Posting language
- English
- Posted
Similar jobs hiring now
Search current openingsOriginal job description
Archived listing. The details below describe a past opening.
Job Title: BSA/Data Analyst
Location: Toronto, ON (3 days a week hybrid)
12 Months Contract
Requirements and responsibilities
What you’ll do
- Working with the project teams, business stakeholders, and 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 and all data domains
- Advocate best practices for development across our teams
What you’ll bring
Must Have
- Expert in SQL, Hadoop, Big Data, Hive, Nifi
- Strong experience in Azure Data Services analysis, BI analysis
- Ability to analyze 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 implementation models.
- Hands-on experience with the Hadoop ecosystem, including HDFS, Hive, Sqoop, NiFi, and YARN.
- Familiar with the 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 in both IT and business
- Business and data analysis skills to gather requirements and translate to technical requirements
- Be self-driven and can multitask 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, databases, and writing scripts.
- Experience of connecting to additional sources such as Azure and MySQL
- CI/CD experience
More about this job
Responsibilities
Collaborate with project teams, business stakeholders, and technical subject matter experts to deliver data insights and develop datasets and interactive dashboards. Understand data and business processes across applications and domains, and promote development best practices across teams.
Requirements
Requires strong SQL, Hadoop ecosystem, Azure Data Services, business intelligence, data warehousing, and DataStage experience, along with retail domain knowledge. Candidates should be able to reverse engineer reports and data relationships, translate business requirements into technical requirements, communicate effectively, and manage multiple projects under tight deadlines.
Skills
- SQL
- Hadoop
- Big Data
- Hive
- NiFi
- Azure Data Services
- Business Intelligence Analysis
- Data Warehousing
- DataStage
- Data Extraction, Transformation, And Loading
- Database DDL And DML
- HDFS
- Sqoop
- YARN
- Requirements Gathering
- Data Analysis
Visa sponsorship
Not detected in the job text
Categories
- Data & Analytics
- Technology
- Retail
Keywords
- SQL
- Hadoop
- Big Data
- Hive
- NiFi
- Azure Data Services
- Business Intelligence
- DataStage
- HDFS
- Sqoop
- YARN
- ESP Job Scheduling
- Data Warehousing
- Data Extraction
- Data Cleansing
- Data Aggregation
- Data Validation
- Data Transformation
- Data Loading
- DDL
- DML
- Retail Domain
- Interactive Dashboards
- Report Reverse Engineering
- CI/CD
- MySQL
- Requirements Gathering
- Data Analysis
- Branched Development
- Mainframe