The Senior Data Engineer designs and maintains the enterprise data warehouse, develops data pipelines, and ensures data integration and security across Azure data services.
Join a Challenger
Being a traditional bank just isn’t our thing. We are big believers in innovating the banking experience because we believe Canadians deserve better options, and we challenge ourselves and our teams to creatively transform what’s possible in banking. Our team is made up of inquisitive and agile minds that find smarter ways of doing things. If you’re not afraid of taking on big challenges and redefining the future, you belong with us. You’ll get to work with people who will encourage you to reach new heights. We like to keep things fun, ask questions and learn together.
We are a big (and growing!) family. Overall we serve more than 670,000 people across Canada through Equitable Bank, Canada's Challenger Bank™, and have been around for more than 50 years. Equitable Bank's wholly-owned subsidiary, Concentra Bank, supports credit unions across Canada that serve more than six million members. Together we have over $125 billion in combined assets under management and administration, with a clear mandate to drive change in Canadian banking to enrich people's lives. Our customers have named our EQ Bank digital platform (eqbank.ca) one of the top banks in Canada on the Forbes World's Best Banks list since 2021.
The Work
The Senior Data Engineer will have the responsibility for the design and maintenance of enterprise data warehouse for various projects, as well as providing on-going support for activities impacting all enterprise databases. The ideal candidate will have hands-on experience with Azure Data Factory, Azure Data Lake, Azure Function App, Logic App, REST APIs, mapping dataflow, and Event Hub. As a key member of our team, you will collaborate with various stakeholders to ensure efficient data flow, storage, and integration, while employing best practices in data engineering.
The core responsibilities
- Design, develop, and maintain scalable Synapse pipelines for data ingestion, processing, and transformation in Azure data platform.
- Develop and optimize T-SQL and Python-based data processing scripts and integrate them with Synapse pipelines for ETL tasks and data transformations.
- Design and develop mapping dataflow solutions for complex data transformations.
- Develop and maintain data storage solutions, ensuring efficient data retrieval and storage on Azure Data Lake and databases.
- Implement and maintain API integrations, including REST APIs, for seamless data flow between systems.
- Design and test the end-to-end process for data ingestion, data transformation, data cleansing, data delivery, data quality and data timeliness.
- Implement and ensure data security and privacy measures, complying with industry standards and regulations.
- Monitor and optimize the performance of Azure data services, Azure Synapse pipelines, Function Apps, and Logic Apps.
- Improve the scalability, efficiency, and cost-effectiveness of data pipelines.
- Participate in Joint Application Development sessions with business units to gather and understand their data and reporting requirements.
- Create and maintain technical documentations for tools, development, and procedures.
- Provide inputs and assist in enablement of Cloud based data solutions.
- Develop and recommend innovative approaches to solve business and technical problems.
- Work and collaborate with the larger team to exchange knowledge, solutions, and practices to build a more consistent, robust approach to development.
- Continuously improve performance and proactively identify and resolve bottlenecks that will reduce time to build and deliver our products.
- Troubleshoot and resolve data-related issues in a timely manner.
1. Designing and Developing of Data Pipelines (70%)
2. Requirements gathering and Technical Documentation (10%)
3. Data Strategy and Planning (10%)
4. Support and Maintenance of Enterprise Data Warehouse (10%)
Let's talk about you!!
- Bachelor's degree or equivalent in the field of Computer Science or Engineering
- 5+ years of Proven experience as a Data Engineer, specifically working with Microsoft Azure technologies.
- Proficient in T-SQL, Mapping Dataflow and Python programming language
- Hands-on experience with Azure data services, including Azure Data Factory, Azure Data Lake, Azure Function App, Azure Logic App, Azure SQL Database, Azure Synapse Analytics, mapping dataflow, and Event Hub.
- Solid understanding of data warehousing concepts and best practices.
- Experience with Data modeling.
- Experience in working with structured, semi-structured and unstructured data.
- Excellent written and verbal communication skills
- Excellent multi-tasking and organizational skills
- Microsoft Certified: Azure Data Engineer Associate or Azure Solutions Architect Expert
- Experience in DevOps pipelines and CI/CD.
- Experience in writing data quality routines for cleansing of data and capturing confidence score.
- Project/Program/Portfolio management experience
- Experience working in financial industry.
- Experience with Agile and Waterfall SDLC methodologies
- Experience with Atlassian (Confluence and JIRA)
- Knowledge of big data technologies such as Apache Spark
Nice-to-have
What we offer [For full-time permanent roles]
💰 Competitive discretionary bonus
✨ Market leading RRSP match program
🩺 Medical, dental, vision, life, and disability benefits
📝 Employee Share Purchase Plan
👶🏽 Maternity/Parental top-up while you care for your little one
🏝 Generous vacation policy and personal days
🖥 Virtual events to connect with your fellow colleagues
🎓 Annual professional development allowance and a comprehensive Career Development program
💛 A fulfilling opportunity to join one of the top FinTechs and help create a new kind of banking experience
The incumbent will be working hybrid and in office time will be spent working from Equitable Bank’s additional office space located at 2200-25 Ontario Street, Toronto, ON.
Equitable Bank is deeply committed to inclusion. Our organization is stronger and our employees thrive when we honour and celebrate everyone’s diverse experiences and perspectives. In tandem with that commitment, we support and encourage our staff to grow not just in their career path, but personally as well.
We commit to providing a barrier-free recruitment process and work environment for all applicants. Please let us know of any accommodations needed so that you can bring your best self to the application process and beyond. All candidates considered for hire must successfully pass a criminal background check and credit check to qualify for hire. While we appreciate your interest in applying, an Equitable recruiter will only contact leading candidates whose skills and qualifications closely match the requirements of the position.
We can’t wait to get to know you!
Top Skills
Azure Data Factory
Azure Data Lake
Azure Function App
Azure Logic App
Azure Sql Database
Azure Synapse Analytics
Event Hub
Python
Rest Apis
Synapse
T-Sql
Similar Jobs
AdTech • Digital Media • eCommerce • Marketing Tech
Responsible for designing and building scalable data pipelines, collaborating across teams to optimize data workflows, and contributing to engineering best practices.
Top Skills:
Aws S3Ci/CdDatabricksDelta LakeGitKafkaPysparkSparkSQL
Blockchain • Fintech • Payments • Consulting • Cryptocurrency • Cybersecurity • Quantum Computing
The Senior Data Engineer will design and maintain data solutions for B2B marketing, focusing on data quality and integration while solving complex data challenges and ensuring compliance with governance policies.
Top Skills:
Apache AirflowApache NifiAWSAzureDatabricksDelta TablesGCPJavaPythonScalaSparkUnity Catalog
Information Technology • Industrial • Manufacturing
The Senior Data Engineer will transform legacy data infrastructure, build data pipelines, and implement a data mesh strategy in collaboration with teams.
Top Skills:
AirflowBigQueryDataformDataplexDbtGithub Ci/CdGoogle Cloud PlatformPythonSQL
What you need to know about the Ottawa Tech Scene
The capital city of Canada and the nation's fourth-largest urban area, Ottawa has proven a rapidly growing global tech hub. With over 1,800 tech companies, many of which are leaders in their sectors, the city's tech talent now makes up more than 13 percent of its total workforce. This growth is driven not only by the big players like UL Solutions and Dropbox, but also by a thriving startup ecosystem, as new businesses emerge to follow in the footsteps of those that came before them.
