Senior Data Engineer AWS at The Carian Group in Newark, NJ | USD115,000-175,000 | Kablio

Role

Description

data curation

ci/cd

system integration

cloud monitoring

redshift design

etl pipelines

Curate and transform datasets into the Curated layer using Python, PySpark, and SQL
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
Design and optimize Redshift tables, views, and materialized views
Build and maintain ELT and ETL pipelines with AWS Glue, Step Functions, Lambda, DMS, and AppFlow
Maintain metadata and lineage using AWS Glue Data Catalog

Requirements

aws

python

sql

8+ years

bachelor’s

glue

Ability to operate independently and deliver high-quality work at enterprise scale
Preferred certifications: AWS Certified Data Engineer Associate, AWS Certified Solutions Architect Associate or Professional, AWS Certified Developer Associate
AWS certifications are a plus
Hands-on expertise with Glue, Step Functions, Lambda, S3, Redshift, DMS, and AppFlow
Experience with Snowflake or Databricks is a plus
Ingest SAP, Salesforce, Google Analytics, OKTA, and other sources into AWS S3 Raw
Bachelor’s degree in Computer Science, Information Systems, Engineering, Data Science, or a related technical field required
Experience with SAP and Salesforce integrations preferred
Strong Python, PySpark, and advanced SQL
8 or more years of experience in data engineering with strong AWS cloud experience
Ability to meet client security and compliance requirements including eligibility for 810 access which may require United States citizenship or permanent residency.
Master’s degree preferred

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

no h1b visa sponsorship offered
eligibility may require us citizenship or permanent residency for 810 access

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 curation

ci/cd

system integration

cloud monitoring

redshift design

etl pipelines

Curate and transform datasets into the Curated layer using Python, PySpark, and SQL
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
Design and optimize Redshift tables, views, and materialized views
Build and maintain ELT and ETL pipelines with AWS Glue, Step Functions, Lambda, DMS, and AppFlow
Maintain metadata and lineage using AWS Glue Data Catalog

Requirements

aws

python

sql

8+ years

bachelor’s

glue

Ability to operate independently and deliver high-quality work at enterprise scale
Preferred certifications: AWS Certified Data Engineer Associate, AWS Certified Solutions Architect Associate or Professional, AWS Certified Developer Associate
AWS certifications are a plus
Hands-on expertise with Glue, Step Functions, Lambda, S3, Redshift, DMS, and AppFlow
Experience with Snowflake or Databricks is a plus
Ingest SAP, Salesforce, Google Analytics, OKTA, and other sources into AWS S3 Raw
Bachelor’s degree in Computer Science, Information Systems, Engineering, Data Science, or a related technical field required
Experience with SAP and Salesforce integrations preferred
Strong Python, PySpark, and advanced SQL
8 or more years of experience in data engineering with strong AWS cloud experience
Ability to meet client security and compliance requirements including eligibility for 810 access which may require United States citizenship or permanent residency.
Master’s degree preferred

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

no h1b visa sponsorship offered
eligibility may require us citizenship or permanent residency for 810 access

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