Partnership HealthPlan of California · 2 days ago
Senior Data Warehouse ETL Developer
Fairfield, CA
Full-time
Onsite
Mid, Senior Level
$136K/yr - $177K/yr
4+ years expPartnership HealthPlan of California is seeking a Senior Data Warehouse ETL Developer responsible for the development of all processes necessary to complete all phases of the Enterprise Data Warehouse (EDW). The role involves leading ETL development, ensuring data flow into the Data Warehouse, and coordinating with other departments for data consistency and accuracy.
Health CareInsuranceNon Profit
Responsibilities
Lead ETL resource on new ETL development for the Data Warehouse
Responsible for the entire flow of the data into the Data Warehouse
Develops and maintains in-depth understanding of SQL Server, Oracle, BusinessObjects, Access databases, and Analysis Services
Responsible for developing SSIS packages used in the Extract, Transform, and Load (ETL) processes for EDW
Provides guidance for all Master Data Management (MDM) aspects involved in the development of the EDW
Responsible for understanding all development in the area of MDM and ETL
Responsible for the transition of documentation, security, development, and testing of all procedures in the EDW
Responsible for coordination with other departments regarding consistency and accuracy of data
Works with Web Team on development and coordination of ETL and other processes
Uses sound technical judgment and makes appropriate systems decisions in absence of the Associate Director, Data Warehouse and Architecture
Responsible to train new staff on ETL architecture, ETL standards, and ETL documentation
Responsible for the coordination of the production, development, and sandbox environments
Designs, develops, tests, and supports client server applications using C# and ASP.NET
Experience in working with .NET Web Services, WCF framework and Web API using WSDL, SOAP and UDDI
Performs other tasks necessary to ensure integrity of eCommerce / AMYSIS databases and the accuracy of reporting data
Leads and participates in special projects as needed and assigned
Qualification
Required
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
Knowledge of databases (SQL Server, BusinessObjects, Access, SSIS, normalization, queries, views)
Some knowledge of Oracle and Oracle programming methodologies
Knowledge of data warehousing, data marts, OLAP, ROLAP, MOLAP, etc
Ability to move data between systems as needed, effortlessly
High standards for data presentation
Significant knowledge of PCs, Windows 2000, and related applications
Understanding of systems and related systems interfaces and how changes impact various systems
Ability to quickly acquire in-depth knowledge of new systems and software configuration at PHC
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
Preferred
Experience with healthcare data
Company
Partnership HealthPlan of California
Partnership HealthPlan of California is a non-profit community-based health care organization that contracts with the state to administer Medi-Cal benefits through local care providers to ensure Medi-Cal recipients have access to high-quality comprehensive cost-effective health care.
1001-5000 employees
H1B Sponsorship
Partnership HealthPlan of California has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2023 (1)
Funding
Current Stage
Late StageLeadership Team
L
Lorna Veloso
Sr. Manager of OpEx/PMO
Recent News
The Express Tribune
2024-03-19
The Express Tribune
2024-03-01
2024-02-23
Company data provided by crunchbase