Senior Business Intelligence System Analyst

Overview

To design, support, and provide strategic planning of the Business Intelligence solution acrossthe enterprise. Manages deployment, maintenance, and support of Business Intelligence toolsand reports. Analyzes, creates, documents, tests, maintains, troubleshoots, and promotes theBusiness Intelligence environment.

Responsibilities

• Designs Business Intelligence lifecycle including analysis, design, development, testing,implementation, support, end-user training, and documentation.
• Creates Semantic Layer for Business Intelligence Reporting.
• Creates and tests new Business Intelligence processes to ensure that all changes areeffective and functional.
• Works with Data Architect to tune and modify back-end Business Intelligence environment.
• Creates and maintains data lineage and data dictionary.
• Provides assistance in data modeling and architecture for the EDW using the Kimballarchitecture modeling.
• Analyzes data issues through SQL Server and Oracle.
• Participates in the selection and promotion of Business Intelligence tools.
• Participates in enterprise Data Warehousing/Business Intelligence strategy.
• Promotes new ways of doing analysis and reporting within the company.
• Assists end-users with reporting tools.
• Coordinates and/or attends all assigned project related meetings.
• Serves as liaison with IT, end-users, vendors, and contractors.
• Ensures business users have the correct understanding of the data, its structure, and theanalytic tools to meet their needs.
• Provides technical and problem resolution support to the user community.
• Works with Report Writer to ensure standards are being met.
• Participates in development of Data Definitions and standards.
• Other duties as assigned.

Qualifications

Education and Experience

Bachelor’s degree in Computer Science, Business, or related field;minimum four (4) years systems analysis experience with experience inBusiness Intelligence systems; or equivalent combination of educationand experience. Experience with healthcare data is preferred.

Special Skills, Licenses and Certifications

Knowledge of databases (SQL Server, BusinessObjects, Access, SSIS,normalization, queries, views). Some knowledge of Oracle and Oracleprogramming methodologies. Knowledge of data warehousing, datamarts, OLAP, ROLAP, MOLAP, etc. Ability to move data betweensystems as needed, effortlessly. High standards for data presentation.Significant knowledge of PCs, Windows, and related applications.Understanding of systems and related systems interfaces and howchanges impact various systems. Valid California driver’s license andproof of current automobile insurance compliant with PHC policy arerequired to operate a vehicle and travel for company business.

Performance Based Competencies

Effective written and oral communication skills and ability to assistothers in defining their needs in a collaborative, tactful manner.Demonstrated aptitude for acquiring new technical skills in datareporting. Detail-oriented with strong organizational skills. Ability to workon multiple projects and assignments simultaneously and meetdeadlines.

Work Environment And Physical Demands

More than 50% of work time is spent in front of a computer monitor.When required, ability to move, carry, and/or lift objects of varying sizes,weighing up to 25 lbs.

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:

$118,518.94 - $154,074.63

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 or definitive 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.

Salary : $118,519 - $154,075