Loading...
USM Jobs / Sr. Datawarehouse Developer
Medium Contract

JB061117 - Sr. Datawarehouse Developer Apply

  • Start Date:
    Interview Types
  • Skills - 7+ years of SQL Se..
    Visa Types Green Card, US Citiz..
Title: Sr. Datawarehouse Developer
Duration: 6 months
 
Description
PHC is looking for a Sr Data Warehouse Developer to support ongoing roadmap expansion. They are a MS SQL Server environment; they use SSIS for ETL. PHC is redesigning their data warehouse to support the new core/claims system.

Link to platform: https://www.zeomega.com/solutions/jiva-healthcare-enterprise-management-platform

- 7-10 years of SSIS and SQL Server development experience
- Sr. ETL developer in support of the new core system implementation.
- Responsible for the entire flow of the data into the Data Warehouse and Provider expert guidance on the architecture & design of EDW
- Develops and maintains in-depth understanding of SQL Server, Oracle & SSIS.
- Understands Data Warehouse design concepts; should know Kimball methodology
- Responsible for developing SSIS packages used in the Extract, Transform, and Load (ETL) processes for EDW.
- Provides support for all Master Data Management (MDM) aspects involved in the development of the EDW.
- Responsible for the transition of documentation, security, development and testing of all procedures in the EDW.
- Responsible to train new staff on ETL architecture, ETL standards and ETL documentation.
- Responsible for the coordination of the production, development and sandbox environments.
 
Top Skills Details
\*\*\*Out of town candidates who will move will be strongly considered Client will sponsor!\*\*\*

- 7+ years of SQL Server development experience
- 3+ years of ETL/SSIS experience
- Must have multiple Data Warehouse development projects
- Must have experience w/ data modeling, creating data marts and Kimball Methodology

.NET integration experience is nice-to-have
Healthcare is a nice-to-have
Cloud is nice-to-have
 
Worksite Address
4665 Business Center Drive,Fairfield,California,United States,94534-1568
 
Additional Information
Please do not send SSRS Report Developers- we need Data Warehouse Developers
 
Workplace Type
Hybrid
 
EVP
Potential conversion to full-time
3 days remote/ 2 onsite
Ability to get experience within the Healthcare industry.
Gain experience with Jiva.

Willl sponsor H1b visa if they convert this person to FTE.
 
Work Environment
Family type environment; rapidly growing company and team.

New facilities
 
Additional Skills & Qualifications
Ability to work with resources across different departments. Ability to gather requirements.

Implementing Jiva for case management and utilization management
 
Impact to the Internal/External Customer
Integrate data from core system to DW and other systems. This will allow for better data collection for initiatives like claims processing, billing, quality reporting, and population health.

More centralized data source for reporting.

Better access to data.
 
Interview Information
1 30 minute phone
2nd 60 minute deep dive technical interview
 
Business Challenge
Implement a case management platform and UM platform. This will help PHC guide their members to providers and services in network. This will lead to fewer denials and a better customer experience