Senior Data Engineer, Enterprise Data Management
Toronto
Equitable Bank
At Equitable Bank, we specialize in providing branchless financial services that meet the unique needs of all Canadians. Our range of mortgages, savings accounts and investment options are designed to offer the right solutions to match any...Equitable Group Inc. trades on the Toronto Stock Exchange (TSX: EQB and EQB.PR.C) and serves a growing number of Canadians through Equitable Bank, Canada's Challenger Bank™. Equitable Bank has grown to become the country's eighth largest independent Schedule I bank with a clear mandate to drive real change in Canadian banking to enrich people's lives. Founded over 50 years ago, Equitable Bank provides diversified personal and commercial banking and through its EQ Bank platform has been named #1 Bank in Canada on the Forbes World's Best Banks 2021 and 2022 lists. EQ Bank provides state-of-the-art digital banking services, like the Savings Plus Account that reimagines banking by offering an everyday high interest rate, plus the flexibility of a chequing account, as well as a wide range of smart banking solutions for Canadians, like fast international money transfers, US dollar accounts and a suite of registered products.
Purpose of Job The Senior Data Engineer, Enterprise Data Management 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. They will be working in a high preforming team to design, build, optimize, and maintain innovative solutions on Microsoft Azure’s Data Platform, using cutting-edge Cloud services. In addition, the incumbent will be accountable for ensuring the integrity of data, allowing for effective, accurate and timely generation of all enterprise reports.
Main Activities
- 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 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 re-designing of 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%)
- Conceptualizing, designing, and developing 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 the efficiency and quality, including the acquisition of data from the different data sources
- Data Strategy (10%)
- Provide inputs and assist in enablement of Cloud based data and analytics
- Develop 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
Skills/Knowledge Requirements
- Bachelor's degree or equivalent in the field of Computer Science or Engineering
- 3+ years of related work experience in Data Engineering in 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 (ETL, ELT, data modeling and data warehousing)
- Experience in identifying and defining data gaps and challenges during data migration efforts of system implementations
- Excellent written and verbal communication skills
- Excellent multi-tasking and organizational skills
- Excellent problem solving and analytical thinking skills
- Excellent interpersonal skills
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
- Project/Program/Portfolio management experience
- Experience working in financial industry
- Experience with CMMI Data Maturity Model
- Experience with Agile and Waterfall SDLC methodologies
- Experience with Atlassian (Confluence and JIRA)
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, personal days and even a moving day 🖥 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
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!
* Salary range is an estimate based on our AI, ML, Data Science Salary Index 💰
Tags: Agile Architecture AWS Azure Banking Big Data Computer Science Data Analytics Databricks Data management Data pipelines Data quality Data strategy Data warehouse Data Warehousing ELT Engineering ETL GCP ITIL Jira Pipelines Python SDLC SQL Testing Unstructured data
Perks/benefits: Career development Health care Salary bonus Team events
More jobs like this
Explore more AI, ML, Data Science career opportunities
Find even more open roles in Artificial Intelligence (AI), Machine Learning (ML), Natural Language Processing (NLP), Computer Vision (CV), Data Engineering, Data Analytics, Big Data, and Data Science in general - ordered by popularity of job title or skills, toolset and products used - below.
- Open Lead Data Analyst jobs
- Open Data Science Manager jobs
- Open Senior Business Intelligence Analyst jobs
- Open MLOps Engineer jobs
- Open Data Manager jobs
- Open Data Engineer II jobs
- Open Power BI Developer jobs
- Open Principal Data Engineer jobs
- Open Sr Data Engineer jobs
- Open Data Analytics Engineer jobs
- Open Business Intelligence Developer jobs
- Open Data Scientist II jobs
- Open Junior Data Scientist jobs
- Open Product Data Analyst jobs
- Open Senior Data Architect jobs
- Open Business Data Analyst jobs
- Open Sr. Data Scientist jobs
- Open Big Data Engineer jobs
- Open Data Analyst Intern jobs
- Open Manager, Data Engineering jobs
- Open Azure Data Engineer jobs
- Open Junior Data Engineer jobs
- Open Data Product Manager jobs
- Open Data Quality Analyst jobs
- Open Principal Data Scientist jobs
- Open Data quality-related jobs
- Open Business Intelligence-related jobs
- Open ML models-related jobs
- Open GCP-related jobs
- Open Data management-related jobs
- Open Java-related jobs
- Open Privacy-related jobs
- Open Finance-related jobs
- Open Data visualization-related jobs
- Open APIs-related jobs
- Open Deep Learning-related jobs
- Open PyTorch-related jobs
- Open Consulting-related jobs
- Open Snowflake-related jobs
- Open TensorFlow-related jobs
- Open PhD-related jobs
- Open CI/CD-related jobs
- Open NLP-related jobs
- Open Kubernetes-related jobs
- Open Data governance-related jobs
- Open LLMs-related jobs
- Open Airflow-related jobs
- Open Data warehouse-related jobs
- Open Hadoop-related jobs
- Open Databricks-related jobs