Current jobs related to Senior Data Warehouse Engineer, Modernization and Performance - Montreal, Quebec - Capgemini

  • Senior Cloud Data Warehouse Engineer

    3 days ago

    Montreal, Quebec, Canada NTT DATA North America Full time $120,000 - $180,000 per year

    Req ID:338998NTT DATA strives to hire exceptional, innovative and passionate individuals who want to grow with us. If you want to be part of an inclusive, adaptable, and forward-thinking organization, apply now.We are currently seeking a Senior Cloud Data Warehouse Engineer to join our team in Montreal, Quebec (CA-QC), Canada (CA).Job Title: Senior Cloud...

  • Senior Data Warehouse Engineer

    1 week ago

    Montreal, Quebec, Canada Epsilon Solutions Ltd. Full time $120,000 - $180,000 per year

    Role Name: Senior Data Warehouse Engineer,Location: Montreal- HybridContractJOB DESCRIPTION:"We are seeking a highly experienced and results-oriented Senior Data Warehouse Engineer to work our data warehouse modernization and performance optimization initiatives. The ideal candidate will possess deep expertise in database programming and enterprise job...

  • Senior Cloud Data Warehouse Engineer

    2 weeks ago

    Montreal, Quebec, Canada Vivid Soft Global Full time $120,000 - $180,000 per year

    Title: Senior Cloud Data Warehouse EngineerLocation: Montreal / Hybrid / Local candidates only / F2F is requiredJOB DESCRIPTION:Team OverviewThe Controls Engineering, Measurement and Analytics (CEMA) department is responsible for Cyber Risk and Control assessment, management, monitoring, and reporting capabilities across Technology, resulting in risk...

  • Senior DevOps Engineer – Data Warehouse

    1 week ago

    Montreal, Quebec, Canada Aptino, Inc. Full time $60,000 - $120,000 per year

    Contract Rate: CAD $40/hourWe are seeking a Senior DevOps Engineer to lead the modernization of our data warehouse and .NET application delivery processes. This high-impact role will design and implement advanced GitLab CI/CD pipelines, automate legacy workflows, and integrate enterprise scheduling tools to transform how we deliver data and...

  • Senior Data Engineers

    3 days ago

    Montreal, Quebec, Canada Software International Full time $120,000 - $180,000 per year

    Software International (SI) supplies technical talent to a variety of clients ranging from Fortune 100/500/1000 companies to small and mid-sized organizations in Canada/US and Europe.We currently have an long term contract role as a Senior Data Engineers (x2) - Microsoft Fabric with our global SAP consulting client, working at a large CPG clients'...

  • Data Warehouse Engineer

    23 hours ago

    Montreal, Quebec, Canada Capgemini Full time US$80,000 - US$120,000 per year

    Choosing Capgemini means choosing a company where you will be empowered to shape your career in the way you'd like, where you'll be supported and inspired by a collaborative community of colleagues around the world, and where you'll be able to reimagine what's possible. Join us and help the world's leading organizations unlock the value of technology and...

  • Senior Data Engineer

    1 week ago

    Montreal, Quebec, Canada KData AI Full time $120,000 - $180,000 per year

    About KData Inc.At KData Inc., we don't just work with data – we unlock its potential. We are a forward-thinking data and AI solutions provider, empowering businesses to transform their operations through the power of the Lakehouse. Our team is a collective of passionate data professionals dedicated to building elegant, scalable, and impactful data...

  • Senior Data Engineering Lead

    7 days ago

    Montreal, Quebec, Canada TM8 Full time US$120,000 - US$180,000 per year

    Senior Data Engineering Lead Our client is seeking a Senior Data Engineering Lead to take ownership of designing, maintaining, and delivering highly scalable, high-performance data solutions. Reporting to the Data Engineering Manager, this role is critical for empowering faster, simpler, and better decision-making across the organization. The successful...

  • Senior Data Engineer

    1 week ago

    Montreal, Quebec, Canada EQUISOFT Full time $120,000 - $180,000 per year

    What is Equisoft? Equisoft is a global provider of digital solutions for insurance and investment, recognized by over 250 of the world's leading financial institutions. We offer a comprehensive ecosystem of scalable solutions that help our customers meet all the challenges brought about by this era of digital transformation, thanks to our business...

  • Senior Data Engineer

    1 week ago

    Montreal, Quebec, Canada Equisoft Full time $100,000 - $120,000 per year

    What is Equisoft?Equisoft is a global provider of digital solutions for insurance and investment, recognized by over 250 of the world's leading financial institutions. We offer a comprehensive ecosystem of scalable solutions that help our customers meet all the challenges brought about by this era of digital transformation, thanks to our business...

