Skip Navigation

SQL Server Developer

  • Location: Toronto, ON
  • Project Type: Information Technology (IT)

Apply to the SQL Server Developer position

"*" indicates required fields

This field is for validation purposes and should be left unchanged.
Max. file size: 128 MB.
Upload or drop files here

An Initial AI Screening will be conducted for this role. Please Click Here to complete your AI screening while submitting your application.

JOB DESCRIPTION

Location: Hybrid (Downtown, Toronto)

Duration: 6 months

Our client a leading financial institution in Downtown Toronto is looking for a SQL Server Developer to support Software Currency Upgrade initiative .The successful candidate will have the opportunity to work with one of the Top 5 Banks in Canada.

Typical Day in role:

  • Implement data ingestion pipelines / DevOps on prem (SQL Server / SSIS / ETL) and / or cloud (Databricks on Azure or GCP) to move data from source systems to our central data warehouse – note that the cloud piece will come later so in the next few months focus will be on prem with SQL server
  • Lead data initiatives as the technical lead / technical pm from intake / requirements / estimations to solution design, development, testing, and productionization of data processes
  • Lead developers (consisting of contractors as well as full time employees) to enable data processes
  • Developing SQL queries / ETL packages using T-SQL and SSIS, python to ingest data from source systems to integrate with data warehouse
  • Provide smooth transition to Operations team to ensure processes are sustained effectively once they go live
  • Support for design and development of high quality dashboards / reports using tools like Power BI, SSRS, Excel/PowerPivot and Tableau.
  • 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

Must-Have Skills:

  • 8 years of relevant working experience as a developer
  • 5+ years’ experience as a SQL Server Developer (SQL Server, TSQL, ETL / SSIS) developing data ingestion processes to warehouse data
  • 5+ years’ experience with database design and data warehousing
  • 5+ years’ experience developing code to consume REST API services

Nice-To-Have Skills:

  • Experience with Data solutions on Azure (eg. Databricks) or GCP (Google Cloud Platform)
  • Experience with implementing DevOps / MS Azure Cloud services
  • Experience with web development (in .NET / SharePoint / Power Apps / Power Platform)
  • Experience from banking sector

Soft Skills Required:

  • Attention to detail
  • Communication skills

Education:

  • Bachelors in technical field
  • Certifications – Databricks, SQL, SQL Serv

FP Inc. is committed to creating an inclusive environment where all team members and clients feel like they belong. In accordance with the requirements set out in the Employment Standards Act, FP Inc. hereby declares that AI is utilized in the screening process for this position. The hourly compensation range for this role is 60/hr -71hr. We seek applicants with a wide range of abilities, and we provide an accessible candidate experience. We advocate for you and welcome anyone regardless of race, colour, religion, national origin, sex, physical or mental disability, or age.