Data Engineer - Modern Data Platform & ETL

Hanson Lee Resourcing Ltd; Arcadia (CA); Hybrid; USD 110,000 - 160,000; Full time

Job summary

Hanson Lee Resourcing Ltd. is seeking a Data Engineer to design, develop and support data warehouse and ETL solutions in a hybrid US-based environment. You will build SQL-based integrations and collaborate with business and technology teams to deliver data projects.

The role emphasizes strong SQL skills, experience with ETL tools, and familiarity with Azure Synapse. 3+ years in data engineering and data warehousing is preferred, with an advantage for insurance/financial services background.

Qualifications

• 3+ years of experience in Data Engineering or Data Warehousing.
• Strong SQL skills and experience with large datasets.
• Experience with ETL tools such as SSIS, Informatica or Azure Data Factory (ADF).
• Experience with SQL Server and/or Azure Synapse preferred.
• Insurance or financial services experience is advantageous.

Responsibilities

• Design, develop and support data warehouse and ETL solutions.
• Build and optimise SQL-based data integrations and pipelines.
• Troubleshoot data quality issues and support production releases.
• Collaborate with business and technology teams to deliver data projects.
• Identify opportunities to improve performance, efficiency and quality.

Skills

Data warehousing

SQL proficiency

ETL processes

Tools

SSIS

Informatica

Azure Data Factory

SQL Server

Azure Synapse

Job description

Hanson Lee Resourcing Ltd. is seeking a Data Engineer to design, develop and support data warehouse and ETL solutions in a hybrid US-based environment. You will build SQL-based integrations and collaborate with business and technology teams to deliver data projects.

The role emphasizes strong SQL skills, experience with ETL tools, and familiarity with Azure Synapse. 3+ years in data engineering and data warehousing is preferred, with an advantage for insurance/financial services background.