Data Engineer

Description

Position: Senior SQL/Data Engineer (Technical Lead)

Locations: Toronto, ON (Hybrid – Onsite 1x/week) /44 King Street W, 19th Floor, Toronto.

Note:

Onsite days may increase to 3–4 days as needed.

Duration: 07+ months (possible extensions) | Contract to FTE

Client: Fin Tech / Banking

Director, Development

You will join the GBME – Regulatory & Compliance Technology group, part of the Global Compliance Technology team. The team builds secure, scalable data and reporting solutions to support compliance, risk management, and procurement initiatives. You’ll work with a collaborative group of 10–15 developers, architects, and project managers across both on‑prem and cloud platforms.

The Senior SQL/Data Engineer will lead and implement end‑to‑end data ingestion solutions, primarily using SQL Server, T‑SQL, SSIS, ETL, and later expanding into Azure Databricks / cloud technologies. This role requires both hands‑on development and technical leadership, including guiding developers, defining requirements, designing solutions, and ensuring quality delivery.

• Design and implement data ingestion pipelines on-prem (SQL Server / SSIS / ETL) and later in cloud environments (Azure Databricks or GCP).
• Develop SQL queries, T‑SQL procedures, SSIS packages, and Python scripts for ETL workflows.
• Build SQL views and data structures that support analytics and reporting.
• Integrate with systems via REST APIs, sFTP, database views, SharePoint lists, etc.

• Lead technical initiatives from intake and requirements gathering to development and production deployment.
• Provide guidance to contractors and FTE developers on data engineering processes.
• Own solution design, estimation, testing, implementation, and documentation.

• Build solutions using Power Apps, Power Automate, SharePoint, and related platforms to capture and manage user input.

• Contribute to the development of dashboards and reports using Power BI, SSRS, Excel/Power Pivot, Tableau.

• Ensure smooth transitions to operations after go-live.
• Troubleshoot and resolve data and application issues.
• Maintain data dictionaries, documentation, and data process flows.
• Coordinate code deployments and production implementation activities.
• Train and support end users at varying technical levels.

• 10+ years of experience as a software/data developer.
• 5+ years of SQL Server development (SQL Server, T‑SQL, SSIS, ETL) for data warehousing and ingestion.
• 5+ years of experience in database design and data warehousing.
• 5+ years of hands‑on experience integrating and consuming REST APIs.

• Experience with Azure data services (Databricks, Synapse, ADF) or GCP.
• Experience with Dev Ops and Azure cloud automation.
• Background in web development (.NET, SharePoint, Power Platform).
• Experience with in the banking or financial sector.

• Strong attention to detail with a focus on quality, thorough testing, and defect resolution.
• Good communication skills (6/10 acceptable); clear comprehension required.
• Ability to work independently, act as a technical lead, and proactively gather requirements.

• Bachelor’s degree in a technical or related field.
• Certifications in SQL, SQL Server, Databricks, or cloud platforms are an asset.

The best candidate is a meticulous, quality-driven SQL developer who can independently lead technical initiatives, design data solutions, and guide team members. They should be proactive, strong in SQL Server development, and comfortable bridging the gap between hands‑on coding and technical leadership.

• 1 round
  • MS Teams video interview (1 hour)
  • Panel:
    Hiring Manager + Architect