Senior Data Engineer: EDW, Dimensional Modeling & Snowflake

Scalence; Morristown (NJ); On-site; USD 120,000 - 150,000; Full time

Job summary

Scalence in Morristown, NJ is seeking a Senior Data Engineer to design, build, and optimize enterprise-grade data pipelines. You will implement dimensional modeling and ensure data quality while collaborating with various teams.

The ideal candidate has over 7 years in data engineering, strong SQL skills, and experience with tools like Snowflake and Databricks. This position is vital for supporting analytics and BI initiatives at scale.

Qualifications

• 7+ years in data engineering with a focus on DW/ETL.
• Experience with ETL/ELT tools like Azure Databricks and Snowflake.
• Advanced SQL skills including performance optimization.

Responsibilities

• Build Kimball-style dimensional models for enterprise analytics.
• Optimize Snowflake curated tables and SQL queries.
• Perform quality checks and reconciliation within transformation pipelines.

Skills

Data engineering

ETL processes

SQL

Dimensional modeling

Data quality testing

Tools

Snowflake

Databricks

IBM DataStage

Apache Spark

Azure Data Factory

Git

Job description

Scalence in Morristown, NJ is seeking a Senior Data Engineer to design, build, and optimize enterprise-grade data pipelines. You will implement dimensional modeling and ensure data quality while collaborating with various teams.

The ideal candidate has over 7 years in data engineering, strong SQL skills, and experience with tools like Snowflake and Databricks. This position is vital for supporting analytics and BI initiatives at scale.