Junior data engineer to develop etls for analytics solutions using python, sql and power bi wit[...]

2 weeks ago

Old Toronto, Canada S.i. Systems Full time

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)

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: 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

Best VS. Average Candidate:

  • The best candidate will have strong data visualization skills and be detail-oriented.

Education & Certificates:

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

Typical Day in Role:

  • 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 review and 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.
Apply #J-18808-Ljbffr

  • SQL developer, Power BI.

    Found in: Whatjobs CA C2 - 2 days ago

    Toronto, Canada ALOIS Solutions Full time

    Hello Applicant - I hope this message finds you in good health. We have a Fulltime/Perm role available with my direct client, where, in addition to a base salary, you will have access to health/medical/dental benefits, PTO, and much more. Job Title: Power BI/SQL Developer. Location: Toronto, Ontario, Canada Duration: Full-time/permanent role Power BI, SQL...

  • SQL developer, Power BI.

    Found in: Whatjobs CA C2 - 4 days ago

    Toronto, Canada ALOIS Solutions Full time

    Hello Applicant - I hope this message finds you in good health. We have a Fulltime/Perm role available with my direct client, where, in addition to a base salary, you will have access to health/medical/dental benefits, PTO, and much more. Job Title: Power BI/SQL Developer. Location: Toronto, Ontario, Canada Duration: Full-time/permanent role Power BI, SQL...

  • SQL developer, Power BI.

    Found in: Appcast CA A2 P - 2 days ago

    Toronto, Canada ALOIS Solutions Full time

    Hello Applicant - I hope this message finds you in good health. We have a Fulltime/Perm role available with my direct client, where, in addition to a base salary, you will have access to health/medical/dental benefits, PTO, and much more.Job Title: Power BI/SQL Developer.Location: Toronto, Ontario, CanadaDuration: Full-time/permanent rolePower BI, SQL...

  • SQL developer, Power BI.

    Found in: Appcast CA C2 Glassdoor - 2 days ago

    Toronto, Canada ALOIS Solutions Full time

    Hello Applicant - I hope this message finds you in good health. We have a Fulltime/Perm role available with my direct client, where, in addition to a base salary, you will have access to health/medical/dental benefits, PTO, and much more.Job Title: Power BI/SQL Developer.Location: Toronto, Ontario, CanadaDuration: Full-time/permanent rolePower BI, SQL...

  • Senior Data Engineer

    Found in: Jooble CA O C2 - 1 week ago

    Toronto, ON, Canada Tiger Analytics, LLC Full time

    Tiger Analytics is a fast-growing advanced analytics consulting firm. Our consultants bring deep expertise in Data Science, Machine Learning and AI. We are the trusted analytics partner for several Fortune 100 companies, enabling them to generate business value from data. Our business value and leadership has been recognized by various market research firms,...

  • Power BI Developer – SQL

    2 weeks ago

    Old Toronto, Canada ProViso Staffing Full time

    Story Behind the Need: • Business group: Global Cash Management• The team focused on internal treasury reporting around liquidity and funding metrics.• We are seeking a skilled Power BI Developer to join our dynamic team. The ideal candidate will be responsible for transforming raw data into meaningful insights through the development of interactive...

  • Power BI Developer – SQL

    2 weeks ago

    Old Toronto, Canada ProViso Staffing Full time

    Story Behind the Need: • Business group: Global Cash Management• The team focused on internal treasury reporting around liquidity and funding metrics.• We are seeking a skilled Power BI Developer to join our dynamic team. The ideal candidate will be responsible for transforming raw data into meaningful insights through the development of interactive...

  • Power BI Developer – SQL

    2 weeks ago

    Old Toronto, Canada ProViso Staffing Full time

    Story Behind the Need: • Business group: Global Cash Management• The team focused on internal treasury reporting around liquidity and funding metrics.• We are seeking a skilled Power BI Developer to join our dynamic team. The ideal candidate will be responsible for transforming raw data into meaningful insights through the development of interactive...

  • Power BI SQL developer CN

    Found in: Appcast CA C2 Glassdoor - 4 days ago

    Toronto, Canada ALOIS Solutions Full time

    Hello Applicant - I hope this message finds you in good health. We have a Fulltime/Perm role available with my direct client, where, in addition to a base salary, you will have access to health/medical/dental benefits, PTO, and much more.Job Title: Power BI/SQL Developer.Location: Toronto, Ontario, CanadaDuration: Full-time/permanent rolePower BI, SQL...

  • Power BI SQL developer CN

    Found in: Appcast CA A2 P - 4 days ago

    Toronto, Canada ALOIS Solutions Full time

    Hello Applicant - I hope this message finds you in good health. We have a Fulltime/Perm role available with my direct client, where, in addition to a base salary, you will have access to health/medical/dental benefits, PTO, and much more.Job Title: Power BI/SQL Developer.Location: Toronto, Ontario, CanadaDuration: Full-time/permanent rolePower BI, SQL...

  • Senior Data Engineer

    2 weeks ago

    Old Toronto, Canada Tiger Analytics, LLC Full time

    Tiger Analytics is a fast-growing advanced analytics consulting firm. Our consultants bring deep expertise in Data Science, Machine Learning and AI. We are the trusted analytics partner for several Fortune 100 companies, enabling them to generate business value from data. Our business value and leadership has been recognized by various market research firms,...

  • Senior Data Engineer

    6 days ago

    Old Toronto, Canada Tiger Analytics, LLC Full time

    Tiger Analytics is a fast-growing advanced analytics consulting firm. Our consultants bring deep expertise in Data Science, Machine Learning and AI. We are the trusted analytics partner for several Fortune 100 companies, enabling them to generate business value from data. Our business value and leadership has been recognized by various market research firms,...

  • Senior Data Engineer

    7 days ago

    Old Toronto, Canada Tiger Analytics, LLC Full time

    Tiger Analytics is a fast-growing advanced analytics consulting firm. Our consultants bring deep expertise in Data Science, Machine Learning and AI. We are the trusted analytics partner for several Fortune 100 companies, enabling them to generate business value from data. Our business value and leadership has been recognized by various market research firms,...

  • BI Specialist – IT

    2 weeks ago

    Old Toronto, Canada Nexus Systems Group Inc. Full time

    BI Specialist Typical Day in Role: • Collaborate with stakeholders to develop BI solutions to address operational needs • 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...

  • BI Specialist – IT

    7 days ago

    Old Toronto, Canada Nexus Systems Group Inc. Full time

    BI Specialist Typical Day in Role: • Collaborate with stakeholders to develop BI solutions to address operational needs • 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...

  • BI Specialist – IT

    6 days ago

    Old Toronto, Canada Nexus Systems Group Inc. Full time

    BI Specialist Typical Day in Role: • Collaborate with stakeholders to develop BI solutions to address operational needs • 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...

  • Power BI Developer

    Found in: Appcast CA A2 P - 2 weeks ago

    Toronto, Canada ALOIS Solutions Full time

    Role Overview:Experience in design, development of data architecture, data flows, Business Intelligence solutions leveraging latest data/technology frameworks.Responsible for design and storage of data in the database.Design and develop schema for BI solutions, system governance process and other data/BI asset management processOwn entire process of...

  • BI Developer-Tableau/SQL

    Found in: Jooble CA O C2 - 7 days ago

    Toronto, ON, Canada Winsopro Full time

    We are seeking a skilled and experienced Business Intelligence (BI) Developer to join our team. As a BI Developer, you will be responsible for designing, developing, and maintaining our business intelligence solutions. You will collaborate with stakeholders to gather requirements, design data models, and create insightful reports and visualizations. Your...

  • Teradata (Python) - Teradata + Power Bi+alteryx

    10 hours ago

    Toronto, Canada Emonics LLC Full time

    Work experience on skillset Teradata + Power BI+Alteryx (any other ETL tool) as mentioned in JD. **Role: Teradata** **Remote** Good in DWH and Data modelling concept Proficient in prototyping, designing, and requirement analysis. Proficient in Requirements gathering from Business Strong Hands on experience in Teradata with BTEQ/MLOAD/FLOAD...

  • Power BI Analyst

    5 days ago

    Toronto, Canada Zeitview Full time

    Zeitview (formerly DroneBase) is the leading intelligent aerial imaging company for high-value infrastructure, providing businesses with actionable, real-time insights to recover revenue, reduce risk and improve build quality. Zeitview serves customers in the solar, wind, insurance, construction, real estate, and critical infrastructure industries. Trusted...