AWS Data Engineering Architect

Title: AWS Data Engineering Architect

Location: Newark, NJ (Hybrid - 3 days per week in the office)

Duration: Full-time with ComTec

Job Description:

Job Summary:

We are looking for a hands-on AWS Data Engineering Architect to lead engineers and own the end-to-end delivery of secure, scalable data solutions. The role requires strong expertise in AWS data services, data warehousing, data modeling, ETL/ELT, SQL, and Python or Java, along with the ability to translate business needs into production-ready solutions, make technical decisions, review code, resolve complex issues, and mentor the team.

Responsibilities:

• Lead a team of data engineers in designing, building, testing, deploying, and supporting AWS data solutions.

• Own technical deliverables from requirements through production, ensuring quality and timely delivery.

• Provide hands-on technical leadership through solution design, development, troubleshooting, and code reviews.

• Design scalable data architectures and pipelines using Amazon S3, Redshift, AWS Glue, DMS, and Lambda.

• Build ETL/ELT pipelines to ingest, transform, integrate, and publish data from structured and semi-structured sources.

• Develop and optimize data warehouses, data models, and SQL workloads for analytics and reporting.

• Build reusable data engineering components and automation using Python and/or Java.

• Establish standards for data quality, validation, error handling, monitoring, logging, and operational support.

• Ensure solutions meet enterprise standards for security, privacy, access control, encryption, compliance, reliability, and maintainability.

• Review designs and code, resolve complex data and performance issues, and guide technical decisions.

• Work with architects, business stakeholders, product owners, and technology teams to translate requirements into technical plans.

• Break initiatives into tasks, estimate effort, manage dependencies, track progress, and resolve delivery risks.

• Support production deployments and establish sustainable operational practices.

• Mentor engineers, delegate effectively, and communicate status, risks, and trade-offs to technical and non-technical stakeholders.

Required Skills:

• 8+ years of experience in data engineering, data warehousing, ETL/ELT, or a related field.

• 3+ years of hands-on experience delivering AWS-based data solutions.

• Strong hands-on experience with Amazon S3, Redshift, AWS Glue, DMS, and Lambda.

• Advanced SQL skills, including complex queries, window functions, stored procedures, and performance tuning.

• Strong Python and/or Java development skills, including testing, logging, error handling, and production-quality coding.

• Extensive experience designing ETL/ELT pipelines, including batch processing, incremental loads, CDC, validation, reconciliation, and recovery.

• Strong knowledge of data warehousing, data lakes, dimensional modeling, and logical and physical data modeling.

• Experience integrating data from databases, files, APIs, applications, and other enterprise sources.

• Understanding of data security and governance, including least-privilege access, encryption, secrets management, and sensitive-data protection.

• Demonstrated experience leading engineers or providing technical direction on complex initiatives.

• Proven ability to own deliverables from design through production implementation.

• Strong troubleshooting, analytical, communication, and cross-team collaboration skills.

• Ability to balance delivery timelines with solution quality, security, scalability, and maintainability.