ETL & Data Integration Engineer (SSIS/SSRS)

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

Job summary

A technology company is seeking an ETL Developer / Data Integration Professional to design, develop, and maintain ETL processes and solutions using Microsoft technologies. Responsibilities include optimizing SQL queries, implementing data warehousing solutions, and ensuring compliance with healthcare standards. The ideal candidate should have strong experience with SSIS and SSRS, proficiency in SQL, and excellent communication skills. This role emphasizes collaboration with business analysts to deliver impactful reporting and analytics.

Qualifications

• Strong experience with Microsoft technologies including SSIS, SSRS, and Visual Studio.
• Proficiency in SQL development and optimization for large datasets.
• Hands-on experience in data mapping, transformation, and ETL processes.

Responsibilities

• Develop and optimize complex SQL queries for data extraction and loading.
• Perform data mapping and transformation to ensure accurate data flow.
• Collaborate with business analysts to gather requirements for ETL solutions.

Skills

Microsoft technologies including SSIS, SSRS, and Visual Studio

SQL development and optimization

Data mapping and transformation

Healthcare regulatory standards (e.g., HIPAA)

Communication skills

Education

Microsoft Certified: Data Engineer Associate

Tools

Jira

Azure DevOps

Job description

A technology company is seeking an ETL Developer / Data Integration Professional to design, develop, and maintain ETL processes and solutions using Microsoft technologies. Responsibilities include optimizing SQL queries, implementing data warehousing solutions, and ensuring compliance with healthcare standards. The ideal candidate should have strong experience with SSIS and SSRS, proficiency in SQL, and excellent communication skills. This role emphasizes collaboration with business analysts to deliver impactful reporting and analytics.