Senior Data Warehouse & BI Lead

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

Job summary

Partnership HealthPlan of California is seeking a Data Warehouse Leader to oversee the organizational and technical support for the data warehouse and BI framework. You will guide the Data Warehouse Team, develop requirements, and ensure data integrity.

The role requires 5+ years in enterprise data warehousing, experience with MS SQL Server, Oracle, SSIS, and BI tools; knowledge of Kimball methodology and data governance is a plus.

Qualifications

• Bachelor’s degree in Computer Science or related field required; Master’s preferred; 5+ years of data warehousing experience.
• Familiarity with HealthPlan data environments and BI tools.
• Knowledge of Kimball methodology and data warehouse concepts.

Responsibilities

• Leads and manages the Data Warehouse Team, providing direction, coaching, and performance feedback.
• Develops requirements and designs for the data warehouse solutions with input from the business.
• Creates and maintains comprehensive documentation and a roadmap for the data warehouse.
• Maintains and updates the enterprise data directory to ensure consistency and accessibility of data definitions.
• Oversees the development of internal reports and BI outputs.
• Develops and maintains in-depth knowledge of the AMISYS table structure and content.

Skills

Analytical skills

Written and verbal communication

Client relationship skills

Education

Bachelor's degree in Computer Science or related field

Master’s degree

Tools

MS SQL Server

Oracle

Business Objects

HealthEdge

AMISYS

Kimball methodology

OLAP

ROLAP

MOLAP

Job description

Partnership HealthPlan of California is seeking a Data Warehouse Leader to oversee the organizational and technical support for the data warehouse and BI framework. You will guide the Data Warehouse Team, develop requirements, and ensure data integrity.

The role requires 5+ years in enterprise data warehousing, experience with MS SQL Server, Oracle, SSIS, and BI tools; knowledge of Kimball methodology and data governance is a plus.