Title: AWS Data Engineering Architect
Location: Newark, NJ (Hybrid - 3 days per week in the office)
Duration: Full-time with ComTecJob 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.
