Hiring Manager: Senior Manager Development, Global Compliance Technology
Location Address: Fully remote
Contract Duration: Until October 31st, 2023
Number of Positions: 1
Scheduled Hours: Monday to Friday, 9am-5pm
Extension Opportunity: Yes
Story Behind the Need:
The Enterprise Compliance and Regulatory Systems team is accountable for developing and supporting a number of compliance and risk management data and reporting solutions within the Bank. The team is seeking an ETL Data Engineer to ingest data from source systems to our data warehouse and to develop dashboards and reports. The incumbent will be joining a team of solution developers and architects that focus on on prem and cloud data platforms utilized in compliance and risk management.
Candidate Value Proposition:
The successful candidate will have the opportunity to work within the bank. We are technology partners who help the business transform how our employees around the world work. You will get to work with and learn from diverse industry leaders, who have hailed from top technology.
Typical Day in Role:
Reporting to the Senior Manager – Development of Enterprise Compliance and Regulatory Systems, the incumbent will be responsible for the following:
• Implementing data ingestion pipelines / DevOps (on prem and Azure cloud) to move data from source systems to our central data warehouse
• Developing SQL queries / ETL packages using T-SQL and SSIS to ingest data from source systems to integrate with data warehouse
• Design and development of high quality dashboards / reports using tools like Power BI, SSRS, Excel/PowerPivot and Tableau.
• Develop custom reports, analytics and KPI’s for the Business and Collecting business requirements / user stories from clients
• Complete testing to ensure high quality product for clients
• Developing SQL views to enable data consumers to read data from data warehouse
• Integrate systems via REST API, database views, SharePoint lists, sFTP, etc
• Responsible for documenting databases, data process flows and maintain data dictionaries
• Troubleshoot and resolve database and applications defects in a timely manner. Consult with internal and external groups as required
• Coordinating code deployments / production implementations.
• Train and assist users at all levels
Candidate Requirements/Must-Have skills:
1. 3+ years of experience with Microsoft BI stack SQL Server, T-SQL, SSIS development required
2. 3+ years of experience with data warehouse, ETL, SSIS to move data / integrate systems required
3. 3+ years of experience with databases, data modeling design required
4. Expertise with data visualization / BI tools e.g. Power BI, SSRS
5. Experience with SDLC methodologies e.g. Agile / Waterfall
Nice-To-Have Skills:
• Experience with Azure Data / Synapse / EDL / Hadoop / Hive / Jupyter Notebooks / Tableau
• Knowledge on Banking / Risk related systems
• Experience developing code to consuming REST API services
• Experience integrating systems with COTS Commercial Off The Shelf software packages
• Experience with implementing DevOps / MS Azure Cloud services, Google Cloud Platform etc.
• Experience with web development (in ASP.NET / SharePoint / Power Apps / Power Platform)
• Experience working with SFTP File transfers
Soft Skills:
• Excellent written, presentation, and verbal communication skills to be able to work well with technical peers and business stakeholders at different levels within the organization.
• Strong decision making, forward thinking and creative problem-solving skills to anticipate and respond quickly to technological/market influences.
• Ability to work as part of a team, as well as work independently or with minimal direction.
• Attention to detail and feedback from clients on dashboards and reports must be completed rapidly
Education/Experience:
• Post-secondary degree in a technical field such as computer science, computer engineering or related IT field required