Data Engineer -Hybrid -Montreal, QC / Mississauga, ON
About the role
Data Engineer We are seeking an experienced Data Engineer with a strong background in Snowflake and SQL to join our technology team. The ideal candidate will be responsible for developing, optimizing, and maintaining our Snowflake data warehouse environment to support financial data analysis and reporting needs. The role requires a deep knowledge of Snowflake's unique capabilities, as well as proficiency in advanced SQL techniques and a comprehensive understanding of financial data.
Responsibilities
- Design, build, and maintain scalable and efficient Snowflake data warehouse solutions tailored for financial industry applications.
- Develop complex SQL queries, stored procedures, and scripts for data manipulation and retrieval.
- Optimize Snowflake performance through effective data modeling, partitioning, and indexing strategies.
- Collaborate with financial analysts and business stakeholders to understand data requirements and deliver precise reporting and analytical solutions.
- Ensure data integrity and security within the Snowflake environment, complying with industry regulations and standards.
- Manage data migration projects from legacy systems to Snowflake, ensuring minimal disruption to business operations.
- Provide technical expertise and support for Snowflake to internal teams, including troubleshooting and resolving issues.
- Stay up to date with Snowflake features and updates, continuously improving and expanding our data warehouse capabilities.
- Develop and maintain documentation for Snowflake processes, systems, and procedures.
Requirements
- Proven 8+ years of experience in Snowflake data warehousing Development
- Strong expertise in Strong SQL and SQL query optimization skills
- Strong knowledge of data warehousing concepts and best practices.
- Familiarity with Snowflake's architecture, features, and best practices.
- Experience with data modeling, ETL development, and data integration techniques.
- Experience with Azure Data Factory (ADF), Data Bricks and other Azure services.
- Knowledge of financial industry standards, regulatory requirements, and data security protocols.
- Proficiency in Python & Pyspark for data processing and automation.
Preferred Qualifications
- Experience with financial reporting, risk management, or investment analytics.
- Familiarity with other data integration tools and BI platforms.
- Relevant certifications such as the Snowflake SnowPro Core Certification.
About W3Global
W3Global is a leading provider of end-to-end consulting services, empowering businesses to achieve their strategic goals and optimize their operations. With over 15 years of experience, we have a proven track record of delivering innovative and effective solutions across a wide range of industries.
Our Mission
At W3Global, we are committed to helping businesses of all sizes achieve their full potential. We believe that by combining our deep industry expertise with our innovative approach, we can deliver exceptional results that exceed our clients' expectations.
Our Services
We offer a comprehensive suite of consulting services designed to address the specific needs of our clients. Our services include:
Strategy Consulting: We help businesses develop and implement winning strategies to achieve their long-term goals.
Business Process Improvement: We identify and optimize business processes to enhance efficiency, reduce costs, and improve customer satisfaction.
Technology Consulting: We provide expert guidance on technology selection, implementation, and integration to support business objectives.
Talent Acquisition: We help businesses find and hire the right talent to support their growth and success.
Human Capital Management: We provide comprehensive HR solutions to help businesses manage their workforce effectively.
Data Engineer -Hybrid -Montreal, QC / Mississauga, ON
About the role
Data Engineer We are seeking an experienced Data Engineer with a strong background in Snowflake and SQL to join our technology team. The ideal candidate will be responsible for developing, optimizing, and maintaining our Snowflake data warehouse environment to support financial data analysis and reporting needs. The role requires a deep knowledge of Snowflake's unique capabilities, as well as proficiency in advanced SQL techniques and a comprehensive understanding of financial data.
Responsibilities
- Design, build, and maintain scalable and efficient Snowflake data warehouse solutions tailored for financial industry applications.
- Develop complex SQL queries, stored procedures, and scripts for data manipulation and retrieval.
- Optimize Snowflake performance through effective data modeling, partitioning, and indexing strategies.
- Collaborate with financial analysts and business stakeholders to understand data requirements and deliver precise reporting and analytical solutions.
- Ensure data integrity and security within the Snowflake environment, complying with industry regulations and standards.
- Manage data migration projects from legacy systems to Snowflake, ensuring minimal disruption to business operations.
- Provide technical expertise and support for Snowflake to internal teams, including troubleshooting and resolving issues.
- Stay up to date with Snowflake features and updates, continuously improving and expanding our data warehouse capabilities.
- Develop and maintain documentation for Snowflake processes, systems, and procedures.
Requirements
- Proven 8+ years of experience in Snowflake data warehousing Development
- Strong expertise in Strong SQL and SQL query optimization skills
- Strong knowledge of data warehousing concepts and best practices.
- Familiarity with Snowflake's architecture, features, and best practices.
- Experience with data modeling, ETL development, and data integration techniques.
- Experience with Azure Data Factory (ADF), Data Bricks and other Azure services.
- Knowledge of financial industry standards, regulatory requirements, and data security protocols.
- Proficiency in Python & Pyspark for data processing and automation.
Preferred Qualifications
- Experience with financial reporting, risk management, or investment analytics.
- Familiarity with other data integration tools and BI platforms.
- Relevant certifications such as the Snowflake SnowPro Core Certification.
About W3Global
W3Global is a leading provider of end-to-end consulting services, empowering businesses to achieve their strategic goals and optimize their operations. With over 15 years of experience, we have a proven track record of delivering innovative and effective solutions across a wide range of industries.
Our Mission
At W3Global, we are committed to helping businesses of all sizes achieve their full potential. We believe that by combining our deep industry expertise with our innovative approach, we can deliver exceptional results that exceed our clients' expectations.
Our Services
We offer a comprehensive suite of consulting services designed to address the specific needs of our clients. Our services include:
Strategy Consulting: We help businesses develop and implement winning strategies to achieve their long-term goals.
Business Process Improvement: We identify and optimize business processes to enhance efficiency, reduce costs, and improve customer satisfaction.
Technology Consulting: We provide expert guidance on technology selection, implementation, and integration to support business objectives.
Talent Acquisition: We help businesses find and hire the right talent to support their growth and success.
Human Capital Management: We provide comprehensive HR solutions to help businesses manage their workforce effectively.