Data Engineer – USA

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

United States (Hybrid) 10 office locations

Join aleading global insureras aData Engineerand help deliver modern data solutions that power business insight and decision-making.

Working within theData Integration & Delivery Team, you’ll develop and support enterprise data warehouse solutions, build ETL processes, improve data quality, and contribute to a modern data platform. You’ll also work in an environment embracing AI and automation to drive smarter outcomes.

What you’ll do

• 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

What you’ll bring

• 3+ years’ experience in Data Engineering or Data Warehousing
• Strong SQL skills and experience working with large datasets
• Experience with ETL tools such asSSIS, Informatica or Azure Data Factory (ADF)
• Experience withSQL Server and/or Azure Synapsepreferred
• Insurance or financial services experience is advantageous