AWS Data Engineering Architect (Newark)
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.