Senior Data Warehouse Engineer, Modernization and Performance

2 weeks ago

Montreal, Quebec, Canada Capgemini Full time $120,000 - $200,000 per year

We are seeking a
Senior Data Warehouse Engineer, Modernization and Performance
to lead critical initiatives focused on modernizing data warehouse systems, optimizing performance, and improving overall data process efficiency. This role requires deep expertise in
database programming, performance tuning, and enterprise job scheduling
, with a strong focus on re-platforming legacy systems to scalable, high-performing architectures. You will be responsible for driving architectural evolution while ensuring operational excellence and reliability across data environments.

Key Responsibilities

  • Lead and execute data warehouse modernization projects, re-platforming legacy components to more scalable, high-performance architectures.
  • Conduct comprehensive performance analysis of warehouse processes, ETL/ELT jobs, and SQL queries to identify bottlenecks and implement improvements.
  • Design, develop, and maintain data models, ETL/ELT frameworks, and integration solutions to support enterprise data initiatives.
  • Develop and optimize SQL and PL/SQL scripts, stored procedures, and functions for efficient data manipulation and transformation.
  • Build and maintain robust batch processes using UNIX/Linux Shell Scripting for data automation, loading, and operational monitoring.
  • Utilize Control-M (or similar enterprise job scheduling tools) to design, manage, and monitor complex workflows, ensuring performance and reliability.
  • Perform root cause analysis (RCA) for performance and system failures, implementing long-term corrective measures.
  • Define and enforce data warehouse best practices, coding standards, and architectural patterns to ensure consistency and scalability.
  • Create and maintain detailed documentation for architecture, modernization processes, and performance improvements.

Technical Profile

  • Minimum 5+ years of experience in data warehousing with a strong focus on modernization and performance optimization.
  • Expert-level proficiency in SQL for writing complex, optimized queries.
  • Advanced experience with PL/SQL for developing efficient database applications and transformations in Oracle or similar environments.
  • Shell Scripting (UNIX/Linux) expertise for job control, automation, and process orchestration.
  • Proven experience with Control-M or equivalent enterprise job schedulers for managing complex batch processes.
  • Strong understanding of data warehouse architecture, dimensional modeling, and performance tuning.
  • Excellent analytical and problem-solving skills, with the ability to identify and implement scalable solutions.
  • Strong collaboration and communication skills for working with cross-functional technical and business teams.

Functional Profile

  • Strategic thinker with a performance-driven mindset and strong attention to technical detail.
  • Capable of leading modernization efforts and influencing architectural decisions.
  • Skilled in cross-functional communication to align technical outcomes with business goals.
  • Experienced in maintaining operational stability while driving transformation projects.
  • Comfortable managing workloads in fast-paced, production-critical environments.

Skills Summary
Core Expertise:
Data warehouse modernization, system performance optimization, data modeling, ETL/ELT design, Oracle database architecture.

Languages & Frameworks
SQL, PL/SQL, Shell Scripting (UNIX/Linux), Python, Perl

Database & Job Scheduling
Oracle, Control-M, enterprise schedulers, SQL performance tuning, query optimization.

Automation & Scripting Tools
Shell, Python, Perl, automation scripts, job orchestration.

Version Control & Management Tools
Git, JIRA, ServiceNow (incident and change management).

Soft Skills
Analytical thinking, process ownership, technical leadership, stakeholder communication, documentation discipline, problem-solving, adaptability.

The pay range that the employer in good faith reasonably expects to pay for this position is $32.39/hour - $50.61/hour. Our benefits include medical, dental, vision and retirement benefits. Applications will be accepted on an ongoing basis. Tundra Technical Solutions is among North America's leading providers of Staffing and Consulting Services. Our success and our clients' success are built on a foundation of service excellence. We are an equal opportunity employer, and we do not discriminate on the basis of race, religion, color, national origin, sex, sexual orientation, age, veteran status, disability, genetic information, or other applicable legally protected characteristic. Qualified applicants with arrest or conviction records will be considered for employment in accordance with applicable law, including the Los Angeles County Fair Chance Ordinance for Employers and the California Fair Chance Act. Unincorporated LA County workers: we reasonably believe that criminal history may have a direct, adverse and negative relationship with the following job duties, potentially resulting in the withdrawal of a conditional offer of employment: client provided property, including hardware (both of which may include data) entrusted to you from theft, loss or damage; return all portable client computer hardware in your possession (including the data contained therein) upon completion of the assignment, and; maintain the confidentiality of client proprietary, confidential, or non-public information. In addition, job duties require access to secure and protected client information technology systems and related data security obligations.