AWS Data Integration & ETL Analyst

Location: Iselin (NJ) | Employment Type: Full Time - 40 hours per week | Job Level: T2 | Work Preference: Onsite at work location address | Job Code: 242971

Job Description:

Job Title

AWS Data Integration & ETL Analyst

Overview / Summary

Seeking a professional with strong SQL and ETL architecture expertise to partner with source system owners, business stakeholders, AI engineers, data modelers, and solution architects. The role focuses on gathering data requirements, defining source-to-target mappings, supporting AWS-based data integration solutions, assessing downstream impacts, and ensuring data quality across the data lifecycle.

Key Responsibilities

Partner with source system owners and business stakeholders to gather data requirements and translate them into clear, actionable source-to-target mapping documents with documented transformation logic and acceptance criteria.
Collaborate directly with AI engineers, data modelers, and solution architects to ensure data pipelines support both traditional analytics and high-volume data transformation requirements.
Design and review ETL architecture patterns on AWS, including Glue, Step Functions, S3, and Redshift/Athena.
Provide hands-on guidance on job orchestration, partitioning strategies, and historic storage approaches.
Write detailed JIRA stories covering business value, mapping changes, data onboarding steps, and expected platform impact.
Assess the impact of new data sources, product changes, and business enhancements on downstream screening and detection platforms.
Proactively identify and communicate risks before they impact production environments.
Hand off refined requirements to scrum teams and remain engaged during development and testing.
Identify and flag data quality issues at the source and work with data stewards and source owners to remediate issues before data enters the integration layer.
Leverage AI-assisted tooling, including code generation, automated testing, and intelligent data profiling, to improve work efficiency.

Required Qualifications

Hands-on SQL experience.
Strong ETL architecture knowledge.
Practical AWS experience with:
- AWS Glue
- AWS Lambda
- Amazon S3
- AWS IAM
- Amazon CloudWatch

What Makes HTC A Great Place To Build Your Future

HTC Global Services wants you to join our team. Come build new things with us and advance your career. At HTC Global, you’ll collaborate with experts, work alongside clients, and be part of high-performing teams driving success together. You’ll have long-term opportunities to grow your career and develop skills in the latest emerging technologies.

At HTC Global Services, our employees have access to a comprehensive benefits package. Benefits can include Group Health (Medical, Dental, and Vision), Paid Time Off, Paid Holidays, 401(k) matching, Group Life and Disability insurance, Professional Development opportunities, Wellness programs, and a variety of other perks.

Our success as a company is built on inclusion and diversity. HTC Global Services is committed to providing a workplace free from discrimination and harassment, where every employee is treated with dignity and respect. We celebrate differences and believe that diverse cultures, perspectives, and skills drive innovation and success. HTC is an Equal Opportunity Employer and a proud National Minority Supplier. We seek to empower each individual, fostering an environment where everyone feels valued, included, and respected.

Apply Now