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

Robust 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

#J-18808-Ljbffr

📌 Senior Database Developer – Contract (Manitoba)
🏢 Jobtailor
📍 Manitoba