Snowflake Data Engineer

Cloud Hybrid Technologies, LLC; Hartford (CT); On-site; USD 100,000 - 130,000; Full time

Job summary

A progressive tech company in Hartford, CT is seeking a skilled Snowflake Data Engineer to design and optimize data pipelines with Matillion. The role focuses on maintaining scalable environments and ensuring high-quality data for decision-making. Candidates should have at least 7 years of experience with Snowflake, strong SQL skills, and familiarity with cloud platforms. This is a great opportunity to collaborate with cross-functional teams in an inclusive environment.

Qualifications

• 7+ years of experience working as a Data Engineer.
• Strong experience with Snowflake, including architecture and performance tuning.
• Hands-on experience with Matillion for developing data pipelines.
• Advanced proficiency in SQL for optimization and debugging.
• Knowledge of dimensional and relational database modeling principles.
• Experience with cloud platforms like AWS, Azure, or Google Cloud.
• Familiarity with REST APIs and data integration.

Responsibilities

• Create and optimize ETL/ELT pipelines using Matillion.
• Develop and maintain Snowflake environments, including performance tuning.
• Collaborate with stakeholders to integrate various data sources.
• Monitor ETL performance and optimize resource usage.
• Ensure data quality through rigorous testing and validation.

Skills

Snowflake data warehouse platform

Matillion ETL

SQL

Cloud platforms (AWS, Azure, GCP)

Data modeling

ETL/ELT pipelines

Data governance

Data quality testing

API integration

Pipeline orchestration (Airflow, DBT)

Job description

Job Description

We are seeking a highly skilled Snowflake Data Engineer with expertise in Matillion ETL to join our client's dynamic data engineering team. The ideal candidate will play a crucial role in designing, building, and maintaining scalable and high-performance data pipelines within the Snowflake ecosystem using Matillion. This role requires expertise in data modeling, data transformation, and cloud technologies while focusing on ensuring quality, performance, and accuracy for data-driven decision-making.

Responsibilities

• Create, implement, and optimize ETL/ELT pipelines using Matillion for ingesting and processing data from multiple sources into Snowflake.
• Develop and maintain scalable Snowflake environments, including database design, warehouse management, and performance tuning to support complex queries.
• Develop and maintain robust transformations in Matillion to ensure that raw data is cleansed, enriched, and modeled for business consumption.
• Collaborate with stakeholders to integrate a variety of data sources (e.g., APIs, flat files, databases) into Snowflake and ensure data is stored accurately and securely.
• Monitor and manage performance of ETL pipelines, optimize the use of compute resources in Snowflake, and improve query performance to enhance speed and efficiency.
• Work closely with cross-functional teams, including Data Scientists, Analysts, and Developers, to deliver data solutions that meet business needs.
• Ensure data quality through rigorous testing, validation, and adherence to best practices for data governance and security requirements.
• Maintain detailed documentation of ETL workflows, data models, and processes to ensure transparency and facilitate support.

Qualifications and Required Skills

• 7+ of experience working as a Data Engineer
• Strong experience with Snowflake data warehouse platform, including architecture, performance tuning, and security.
• Hands‑on experience with Matillion for developing and managing scalable data pipelines.
• Advanced proficiency in SQL, including query optimization and debugging.
• Strong knowledge of dimensional and relational database modeling principles for building efficient Snowflake databases.
• Experience with cloud platforms (Azure Preferred but not a requirement) like AWS, Azure, or Google Cloud, including relevant services (e.g., S3, Lambda, Data Factory, BigQuery).
• Familiarity with integrating REST APIs and other data sources into the Snowflake ecosystem.
• Knowledge of pipeline orchestration tools or workflows (e.g., Airflow, DBT).
• Ability to troubleshoot data‑related issues, identify root causes, and implement solutions.
• Strong communication and collaboration skills to interact with technical and non-technical stakeholders.

Cloud Hybrid is an equal opportunity employer inclusive of female, minority, disability and veterans, (M/F/D/V). Hiring, promotion, transfer, compensation, benefits, discipline, termination and all other employment decisions are made without regard to race, color, religion, sex, sexual orientation, gender identity, age, disability, national origin, citizenship/immigration status, veteran status or any other protected status. Cloud Hybrid will not make any posting or employment decision that does not comply with applicable laws relating to labor and employment, equal opportunity, employment eligibility requirements or related matters. Nor will Cloud Hybrid require in a posting or otherwise U.S. citizenship or lawful permanent residency in the U.S. as a condition of employment except as necessary to comply with law, regulation, executive order, or federal, state, or local government contract.