Senior Data Engineer / Technical Lead (SQL Server & Data Warehouse)

Dawn InfoTek Inc. is a professional IT consulting team that partners with major financial institutions, investment firms and government sectors. We have been dedicated to delivering cutting-edge consulting services and recruiting all levels of IT positions for our clients.

We are currently seeking competent individuals to fulfill the role of Senior Data Engineer / Technical Lead (SQL Server & Data Warehouse) to join our dynamic team for our client, one of the major banks.

Location Address: Hybrid - 1 day/week (flexible)

Subject to change: 3–4 days onsite may be required based on business needs

Contract Duration: ASAP to 10/31/2026 – approx. 7 months

Possibility of extension & conversion to FTE

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

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:

1) 10 years of relevant working experience as a developer

2) 5+ years’ experience as a SQL Server Developer (SQL Server, TSQL, ETL / SSIS) developing data ingestion processes to warehouse data

3) 5+ years’ experience with database design and data warehousing

Nice-To-Have Skills:

1) Experience with Data solutions on Azure (eg. Databricks or Synapse/ADF) or GCP (Google Cloud Platform) a plus

2) Experience with implementing DevOps / MS Azure Cloud services,

3) Experience with web development (in .NET / SharePoint / Power Apps / Power Platform) a plus

4) Experience from banking sector

4) 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

Education

Bachelors in technical field

Certifications – Databricks, SQL, SQL Server – nice to have