Job Title

Join a ChallengerBeing a traditional bank just isnt 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 whats possible in banking. Our team is made up of inquisitive and agile minds that find smarter ways of doing things. If youre not afraid of taking on big challenges and redefining the future, you belong with us. Youll 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 workThe 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 engineeringThe Core Responsibilities Designing and Developing of Data Pipelines (70%)Design, develop, and maintain scalable Synapse pipelines for data ingestion, processing, and transformation in Azure data platformDevelop and optimize T-SQL and Python-based data processing scripts and integrate them with Synapse pipelines for ETL tasks and data transformationsDesign and develop mapping dataflow solutions for complex data transformationsDevelop and maintain data storage solutions, ensuring efficient data retrieval and storage on Azure Data Lake and databasesImplement and maintain API integrations, including REST APIs, for seamless data flow between systemsDesign and test the end-to-end process for data ingestion, data transformation, data cleansing, data delivery, data quality and data timelinessImplement and ensure data security and privacy measures, complying with industry standards and regulationsMonitor and optimize the performance of Azure data services, Azure Synapse pipelines, Function Apps, and Logic AppsImprove the scalability, efficiency, and cost-effectiveness of data pipelines Requirements gathering and Technical Documentation (10%)Participate in Joint Application Development sessions with business units to gather and understand their data and reporting requirementsCreate and maintain technical documentations for tools, development, and procedures Data Strategy and Planning (10%)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. Support and Maintenance of Enterprise Data Warehouse (10%)Continuously improve performance and proactively identify and resolve bottlenecks that will reduce time to build and deliver our productsTroubleshoot and resolve data-related issues in a timely mannerLet's talk about you!!Bachelor's degree or equivalent in the field of Computer Science or Engineering5+ years of Proven experience as a Data Engineer, specifically working with Microsoft Azure technologiesProficient in T-SQL, Mapping Dataflow and Python programming languageHands-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 HubSolid understanding of data warehousing concepts and best practicesExperience with Data modelingExperience in working with structured, semi-structured and unstructured dataExcellent written and verbal communication skillsExcellent multi-tasking and organizational skillsNice-to-haveMicrosoft Certified: Azure Data Engineer Associate or Azure Solutions Architect ExpertExperience in DevOps pipelines and CI/CDExperience in writing data quality routines for cleansing of data and capturing confidence scoreProject/Program/Portfolio management experienceExperience working in financial industryExperience with Agile and Waterfall SDLC methodologiesExperience with Atlassian (Confluence and JIRA)Knowledge of big data technologies such as Apache SparkWhat we offer (For full-time permanent roles) Competitive discretionary bonus Market leading RRSP match program