ETL & Data Warehouse Developer

Wissen Technology; Montreal (administrative region); Hybrid; CAD 80,000 - 100,000; Full time

Benefits offered by this job

Healthcare insurance for you and your family

Paid Time Off

Support for industry certifications

Job summary

A high-end technical consulting firm is seeking an ETL & Data Warehouse Developer to design and maintain robust database solutions. Candidates should have over 6 years of experience with a strong background in SQL, data warehousing, and ETL processes. The role requires collaboration with stakeholders to ensure data integrity and quality. This is a full-time hybrid position with excellent benefits.

Qualifications

• 6+ years of experience in database development, ETL, or data engineering roles.
• Strong expertise in SQL for optimization and modeling.
• Experience with data warehousing concepts and ETL tools.

Responsibilities

• Design and develop database objects and ETL pipelines.
• Collaborate with stakeholders for high-quality data solutions.
• Ensure data integrity and quality across all stages.

Skills

SQL (query optimization, data modeling)

ETL processes

Snowflake or similar cloud platforms

Data performance analysis

Python/Shell scripting

Education

Graduate-level degree in computer science, engineering, or related technical field

Tools

Snowflake

Spark

Databricks

Job description

Overview

The Wissen team continues to expand its footprint in the USA, Canada, UK, Australia, and India. More openings to come as we continue to grow the team!

Please read below for a brilliant career opportunity.

Role: ETL & Data Warehouse Developer

Title: AVP

Mode of Work: 3 days/week onsite required

Required Experience: 6+ years

Responsibilities

• Design, develop, and maintain robust database objects, ETL pipelines, and large-scale data warehouse solutions to support enterprise-level reporting and analytics initiatives.
• Build and optimize data models, perform data and performance analysis, and ensure best practices in database design and query optimization.
• Develop and maintain scalable ETL processes for data ingestion, transformation, and integration from multiple sources.
• Leverage Snowflake (or similar cloud data platforms) for scalable data storage, processing, and analytics; experience with Spark or Databricks is a plus.
• Collaborate with business stakeholders, data engineers, and analytics teams to understand requirements and deliver high-quality data solutions.
• Optimize and troubleshoot SQL queries, data models, and ETL scripts for performance and reliability.
• Ensure data integrity, quality, and security across all stages of the data lifecycle.
• Document data flows, processes, and technical solutions for ongoing support and knowledge sharing.
• Participate in agile ceremonies, continuous improvement initiatives, and foster a culture of innovation and learning.

Required Technical Skills

• 5+ years of hands-on experience in database development, ETL, or data engineering roles.
• Strong expertise in SQL (query optimization, data modeling, and performance tuning).
• Proficiency with Snowflake (ideal) or similar cloud data platforms for data warehousing and analytics.
• Experience with ETL tools, scripting (Python/Shell), and building scalable data pipelines.
• Solid understanding of data warehousing concepts, dimensional modeling, and best practices.
• Experience with data and performance analysis, troubleshooting, and optimization.
• Demonstrated experience or strong interest in leveraging GenAI, Copilot, or AI-based tools for data engineering, automation, or reporting, including design, code completion, review, and automated test case generation.
• Experience with automated testing and testing frameworks.

Additional Skills (Good to Have)

• Experience with Spark, Databricks, or Azure cloud platforms.
• Familiarity with Power BI for data visualization and reporting.
• Experience with workflow automation tools (e.g., Apache Airflow, Autosys).
• Exposure to OLAP tools and multidimensional data modeling.
• Knowledge of data processing using Python and JSON data manipulation.
• Excellent problem-solving, analytical, and communication skills.
• Strong communication skills and ability to work collaboratively in a global team environment.
• Dynamic, flexible, and eager to learn new technologies; solution-oriented and adaptable to changing priorities.
• Prior exposure to the finance or investment banking domain is an advantage.

Benefits

