Snowflake AND Matillion ETL Developer Job at Cloud Analytics Technologies LLC, New York, NY

UERYUytEYnJSYmQvak1JT2JHQk8wdlpab2c9PQ==
  • Cloud Analytics Technologies LLC
  • New York, NY

Job Description

Job Details

Job Summary:

We are seeking an experienced  Snowflake + Matillion ETL Developer / Data Engineer to design, develop, and optimize cloud-based data pipelines and analytics solutions. The ideal candidate will have deep expertise in  Snowflake Data Warehouse ,  Matillion ETL ,  AWS data services , and  data modeling (Facts, Dimensions, SCD Type 2). This role involves building reliable, scalable, and high-performance data integration solutions that power business insights and reporting.

Key Responsibilities:

  • Design, develop, and deploy  ETL/ELT pipelines using  Matillion ETL and  Snowflake for data ingestion, transformation, and analytics.

  • Build and maintain  Matillion architecture including orchestration jobs, transformation workflows, and variable management.

  • Create and manage  Snowflake objects databases, schemas, tables, views, streams, tasks, and stored procedures.

  • Implement  data validation, cleaning, and transformation to ensure data accuracy, completeness, and consistency.

  • Design and maintain  data warehouse models (Star/Snowflake schema) including  Slowly Changing Dimensions (SCD Type 2) .

  • Integrate data from multiple sources such as  AWS S3, RDS, Redshift, and APIs using Matillion and Python connectors.

  • Optimize  SQL queries, transformations, and Snowflake workloads for performance and cost efficiency.

  • Collaborate with  data architects, BI developers, and DevOps teams to implement CI/CD pipelines (Git, Jenkins, GitHub Actions).

  • Monitor ETL processes, troubleshoot issues, and ensure on-time delivery of reliable data pipelines.

  • Apply  data governance, quality, and security best practices across all environment

  • Required Skills & Experience:

  • 8 10 years of overall IT experience with 4+ years in  Snowflake Data Engineering and 3+ years in  Matillion ETL .

  • Strong proficiency in  SQL and  Snowflake scripting (Streams, Tasks, Procedures, Performance Tuning).

  • Expertise in  Matillion ETL job design , orchestration, and optimization.

  • In-depth understanding of  data modeling concepts Facts, Dimensions, Hierarchies, and  SCD Type 2 .

  • Experience with  AWS data services such as S3, Glue, Lambda, and Redshift.

  • Proficiency in  Python for data transformations and automation.

  • Hands-on experience with  CI/CD pipelines and Git-based version control systems.

  • Strong analytical, problem-solving, and communication skills.

  • Preferred Qualifications:

  • SnowPro Core Certification or  Matillion Associate Certification .

  • Experience with  BI tools (Tableau, Power BI, Looker) for data validation and visualization.

  • Familiarity with  Airflow or  AWS Step Functions for orchestration.

  • Understanding of  data lake architecture ,  real-time streaming , and  data governance frameworks .

Job Tags

Similar Jobs

U.S. Realty Advisors, LLC

Office Manager and Executive Assistant to Managing Partner Job at U.S. Realty Advisors, LLC

 ...Executive Assistant to Managing Partner U.S. Realty Advisors is seeking a polished, proactive, and highly personable Executive Assistant & Office Manager to support our Managing Partner and keep our NYC office running seamlessly. This role is perfect for someone who... 

Aegis Manufacturing & Engineering

Food and Beverage Technician Job at Aegis Manufacturing & Engineering

 ...Overview We are seeking a dedicated and skilled Food and Beverage Technician to join our dynamic team in Indianapolis, IN. In this role, you will play a crucial part in ensuring the quality and safety of our food and beverage offerings. If you have a passion for the... 

United Therapy Solutions

Certified Occupational Therapy Assistant Job at United Therapy Solutions

 ...United Therapy Solutions is hiring Certified Occupational Therapy Assistants our full-time, school-based position! United Therapy Solutions is a New Jersey-based pediatric therapy company exclusively servicing NJ school districts and their families. Our management team... 

WHSmith North America

Warehouse Operations Manager Job at WHSmith North America

 ...driving force for our stores merchandise! As the Operations Manager , you will assist the DC Sr. Operations Manager in...  ...Job Requirements ~4-5 years' general distribution center/warehouse warehouse experience ~2+ years leadership experience in a supervisory... 

Robert Half

Data Entry Clerk Job at Robert Half

Description Support our team's accuracy and efficiency as a Data Entry Clerk. In this essential role, you will be responsible for processing and managing information to ensure smooth business operations.Key Responsibilities:+ Enter, update, and verify data in various...