Senior Data Engineer with Python and ETL/SQL experience to support the global reporting and analytics teams with one of our major banking clients- 36551

Senior Data Engineer with Python and ETL/SQL experience to support the global reporting and analytics teams with one of our major banking clients- 36551

Location Address Hybrid- 1 day per week - Toronto

Contract Duration: 4 months (High Chance of Extension)

Schedule Hours: 9 am-5:00 pm Monday-Friday; standard 37.5 hrs/week

Business group: Global MIS, Reporting & Data Analytics

• The business line supports the Director of Analytics at bank’s Global Contact Centres in developing advanced analytics (AI / ML) capabilities through data engineering. The primary focus of the role is to work with the Customer Insights & Analytics Team and the Global Data & Analytics Team in building and maintaining data pipelines and assisting the MIS & Reporting team with designing and evolving departmental reporting platforms and infrastructure.

Typical Day in Role:

• Collaborate with stakeholders to deliver data models to address operational needs
• Combine multiple data sources across all contact center platforms and applications to support advanced analytics products
• Ingest massive volumes of structured and unstructured format data, model, transform, and store it in a variety of data stores
• Support the Senior Data Engineer in defining data quality metrics and processes to monitor data in a production environmen
• Assist MIS & Data Analytics team with infrastructure development
• Develop ETL/ELT 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)
• Support the Senior Data Engineer in preparing reports and presentations to communicate findings to stakeholders
• Assist in mentoring and up-skilling peers for advanced analytics
• Streamline, enhance and, automate existing products to create capacity for the team to develop a new solution

Must Have Skills:

• 8- 10+ years of data engineering experience working with cross-functional data teams
• 8- 10+ years using Python or other programming languages, package management, dependencies, and deployment
• 8- 10+ years using SQL for ETL and data analysis, flexibility on syntax (SQL server, PostgreSQL)
• 8- 10+ years of experience with data modeling, data warehousing and database design
• 8- 10+ years’ experience designing and building ETL/ELT, data pipelines, or data engineering solutions
• Strong Experience with Linux tools and shell scripting

Nice-To-Have Skills:

• Experience with cloud architecture and security (Azure, AWS, GCP)
• Experience and understanding of various ML techniques including NLP
• Hands-on experience with Big Data ecosystem tools (e.g. Hadoop, Hive, Spark, BigQuery) and object storage (e.g. blob, MinIO, GCS).
• Understanding of Agile and Scrum methodologies and experience working in a Scrum environment (Jira and Confluence)
• Experience with Docker, CI/CD tools, Airflow and Kubernetes
• French and/or Spanish fluency an asset
• Contact center experience as an asset
• Experience with telephony data (Avaya, Genesys) and WFM data (Verint, Aspect) an asset

Education:

• University degree in science, computer science, math, statistics, finance, economics, or another quantitative field, or equivalent experience.

Best VS. Average Candidate

The best candidate is someone with the must and nice to have skills and senior using Python so can pass the coding test.

The best candidate will have solid experience with Python and PostgreSQL, as well as data modeling and pipeline designing, implementation, SQL, Query skills, Linux shell script skills, cloud experience in machine learning, and advanced data analysis skills.

Candidate Review & Selection

1 round - Technical interview -Coding test using Python language- MS Teams Video Interview - 1 hour - with HM and another team member

• 2nd round Director and HM MS Teams Video Interview - 30 mins - Attitude and behavioral questions and previous experience