Senior Data Engineer AWS

Newark, DE - USA

Yearly Salary: $ 115000 - 175000

Posted on: 30+ days ago

Vacancies: 1 Vacancy

Department:

Digital Transformation

Job Summary

Senior Data Engineer AWS

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 Engineer AWS to support a major Customer Data Asset initiative for our client in Newark NJ. This work focuses on centralizing customer-level data and enabling advanced analytics and customer insights across the enterprise.

The Senior Data Engineer will build and maintain AWS-native data pipelines integrate SAP Salesforce OKTA and other systems and develop optimized Redshift structures. This role requires strong cloud data engineering experience and the ability to deliver in a fast-moving enterprise environment.

Key Responsibilities

Ingest SAP Salesforce Google Analytics OKTA and other sources into AWS S3 Raw
Curate and transform datasets into the Curated layer using Python PySpark and SQL
Build and maintain ELT and ETL pipelines with AWS Glue Step Functions Lambda DMS and AppFlow
Design and optimize Redshift tables views and materialized views
Implement CI or CD practices using GitHub and follow client governance standards
Integrate with on-prem and SaaS systems through Simplement MuleSoft OKTA and JAMS
Use CloudWatch CloudTrail and Secrets Manager for monitoring and security
Maintain metadata and lineage using AWS Glue Data Catalog

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 engineering with strong AWS cloud experience
Hands-on expertise with Glue Step Functions Lambda S3 Redshift DMS and AppFlow
Strong Python PySpark and advanced SQL
Experience with SAP and Salesforce integrations preferred
Ability to operate independently and deliver high-quality work at enterprise scale
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 $115000 to $175000 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

Senior Data Engineer AWSLocation: Newark NJ (Hybrid 3 days in the office)Job Type: Full TimeAbout UsCARIAN 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 dis...