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.