SQL Web Developer

About The CompanyPartnership HealthPlan of California is a leading healthcare organization dedicated to providing high-quality, accessible, and cost-effective healthcare services to diverse communities across California. With a focus on innovative healthcare solutions and community-centric approaches, Partnership HealthPlan strives to improve health outcomes through comprehensive care management, advanced health information systems, and collaborative partnerships. The company is committed to fostering a dynamic work environment that values integrity, excellence, and continuous improvement, ensuring both employee growth and exceptional service delivery to its members.About The RoleThe Web Applications Data Integration Specialist at Partnership HealthPlan of California plays a pivotal role in developing and maintaining the processes necessary for the successful execution of the Software Development Life Cycle (SDLC) for web applications and automation projects. This position involves designing, implementing, and overseeing Extract, Transform, Load (ETL) processes, ensuring data integrity, and supporting data warehousing initiatives. The ideal candidate will possess a strong technical background in SQL Server, SSIS, Oracle, and related technologies, with a keen eye for detail and a strategic mindset to support the organization’s data-driven decision-making. This role requires close collaboration with cross-functional teams, including EIM, EDW, and IT, to ensure seamless data integration, quality, and security across healthcare systems.QualificationsCandidates should possess a Bachelor's degree in Computer Science, Information Technology, Business, or a related field. A minimum of four years of experience in systems analysis, particularly within healthcare data environments, is essential. Experience with healthcare information systems, data warehousing, and ETL processes is highly preferred. Technical proficiency in SQL Server, SSIS, SSRS, Oracle, and related database management tools is required. Familiarity with data masking, data quality management, OLTP, OLAP, and system interfaces will be advantageous. Strong analytical, troubleshooting, and communication skills are necessary to effectively interpret complex technical requirements and collaborate with diverse teams. Certifications in relevant technologies or healthcare data management are a plus.ResponsibilitiesLead the design, development, and implementation of ETL processes to support web applications and automation initiatives, ensuring efficient data flow and integrity.Design and develop SSIS packages used in extracting, transforming, and loading data across various healthcare systems and databases.Support production environments by monitoring ETL jobs, troubleshooting issues, and ensuring timely data processing.Develop and maintain a comprehensive understanding of SQL Server, SSIS, Oracle, and Analysis Services to optimize data workflows and reporting.Collaborate closely with the Enterprise Information Management (EIM) and Enterprise Data Warehouse (EDW) teams to retire legacy systems and facilitate data migration to new platforms.Source and integrate data from HIE and EDW systems to support web applications, ensuring data accuracy and consistency.Maintain detailed data lineage documentation for all ETL processes, supporting audit and compliance requirements.Design and implement data archiving solutions to manage historical web application data securely and efficiently.Coordinate with the EDI team to centralize ETL jobs using ActiveBatch, promoting automation and process standardization.Work with IT and business stakeholders to resolve data issues, improve process efficiency, and ensure data quality standards are met.Leverage technical expertise to make informed decisions in the absence of managerial oversight, ensuring project continuity and quality.Train new staff on web application processes, ETL architecture, data standards, and documentation practices to foster team development.Oversee coordination of development, testing, and production environments to ensure smooth deployment and operation of data processes.BenefitsPartnership HealthPlan of California offers a comprehensive benefits package designed to support employee well-being and professional growth. Employees enjoy competitive salaries, health insurance coverage including medical, dental, and vision plans, and retirement savings options. The organization promotes work-life balance through flexible work arrangements and paid time off policies. Opportunities for continuous learning and development are available through training programs, certifications, and career advancement pathways. Additionally, employees benefit from a collaborative work environment that values innovation, diversity, and inclusion, fostering a culture of respect and mutual support.Equal OpportunityPartnership HealthPlan of California is an equal opportunity employer committed to fostering a diverse and inclusive workplace. We do not discriminate based on race, color, religion, sex, national origin, age, disability, sexual orientation, gender identity, or any other protected status. We believe that a diverse workforce enhances our ability to serve our members effectively and innovatively. All qualified applicants will receive consideration for employment without regard to any protected characteristic, and we are dedicated to providing a work environment where everyone can thrive.