SQL Server Data Engineer & ETL Specialist

Becker County; Brantford; On-site; CAD 71,000 - 88,000; Full time

Job summary

Holstein Canada is seeking a skilled Database Administrator and Developer to support an ETL and data migration project and ensure reliable, secure, high-performing SQL Server environments. This role collaborates with SMEs, analysts, developers, and internal teams to understand business rules, data relationships, validation needs, and operational requirements.

The successful candidate will bring strong SQL Server, ETL, reporting, database administration, and documentation skills, along with the

Qualifications

• Strong experience with SQL Server, T-SQL, SSMS, SSIS, SSRS, SSAS, ETL development, and database administration.
• Experience building and maintaining data warehouses.
• Knowledge of backup/recovery, maintenance, performance tuning, indexing, monitoring, and troubleshooting.
• Experience with data migration, mapping, reconciliation, validation, and data quality resolution.
• Knowledge of database security, permissions, access reviews, service accounts, and handling sensitive data.
• Experience with Azure DevOps, Visual Studio, Git, GitHub Copilot, deployments, pipelines, and environment promotion is an asset.
• Ability to quickly learn complex business processes, systems, terminology, and data relationships.
• Strong documentation skills to create clear standards, procedures, and support materials.
• Excellent analytical, troubleshooting, communication, and collaboration skills.

Responsibilities

• Design, develop, administer SQL Server databases, ETL processes, and related solutions.
• Manage backups, recovery testing, maintenance, indexing, monitoring, and health checks.
• Manage Azure DevOps build and release pipelines for SQL Server databases, SSIS, SSAS and SSRS projects, ensuring controlled deployments, validation, and rollback processes
• Write, debug, and optimize complex T-SQL, stored procedures, functions, and database objects.
• Support data mapping, migration, validation, reconciliation, and issue resolution.
• Build and maintain database and BI solutions using SQL Server, SSIS, SSAS, and SSRS.
• Monitor, troubleshoot, and improve database performance, query execution, resource use, and configuration.
• Support database security, access management, permissions, service accounts, and secure data handling.
• Coordinate refreshes, environment updates, deployments, version control, validation, and rollback processes.
• Document business rules, ETL logic, standards, dependencies, procedures, and processes.
• Collaborate with SMEs, analysts, developers, third parties, and internal teams on reliable data solutions.

Skills

SQL Server

T-SQL

SSMS

SSIS

SSRS

SSAS

ETL

Data Warehousing

Database Administration

Azure DevOps

Git

GitHub Copilot

Education

Post-secondary education in Computer Science / IT or related field

Tools

Azure DevOps

Visual Studio

Git

GitHub Copilot

Job description

Holstein Canada is seeking a skilled Database Administrator and Developer to support an ETL and data migration project and ensure reliable, secure, high-performing SQL Server environments. This role collaborates with SMEs, analysts, developers, and internal teams to understand business rules, data relationships, validation needs, and operational requirements.

The successful candidate will bring strong SQL Server, ETL, reporting, database administration, and documentation skills, along with the