Senior Database Developer – Contract

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

• 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 further automate, fix issues, and increase efficiency across database, ETL, and business line processing
• Focus on SQL and PL/SQL application development using packages, store procedures, functions, triggers, and views
• Automate complex processes using SQL agent jobs, SQL Server Integration Services, 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 the implementation of the code
• Write clean, fast code that is free of bloat and unnecessary overhead
• Ensure accuracy and integrity of data through the development of constraints and validation rules

Requirements

• Bachelor’s degree in computer science or related field is preferred
• A combination of education and experience will be considered
• Experience with: SQL Server 2019 or above, SSIS, SSRS, SSAS
• Extensive (ideally at least 7 years of) experience developing ETL
• A strong technical background and substantial experience in managing and administering Microsoft SQL Server infrastructure
• Demonstration of a deep understanding of database architecture, performance, security, and integrity
• Data access and table maintenance, developing and administering ETL processes using SSIS and other tools
• SQL coding and performance tuning, and proactive monitoring and alerting
• Experience utilizing and interpreting data models, developing reporting, data marts, analytic cubes, and visualization
• Strong analytical and critical thinking skills
• Ability to clearly articulate complex technical information to non-technical stakeholders and collaborate effectively with cross-functional teams
• Ability to manage multiple projects and priorities while meeting deadlines and maintaining high-quality work
• Ability to find innovative solutions to data management challenges, especially when dealing with complex or ambiguous situations
• Ability to evaluate and interpret data-related requirements, anticipate issues, and propose effective, scalable solutions
• Commitment to staying current with database/reporting/Microsoft SQL Server tools and technologies

Core Competencies

Demonstrates expertise in SQL and PL/SQL application development, including ETL processes and database performance tuning. Proficient in managing Microsoft SQL Server infrastructure and implementing data solutions that ensure accuracy, integrity, and efficiency.

Hard Skills

• SQL Development
• PL/SQL Application Development
• ETL Processes
• Database Architecture
• Performance Monitoring
• Data Structures
• Data Analysis
• Data Integrity
• SQL Coding Standards
• Data Visualization

Soft Skills

• Analytical Thinking
• Collaboration
• Project Management
• Problem Solving
• Communication

Industry Keywords

• OLTP
• OLAP
• Data Marts
• Analytic Cubes
• Continuous Improvement

Tools & Technologies

• SQL Server Integration Services
• SQL Server Reporting Services
• SQL Server Analysis Services
• Source Control Systems
• SQL Agent Jobs