Data Warehouse Programmer Analyst at Partnership HealthPlan of California

Fairfield, California, United States -

Full Time

Start Date

Immediate

Expiry Date

02 Jul, 26

Salary

133977.94

Posted On

03 Apr, 26

Experience

2 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

SQL Server, Business Intelligence, Data Warehousing, SSIS, ETL, Reporting Tools, Business Objects, Access, Oracle, Data Analysis, Systems Analysis, Medical Information Systems, OLAP, ROLAP, MOLAP, Data Presentation

Industry

Insurance

Description

Overview Responsible for the delivery of business intelligence solutions across the enterprise. Manages deployment, maintenance, and support of data access tools and reports. Responsibilities Works with Data Warehouse/Business Intelligence (DW/BI) Architect to tune and modify backend Business Intelligence environment. Participates in enterprise DW/BI strategy. Assists ETL Developer with strategy and SSIS programming. Responsible for the business intelligence reporting software. Assists end users with reporting tools. Schedules and sets up standard reports. Coordinates and/or attends all assigned project related meetings. Trains users on data access tools. Analyzes data issues through SQL Server. Liaison with IT, end users, vendors, and contractors. Performs other duties as assigned. SECONDARY DUTIES AND RESPONSIBILITIES Assists with other coordination of reporting efforts to reduce unnecessary duplication of reporting and promotes consistent use and interpretation of data elements. Assists in the development and maintenance of standards and methodologies for various types of reports to promote consistency in data reporting and analysis. Participates in special projects and assignments as needed. Qualifications Education and Experience Bachelor’s degree in Computer Science, Business, or related field; minimum four (4) years systems analysis experience with experience in medical information systems; or equivalent combination of education and experience. Experience with health care data is preferred. Special Skills, Licenses and Certifications Knowledge of databases (SQL Server, Business Objects, Access, SSIS, normalization, queries, views). Some knowledge of Oracle and Oracle programming methodologies. Knowledge of data warehousing, data marts, OLAP, ROLAP, MOLAP, etc. Ability to move data between systems as needed, effortlessly. High standards for data presentation. Significant knowledge of PCs, Windows 2000, and related applications. Understanding of systems and related system interfaces, and how changes impact various systems. Performance Based Competencies Effective written and oral communication skills and ability to assist others in defining their needs in a collaborative, tactful manner. Demonstrated aptitude for acquiring new technical skills in data reporting. Detail oriented with strong organizational skills. Ability to work on multiple projects and assignments simultaneously and meet deadlines. Work Environment And Physical Demands Standard cubicle within a shared common area. Ability to use a PC with standard software packages. More than 50% of work in 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. Must be able to operate a vehicle for company business. 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: $103,059.95 - $133,977.94 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.

Responsibilities

The Data Warehouse Programmer Analyst is responsible for delivering business intelligence solutions, managing data access tools, and supporting backend BI environments. They collaborate with architects and end users to ensure consistent data reporting, perform SQL analysis, and provide training on data tools.