Job Description
Junior Data Engineer to develop ETLs for analytics solutions using Python, SQL and Power BI with one of our major banking clients - BNSJP00033747
Location Address: Hybrid/Toronto – 2 times in the office per week max
Contract Duration: ASAP - Oct 2024 5-6 months (possibility of extension or conversion to FTE depending on performance)
Schedule Hours: 37.5 Hours Per Week
Business group: MIS, Reporting & Data Analytics (OU20018661)
Purpose
The purpose of this role is to support the Senior Manager of MIS and Data Analytics at Scotiabank’s Global Contact Centres in developing advanced analytics (AI / ML) and visualization capabilities. The primary focus of the role is to work with the Customer Insights & Analytics Team and the Global Data & Analytics Team in conducting analyses and assisting the MIS & Reporting team with designing and evolving departmental reporting platforms and infrastructure.
Project
Project: CBCC Optimization – Enhances on the offers, IVR and segmentation analysis of the customers
Must Have Skills
- 1-2 years of experience as a Data Engineer working with business intelligence, analytics, data science and development skills
- 1-2 years of reporting, UI design, and BI solutions
- 1-2 years using Python for data analysis and analytics (Pandas, Dask, Numpy, etc..)
- 1-2 years using SQL for ETL extract transform and load and data analysis, flexibility on syntax (SQL server, PostgreSQL)
- 1-2 years of experience in Power BI, Tableau, or any other visualization software
Nice-To-Have Skills
- Experience with cloud architecture (Azure, AWS, GCP) an asset
- Contact center experience an asset
- Experience with telephony data (Avaya, Genesys) and WFM data (Verint, Aspect) an asset
- Experience with Docker, CI/CD tools, and Airflow and Kubernetes an asset
Requirements
Education & Certificates:
- University degree in science, computer science, math, statistics, finance, economics, or another quantitative field, or equivalent experience
Responsibilities
- Combine multiple data sources across all contact center platforms and applications to build end-to-end BI products
- Define metrics / KPIs and develop customer insights models
- Assist MIS & Data Analytics team with architecture and infrastructure design/development
- Develop ETLs for analytics solutions using Python, Spark, SQL and Power BI
- Produce ad hoc analyses, deep dives, and drill-downs on specific issues, topics, or areas of opportunity (e.g. process improvements)
- Prepare reports and presentations to communicate findings to stakeholders
Candidate Selection
- 1 round interview – 30 - mins MS Teams Video – Hiring manager and product manager or data architect.
- Behavioral questions and previous experience, skills, and knowledge questions.
- 2 Round 30 - mins MS Teams Video – Hiring manager and Director Behavioural questions and previous experience, skills, and knowledge questions.