Senior Data Modeler and Data Architect AWS Redshift at The Carian Group in Newark, NJ | USD125,000-195,000 | Kablio

Role

Description

data governance

redshift optimization

sme collaboration

data modeling

pipeline alignment

dimensional modeling

Document data flows lineage and governance structures
Build and optimize Redshift tables, views, and materialized views for performance
Collaborate with business SMEs to capture analytical and reporting needs
Define data standards, relationships, and modeling requirements
Partner with Data Engineering to ensure pipelines align with architectural requirements
Translate requirements into conceptual, logical, and physical data models
Design dimensional models including Star and Snowflake patterns for Redshift

Requirements

aws certified

snowflake

databricks

bachelor’s

data modeling

redshift

Preferred certifications: AWS Certified Data Engineer Associate, AWS Certified Solutions Architect Associate or Professional, AWS Certified Developer Associate
AWS certifications are a plus
Experience in customer analytics environments preferred
Experience with Snowflake or Databricks is a plus
Bachelor’s degree in Computer Science, Information Systems, Engineering, Data Science, or a related technical field required
Leverage AWS Glue, Step Functions, DataZone, and related AWS services
Ability to meet client security and compliance requirements including eligibility for 810 access which may require United States citizenship or permanent residency.
Expert dimensional modeling and advanced SQL
8 or more years of experience in data modeling, data architecture, or analytical engineering
Master’s degree preferred
Strong experience designing Redshift schemas for performance and scale
Ability to communicate clearly across technical and business teams

Benefits

Competitive total rewards. Strong compensation, full benefits, 401(k) match, and meaningful work.
Career growth. Opportunities to lead major programs and mentor high-performing teams.

Training + Development

Information not given or found

Interview process

Information not given or found

Visa Sponsorship

carian does not sponsor h1b visas.
candidates must meet security requirements, possibly requiring us citizenship or permanent residency.

Security clearance

Information not given or found

Company

Overview

Brings together expertise in delivering cutting-edge solutions across various sectors.
Recognized leader in engineering and comprehensive project management.
Delivers tailored solutions for complex challenges in energy, infrastructure, and industry.
Showcases versatility through diverse project portfolio, from residential developments to large-scale infrastructure.
Ensures high-quality service with the latest technologies and methodologies.
Provides end-to-end support from concept to completion across industries.
Known for significant contributions to transportation and utilities sectors globally.
Thrives on adaptability, innovation, and continuous evolution in the global market.

Culture + Values

Mission: build rewarding, sustained relationships with clients through quality engagements, while contributing to the long-term sustainability of the communities served.
A woman-owned firm certified as WBENC, WBE, DBE, and SBE, underscoring commitment to diversity and supplier certification.
Known for flexibility, experience, competence, and a 'can-do' approach in delivering capital projects.
Encourages staff and community support, emphasizing sustainability and opportunities for giving back.

Environment + Sustainability

Links long-term sustainability of communities to its mission—implying environmental stewardship.
Encourages staff community support with a focus on planetary sustainability and community giving-back programs.
Operates in renewables, utilities, power, infrastructure sectors—aligning business focus with sustainable industries.

Inclusion & Diversity

78 employees

Global Workforce

The company has approximately 78 employees spread across four continents, emphasizing an inclusive culture for women, veterans, and underrepresented minorities.

Certified Woman-Owned Business Enterprise (WBENC), Women-Owned Business Enterprise (WBE), Disadvantaged Business Enterprise (DBE), Small Business Enterprise (SBE).
Self-identifies as a proud, woman-owned consulting and advisory firm.
Identifies as a diverse supplier and states 'Diversity is our Strength, Excellence is our Reward'.

Articles

About Us

Careers

Projects

Role

Description

data governance

redshift optimization

sme collaboration

data modeling

pipeline alignment

dimensional modeling

Document data flows lineage and governance structures
Build and optimize Redshift tables, views, and materialized views for performance
Collaborate with business SMEs to capture analytical and reporting needs
Define data standards, relationships, and modeling requirements
Partner with Data Engineering to ensure pipelines align with architectural requirements
Translate requirements into conceptual, logical, and physical data models
Design dimensional models including Star and Snowflake patterns for Redshift

Requirements

aws certified

snowflake

databricks

bachelor’s

data modeling

redshift

Preferred certifications: AWS Certified Data Engineer Associate, AWS Certified Solutions Architect Associate or Professional, AWS Certified Developer Associate
AWS certifications are a plus
Experience in customer analytics environments preferred
Experience with Snowflake or Databricks is a plus
Bachelor’s degree in Computer Science, Information Systems, Engineering, Data Science, or a related technical field required
Leverage AWS Glue, Step Functions, DataZone, and related AWS services
Ability to meet client security and compliance requirements including eligibility for 810 access which may require United States citizenship or permanent residency.
Expert dimensional modeling and advanced SQL
8 or more years of experience in data modeling, data architecture, or analytical engineering
Master’s degree preferred
Strong experience designing Redshift schemas for performance and scale
Ability to communicate clearly across technical and business teams

Benefits

Competitive total rewards. Strong compensation, full benefits, 401(k) match, and meaningful work.
Career growth. Opportunities to lead major programs and mentor high-performing teams.

Training + Development

Information not given or found

Interview process

Information not given or found

Visa Sponsorship

carian does not sponsor h1b visas.
candidates must meet security requirements, possibly requiring us citizenship or permanent residency.

Security clearance

Information not given or found

Company

Overview

Brings together expertise in delivering cutting-edge solutions across various sectors.
Recognized leader in engineering and comprehensive project management.
Delivers tailored solutions for complex challenges in energy, infrastructure, and industry.
Showcases versatility through diverse project portfolio, from residential developments to large-scale infrastructure.
Ensures high-quality service with the latest technologies and methodologies.
Provides end-to-end support from concept to completion across industries.
Known for significant contributions to transportation and utilities sectors globally.
Thrives on adaptability, innovation, and continuous evolution in the global market.

Culture + Values

Mission: build rewarding, sustained relationships with clients through quality engagements, while contributing to the long-term sustainability of the communities served.
A woman-owned firm certified as WBENC, WBE, DBE, and SBE, underscoring commitment to diversity and supplier certification.
Known for flexibility, experience, competence, and a 'can-do' approach in delivering capital projects.
Encourages staff and community support, emphasizing sustainability and opportunities for giving back.

Environment + Sustainability

Links long-term sustainability of communities to its mission—implying environmental stewardship.
Encourages staff community support with a focus on planetary sustainability and community giving-back programs.
Operates in renewables, utilities, power, infrastructure sectors—aligning business focus with sustainable industries.

Inclusion & Diversity

78 employees

Global Workforce

The company has approximately 78 employees spread across four continents, emphasizing an inclusive culture for women, veterans, and underrepresented minorities.

Certified Woman-Owned Business Enterprise (WBENC), Women-Owned Business Enterprise (WBE), Disadvantaged Business Enterprise (DBE), Small Business Enterprise (SBE).
Self-identifies as a proud, woman-owned consulting and advisory firm.
Identifies as a diverse supplier and states 'Diversity is our Strength, Excellence is our Reward'.

Articles

About Us

Careers

Projects