AWS Data Engineering Architect
Job Description
Title: AWS Data Engineering Architect
\n
Location: Newark, NJ (Hybrid - 3 days per week in the office)
\n
Duration: Full-time with ComTec
\n
\n
Job Description:
\n
Job Summary:
\n
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.
\n
\n
Responsibilities:
\n
• Lead a team of data engineers in designing, building, testing, deploying, and supporting AWS data solutions.
\n
• Own technical deliverables from requirements through production, ensuring quality and timely delivery.
\n
• Provide hands-on technical leadership through solution design, development, troubleshooting, and code reviews.
\n
• Design scalable data architectures and pipelines using Amazon S3, Redshift, AWS Glue, DMS, and Lambda.
\n
• Build ETL/ELT pipelines to ingest, transform, integrate, and publish data from structured and semi-structured sources.
\n
• Develop and optimize data warehouses, data models, and SQL workloads for analytics and reporting.
\n
• Build reusable data engineering components and automation using Python and/or Java.
\n
• Establish standards for data quality, validation, error handling, monitoring, logging, and operational support.
\n
• Ensure solutions meet enterprise standards for security, privacy, access control, encryption, compliance, reliability, and maintainability.
\n
• Review designs and code, resolve complex data and performance issues, and guide technical decisions.
\n
• Work with architects, business stakeholders, product owners, and technology teams to translate requirements into technical plans.
\n
• Break initiatives into tasks, estimate effort, manage dependencies, track progress, and resolve delivery risks.
\n
• Support production deployments and establish sustainable operational practices.
\n
• Mentor engineers, delegate effectively, and communicate status, risks, and trade-offs to technical and non-technical stakeholders.
\n
\n
Required Skills:
\n
• 8+ years of experience in data engineering, data warehousing, ETL/ELT, or a related field.
\n
• 3+ years of hands-on experience delivering AWS-based data solutions.
\n
• Strong hands-on experience with Amazon S3, Redshift, AWS Glue, DMS, and Lambda.
\n
• Advanced SQL skills, including complex queries, window functions, stored procedures, and performance tuning.
\n
• Strong Python and/or Java development skills, including testing, logging, error handling, and production-quality coding.
\n
• Extensive experience designing ETL/ELT pipelines, including batch processing, incremental loads, CDC, validation, reconciliation, and recovery.
\n
• Strong knowledge of data warehousing, data lakes, dimensional modeling, and logical and physical data modeling.
\n
• Experience integrating data from databases, files, APIs, applications, and other enterprise sources.
\n
• Understanding of data security and governance, including least-privilege access, encryption, secrets management, and sensitive-data protection.
\n
• Demonstrated experience leading engineers or providing technical direction on complex initiatives.
\n
• Proven ability to own deliverables from design through production implementation.
\n
• Strong troubleshooting, analytical, communication, and cross-team collaboration skills.
\n
• Ability to balance delivery timelines with solution quality, security, scalability, and maintainability.