HTC Global Services

AWS Data Integration & ETL Analyst

HTC Global Services • $90K — $120K *
Iselin, NJ 08830In-Person
Information Technology
Less than 5 years of experience
Today
Be an Early Applicant
Job Overview by Ladders

Qualifications

  • Hands-on SQL experience
  • Strong ETL architecture knowledge
  • Practical AWS experience with AWS Glue, Lambda, S3, IAM, and CloudWatch

Responsibilities

  • Partner with stakeholders to gather data requirements and create source-to-target mappings
  • Collaborate with AI engineers and data modelers to support analytics and data transformation
  • Design and review ETL architecture patterns on AWS tools such as Glue and Redshift
  • Provide guidance on job orchestration and partitioning strategies
  • Prepare detailed JIRA stories that outline business value and mapping changes
  • Assess impacts of new data sources and business changes on downstream platforms
  • Proactively identify and communicate risks to ensure production stability
  • Engage with scrum teams during development and testing phases
  • Identify data quality issues and work with data stewards for remediation

Benefits

  • Collaborative work environment with a focus on innovation
  • Opportunity to work with cutting-edge AI-assisted tooling
  • Engagement with cross-functional teams for comprehensive project insights
  • Professional development opportunities in AWS technologies
  • Impactful role that contributes to data quality and business intelligence
Full 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

About HTC Global Services

HTC Global Services is a global provider of IT and Business Process Services and Solutions. Founded in 1990, HTC is headquartered in Troy, Michigan with delivery centers across multiple locations in North America, Europe, India, and Malaysia. HTC is an Inc. 500 Hall of Fame company and has been recognized by numerous industry and trade publications as a top provider of services. HTC has a strong client base of Global 2000 customers. HTC has a strong focus on healthcare, retail, financial services, and automotive verticals. HTC has a strong commitment to corporate social responsibility and has been recognized for its contributions to the community.
Learn more about HTC Global Services
Size
17,575 employees
Industry
Information Technology
Founded
1990
NASDAQ
HTCKF
* Ladders Estimates

Similar Jobs

Ad banner background

Get Ready For Your
Next Interview

More Jobs at HTC Global Services

More Information Technology Jobs

Find similar AWS Data Integration & ETL Analyst jobs:

NationwideIselin, NJ