Job Description
Job title: Data Engineer (Python/SQL/Databricks/Azure/Snowflake)
Location: Mississauga, ON or Montreal, QC (Hybrid 3 day)
Position Type-Regular Full-Time Contract
Please reply with your expected Contract range--
Job Description:
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.
Regards,
Compest Solutions Inc
D: 647-660-7562
Job Type: Fixed term contract
Contract length: 12 months
Pay: $55.00-$60.00 per hour
Expected hours: 40 per week
Schedule:
- 8 hour shift
Experience:
- Azure Data Engineer: 10 years (required)
- Strong SQL and SQL query: 10 years (preferred)
- Python for data processing and automation: 10 years (preferred)
- Azure Data Factory (ADF) and other Azure services: 10 years (preferred)
- ETL development, and data integration: 10 years (preferred)
- data warehousing concepts and best practices: 10 years (preferred)
- Investment banking: 10 years (preferred)
- Snowflake Developer: 8 years (preferred)
- Capital market: 10 years (preferred)
Licence/Certification:
- SnowPro Core (preferred)
Work Location: On the road
Visit Original Source:
http://ca.indeed.com/viewjob