Associate Data Architect: ETL, Warehousing & HIPAA

Compunnel, Inc.; Aliso Viejo (CA); On-site; USD 80,000 - 110,000; Full time

Job summary

A leading data solutions firm is seeking a Data Engineering Associate III responsible for delivering high-quality data solutions. The role focuses on SQL development, designing ETL processes using Microsoft technologies, and ensuring compliance with healthcare standards. The ideal candidate has experience with complex datasets, strong communication skills, and a background in data warehousing. This position offers opportunities for strategic data architecture involvement and engagement with cross-functional teams.

Qualifications

• Experience with Microsoft databases technical stack required.
• Strong ability in SQL development across large datasets.
• Hands-on with ETL processes using Microsoft technologies.
• Solid understanding of data warehousing practices.

Responsibilities

• Develop complex SQL queries for data transformation.
• Design and maintain ETL processes using SSIS and SSRS.
• Collaborate with stakeholders to gather requirements.
• Ensure compliance with healthcare regulatory standards.
• Create and maintain comprehensive technical documentation.

Skills

Microsoft databases technical stack experience

Complex SQL development

ETL/ELT solutions using SSIS/SSRS/Visual Studio

Data warehousing expertise

Defect tracking/ALM tools experience

Healthcare regulatory standards knowledge

Analytical capability

Education

Architect/Big Data Specialty certification in AWS, Azure, or GCP

Tools

Jira

Azure DevOps

SSIS

SSRS

Visual Studio

Job description

A leading data solutions firm is seeking a Data Engineering Associate III responsible for delivering high-quality data solutions. The role focuses on SQL development, designing ETL processes using Microsoft technologies, and ensuring compliance with healthcare standards. The ideal candidate has experience with complex datasets, strong communication skills, and a background in data warehousing. This position offers opportunities for strategic data architecture involvement and engagement with cross-functional teams.