• Healthcare insurance for you and your family (medical, dental, vision).
• Short / Long term disability insurance.
• Life Insurance.
• Accidental death & disability Insurance.
• 3 weeks of Paid Time Off.
• Support and fee coverage for immigration needs.
• Remote office set up stipend.
• Support for industry certifications.
• Additional cash incentives.
• Reskilling opportunities to transition between technologies.

Schedule: Monday to Friday

Work Mode: Hybrid

Job Type: Full-time

We are: A high end technical consulting firm built and run by highly qualified technologists. Our workforce consists of 5000+ highly skilled professionals, with leadership from Wharton, MIT, IITs, IIMs, and NITs and decades of experience at Goldman Sachs, Morgan Stanley, MSCI, Deutsche Bank, Credit Suisse, Verizon, British Telecom, ISRO etc. Without any external funding or investments, Wissen Technology has grown its revenues by 100% every other year since it started as a subsidiary of Wissen Group in 2015. We have a global presence with offices in the US, India, UK, Australia, Mexico, and Canada.

You are: A true tech or domain ninja. Or both. Comfortable working in a quickly growing profitable startup, have a “can do” attitude and are willing to take on any task thrown your way.

You will:

• Develop and promote the company’s culture of engineering excellence.
• Define, develop and deliver solutions at a top tier investment bank or another esteemed client.
• Perform other duties as needed

Your Education and Experience:

• We value candidates who can execute on our vision and help us build an industry-leading organization.
• Graduate-level degree in computer science, engineering, or related technical field
• Wissen embraces diversity and is an equal opportunity employer. We are committed to building a team that represents a variety of backgrounds, skills, and abilities. We believe that the more inclusive our team is, the better our work will be. All qualified applicants, including but not limited to LGBTQ+, Minorities, Females, the Disabled, and Veterans, are encouraged to apply.

The Wissen Group was founded in the year 2000. Wissen Technology, a part of Wissen Group, was established in the year 2015. Wissen Technology is a specialized technology company that delivers high-end consulting for diverse industries, including Banking, E-commerce, Telecom, Healthcare, Manufacturing, and Energy. We help clients build world-class products. We have offices in the US, India (Bangalore, Hyderabad, Chennai, Gurugram, Mumbai, Pune), UK, Australia, Mexico, Vietnam, and Canada.

We empower businesses with a dynamic portfolio of services and accelerators tailored to today’s digital demands and based on future ready technology stack. Our services include Industry Leading Custom Software Development, AI-Driven Software Engineering, Generative AI & Machine Learning, Real-Time Data Analytics & Insights, Interactive Data Visualization & Decision Intelligence, Intelligent Process Automation, Multi-Cloud & Hybrid Cloud Strategies, Cross-Platform Mobile Experiences, CI/CD-Powered Agile DevOps, Automated Quality Engineering, and cutting-edge integrations.

Certified as a Great Place to Work® for five consecutive years (2020-2025) and recognized as a Top 20 AI/ML vendor by CIO Insider, Wissen Group has delivered multimillion-dollar projects for over 20 Fortune 500 companies. Wissen Technology delivers exceptional value on mission-critical projects through thought leadership, ownership, and reliable, high-quality, on-time delivery.

Our industry-leading technical expertise stem from the talented professionals we attract. Committed to fostering their growth and providing top-tier career opportunities, Wissen ensures an outstanding experience and value for our clients and employees.

We Value:

• Perfection: Pursuit of excellence through continuous improvement.
• Curiosity: Fostering continuous learning and exploration.
• Respect: Valuing diversity and mutual respect.
• Integrity: Commitment to ethical conduct and transparency.
• Transparency: Open communication and trust.

Wissen Thought leadership: https://www.wissen.com/articles/

Employee Speak:

https://www.wissen.com/blog/we-work-on-highly-complex-technology-projects-here-is-how-it-changes-whom-we-hire/

Wissen: A Great Place to Work

https://www.wissen.com/blog/here-is-what-ownership-and-commitment-mean-to-wissenites/

A technology consultancy that drives digital innovation by connecting strategy and execution, helping global clients to strengthen their core technology.