Job Title

Location Hybrid - 44 King Street W 19th Floor, Toronto 2 days/week (Monday, Wednesday). Subject to change: 34 days onsite may be required based on business needs. Contract Duration: ASAP to Oct 31, 2026 approx. 6.5 months. Possibility of extension. Schedule Hours: 9am-5pm Monday-Friday; standard 37.5 hrs/week Project The project focuses on MS SQL Server programming to enhance and expand a Master Data Management (MDM) system. The existing MDM stores and manages enterprise metadata. The team has recently developed the core MDM platform, and the next phase is to integrate an additional system and introduce new workflow functionality, specifically to support a multistep metadata approval process. Two other teams manage the UI components; this role is fully backendfocused, responsible for designing the database layer, building backend logic, and supporting endtoend metadata workflow processing. When end users request changes to metadata, those changes move through a defined approval process involving multiple approval groups. Once approved, they are committed to the MDM system. Your work will enable and extend this workflow. Typical Day in Role Conduct data, application, and workflow analysis Perform data modeling to define the appropriate structures for new requirements Design database objects (tables, views, functions, stored procedures) Develop and optimize TSQL code Ensure highperformance execution of queries and procedures Participate in meetings, requirement discussions, development, and debugging Work primarily in Microsoft SQL Server environments Candidate Value Proposition The successful candidate will gain handson experience with enterpriselevel metadata management within a major Canadian bank. This system is central to key bank functionsincluding ERP platforms, data warehousing, and regulatory reportingmaking this a highimpact opportunity within a critical domain. Candidate Requirements / Must Have Skills 8+ years SQL Server Database development and advanced TSQL programming 7+ years experience in Data Modeling, Data Architecture, Data Integration, Data Interfaces, or Database Design 7+ years handson Database/SQL performance tuning 5+ years experience working with data models in ERP, CRM, or other large OLTP applications NiceToHave Skills Experience with ETL or BI tools such as SSIS, SSAS, Informatica, or DataStage Experience with BI visualization tools: Power BI, Tableau, OBIEE Solid understanding of Web Services, .NET, XML, SOAP, REST, APIs, or Java Prior experience in financial services or banking Education BSc degree in Computer Science or relevant information technology field Best VS. Average Candidate The ideal candidate is a strong SQL programmer who can go beyond querying data. They should be capable of designing backend database structures, developing stored procedures and functions, and architecting solutions that deliver the required functionality efficiently and with optimal performance. Candidate Review & Selection Interview Process 1 round: 1hour MS Teams video interview with the Hiring Manager and Senior Manager, including technical SQL questions and a practical SQL programming test. #J-18808-Ljbffr