Hybrid SQL & Database Specialist II - Healthcare Analytics

Inland-Empire-Health-Plan-; Rancho Cucamonga (CA); Hybrid; USD 104,041 - 137,842; Full time

Benefits offered by this job

Competitive salary

On-site fitness center

Medical Insurance with Dental and Vis

Life, short-term, and long-term disabl

Career advancement opportunities and

Wellness programs that promote a heal

Flexible Spending Account – Health C

CalPERS retirement

457(b) option with a contribution mat

Paid life insurance for employees

Pet care insurance

Job summary

IEHP in Rancho Cucamonga, CA is seeking a Database Specialist II to maintain and enhance our SQL database environment. You will develop and support database applications for regular reports, create reference tables for the Finance team, and pull data for ad hoc analyses to support financial reporting.

The role requires 5+ years in database development and 2+ years in SQL Server administration, with strong SQL/PL-SQL skills and a focus on data quality and PHI privacy.

Qualifications

• 5+ years in database development and design using Microsoft Access or similar PC based relational database
• 2+ years in database administration and development using Microsoft SQL Server or similar relational database
• 2+ years programming with SQL
• Bachelor's degree in a related field or 4+ years of additional relevant work experience

Responsibilities

• Develop and maintain database applications for regular report requests and reference tables.
• Develop ad-hoc reports using business requirements to extract healthcare and membership data for financial reporting.
• Create critical reference tables for Finance analysts to use.
• Pull and manipulate data requests for ad hoc analysis as required by analysts.
• Mentor/train accountants/analysts on how to pull data from the SQL database.

Skills

Oracle database

SQL

PL/SQL

Education

Bachelor's degree

Tools

MS SQL Server

SSMS

SSIS

T-SQL

Crystal Reports

Job description

IEHP in Rancho Cucamonga, CA is seeking a Database Specialist II to maintain and enhance our SQL database environment. You will develop and support database applications for regular reports, create reference tables for the Finance team, and pull data for ad hoc analyses to support financial reporting.

The role requires 5+ years in database development and 2+ years in SQL Server administration, with strong SQL/PL-SQL skills and a focus on data quality and PHI privacy.