Data Engineer (Matillion)

TechDigital Group; Secaucus (NJ); On-site; USD 120,000 - 150,000; Full time

Job summary

A leading technology firm in the United States is seeking a seasoned Data Engineer with over 8 years of experience. The ideal candidate should have mastery of Matillion ETL tools and strong SQL skills, alongside extensive knowledge of cloud data platforms such as Snowflake and Amazon Redshift. Experience with dimensional and relational modeling is essential. This position offers an excellent opportunity to work in a dynamic environment embracing Agile principles.

Qualifications

• 8+ years of experience in Data Engineering, specifically with Matillion.
• Expert level experience with SQL and cloud-based data warehouses.
• Solid knowledge of dimensional and relational modeling.

Skills

Data Engineering

Matillion ETL tools

SQL

Cloud platforms (AWS, Azure, Google Cloud)

Data modeling

Agile Principles

Tools

Snowflake

Amazon Redshift

Google BigQuery

Matillion

Job description

Job Details:

• 8+ Years of Experience in Data Engineering and in Matillion ELT/ELT tools.
• Mastery of Matillion ETL components, including connectors (database, API, SaaS), transformations (Join, Filter, Aggregate, Calculator, Window Functions), and orchestration components.
• Understanding how Matillion generated SQL executes on cloud data warehouses for efficient transformations.
• Proficiency in advanced job design, modular, reusable, and parameterized workflows, version control integration with Git and environment management.
• Awareness of performance tuning within Matillion pipelines to optimize underlying SQL queries and reduce cloud consumption costs.
• Expertise in platforms such as Snowflake, Amazon Redshift, Google BigQuery.
• Solid knowledge of dimensional and relational modeling (star and snowflake schemas).
• Understanding of ETL versus ELT patterns and their impact on pipeline design.
• Experience with cloud-based ETL/ELT tools (Matillion, Glue, Data Factory) and data modelling.
• Expert level experience with SQL.
• Experience with the cloud (AWS, Azure and/or Google Cloud Platform).
• Experience in cloud-based data warehouses (Snowflake, Google BigQuery, Amazon Redshift, Azure Synapse Analytics).
• Understanding of and willingness to embrace Agile Principles.