Data Warehouse Lead & BI Architect

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 seasoned Data Warehouse Leader to guide the team responsible for the data warehouse and BI framework. You will steer requirements, design, and documentation while ensuring data integrity across enterprise assets.

The role emphasizes SSIS/ETL development, master data management alignment, and strong SQL/BI tooling knowledge within a health plan context.

Qualifications

• Bachelor’s degree in Computer Science or related field required.
• Master’s degree preferred.
• Five+ years systems analysis experience with a focus on enterprise data warehousing.
• Knowledge of databases including MS SQL Server, Oracle and Business Objects.
• Knowledge of data warehousing, data marts, OLAP, ROLAP, and MOLAP.
• Significant knowledge of HealthEdge and or AMISYS is a plus.
• Understands Data Warehouse design concepts, should know Kimball methodology.

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.
• Ensures the accuracy, integrity, and reliability of enterprise data assets.
• Designs, develops, and maintains SSIS packages to support ETL processes within the Enterprise Data Warehouse.
• Supports master data management initiatives and ensure alignment with data governance practices.
• Maintains and updates the enterprise data directory to ensure consistency and accessibility of data definitions.
• Assigns work to staff and supports them in analysis, design, and database use.
• Oversees the development of internal reports.
• Develops and maintains in-depth knowledge of the AMISYS table structure and content.
• Develops and maintains in-depth understanding of SQL Server, Oracle, business intelligence software, and other databases.
• Provides feedback to staff regarding performance.

Skills

Data warehousing

Analytical skills

Communication skills

Leadership

SQL

Education

Bachelor’s degree in Computer Science or related field

Master’s degree preferred

Tools

MS SQL Server

Oracle

Business Objects

Job description

Partnership HealthPlan of California is seeking a seasoned Data Warehouse Leader to guide the team responsible for the data warehouse and BI framework. You will steer requirements, design, and documentation while ensuring data integrity across enterprise assets.

The role emphasizes SSIS/ETL development, master data management alignment, and strong SQL/BI tooling knowledge within a health plan context.