Compunnel, Inc.
ETL Developer / Data Integration Professional
Compunnel, Inc., Aliso Viejo, California, United States, 92656
Job Summary
The ETL Developer / Data Integration Professional is responsible for designing, developing, and maintaining ETL processes and data integration solutions using Microsoft technologies. This role involves optimizing SQL queries, implementing data warehousing solutions, and ensuring accurate and secure data flow across multiple systems. The position requires strong collaboration with business analysts and stakeholders to deliver high-quality reporting and analytics solutions while adhering to healthcare regulatory standards.
Key Responsibilities
Develop and optimize complex SQL queries for data extraction, transformation, and loading across multiple systems and large datasets.
Perform data mapping and transformation between source and target systems to ensure accurate and consistent data flow.
Collaborate with business analysts and stakeholders to gather requirements and translate them into technical specifications for ETL and reporting solutions.
Design, develop, and maintain ETL processes using Microsoft technologies including SSIS, SSRS, and Visual Studio to support data integration and reporting needs.
Implement and maintain data warehousing solutions, applying best practices for architecture, modeling, and performance tuning.
Create and maintain SSRS reports and dashboards, delivering actionable insights to business users.
Troubleshoot and resolve data integration issues, ensuring timely and accurate data delivery across systems.
Document ETL processes, data flows, and system configurations, maintaining clear and comprehensive technical documentation.
Log, track, and manage defects using tools such as Jira or Azure DevOps; collaborate closely with testers and other data engineers to resolve issues and provide fixes.
Ensure all development and deliverables comply with healthcare regulatory standards (e.g., HIPAA) and support audit and compliance requirements.
Demonstrate strong communication skills and a self-starter attitude, working independently and as part of a team to meet project deadlines and objectives.
Required 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.
Knowledge of data warehousing architecture, modeling, and performance tuning.
Familiarity with defect tracking tools such as Jira or Azure DevOps.
Understanding of healthcare regulatory standards (e.g., HIPAA).
Excellent communication skills and ability to work independently and in teams.
Preferred Qualifications
Experience in creating dashboards and advanced reporting solutions.
Exposure to cloud-based data integration tools and platforms.
Knowledge of best practices in data governance and security.
Certifications
Microsoft Certified: Data Engineer Associate or equivalent (preferred).
#J-18808-Ljbffr
Key Responsibilities
Develop and optimize complex SQL queries for data extraction, transformation, and loading across multiple systems and large datasets.
Perform data mapping and transformation between source and target systems to ensure accurate and consistent data flow.
Collaborate with business analysts and stakeholders to gather requirements and translate them into technical specifications for ETL and reporting solutions.
Design, develop, and maintain ETL processes using Microsoft technologies including SSIS, SSRS, and Visual Studio to support data integration and reporting needs.
Implement and maintain data warehousing solutions, applying best practices for architecture, modeling, and performance tuning.
Create and maintain SSRS reports and dashboards, delivering actionable insights to business users.
Troubleshoot and resolve data integration issues, ensuring timely and accurate data delivery across systems.
Document ETL processes, data flows, and system configurations, maintaining clear and comprehensive technical documentation.
Log, track, and manage defects using tools such as Jira or Azure DevOps; collaborate closely with testers and other data engineers to resolve issues and provide fixes.
Ensure all development and deliverables comply with healthcare regulatory standards (e.g., HIPAA) and support audit and compliance requirements.
Demonstrate strong communication skills and a self-starter attitude, working independently and as part of a team to meet project deadlines and objectives.
Required 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.
Knowledge of data warehousing architecture, modeling, and performance tuning.
Familiarity with defect tracking tools such as Jira or Azure DevOps.
Understanding of healthcare regulatory standards (e.g., HIPAA).
Excellent communication skills and ability to work independently and in teams.
Preferred Qualifications
Experience in creating dashboards and advanced reporting solutions.
Exposure to cloud-based data integration tools and platforms.
Knowledge of best practices in data governance and security.
Certifications
Microsoft Certified: Data Engineer Associate or equivalent (preferred).
#J-18808-Ljbffr