ETL and Data Developer

Jobtailor; Quebec; On-site; CAD 90,000 - 120,000; Full time

Job summary

Jobtailor in Quebec, Canada seeks an experienced analytics solutions developer to support business lines and solution designers by analyzing data and translating needs into specifications.

You will document data flows, implement data solutions, and test strategies while collaborating across business units to deploy reliable analytics and data-loading processes.

Qualifications

• 5+ years in analytics solutions development with IT training.
• Strong Azure, Data Factory, Snowflake, ETL concepts, and deployment pipelines.
• Knowledge of medallion architecture is a plus.
• Familiar with SAFe®, Agile, and SDLC methodologies.
• Clear communicator, organized, team-oriented with problem-solving skills.
• Experience in analytics, data warehousing, and data promotion/loading processes.
• Fluent French and intermediate English.

Responsibilities

• Support the business line and solution designer in analyzing data and translating business needs into specifications.
• Document data flows and processing rules for corporate data.
• Implement data solutions in line with data models and best practices.
• Document testing strategy and implement functional test scenarios.
• Create access groups and the RBAC matrix.
• Collaborate on iterative production deployment with various units.
• Implement data quality controls for solutions.
• Oversee data loads, communicate progress, and support operations.
• Handle service requests, incidents, and data corrections.
• Respond to audit requests and participate in planning and obsolescence management.
• Communicate with vendors to resolve issues and manage version updates.

Skills

Azure

Data Factory

SQL

ETL Concepts

Data Warehousing

Deployment Pipelines

Agile Methodologies

SAFe Framework

Software Development Lifecycle

French fluency

English proficiency

Education

Formal training in information technology

Tools

Snowflake

Deployment Pipelines

Job description

• Support the business line and solution designer in analyzing data and translating business needs into specifications
• Document data flows and processing rules for corporate data
• Implement data solutions in accordance with data models and analytical development best practices
• Document the testing strategy and implement functional test scenarios
• Create access groups and the RBAC matrix
• Collaborate on the iterative production deployment of solutions with various business units
• Implement data solution quality controls
• Oversee data loads, communicate progress, resolve issues, and support solution operations
• Handle service requests, incidents, and data corrections
• Respond to internal and external audit requests
• Participate in the planning and evolution of data solutions, including obsolescence management
• Communicate with vendors to resolve issues and manage version updates

Requirements

• At least 5 years of experience developing analytics solutions, along with formal training in information technology
• Strong proficiency in Azure, Data Factory, Snowflake, ETL concepts, and deployment pipelines
• Knowledge of medallion architecture concepts is an asset
• Good knowledge of techniques, frameworks, and methodologies used in the field, including SAFe®, Agile, and the Software Development Lifecycle
• Excellent communicator who is organized and able to explain technical concepts clearly, with strong synthesis skills and the ability to work effectively in a team
• Proactive in identifying and resolving problems
• Extensive knowledge of analytics methodologies and tools, including data warehousing
• Knowledge of data promotion and loading processes
• Strong command of SQL
• Curious, self-directed, and rigorous
• Knowledge of the insurance and financial services industries is a strong asset
• Fluency in French
• Intermediate proficiency in English

Core Competencies

Demonstrates expertise in developing analytics solutions, implementing data quality controls, and managing data flows while effectively communicating technical concepts. Proficient in SQL and familiar with Azure, Data Factory, and ETL processes, with a strong understanding of the insurance and financial services industries.

Highest-signal resume keywords

• Azure
• Data Factory
• SQL
• ETL Concepts
• Data Warehousing

Hard Skills

• Analytics Solutions Development
• Data Flow Documentation
• Functional Testing Strategy
• Data Solution Quality Controls
• Data Promotion Processes
• Medallion Architecture Concepts
• Deployment Pipelines
• Agile Methodologies
• SAFe® Framework
• Software Development Lifecycle

Soft Skills

• Excellent Communication
• Organizational Skills
• Problem Solving
• Team Collaboration
• Synthesis Skills

Industry Keywords

• Insurance Industry
• Financial Services Industry