Developer – SQL & ETL

Developer – SQL & ETL

ProViso Consulting

Story Behind of the Need:

• Business Group: IT Risk is seeking a SQL/ ETL Developer to work on a Microsoft solution to build a data repository and reporting based on it
• Project: The group is working on Regulatory Reviews that are anticipated to be completed Q1 2023

Primary Responsibilities:

• Understand and interpret business requirements, design the data model and find the best fit data architecture solution
• Identify and document specifications and processes
• Work in Extract Transform and Load (ETL) development and testing using SQL Server Integration Services (SSIS) to acquire or transpose data from other systems or databases into report databases and maintain databases as required to support reporting and reporting environments
• Conduct ETL, SQL and DB performance tuning, troubleshooting, support, and capacity estimation to ensure highest data quality standards with the business and technical SME’s
• Design and develop solutions to integrate various data sources into a complex environment

Candidate Value Proposition

• The successful candidate will have the opportunity to gain exposure to multiple bank streams while analyzing and ensuring regulatory data is accurate for business users
• The successful contractor will be on a long term engagement for upwards of two years

Must have skills:

• 5 + years ETL Development experience
• 5 + years experience reading, writing and creating SQL Queries as well as SSIS
• 5 + years experience with Microsoft Stack (SQL server, SSIS, SSMS)
• Strong communication skills to work with BSA to ensure accurate translation of requirements into technical requirements

Nice to have:

• Financial Industry experience with Regulations
• Power BI is a plus and will be prioritized


• Microsoft Teams Interview: 2 Interview through teams ( 1 Technical + 1 Situational)
• Decision Date: Target decision date by July 16th

Additional Notes:

• Open to resources from any industry is ok as long as they have relevant experience.
• Manager needs someone who can hit the ground running and can start for the first week of August
• Breakdown of the role:
o Data management (needed for the ETL Developer – 70 – 75%) – analyze data from being collected
o BSA – (70 – 75%) for liasing would be collecting requirements, identify sources, look for project, looking for someone who can work with skills (maybe some PM skills) to analyze data and work with stakeholders and fill gap

Job Details



12 Months



Latest Blogs

© 2020 ProViso Consulting - Toronto Recruitment and Staffing Agency

Send this to a friend