Job Description

Candidate Profile Details:

• Degree/Certifications Required: Bachelor's degree in technology, information systems or equivalent
• Years of Overall Experience: 8yrs
• Preferred Candidate Background: 8+ years of experience in database administration, automation implementation, administration, configuration and support
• How will performance be measured: N/A
• Selling Points of Position (CVP): Working within a leading FI organization
• The Workforce Identity and Access Management (IAM) team has an enterprise-wide focus on Identity, authentication, authorization, and IAM governance. Ensuring users have the right access at the right time for the right reasons.
• This position is for an Senior Data Engineer reporting to the Senior Manager, Information Security.
• This role is to act as a functional team member for the Governance and Analytics team the provide data driven actionable insights across the various information security principles and related software.
• This primary focus is on reducing risk and improving the banks Workforce IAM security posture.

Below are the responsibilities for this candidate:

• Develop automated data pipelines and data stores from multiple systems including designing, implementing, testing, debugging, and deploying.
• Develop complex SQL queries, stored procedures, and scripts for data manipulation and retrieval.
• Build metadata-driven solutions that are reusable and highly configurable.
• Optimize data warehouse performance through effective data modeling, partitioning, and indexing strategies.
• Spearhead the design and implementation of ETL processes.
• Collaborate with various system owner to understand data requirements and deliver precise reporting and analytical solutions.
• Ensure data integrity and security within the data environment, complying with industry regulations and standards.
• Work on an agile team to quickly iterate and release solutions.
• Research and put forward new recommendations to create, automate and improve processes
• Provide technical expertise and support for warehouse to internal teams, including troubleshooting and resolving issues.
• Stay up to date with data features and updates, continuously improving and expanding our data warehouse capabilities.
• Develop and maintain documentation for processes, systems, and procedures.
• Design, develop, and support a data lake environment, ensuring efficient data storage, retrieval, and processing.
• Implement data governance and data quality frameworks to ensure the accuracy and reliability of data within the environment.
• Integrate warehouse with other data sources and platforms, including both cloud-based and on-premises systems.

Must-Have Hard Skills:

• In-depth proven experience with complex SQL data manipulation
• Proven Java experience ( TBC )
• Working knowledge of data warehouse
• XML, XLSX, JSON, CSV and other data source experience
• Strong oral and written communication skills and ability to simplify and explain technical issues into understandable business language.
• Sailpoint experience with bean shell knowledge

Nice-To-Have:

• Powershell experience

Soft Skills:

• Strong coordination and interpersonal skills as this role require significant interaction with different stakeholders across the Workforce IAM organization.

Job Details
13768
Contract
10 months
Toronto
89.00 CAD
Recruiter
Karan Singh
|

Skills Required