IT Data Analytics Specialist – Data Engineer

Role Overview

The ideal candidate will design, build, and optimize scalable data pipelines that feed our Data Marketplace and enable the creation, publication, and consumption of certified Data Products across the enterprise.

What You Will Do

Design, build, and maintain scalable ETL/ELT pipelines using Matillion on AWS to ingest, transform, and curate data across incoming (raw/staging), silver (cleansed & conformed), and gold (business-ready/aggregated) layers in Snowflake.

Why It Might Be a Fit

The successful candidate will have 5+ years of experience as a Data Engineer or similar role, strong expertise with Snowflake, and hands-on experience with Matillion on AWS.

Requirements

• 5+ years of experience as a Data Engineer or similar role
• Strong expertise with Snowflake (SQL, performance tuning, data modeling, warehouse configuration, streams, tasks)
• Hands-on experience with Matillion on AWS (or comparable ETL/ELT tools such as Talend, Informatica, dbt, Azure Data Factory)
• Solid understanding of Data Product and Data Marketplace concepts (data contracts, data-as-a-product, self-service data consumption)
• Advanced SQL skills; ability to write complex queries and optimize them
• Strong understanding of data modeling, dimensional models, star schemas, and data warehouse/data lake concepts (bronze/silver/gold architecture)
• Experience with cloud platforms, specifically AWS
• Experience with Oracle Business Applications (ERP/EBS) as source systems is a plus
• Proficiency in Python, Airflow, or other orchestration tools
• Familiarity with Git, CI/CD, and general DevOps practices
• Knowledge of data governance principles, metadata management, and data cataloging tools

Tagged as: Data Analysis