Senior SQL & ETL Database Engineer

Jobtailor; Winnipeg; On-site; CAD 85,000 - 120,000; Full time

Job summary

Jobtailor is seeking a senior SQL/ETL professional to design, implement, and optimize data interfaces and OLTP/OLAP databases in Winnipeg, Manitoba. You will develop transactional systems, ETL staging, and analytics data structures, while automating processes and enforcing coding standards.

The role requires deep SQL Server expertise (SSIS/SSRS/SSAS) and experience managing SQL Server infrastructure, with a focus on data integrity and performance.

Qualifications

• Bachelor’s degree in computer science or related field preferred.
• Extensive ETL development experience (7+ years).
• Strong MS SQL Server infrastructure management experience.
• Experience with SSIS/SSRS/SSAS and data modeling for analytics.
• Ability to optimize SQL performance and enforce coding standards.
• Excellent problem solving and cross-functional collaboration.

Responsibilities

• Plan, design, and implement complex data interfaces, transformations, and OLTP and OLAP databases.
• Model, develop, and implement transactional, ETL staging, and analysis/reporting databases, data structures, and cubes to satisfy business and technical requirements.
• Complete continuous improvement projects to increase automation, fix issues, and enhance efficiency across database, ETL, and business line processing.
• Focus on SQL and PL/SQL application development using packages, stored procedures, functions, triggers, and views.
• Automate complex processes using SQL agent jobs, SSIS, etc.
• Manage SQL code in a source control system.
• Implement database performance monitoring and tuning.
• Establish and enforce SQL development coding standards and best practices.
• Lead/participate in SQL code reviews.
• Train other development teams on code implementation.
• Write clean, fast code free of overhead and bloating.
• Ensure data accuracy and integrity through constraints and validation rules.

Skills

SQL Development

PL/SQL Application Development

ETL Processes

Database Architecture

Performance Monitoring

Data Structures

Data Analysis

Data Integrity

SQL Coding Standards

Data Visualization

Education

Bachelor’s degree in computer science or related field

Combination of education and experience considered

Tools

SQL Server Integration Services

SQL Server Reporting Services

SQL Server Analysis Services

Source Control Systems

SQL Agent Jobs

SQL Server 2019+

Job description

Jobtailor is seeking a senior SQL/ETL professional to design, implement, and optimize data interfaces and OLTP/OLAP databases in Winnipeg, Manitoba. You will develop transactional systems, ETL staging, and analytics data structures, while automating processes and enforcing coding standards.

The role requires deep SQL Server expertise (SSIS/SSRS/SSAS) and experience managing SQL Server infrastructure, with a focus on data integrity and performance.