Reporting Data Analyst II PPMSI

  • HCA
  • Foster City, CA, USA
  • Sep 21, 2018
Systems Analyst

Job Description

Job Code: 24614-71004

Full-time

No Weekends

The HCA Physician Services Group (PSG) is the physician and practice management solution for the Hospital Corporation of America (HCA). PSG operates more than 750 practices, Urgent Care Facilities, and partners with HCA's 165 hospitals to structure employed provider programs, professional service agreements, and joint ventures that offer the communities we serve high quality, cost effective care. We manage a collection of highly motivated and innovative leaders who are committed to excellence in every aspect of their career.

Pacific Partners Management Services (PPMSI) is a managed services organization formed in 1997 with administrative offices located in Foster City, CA. We provide services to IPAs in the Santa Clara and Monterey Bay areas. Our managed care and ACO services support approximately 1,000 independent physicians and include executive management, full financial services, utilization management, quality improvement, credentialing, contracting, claims processing and provider and member network services.

PPMSI is part of HCA Physician Services Group (PSG), the physician and practice management solution for the Hospital Corporation of America (HCA). PSG operates more than 750 practices, Urgent Care Facilities, and partners with HCA's 165 hospitals to structure employed provider programs, professional service agreements, and joint ventures that offer the communities we serve high quality, cost effective care. We manage a collection of highly motivated and innovative leaders who are committed to excellence in every aspect of their career.

We offer an excellent benefits package, competitive salary and growth opportunities. Join our team and share your skills and talents with the nation's largest private provider of healthcare services.

The Reporting and Database Analyst II's primary function is to analyze, develop, organize, coordinate, review projects, and produce reports for all departments to facilitate improved operational performance and health plan and regulatory compliance.

DUTIES AND ESSENTIAL JOB FUNCTIONS
  1. Create, schedule, and maintain reports primarily in SQL Server and Microsoft Access.
  2. Monitor jobs run through SQL Server/PPMSI scheduler and correct any anomalies.
  3. Create and manage project plan/documentation(s). Facilitate necessary meetings and prepare necessary status reports to ensure project tasks are being completed in a timely manner.
  4. Create required reference material and technical documentation as needed.
  5. Document processes and maintain report request/helpdesk logs.
  6. Effective collaborator with both IT peers and customers. Participate in team design sessions and code reviews.
  7. Ability to interpret customer requirements, analyze data and identify trends and variance analyses.
  8. Ability to adapt to shifting priorities, and multitasking for client requirements
  9. Maintain constant knowledge of application changes and industry changes to improve processes.
  10. Keep upper management informed of system and operational issues.
  11. Ensure quality of reports.
  12. Coordinate testing of system enhancements/implementations.


REQUIRED
  1. College degree or equivalent work experience.
  2. Computer programming or business major preferred.
  3. Intermediate SQL Server programming and administration skills.
  4. Experience with Visual SourceSafe or other source code control systems.
  5. Strong knowledge of Crystal Reports and MS reporting service.
  6. Strong knowledge of claims and finance processes.
  7. Technical writing experience, preferably documenting system procedures.
  8. Strong system experience and ability to learn new system structures.
  9. In-depth understanding of IPA and MSO medical management business model and processes.
  10. Ability to understand system interfaces and organization operations and work as a team member to identify issues and develop solutions.
  11. Excellent written and verbal communication skills.
  12. Demonstrated analytical skills with ability to review information to resolve user problems.
  13. IBM AS400 experience is a plus.
PREFERRED
  1. Group presentation experience preferred.
  2. Ability to work independently and to prioritize and schedule tasks.
  3. Preferred programming languages: T-SQL, XML, ETL, .Net, #C, or VB
  4. Preferred translation tools knowledge: Visual Studio IDE, SSIS


Last Edited: 08/09/2018