Senior Data Engineer
Senior Data Engineer (engaged through staffing firm Compunnel for its client) in Montréal: designing and managing Snowflake data warehouse objects, migrating relational data domains into Snowflake, and building ETL/ingestion pipelines with Talend and Informatica, plus SQL/Python automation and Snowflake REST API data distribution layers.
- Compensation
- Not disclosed
- Location
- Montréal, Canada
- Work setup
- Not specified
- Seniority
- Senior
- Employment
- Not specified
- Experience
- Not specified
- Category
- Data engineering
- Posted
Skills
Must have
- Bachelor's degree in Computer Science, Software Engineering, IT, MIS, or related field
- 7–10 years of experience in data analysis, data object development, and modeling in Snowflake
- Hands-on experience with Snowflake REST API
- Strong ETL experience with Informatica and Talend
- Proficiency in SQL query development
- Python scripting for automation and analytics
- Proven ability to work in distributed systems environments
- Strong knowledge of relational databases (e.g., DB2) and data transformation practices
- Strong data modeling concepts and schema design for relational and cloud data stores
- Effective verbal and written communication and collaboration across IT and business groups
- Strong problem-solving skills and collaborative, team-oriented mindset
Nice to have
- Master's degree
- Familiarity with data visualization tools such as Tableau and Power BI
- Experience collaborating with data scientists to integrate machine learning models into Snowflake
Full description
Client is seeking a Senior Data Engineer to support the modernization of tooling enablement functions. This role is responsible for designing, modeling, developing, and managing data warehouse objects in the Snowflake cloud data store, utilizing ETL pipelines (Talend, Informatica) and APIs. The ideal candidate is a self-driven, strategic thinker who thrives in collaborative environments and brings deep technical expertise in Snowflake, data engineering, and distributed systems.
Design, pipeline, ingestion, initialization, a granularity relationship, an ingestion saving, a monitoring, explains from impact, high logic, visual, and analytics, a chain,.
KEY RESPONSIBILITIES
- Design, implement, and manage scalable data solutions using Snowflake for optimized storage and processing.
- Migrate existing data domains/flows from relational databases to Snowflake cloud data store.
- Identify, optimize, and implement new/existing data workflows and integrity practices.
- Integrate data governance and data science tools with the Snowflake ecosystem.
- Develop data models and ETL processes to ensure high-quality ingestion into Snowflake.
- Collaborate with team members to design and implement effective data workflows and transformations.
- Maintain and optimize Snowflake environments to improve performance and reduce costs.
- Contribute to proof-of-concept initiatives, documentation, and best practices for data management and governance.
- Participate in code reviews and provide constructive feedback to improve deliverables.
- Design and develop data ingestion pipelines using Talend/Informatica following industry best practices.
- Write efficient SQL and Python scripts for large dataset analysis and end-to-end automation.
- Design and implement data distribution layers using Snowflake REST API.
- Support development of semantic models in Snowflake and Power BI (preferred).
QUALIFICATIONS
- Bachelor’s degree in Computer Science, Software Engineering, Information Technology, MIS, or related field required; Master’s degree preferred.
- 7–10 years of experience in data analysis, data object development, and modeling in Snowflake.
- Hands‑on experience with Snowflake REST API.
- Strong ETL experience with Informatica and Talend.
- Proficiency in SQL query development and Python scripting for automation and analytics.
- Proven ability to work in distributed systems environments.
- Strong knowledge of relational databases (e.g., DB2) and data transformation practices.
- Excellent problem‑solving skills and a collaborative, team‑oriented mindset.
- Strong data modeling concepts and schema design for both relational and cloud data stores.