SQL Server Developer – Azure

JOB DESCRIPTION

Location: Hybrid | Downtown, Toronto

Duration: 4 months | Possibility of extension

Our client, a leading financial institution in Downtown Toronto, is looking for a SQL Server Developer - Azure to Train and assist users at all levels. 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
• Developing Power Apps / Power Automate / SharePoint solutions to capture information from end users
• Provide smooth transition to the 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 maintaining data dictionaries
• Troubleshoot and resolve database and application defects in a timely manner. Consult with internal and external groups as required
• Coordinating code deployments/production implementations.

Must Have Skills:

• 10 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

Nice-To-Have Skills:

• Experience with Data solutions on Azure (eg. Databricks or Synapse/ADF) or GCP (Google Cloud Platform) a plus
• Experience with implementing DevOps / MS Azure Cloud services,
• Experience with web development (in .NET / SharePoint / Power Apps / Power Platform) a plus
• Experience from banking sector
• Experience developing code to consume REST API services

Soft Skills Required:

• Attention to detail – keen eye for testing, defects – need someone who can focus on delivering quality results – needs to be meticulous
• Communication skills – 6/10 is OK, as long as can understand each other, accented is OK

Education

• Bachelors in technical field
• Certifications – Databricks, SQL, SQL Server – nice to have

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 -$74/hr. 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.