Data Engineer (Data ModelingData Governance)
Job Summary
Requisition ID: 274855
At Tangerinewereredefining banking. As Canadas leading digital bank we thrive on innovation agility and bold thinking tackling every challenge head-on with leading technology and the unstoppable power of collaboration.
Our client-obsessed teams deliver flexible accessible banking solutions breakthrough products and award-winning service. Beyond bankingwerecommitted to making an impact in the communities we serve and across our organization. We foster a culture built on integrity inclusion and fearless ambition where diverse perspectives are valued and people are empowered to do their best work.
Are you ready to disrupt the status quo Do you crave challenges that push boundaries Ifyourea high performer looking to accelerate your career and reimagine the banking landscape this is your moment.
Letsshape the future of banking together!
Position Overview
We are looking for an experienced Data Engineer to design develop and support scalable enterprise data solutions within a financial services environment.
The ideal candidate will have strong hands-on experience in data engineering data modeling data warehouse development and building data products with expertise in GCP BigQuery Apache Airflow Informatica Python SQL and Git. A strong focus on data governance data quality security and privacy is essential.
Is this role right for you In this role you will:
- Design build and support scalable data pipelines data warehouses data models and data products.
- Develop cloud-based data solutions using GCP BigQuery Apache Airflow Informatica Python and SQL.
- Design conceptual logical physical and dimensional data models.
- Build reliable ETL/ELT processes and optimize data transformation workloads.
- Apply data governance metadata lineage data quality security privacy and access-control principles throughout solution design and development.
- Troubleshoot data and technical issues and recommend effective solutions.
- Produce clear technical documentation covering data models data flows designs and operational processes.
- Collaborate with business architecture governance security and technology teams.
- Participate throughout the SDLC including design development testing deployment release and production support.
- Provide technical guidance and support engineering best practices.
Do you have the skills that will enable you to succeed in this role Wed love to work with you if you have:
- University or College degree in a relevant field or equivalent professional experience.
- 5 years of experience in data engineering data management solution design and development.
- Strong experience in data modeling data warehouse development ETL/ELT and data product development.
- Strong financial services background with retail banking knowledge preferred.
- Proven ability to work effectively with technical and business stakeholders.
- Strong analytical problem-solving and documentation skills.
- Strong hands-on experience with: GCP and BigQueryApache Airflow InformaticaPython and SQLGitData modeling and dimensional modelingData warehouse design and developmentETL/ELT and data pipeline engineeringData product developmentData governance metadata lineage and data qualityData security privacy and access controlSDLC and release management
- Excellent written and verbal communication skills.
- Strong analytical and problem-solving abilities.
- Strong collaboration and stakeholder-management skills.
- Commitment to data quality governance security reliability and maintainability.
- Positive proactive attitude with the ability to influence lead and mentor others.
Whats in it for you
- You will be part of a diverse and inclusive team of Client-focused go-getters looking to learn from each other in an environment that celebrates and recognizes success!
- You will have access to thousands of online and in person courses so you can shape your career growth with the support from diverse industry leaders.
- You will get our help to save for your future and to invest in your total wellbeing through our Tangerine benefits*.
- You belong here we are equal and un-complicated. Bring your true self to work dress codes dont apply here.
- You will enjoy workspace flexibility and all the excitement that comes from working at the official Bank of the Toronto Raptors.
*Tangerine employees participate in Scotiabanks pension & benefits programs (available to permanent employees)
Location(s): Canada : Ontario : Toronto
At Tangerine we value the unique skills and experiences each individual brings to the team and are committed to creating and maintaining an inclusive and accessible environment. If you require accommodation during the recruitment and selection process please let our Recruitment team know.
Required Experience:
IC
About Company
Scotiabank is one of the leading foreign banks serving large national and multinational corporations in the U.S. through its Global Banking and Markets, Global Transaction Banking and Wealth Management business lines.