Data Engineer

System One
Elizabeth, NJ
Job Title: Data Engineer Location: Elizabeth, New Jersey Type: Contract Contractor Work Model: Hybrid - remote, occasional travel to the office will be required Data Engineer We're seeking a Data Engineer who is motivated by variety, is seeking a challenging environment for professional growth, and is interested in supporting large information technology projects for one of our clients in the northeast. The Data Engineer will build and maintain the infrastructure for the organization's data by designing, constructing, and optimizing data pipelines and architecture. Location: This position located in Newark, NJ. Ideal candidate must be local to the area and able to go into the office periodically when needed. If not local, they must be willing to travel as needed. Responsibilities: + Ingest data from SAP, Salesforce, Google Analytics, OKTA, and other sources into AWS S3 Raw layer + Curate and transform data into standardized datasets in the Curated layer + Define and implement data mapping and transformation logic/code and load data into Redshift tables and views for optimal performance + Deploy and promote data pipeline code from lower environments (Dev/Test) to Production following PSEG governance and change control processes + Develop and maintain ELT/ETL pipelines using AWS Glue, Step Functions, Lambda, DMS, and AppFlow + Automate transformations and model refresh using Python, PySpark and SQL + Implement end-to-end source-to-target data integration, mapping and transformation across data source ? Raw ? Curated ? Redshift + Proficient in Redshift SQL for transformations, optimization, and model refresh + Integrate with on-prem and SaaS data sources, such as SAP (via Simplement), Salesforce, OKTA, MuleSoft and JAMS + Implement CI/CD deployment using Github + Familiar with CloudWatch, CloudTrail, Secrets Manager for monitoring and security + Manage metadata and lineage via AWS Glue Data Catalog Required Education & Experience: + Bachelor's degree in related field with 8+ years of experience as a data engineer Additional years of experience may be considered in lieu of a degree. + Proficiency in programming languages like Python or Java, strong SQL skills, and knowledge of big data tools like Apache Hadoop, Spark, or Kafka. + Experience with cloud platforms (AWS, Azure, GCP) and data warehousing solutions (Snowflake, Redshift, BigQuery) + Self-driven and have demonstrated the ability to work independently with minimum guidance + Demonstrated multitasking ability, problem solving skills and a consistent record of on time delivery and customer service + Excellent organizational and communication skills Preferred Qualifications: + Utilities experience + AWS Certified Data Engineer - Associate + AWS Certified Developer - Associate Ref: #850-Rockville (ALTA IT) System One, and its subsidiaries including Joulé, ALTA IT Services, CM Access, TPGS, and MOUNTAIN, LTD., are leaders in delivering workforce solutions and integrated services across North America. We help clients get work done more efficiently and economically, without compromising quality. System One not only serves as a valued partner for our clients, but we offer eligible full-time employees health and welfare benefits coverage options including medical, dental, vision, spending accounts, life insurance, voluntary plans, as well as participation in a 401(k) plan. System One is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex (including pregnancy, childbirth, or related medical conditions), sexual orientation, gender identity, age, national origin, disability, family care or medical leave status, genetic information, veteran status, marital status, or any other characteristic protected by applicable federal, state, or local law.
Posted 2025-11-14

Recommended Jobs

Director of Senior Living

Wohlsen Construction
Clark, NJ

About Your Opportunity You will provide the preconstruction services to clients from the time Wohlsen is hired or awarded a project until the GMP is signed, and construction starts. You will be re…

View Details
Posted 2025-11-07

Hybrid Board Certified Behavior Analyst (BCBA)

Advanced Behavioral Therapy
Plainfield, NJ

As an experienced BCBA you have changed many lives through your work. At Advanced Behavioral Therapy, we want to be the company that changes your life. ABT is proudly clinician owned and operated.…

View Details
Posted 2025-10-29

Workers Compensation Attorney

Kent & McBride
Trenton, NJ

Job Description Job Description Please note; this role is based in Cherry Hill, NJ. Job Summary Kent & McBride, P.C., a growing regional Civil Defense Litigation firm, is seeking a motivate…

View Details
Posted 2025-11-08

Basketball Tournament Director

Prep Network
Manalapan, NJ

Mission: Lead unforgettable events that create long-lasting memories for prep athletes What You’ll Do As an Event Director with Prep Network, you’ll take the lead in delivering high-quality, w…

View Details
Posted 2025-11-04

Process Technician

Hamilton, NJ

Job Title: Process Technician Job Description We are seeking a skilled and detail-oriented Process Technician with strong expertise in plastics processing and injection molding. The ideal candi…

View Details
Posted 2025-10-15

Vice President, Product Marketing Strategy Lead, Embedded Finance & Solutions

JPMorgan Chase & Co.
Jersey City, NJ

Job Description Job Description   This team is responsible for creating, leading and delivering an end-to-end marketing plan for a portfolio of global payments products and solutions. Working …

View Details
Posted 2025-11-12

Busser

Cheddar's Scratch Kitchen
Newark, NJ

For this position, pay will be variable by location - plus tips. The need for speed describes the Cheddar's Server Assistants; this job is a critical part of creating a positive guest exper…

View Details
Posted 2025-10-29

Sales Associate

Crocs, Inc.
Jackson, NJ

At Crocs, Inc., every career offers a chance to make a real impact. No two journeys look the same. And that's exactly how we like it. Whether you’re welcoming customers into our stores, collaborating …

View Details
Posted 2025-11-08

Testing Center of Excellence Test Architect

PSEG
Newark, NJ

  Requisition: 82286   PSEG Company: PSEG Services Corp.   Salary Range: $ 101,600 - $ 160,900   Work Location Category: Hybrid Flexible   We’re one of the country’s large…

View Details
Posted 2025-09-04

Business Finance Analyst

Raytheon-Rafael Area Protection Systems (R2S)
Camden, NJ

Raytheon-Rafael Area Protection Systems (R2S) Joint Venture (JV) is seeking a proven, high performing  Business Finance Analyst to fill this key role supporting a dynamic and growing joint venture. O…

View Details
Posted 2025-10-29