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- Hybrid

Contract

JOB 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 scheduling, with a strong focus on enhancing system architecture, re-platforming legacy components, and improving data process efficiency. This role requires hands-on technical skills who can drive strategic improvements while maintaining operational excellence.

Responsibilities


• Lead and execute data warehouse modernization projects, including identifying and re-platforming legacy components to more modern, scalable architectures.


• Conduct in-depth performance analysis of data warehouse processes, queries, and ETL/ELT jobs to identify bottlenecks and implement strategic optimizations.


• Design, develop, and maintain advanced data models, ETL/ELT frameworks, and data integration solutions.


• Develop and optimize complex SQL and PL/SQL scripts, stored procedures, functions, and packages for data manipulation and transformation.


• Architect, develop, and maintain robust batch processes using Shell Scripting (UNIX/Linux) to support data loads, system automation, and operational monitoring.


• Utilize Control-M or similar enterprise job scheduling tools to design, manage, and monitor complex job workflows, ensuring optimal performance and reliability.


• Perform comprehensive root cause analysis (RCA) on performance degradation and system failures, developing and implementing long-term preventative solutions.


• Develop and enforce data warehouse best practices, coding standards, and architectural patterns.


• Create and maintain detailed documentation for modernized processes, system architecture, and performance improvements.

Skills and Qualifications


• Minimum of 5 years of experience in data warehousing, with significant experience in modernization and performance-focused initiatives.


• Expert-level proficiency in SQL for writing complex, highly optimized queries.


• Extensive experience with PL/SQL for designing and developing efficient database applications and transformations in an Oracle or similar environment.


• Strong expertise in Shell Scripting (UNIX/Linux) for process automation, job control, and system administration.


• Proven hands-on experience with Control-M or another major enterprise job scheduler for orchestrating complex data workflows.


• Deep understanding of data warehouse concepts, dimensional modeling, and database architecture.


• Excellent analytical and problem-solving skills, with a focus on delivering high-performance, scalable solutions.


• Strong communication and collaboration skills, with the ability to influence technical and non-technical stakeholders.

Preferred (Optional) Skills


• Perl: Experience with Perl scripting for data processing, reporting, and automation.


• Python: Experience with Python for scripting, data manipulation, and building data pipelines.


• Experience with version control systems like Git.


• Incident management and change management tools experience like JIRA, ServiceNow"

  • Senior Cloud Data Warehouse Engineer

    1 day 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

    2 weeks ago

    Montreal, Quebec, Canada Aptino, Inc. Full time $90,000 - $140,000 per year

    We are looking for an experiencedSenior Data Warehouse Engineerto lead our modernization and performance optimization initiatives. This role involves re-platforming legacy systems, enhancing warehouse architecture, and driving efficiency across complex data processes. The ideal candidate is a hands-on technical expert with a deep understanding of SQL,...

  • 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

    1 day 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'...

  • 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 aSenior Data Warehouse Engineer, Modernization and Performanceto lead critical initiatives focused on modernizing data warehouse systems, optimizing performance, and improving overall data process efficiency. This role requires deep expertise indatabase programming, performance tuning, and enterprise job scheduling, with a strong focus on...

  • Data Engineer

    2 weeks ago

    Montreal, Quebec, Canada Wireframe Solutions-IT Consulting Company Full time $90,000 - $120,000 per year

    Position; Senior Data EngineerLocation: Montreal, CA ( 3 days onsite is must)Duration: 12 MonthsHands on experience 5+ years in Snowflake and virtual data warehouse set upSnowflake data modelingMust have done projects where semi-structured and unstructured data is brought into SnowflakeDeep understanding of using REST APIHands on background in Talend 5+...

  • Senior Cloud Data Warehousing

    2 days ago

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

    Join Controls Engineering, Measurement and Analytics (CEMA) team as a Senior Cloud Data Warehouse Engineer. Drive innovation by building next-gen cloud data platforms that empower Cyber Risk and Technology Risk analytics across the firm.What You'll Do:Design, develop, and manage our Snowflake data warehouse solutionsCollaborate with cross-functional teams on...

  • Senior Software Developer

    2 days ago

    Montreal, Quebec, Canada Yeji Data Lab Full time US$90,000 - US$180,000 per year

    Cette offre d'emploi est rédigée en anglais pour des raisons de simplicité. La maîtrise des deux langues (français et anglais) est préférable.Senior Software Developer - Machine LearningAs a global firm at the forefront of the AI revolution, Yeji Data Lab partners with world-leading clients to address their critical challenges. We leverage...

  • Senior Data Engineering Lead

    5 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...