Senior SQL Web Developer: ETL, Data Architecture & Web Apps

Partnership HealthPlan of California; Fair Field (AR); On-site; USD 123,000 - 159,000; Full time

Job summary

Partnership HealthPlan of California seeks an experienced ETL/ data integration professional to lead the design, development, and deployment of ETL processes for Web Applications and Automation projects. You will design SSIS packages, monitor production jobs, and collaborate with EIM/EDW teams to retire legacy data stores.

The role requires strong SQL Server/SSIS knowledge, healthcare data experience, and the ability to translate business needs into robust data pipelines with clear documentation

Qualifications

• Bachelor's degree in Computer Science, Business, or related field; minimum four (4) years of systems analysis experience with experience in medical information systems; or equivalent combination of education and experience.
• Experience with healthcare data is preferred.

Responsibilities

• Lead design, develop and implement ETL process to support Web Applications and Automation projects.
• Responsible for designing and developing SSIS packages used in the Extract, Transform, and Load (ETL) processes.
• Responsible for supporting production of all Web Applications ETL process and monitoring production jobs.
• Develops and maintains in-depth understanding of SQL Server, SSIS, Oracle, and Analysis Services.
• Responsible for working closely with EIM and EDW teams to retire all processes related to old data warehouse and lab data databases.
• Work closely with EIM and EDW to source HIE and EDW data for web applications.
• Responsible for developing and maintaining data linage for all ETL Processes.
• Responsible designing, developing, and implementing solutions to archive web applications data.
• Responsible for working closely with EDI team in centralizing all web applications ETL Jobs using ActiveBatch.
• Responsible for coordination with other departments regarding resolving issues, consistency and accuracy of data.
• Works with IT and business stakeholders on development and coordination of ETL and other processes.
• Uses sound technical judgment and makes appropriate systems decisions in absence of the Manager / Director Web Applications Development.
• Responsible to train new staff on Web applications, process, Web Systems Data, and ETL architecture, ETL standards, and ETL documentation.
• Responsible for the coordination of the production, development, and UAT environments.

Skills

Data analytics

Communication

Team collaboration

Education

Bachelor's degree in Computer Science or related field

Tools

SQL Server

SSIS

SSRS

Oracle

Analysis Services

Job description

Partnership HealthPlan of California seeks an experienced ETL/ data integration professional to lead the design, development, and deployment of ETL processes for Web Applications and Automation projects. You will design SSIS packages, monitor production jobs, and collaborate with EIM/EDW teams to retire legacy data stores.

The role requires strong SQL Server/SSIS knowledge, healthcare data experience, and the ability to translate business needs into robust data pipelines with clear documentation