Manager of Data Warehouse

Partnership HealthPlan of California; Fairfield (CA); On-site; USD 141,000 - 183,000; Full time

Job summary

Partnership HealthPlan of California is seeking an experienced Data Warehouse Manager to lead the Data Warehouse Team and drive the architecture and BI framework aligned with organizational goals.

The role requires strong SQL/Oracle skills, data warehousing expertise, and the ability to translate business needs into scalable solutions. You will mentor staff, develop ETL designs, and ensure data integrity across enterprise assets.

Qualifications

• Bachelor’s degree in Computer Science or related field required; Master’s preferred; five plus (5+) 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 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.
• Oversees the development and maintenance of SSIS packages to support ETL processes within the Enterprise Data Warehouse.

Skills

Data warehousing concepts

Kimball methodology

Strong communication skills

Analytical skills

Education

Bachelor's degree in Computer Science or related field

Master’s degree preferred

Tools

MS SQL Server

Oracle

Business Objects

HealthEdge

AMISYS

Job description

Overview

Oversees the organizational and technical support for the data warehouse. Accountable for the delivery and maintenance of the data warehouse architecture and business intelligence framework that meets the short and long term goals of Partnership.

Responsibilities

PRIMARY DUTIES AND 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 Extract, Transform, and Load (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.

SECONDARY DUTIES AND RESPONSIBILITIES

• Researches trends in data warehousing and business intelligence. Recommends strategies which support the company’s strategic plans.
• Participates in special projects and assignments as needed.
• Provides expert guidance to the user community.

Qualifications

Education and Experience

Bachelor’s degree in Computer Science or related field required; Master’s preferred; five plus (5+) years systems analysis experience with a focus on enterprise data warehousing.

Special Skills, Licenses and Certifications

Knowledge of databases including MS SQL Server, Oracle and Busienss 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.

Performance Based Competencies

Ability to quickly acquire in-depth knowledge of new systems and software configurations; strong written and oral communication skills; excellent analytical skills; good client relationship skills. Strong analytical, problem solving, written and verbal communication.

Work Environment And Physical Demands

Most work time is spent in front of a computer monitor. May also be required to bend, stoop, kneel, or crawl.

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.

HIRING RANGE:

$141,067.17 - $183,387.32

IMPORTANT DISCLAIMER NOTICE

The 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.