Data Engineer

We are looking for a Business Analyst/Project Lead! Reach out if you are interested and feel free to refer friends/colleagues!

Type of Employment: Contract
Title: Business Analyst/Project Lead
Term: Contract – 12 months with extension
Location: Toronto – Hybrid 2 days a week
Industry: Banking
Job ID number: 211

Story Behind the Need:
Business Group: The CIDA team at Scotiabank is at the forefront of the journey to transform the Bank into a data centric organization through impactful customer insights, innovative analytics, and well governed data. One of the main areas of transformation is the way data is produced, consumed, and managed at an enterprise level to drive business value. The aim is to provide a truly productized offering of re-usable data that can be delivered iteratively through a streamlined process and framework in order to meet the velocity that will allow data consumers to focus on delivering business value. We are looking to build our delivery team with influencers, makers, creators and industry leaders who will drive us forward.

Project: The role of the Data Quality Developer operates within the Enterprise Data Quality and Data Management team in the Enterprise Data Office. This valuable member of the team will be responsible to work on Automated Data Quality, Data Profiling for the enterprise. The successful candidate will work closely with Senior members of the following teams: business partners, data engineers, data architects, data modelers, analytics teams, technology teams and other development/engineering teams in the bank to support in the technical development of enterprise Data Quality services.

Candidate Value Proposition:
The candidate will have the opportunity to work on a large highly visible project within one of Canada’s top banks on a highly visible project.

Typical Day in the Role:
• Develop Data Quality and Data Profiling solutions, data pipelines, services, and components to enable enterprise-wide use of Data Quality Services
• Work closely with Enterprise platform partners, IT partners, Data Governance Offices and business users across the enterprise to build well-managed data quality that drives data transparency and ensures a high degree of data quality across the bank
• Work closely with data engineers and DevOps engineers to build data management capabilities that drive real business outcomes
• Participate in planning and retrospective sessions, attend stand-ups, etc.
• Work with Solution leads to enhance Data Quality capabilities
• Participate in planning and retrospective sessions, attend stand-ups, etc.

Must Have Skills/Requirements:

• 8+ years experience as a Data Engineer
• Experience in building data software; experience with ETL Talend, DataStage,
• Experience working with Python, DBT, big Query
• Experience working with relational databases (Oracle, SQL Server, MySQL, PostgreSQL).
• Experience working with big data technologies (e.g. Spark, Hive, Airflow)
• Understanding of data management disciplines such as data quality, data profiling, etc.

Nice to have Skills:

• Previous experience working in a financial institution
• Experience with Talend, IBM DataStage

Soft Skills:

• Strong Analytical skills.
• Strong communication skills, both written and spoken
• Team player, self-starter
• Attention to details, high standards for quality
• Writing and maintaining clear documentation

Best Vs Average Candidate: The ideal candidate would have strong analytical and interpersonal skills. It would also be preferred if the candidate had prior FI experience.