Job expired!
Join a Challenger
Being a traditional bank just isn't our thing. We believe 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 curious 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 large (and growing!) family. Overall, we serve more than 370,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 5 million members. Together we have over $100 billion in combined assets under management and administration, with a clear mandate to drive change in Canadian banking to enrich people's lives. Our EQ Bank platform () has been named the top Schedule I Bank in Canada on the Forbes World's Best Banks 2023, 2022, and 2021 lists.
Level 6 out of 12
Purpose of Job
The Senior Data Engineer, Enterprise Data Management will be responsible for the design and maintenance of the enterprise data warehouse for various projects, as well as providing ongoing support for activities impacting all enterprise databases. They will work in a high-performing team to design, build, optimize, and maintain innovative solutions on Microsoft Azure’s Data Platform, using cutting-edge Cloud services. Additionally, the incumbent will be responsible for ensuring the integrity of data, allowing for effective, accurate and timely generation of all enterprise reports.
The Work!
- Business Analysis (40%)
- Participate in Joint Application Development sessions with business units to gather and understand their data and reporting requirements
- Support key data architecture and design decisions for data platform and pipelines modernization
- Gather technical requirements, assess compatibility, and analyze findings to provide appropriate Cloud solution recommendations
- Building and Designing of Data Pipelines (20%)
- Develop Proof of Concept (POC) to validate and influence the solution proposed for data migration
- Design and test the end-to-end process for data ingestion, data transformation, data cleansing, data delivery, data quality and data timeliness
- Explore new tools and opportunities for redesigning existing data infrastructure to improve scalability and performance
- Assist with data-related technical challenges and perform root-cause analysis
- Document policies and best practices
- Create and maintain technical documentations for tools, deployment and procedures
- Reporting and Data Analytics (20%)
- Conceptualize, design, and develop analytical solutions as required.
- Design and write automated SQL Jobs/Scripts to perform a variety of functions
- Ensure Documentation of all reporting and related processes is in place and kept current
- Develop and implement data analyses, data collection systems and other strategies that optimize efficiency and quality, including the acquisition of data from different data sources
- Data Strategy (10%)
- Provide inputs and assist in the enablement of Cloud based data and analytics
- Design and recommend innovative approaches to solve business and technical problems in the data and analytics domain
- 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 products
- Provide data-related technical support for downstream applications
Let's Talk About You!
- Bachelor's degree or equivalent in the field of Computer Science or Engineering
- 3+ years of relevant work experience in Data Engineering in a Cloud Data Warehouse environment (Azure, AWS or GCP)
- 3+ years of development experience in Python, SQL, and Cloud Shell
- Experience in designing, building, and testing data pipelines for integrating multiple sources into a centralized data platform or Enterprise Data Warehouse
- Experience in working with structured, semi-structured, and unstructured data
- Understanding of data transformation practices (, ELT, data modeling, and data warehousing)
- Experience in identifying and defining data gaps and challenges during data migration efforts of system implementation
- Excellent written and verbal communication skills
- Excellent multi-tasking and organizational skills
- Excellent problem-solving and analytical thinking skills
- Excellent interpersonal skills
The Nice-to-Have!
- Experience with Azure Big data technologies (Azure Data Lake, Azure Data Factory, Azure Data Bricks, Azure Synapse)
- Microsoft Certified: Azure Data Engineer Associate or Azure Solutions Architect Expert
- Experience in building and optimizing 'big data' data pipelines
- Experience in writing Stored Procedures, Secure coding with safeguards against SQL injection attacks
- Experience in writing data quality routines for cleansing of data and capturing confidence score
- DAMA Certified Data Management Professional (CDMP)
- ISACA Certified Enterprise Data Management Associate
- Familiarity with ITIL and IT service management best practices
- Experience working in the financial industry
- Experience with CMMI Data Maturity Model
- Experience with Agile and Waterfall SDLC methodologies
- Experience with Atlassian (Confluence and JIRA)
#LI-Hybrid
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
