Data And Reporting Analyst

Requisition# 20370

Employment Type

Full-time

Experience

Health Plan experience required

Three years reporting analysis experience

Required Degree

Bachelors Degree in Computer Science or related field

Location

445 Grant Avenue, San Francisco, CA 94108

Region

Questions

[email protected]

POSITION SUMMARY

As a Data Reporting Analyst, this role will design and develop programs and reports in a Microsoft centric environment. Utilizing MS SQL, Access, and Excel, as well as SSIS and SSRS toolsets, this position will provide accurate end user information based on complex analysis. Must be able to work independently and communicate effectively with the business in a fast-paced environment. College degree required, with previous healthcare experience desired.

ESSENTIAL DUTIES AND RESPONSIBILITIES

Primary Accountability:

• Review, analyze and develop reports on a variety of projects
• Respond timely to ad hoc query requests as needed
• Maintain and acknowledge changes to databases (i.e. data warehouse) and perform updates as necessary to ensure accuracy
• Communicate the results of data analysis in written and verbal form to both I.T. and user departments
• Other duties as assigned by IT Director
• Maintains appropriate records, logs and reporting of support activities
• Support all departments in reaching their goals via analysis and information
• Diagnose and correct errors as identified by the appropriate user/programmer/log.
• In conjunction with I.T. operations, design packages for scheduled recurring jobs
• Work with analysts on appropriate architecture and design of internally developed solutions
• Interact daily with I.T. Director, I.T. staff, and user departments

Systems /Professional Development:

• Provides training and assistance to other IT staff and business users in order to develop/maintain in-house expertise among all staff
• Maintains and develops professional skills through training (both company provided and self- directed), reading pertinent journals, manuals, and documentation, and participating in IT related organizations/user groups

QUALIFICATIONS

• Ability to use SQL and Excel to create pivot tables, graphs and charts
• Proficient with MS SQL, SSIS ETL, SSRS, Crystal Reports, Access and Excel
• Healthplan experience required
• Work with sensitive information with the highest degree of integrity and confidentiality
• Ability to provide MS SQL database administration a plus
• Bachelor’s Degree in Computer Science or related field
• Minimum of 3 years of reporting analysis experience
• Knowledge of data warehouse principals, hierarchies and tools
• Demonstrated ability to manage time and prioritize projects to meet deadlines
• Possess good verbal and written communication skills
• Ability to plan and work effectively

PHYSICAL REQUIREMENTS

• Able to lift up to 30 pounds
• Standing, walking and moving 50% of the day.
• Use proper body mechanics when handling equipment

In our efforts to control the spread of COVID-19 and its variants, CCHP requires that its employees be fully vaccinated as of their start date. If you require a medical or religious accommodation we will engage in the interactive process with you. Proof of vaccination will be required prior to start. If we make you an offer and you are not yet vaccinated, we will accommodate a delay in start date. CCHP may also mandate that its employees receive vaccine boosters, and all accommodation laws will be followed.

Base Pay Scale: Starting at $84,510/year– $110,261 /year
The salary of the finalist selected for this role will be set based on a variety of factors, including but not limited to, internal equity, experience, education, specialty and training. This pay scale is not a promise of a particular wage.