Senior SQL & ETL Web Architect

Partnership HealthPlan of California; Fairfield (CA); On-site; USD 123,000 - 159,000; Full time

Job summary

Partnership HealthPlan of California is seeking an experienced ETL professional to lead the design, development, and oversight of ETL processes for our web applications and automation projects. You will develop SSIS packages, monitor production jobs, and partner with EIM/EDW teams to retire legacy data warehouses while ensuring data lineage and data quality across systems.

The role requires a Bachelor's degree in a related field and at least four years in systems analysis within healthcare data

Qualifications

• Bachelor's degree required in CS, Business, or related field.
• At least four years of systems analysis experience in healthcare data.
• Experience with SQL Server, SSIS/SSRS and Oracle preferred.
• Strong data modeling and ETL design capabilities.

Responsibilities

• Lead design and implementation of ETL processes for web apps.
• Develop SSIS packages and oversee ETL production.
• Collaborate with EIM/EDW teams to retire old data warehouse.
• Ensure data lineage, integrity and quality across systems.
• Coordinate with departments to resolve data issues.

Skills

Systems analysis

Data quality

Analytical skills

Communication skills

Education

Bachelor's degree in CS/related field

Tools

SQL Server

SSRS

SQL Stored Procedures

SSIS

Oracle

Job description

Partnership HealthPlan of California is seeking an experienced ETL professional to lead the design, development, and oversight of ETL processes for our web applications and automation projects. You will develop SSIS packages, monitor production jobs, and partner with EIM/EDW teams to retire legacy data warehouses while ensuring data lineage and data quality across systems.

The role requires a Bachelor's degree in a related field and at least four years in systems analysis within healthcare data