Senior Data Modeler and Data Architect AWS Redshift

Senior Data Modeler and Data Architect AWS Redshift

Location : Newark NJ (Hybrid 3 days in the office)

Job Type : Full Time

About Us

CARIAN is a purpose-driven woman-owned consulting and advisory firm dedicated exclusively to the power sector. We partner with leading electric and gas utilities to provide strategic advisory and disciplined execution across program management business intelligence and field execution oversight. Guided by integrity trust excellence and accountability our team helps deliver complex capital programs and build the resilient energy infrastructure that communities depend on.

Position Overview

CARIAN is seeking a Senior Data Modeler and Data Architect to support a large Customer Data Asset program for our client in Newark NJ. This role is central to building the conceptual logical and physical data models that power customer analytics reporting and enterprise visibility.

The position requires deep experience designing Redshift models dimensional schemas and enterprise data structures along with the ability to translate business needs into scalable architecture.

Key Responsibilities

Collaborate with business SMEs to capture analytical and reporting needs

Translate requirements into conceptual logical and physical data models

Design dimensional models including Star and Snowflake patterns for Redshift

Define data standards relationships and modeling requirements

Build and optimize Redshift tables views and materialized views for performance

Document data flows lineage and governance structures

Partner with Data Engineering to ensure pipelines align with architectural requirements

Leverage AWS Glue Step Functions DataZone and related AWS services

Qualifications

Bachelors degree in Computer Science Information Systems Engineering Data Science or a related technical field required

Masters degree preferred

8 or more years of experience in data modeling data architecture or analytical engineering

Expert dimensional modeling and advanced SQL

Strong experience designing Redshift schemas for performance and scale

Experience in customer analytics environments preferred

Ability to communicate clearly across technical and business teams

AWS certifications are a plus

Ability to meet client security and compliance requirements including eligibility for 810 access which may require United States citizenship or permanent residency.

Preferred certifications : AWS Certified Data Engineer Associate AWS Certified Solutions Architect Associate or Professional AWS Certified Developer Associate

Experience with Snowflake or Databricks is a plus

Why CARIAN

Purpose-driven work. Help deliver infrastructure that powers communities.

Industry reputation. Trusted by leading utilities for our reliability and results.

Career growth. Opportunities to lead major programs and mentor high-performing teams.

Collaborative culture. Join a team that values delivery excellence and long-term relationships.

Competitive total rewards. Strong compensation full benefits 401(k) match and meaningful work.

Equal Employment Opportunity

CARIAN is proud to be an equal opportunity employer. We hire and develop talent based on qualifications performance and business needs. Employment decisions are made without regard to race color religion sex sexual orientation gender identity national origin age disability veteran status or any other protected characteristic. As a women-owned firm dedicated to the power sector we are committed to building a team that reflects professionalism expertise and integrity at every level.

Compensation

The base salary range for this role is $125000 to $195000 annually based on a full-time equivalent schedule. This range represents a good-faith estimate at the time of posting. Actual compensation will depend on experience qualifications and other factors permitted by addition to base salary the role includes eligibility for bonus incentives a comprehensive benefits package and a company 401(k) match.

CARIAN does not sponsor H1B-Visas at this time.

Required Experience :

Senior IC

Key Skills

Fund Management,Drafting,End User Support,Infrastructure,Airlines,Catia

Employment Type : Full-Time

Department / Functional Area : Digital Transformation

Experience : years

Vacancy : 1

Yearly Salary Salary : 125000 - 195000