SQL Developer

TekStaff's Client has a current vacancy for SQL Developer

Pay Rate Range: $59-$73 per hour

This is a 4 month contract located in Toronto, ON/ Hybrid (1 day/ week)

Job Description 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, 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 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

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

Train and assist users at all levels

Candidate Value Proposition We're looking for a passionate Software Engineer who thrives on solving data challenges and building reliable pipelines that fuel decision-making. If you're excited by the idea of working with modern data platforms and contributing to meaningful initiatives, this is your opportunity to grow and make a difference. Potential exposure to Azure Data Bricks, new technologies.

Candidate Requirements / 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

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

Interview Process 1 round – MS Teams Video Interview – 1 hour – with HM and an architect

behavioural and situation questions

TekStaff may use artificial intelligence (AI) tools as part of the applicant screening process. However, applications will also be reviewed by a member of our Recruitment team to ensure a fair and thorough assessment.

#J-18808-Ljbffr