Data Modeler / Data Architect Newark NJ

Overview

Hybrid
Depends on Experience
Accepts corp to corp applications
Contract - W2
Contract - Independent
Contract - 12 Month(s)
50% Travel
Able to Provide Sponsorship

Skills

Amazon Redshift
Amazon Web Services
Analytical Skill
Customer Analysis
Data Architecture
Data Engineering
Dimensional Modeling
Documentation
Extract
Transform
Load
FOCUS
Management
Modeling
Performance Tuning
Reporting
Snow Flake Schema
Step-Functions
Translation
Use Cases

Job Details

Data Modeler / Data Architect (Redshift & Dimensional Modelling)

  • Job Title: Data Modeler / Data Architect
  • Location: Newark NJ

Job Summary

We are seeking a seasoned Data Modeler / Data Architect responsible for translating complex business and reporting needs, particularly related to customer analytics, into robust conceptual, logical, and physical data models. A primary focus of the role is the design and implementation of highly optimized data models in AWS Redshift, utilizing expertise in dimensional modeling (Star and Snowflake schemas). The successful candidate will define data standards and transformation requirements for data engineering teams and possess strong knowledge of the AWS data architecture ecosystem (Redshift, Glue, Step Functions, and DataZone).

Key Focus Areas & Required Technical Skills

  • Data Modelling Expertise: Expertise in dimensional modelling (Star and Snowflake schemas) is mandatory.
  • Design & Documentation: Proficiently design and document conceptual, logical, and physical models for analytical use cases, specifically focusing on AWS Redshift.
  • Translation & Requirements: Experience working with business SMEs to understand analytical and reporting requirements and defining data standards and data pipeline transformation requirements.
  • AWS Redshift Specialization: Experience with AWS Redshift and demonstrated ability to implement models (tables, views/materialized view) and perform performance optimization.
  • Data Architecture Knowledge: Familiarity with the AWS data ecosystem, including AWS Glue, Redshift, and Step Functions.
  • Governance: Knowledge of AWS Datazone for managing data lineage and governance.
  • Domain (Ideal): Ideally, experience working with customer analytics.

Preferred Certifications

  • AWS Certified Solutions Architect Professional (or Associate)
  • AWS Certified Data Engineer Associate

Thanks,

_______________________________________

Aditya Jain | New York Technology Partners

120 Wood Avenue S | Suite 504 | Iselin NJ 08830

Email: Direct: EXT: 482

|

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.