Data Engineer

About the role

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.

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 serve both traditional analytics and supports transforming data with high volumes capability.
• Design and review ETL architecture patterns on AWS (Glue, Step Functions, S3, Redshift/Athena), providing hands-on guidance on job orchestration, partitioning strategies and historic storages.
• Write detailed JIRA stories covering business value, mapping changes, data onboarding steps, and expected platform impact — stories that engineering teams can pick up with minimum transition support.
• Assess the impact of new data sources, product changes, or business enhancements on downstream screening and detection platforms, proactively flagging risks before they hit production.
• Hand off refined requirements to scrum teams and remain partitioning during development and testing.
• Identify and flag data quality issues at source, working with data stewards and source owners to remediate before data enters the integration layer.
• Leverage AI-assisted tooling (code generation, automated testing, intelligent data profiling) as a work efficiencies multiplier.

Requirements

• Hands-on SQL experience.
• Strong ETL architecture knowledge with practical AWS experience (Glue, Lambda, S3, IAM, CloudWatch).

Preferred Experience

• On Apache Iceberg

Benefits

At HTC Global Services, you will have access to a comprehensive benefits package including 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.

Pay

Details on pay are not specified in this job description.

Schedule

Details on schedule are not specified in this job description.