Overview
Remote
On Site
USD 120,000.00 - 140,000.00 per year
Full Time
Skills
Data Engineering
Decision-making
ELT
Database Design
Warehouse Management
Flat File
Quality Assurance
Data Quality
Testing
Data Governance
Documentation
Data Warehouse
Performance Tuning
Extract
Transform
Load
Management
SQL
Query Optimization
Debugging
Data Modeling
RDBMS
Modeling
Database
Microsoft Azure
Google Cloud Platform
Google Cloud
Amazon S3
Data Integration
Orchestration
Workflow
Conflict Resolution
Problem Solving
ROOT
Soft Skills
Communication
Collaboration
Cloud Computing
Data Visualization
API
Amazon Web Services
Snow Flake Schema
Python
SQL Azure
Finance
Accounting
Marketing
Legal
Customer Support
Online Training
Artificial Intelligence
Insurance
.NET
Job Details
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
Design and Build Data Pipelines: Create, implement, and optimize ETL/ELT pipelines using Matillion for ingesting and processing data from multiple sources into Snowflake.
Snowflake Architecture Design: Develop and maintain scalable Snowflake environments, including database design, warehouse management, and performance tuning to support complex queries.
Data Transformation: Develop and maintain robust transformations in Matillion to ensure that raw data is cleansed, enriched, and modeled for business consumption.
Data Integration: 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.
Performance Optimization: Monitor and manage performance of ETL pipelines, optimize the use of compute resources in Snowflake, and improve query performance to enhance speed and efficiency.
Collaboration: Work closely with cross-functional teams, including Data Scientists, Analysts, and Developers, to deliver data solutions that meet business needs.
Quality Assurance: Ensure data quality through rigorous testing, validation, and adherence to best practices for data governance and security requirements.
Documentation: 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
Expertise in Snowflake: Strong experience with Snowflake data warehouse platform, including architecture, performance tuning, and security.
Matillion ETL Expertise: Hands-on experience with Matillion for developing and managing scalable data pipelines.
SQL Proficiency: Advanced proficiency in SQL, including query optimization and debugging.
Data Modeling: Strong knowledge of dimensional and relational database modeling principles for building efficient Snowflake databases.
Cloud Technologies: 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).
Experience with APIs and Data Integration: Familiarity with integrating REST APIs and other data sources into the Snowflake ecosystem.
Pipeline Automation: Knowledge of pipeline orchestration tools or workflows (e.g., Airflow, DBT).
Problem-Solving Skills: Ability to troubleshoot data-related issues, identify root causes, and implement solutions.
Soft Skills: Strong communication and collaboration skills to interact with technical and non-technical stakeholders.
Requirements
Cloud Technologies, Data Visualization, API Development, AWS Technologies, Matillion, Snowflake, Python, Azure SQL Database
Technology Doesn't Change the World, People Do.
Robert Half is the world's first and largest specialized talent solutions firm that connects highly qualified job seekers to opportunities at great companies. We offer contract, temporary and permanent placement solutions for finance and accounting, technology, marketing and creative, legal, and administrative and customer support roles.
Robert Half works to put you in the best position to succeed. We provide access to top jobs, competitive compensation and benefits, and free online training. Stay on top of every opportunity - whenever you choose - even on the go. Download the Robert Half app and get 1-tap apply, notifications of AI-matched jobs, and much more.
All applicants applying for U.S. job openings must be legally authorized to work in the United States. Benefits are available to contract/temporary professionals, including medical, vision, dental, and life and disability insurance. Hired contract/temporary professionals are also eligible to enroll in our company 401(k) plan. Visit roberthalf.gobenefits.net for more information.
2025 Robert Half. An Equal Opportunity Employer. M/F/Disability/Veterans. By clicking "Apply Now," you're agreeing to Robert Half's Terms of Use.
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
Design and Build Data Pipelines: Create, implement, and optimize ETL/ELT pipelines using Matillion for ingesting and processing data from multiple sources into Snowflake.
Snowflake Architecture Design: Develop and maintain scalable Snowflake environments, including database design, warehouse management, and performance tuning to support complex queries.
Data Transformation: Develop and maintain robust transformations in Matillion to ensure that raw data is cleansed, enriched, and modeled for business consumption.
Data Integration: 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.
Performance Optimization: Monitor and manage performance of ETL pipelines, optimize the use of compute resources in Snowflake, and improve query performance to enhance speed and efficiency.
Collaboration: Work closely with cross-functional teams, including Data Scientists, Analysts, and Developers, to deliver data solutions that meet business needs.
Quality Assurance: Ensure data quality through rigorous testing, validation, and adherence to best practices for data governance and security requirements.
Documentation: 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
Expertise in Snowflake: Strong experience with Snowflake data warehouse platform, including architecture, performance tuning, and security.
Matillion ETL Expertise: Hands-on experience with Matillion for developing and managing scalable data pipelines.
SQL Proficiency: Advanced proficiency in SQL, including query optimization and debugging.
Data Modeling: Strong knowledge of dimensional and relational database modeling principles for building efficient Snowflake databases.
Cloud Technologies: 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).
Experience with APIs and Data Integration: Familiarity with integrating REST APIs and other data sources into the Snowflake ecosystem.
Pipeline Automation: Knowledge of pipeline orchestration tools or workflows (e.g., Airflow, DBT).
Problem-Solving Skills: Ability to troubleshoot data-related issues, identify root causes, and implement solutions.
Soft Skills: Strong communication and collaboration skills to interact with technical and non-technical stakeholders.
Requirements
Cloud Technologies, Data Visualization, API Development, AWS Technologies, Matillion, Snowflake, Python, Azure SQL Database
Technology Doesn't Change the World, People Do.
Robert Half is the world's first and largest specialized talent solutions firm that connects highly qualified job seekers to opportunities at great companies. We offer contract, temporary and permanent placement solutions for finance and accounting, technology, marketing and creative, legal, and administrative and customer support roles.
Robert Half works to put you in the best position to succeed. We provide access to top jobs, competitive compensation and benefits, and free online training. Stay on top of every opportunity - whenever you choose - even on the go. Download the Robert Half app and get 1-tap apply, notifications of AI-matched jobs, and much more.
All applicants applying for U.S. job openings must be legally authorized to work in the United States. Benefits are available to contract/temporary professionals, including medical, vision, dental, and life and disability insurance. Hired contract/temporary professionals are also eligible to enroll in our company 401(k) plan. Visit roberthalf.gobenefits.net for more information.
2025 Robert Half. An Equal Opportunity Employer. M/F/Disability/Veterans. By clicking "Apply Now," you're agreeing to Robert Half's Terms of Use.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.