AWS Data Integration & ETL Analyst

HTC Global Services Inc

Iselin, NJ

JOB DETAILS
JOB TYPE
Full-time, Employee
SKILLS
AWS Lambda, Amazon Simple Storage Service (S3), Amazon Web Services (AWS), Analysis Skills, Artificial Intelligence (AI), Atlassian JIRA, Career Counseling, Data Collection, Data Management, Data Mapping, Data Modeling, Data Profiling, Data Quality, Database Extract Transform and Load (ETL), Emerging Technology, Environmental Impact, Machine Tool, Onboarding, Production Systems, Requirements Management, Risk Analysis, SQL (Structured Query Language), Scrum Project Management and Software Development, Test Automation, Test Plan/Schedule, Writing Skills
LOCATION
Iselin, NJ
POSTED
28 days ago

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.

#LI-Onsite 

About the Company

H

HTC Global Services Inc

Shaping careers since 1990 - our long tenured employees are a testimony of the work culture. Join our global employee base of 12,000 and help us bring human expertise to tech in order to deliver purposeful solutions that amplify value.
COMPANY SIZE
1,000 to 1,499 employees
INDUSTRY
Computer/IT Services
FOUNDED
1990
WEBSITE
https://www.htcinc.com/