Data Engineer

ALLTECH CONSULTING SVC INC; Montreal (administrative region); On-site; CAD 75,000 - 95,000; Full time

Benefits offered by this job

Career development opportunities

Supportive learning environment

State-of-the-art office space

Job summary

A consulting services company in Montreal is seeking a skilled ETL Developer to spearhead data extraction and transformation initiatives. This role requires strong Python expertise, hands-on experience with cloud services like DataBricks, and a firm grasp of ETL principles. The ideal candidate thrives in an agile setting and possesses excellent problem-solving skills. Join us to innovate and streamline data processes in a vibrant, collaborative environment.

Qualifications

• Proficiency in Python programming and writing efficient code.
• Experience with DataBricks for scalable data pipeline management.
• Solid understanding of ETL principles and data warehousing concepts.

Responsibilities

• Collaborate with teams to design efficient ETL processes.
• Develop and deploy ETL jobs that extract data from various sources.
• Take ownership of the entire engineering lifecycle for ETL.

Skills

Python programming

DataBricks

ETL processes

Snowflake

Agile methodologies

Git

Linux operating systems

REST APIs

Tools

Power BI

Apache Airflow

Hadoop

Spark

Job description

Job Description

We provide:

• A robust career development path offering numerous opportunities for growth, learning and advancement.
• A supportive, learning-oriented environment in collaboration with development within fast-feedback agile delivery squads
• Collaborative work within cross-functional squads, following agile practices and utilizing both cloud and on-premises technology to deliver innovative solutions.
• Encouragement for every developer to contribute their unique perspective – your ideas will be valued, and you’ll receive full support in their implementation!
• Participation in an international environment with various multidisciplinary squads, working alongside customers, product experts, and SREs.
• A dynamic environment where cutting-edge technology propels us.
• State-of-the-art offices located in the City Centre designed to enhance collaboration.

Role Responsibilities

You will be responsible for:

• Collaborating with cross-functional teams to understand data requirements, and design efficient, scalable, and reliable ETL processes using Python and DataBricks
• Developing and deploying ETL jobs that extract data from various sources, transforming it to meet business needs.
• Taking ownership of the end-to-end engineering lifecycle, including data extraction, cleansing, transformation, and loading, ensuring accuracy and consistency.
• Creating and manage data pipelines, ensuring proper error handling, monitoring and performance optimizations
• Working in an agile environment, participating in sprint planning, daily stand-ups, and retrospectives.
• Conducting code reviews, provide constructive feedback, and enforce coding standards to maintain a high quality.
• Developing and maintain tooling and automation scripts to streamline repetitive tasks.
• Implementing unit, integration, and other testing methodologies to ensure the reliability of the ETL processes
• Utilizing REST APIs and other integration techniques to connect various data sources
• Maintaining documentation, including data flow diagrams, technical specifications, and processes.

You have

• Proficiency in Python programming, including experience in writing efficient and maintainable code.
• Hands‑on experience with cloud services, especially DataBricks, for building and managing scalable data pipelines
• Proficiency in working with Snowflake or similar cloud-based data warehousing solutions
• Solid understanding of ETL principles, data modelling, data warehousing concepts, and data integration best practices
• Familiarity with agile methodologies and the ability to work collaboratively in a fast‑paced, dynamic environment.
• Experience with code versioning tools (e.g., Git)
• Meticulous attention to detail and a passion for problem solving
• Knowledge of Linux operating systems-Familiarity with REST APIs and integration techniques

You might also have

• Familiarity with data visualization tools and libraries (e.g., Power BI)
• Background in database administration or performance tuning
• Familiarity with data orchestration tools, such as Apache Airflow
• Previous exposure to big data technologies (e.g., Hadoop, Spark) for large data processing