Tuesday, July 08, 2008

Kaiser Permanente - Programmer Analyst, Clarity Technical Lead

Job ID DE.0800336
Company Name Kaiser Permanente
Job Category Healthcare
Location Denver, CO
Position Type Part-Time, Employee
Experience 5-10 Years Experience
Date Posted July 8, 2008

Kaiser Permanente
View Kaiser Permanente profile and job listings

INTERNAL POSTING PERIOD: 7/1/08-7/3/08

IF YOU ARE A COLORADO INTERNAL EMPLOYEE, YOU MUST PLACE YOUR BID ON THE BID LINE 303-614-1510, NOT ONLINE.

PREFERRED SKILLS: Experience using other analytic and access tools such as Focus, Easy Reporter, EasyTrieve, and Business Objects helpful.

Experience with Data Warehouses helpful.

Knowledge of DB2/Oracle, and MS Access helpful.

POSITION SUMMARY: Provides expertise in data extraction and data delivery specific to HEDIS, NCQA, Quality improvement and other regulatory requirements. Works with the IQTS (Integrated Quality Tools and Systems) team to produce quarterly and annual reports based on regulatory specifications. Maintain and support a culture of compliance, ethics and integrity. Responsible for ensuring ongoing compliance within PPS/IQTS. Maintains and supports a culture of compliance, ethics and integrity. Maintains knowledge of policies and procedures and performs in accordance with the Principles of Responsibilities and applicable regulatory requirements, external laws and accreditation standards. Appropriately reports observed fraud or abuse.


POSITION REQUIREMENTS: Bachelor’s degree in business, statistics, information technology, or related area. Equivalent experience will be considered. High level of SAS programming skills (5+ years experience). Experience using other analytical and data access tools such as Focus, and EasyTrieve helpful. Experience with Data Warehouses and Business Objects helpful.
Extensive knowledge of IBM mainframe MVS, JCL, and TSO, as well as SQL and PC/SAS. Extensive knowledge of MS Excel and MS Word. Knowledge of DB2/Oracle and MS Access database management systems helpful.
Strong analytical skills and strong skills in report programming/automation. Excellent customer service skills, and strong verbal and written communication skills a must. A self-starter, who is able to work in a team environment, and yet work independently, and work with initiative


ESSENTIAL RESPONSIBILITES: Provides expertise to the PPS/IQTS team in accessing data from interdepartmental systems as required by regulatory agency specifications. Creates and interprets ad hoc, quarterly and annual reports for regulatory requirements including NCQA, HEDIS, CMI, and CMS. Problem solves, consults on and resolves data quality issues.
Creates, tests, and maintains programming code to extract data and create reports based on complex HEDIS-specific requirements, as well as other regulatory requirements.
Develops quality control procedures to ensure the accuracy of data and reports.
Maintains a programming code library for regulatory-specific program code and maintains security. Establishes programming procedures for regulatory requirements such as NCQA and HEDIS.
Provides support and expertise in the consolidation and automation of regulatory data.
Tracks and documents changes to regulatory data and programming coding.
Supervises temporary programmers, contracted for regulatory reporting.


Functional and Environmental Factors available upon request.

SCHEDULE: Variable hours Mon-Fri.

STARTING SALARY RANGE : $2834 - $3615 (Monthly)

--------------------------------------------------------------

Job ID 71265
Company Name Kaiser Permanente
Job Category Technology
Location Aurora, CO
Position Type Full-Time, Employee
Experience 5-10 Years Experience
Date Posted July 8, 2008

Kaiser Permanente
View Kaiser Permanente profile and job listings
KPHC Clarity Technical Lead - CO Region


Kaiser Permanente is seeking a highly-motivated, results oriented candidate with Project Management, reporting and technical skills to support, coordinate, and execute activities in a complex reporting environment. The Regional Technical Clarity Lead acts as the primary Clarity support and primary point of contact for the Region. The lead is the first point of contact for the region on any issues or questions related to Clarity and act as the Clarity Consultant to the Region. This candidate must possess the demonstrated ability to:

Oversee and drive efforts, in addition to providing consultancy and direction to the region on KPHC Business Intelligence (BI) solutions, such as reporting, views, data extracts, etc.
Provide Clarity Production Support to ensure daily ETL meets SLA.
Provide Clarity Environment management support and coordination.
Coordinate installation and testing of Clarity Releases and Upgrades, which includes review of Release notes.
Work with various KPHC teams to research and resolve Clarity data quality issues and mitigate overall regional risk on issues raised by the region, which includes tracking issues, helping to drive root cause analysis, coordinating with regional and national teams and Epic, attending various meetings, championing the regions needs and testing technical changes.
Serve as the liaison between the local (regional) business reporting team and the National IT reporting team.
Analyze/review solutions with a focus toward leveraging the solutions across regions/groups.
Create, track and resolve issues using the Remedy tracking system.
Coordinate Regional Reporting/database training and brown bag sessions.
Participate in regional forums.
Perform Clarity audit checks and validate daily/monthly TDL stats, etc. which includes analyzing data from Teradata access logs to determine use of group IDs and reviewing defined audit steps and validating record counts.
Involve in regional IT Clarity SOX, HIPAA, MPII, etc. regulatory compliance efforts.

Required Education & Skills:

Minimum of 2-5 years of experience in a reporting environment or department.
Minimum of 5-7 years of lead or project management experience.
Relational database experience, ie: Teradata, Oracle, SQL Server, and Sybase.
Ability to use SQL to develop queries and reports and scripting.
Experience in project management and coordination of complex reporting system release activities.
Strong analytical and problem-solving skills. Ability to think outside of the box and meet goals and objectives to provide business value.
Excellent oral and written communication as well as demonstrated ability to work with end users to communicate changes, thoroughness is closing out issues, an understanding of potential impacts and the ability to bring to managements attention, and require minimal supervision.
Ability to participate as a team member and team leader, along with innovative thinking.
Knowledge and experience in EPIC, ie: Epic (OLTP) System Applications, Epic Clarity and/or Healthcare.
Ability to work with multiple distributed teams and leadership.
Ability to document requirements, analysis, design and user guides.

Skills helpful to have:

Knowledge of multiple reporting tools and software ie: SAS, Cognos, Business Objects, Crystal Reports/Enterprise.
Knowledge of Microsoft Office Suite (Word, Excel, Powerpoint, Access, Visio).
Knowledge and experience in hardware and software in multiple computing platforms (IBM AIX, UNIX, MVS).
Knowledge of Healthcare systems for Clinical Care, Practice Management
Experience with developing web content.
Experience working in large corporations.
This position consistently supports compliance and the Principles of Responsibility (Kaiser Permanentes Code of Conduct) by maintaining the privacy and confidentiality of information, protecting the assets of the organization, acting with ethics and integrity, reporting non-compliance, and adhering to applicable federal, state and local laws and regulations, accreditation and licensure requirements (if applicable), and Kaiser Permanentes policies and procedures.
Kaiser Permanente is proud to be an equal opportunity/affirmative action employer.