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.