Responsible for the development of all processes necessary to complete SDLC phases of the Web Applications and Automation projects. This includes understanding of business processes, source identification, process design, data collection, data transformation, normalization, error detection and correction, data storage, data linage management, data achieving, and ETL Process oversight for web applications.
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.
- Performs other tasks necessary to ensure integrity of HIE / EDI/ Claims System databases and the accuracy of reporting data.
- Represent Web Applications team in data quality meetings
- Leads and participates in special projects as needed and assigned.
Education and Experience
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.
Special Skills,
Licenses and
Certifications
Knowledge of databases (SQL Server, SSRS, SQL Stored procedures, SSIS, normalization, queries, views). Some knowledge of Oracle and Oracle programming methodologies. Knowledge of data masking, centralizing ETL configuration, data quality, data Integrity, OLTP, OLAP, etc. Ability to move data between systems as needed, effortlessly. High standards for data presentation. Significant knowledge of PCs, Windows 10, and related applications. Understanding of systems and related systems interfaces and how changes impact various systems.
Performance
Based
Competencies
Ability to quickly acquire in-depth knowledge of new systems and software configuration at Partnership. Strong written and oral communication skills with ability to interpret and understand technical requirements. Excellent analytical skills to troubleshoot and resolve systems problems. Able to develop procedures to automate jobs and to document extensively and clearly. Good client relations skills.
Work Environment
And Physical
Demands
More than 50% of work time is spent in front of a computer monitor. May be required to bend, stoop, kneel, crawl, or work in other nonstanding and non-sitting positions to install cabling, systems hardware, and other related equipment.
All HealthPlan employees are expected to:
- Provide the highest possible level of service to clients;
- Promote teamwork and cooperative effort among employees;
- Maintain safe practices; and
- Abide by the HealthPlan’s policies and procedures, as they may from time to time be updated.
$122,667.11 - $159,467.24
IMPORTANT DISCLAIMER NOTICEThe job duties, elements, responsibilities, skills, functions, experience, educational factors and the requirements and conditions listed in this job description are representative only and not exhaustive of the tasks that an employee may be required to perform. The employer reserves the right to revise this job description at any time and to require employees to perform other tasks as circumstances or conditions of its business, competitive considerations, or work environment change.
Skills Required
- Bachelor’s degree in Computer Science, Business, or a related field
- Minimum four years of systems analysis experience
- Experience with medical information systems
- Equivalent combination of education and experience may be accepted
- Experience with healthcare data
- Knowledge of SQL Server, SSRS, SQL stored procedures, SSIS, database normalization, queries, and views
- Some knowledge of Oracle and Oracle programming methodologies
- Knowledge of data masking, ETL configuration, data quality, data integrity, OLTP, and OLAP
- Ability to move data between systems and understand system interfaces and impacts of changes
- Strong written and oral communication skills
- Excellent analytical and troubleshooting skills
- Ability to automate jobs and document procedures clearly
- Good client relations skills
What We Do
Partnership HealthPlan of California is a nonprofit, community-based health care organization and managed-care plan. It contracts with the state to administer Medi-Cal benefits through local care providers, helping recipients access high-quality, comprehensive, and cost-effective care. Its mission is to help its members and the communities it serves be healthy, while coordinating health services across Northern California and supporting local providers.
