IEHP

Database Specialist II

IEHP  •  Hybrid  •  2 hours ago
Apply
Save Job
Mark Applied Mark Interviewed Mark Offered
Hide Job Report Job
AI can make mistakes so check important info. Chat history is never stored.

Job Description

What you can expect!

Find joy in serving others with IEHP! We welcome you to join us in “healing and inspiring the human spirit” and to pivot from a “job” opportunity to an authentic experience!

The Database Specialist II is responsible for tasks listed under the SQL Database Specialist role with additional duties to include Documentation, workload balancing, communications with users, and supervision of the Access and Database Administration projects and tasks.

Commitment to Quality: The IEHP Team is committed to incorporate IEHP’s Quality Program goals including, but not limited to, HEDIS, CAHPS, and NCQA Accreditation.

Additional Benefits

Perks

IEHP is not only committed to healing and inspiring the human spirit of our Members, but we also aim to match our team members with the same energy by providing prime benefits and more.

  • Competitive salary
  • State of the art fitness center on-site
  • Medical Insurance with Dental and Vision
  • Life, short-term, and long-term disability options
  • Career advancement opportunities and professional development
  • Wellness programs that promote a healthy work-life balance
  • Flexible Spending Account – Health Care/Childcare
  • CalPERS retirement
  • 457(b) option with a contribution match
  • Paid life insurance for employees
  • Pet care insurance

Key Responsibilities

  • Same duties as described in the “Major Responsibilities” of a SQL Database Specialist.
  • Develop and maintain database applications for regular report requests and reference tables.
  • Develop ad-hoc report using programming logic based on business requirements in order to extract healthcare and membership data for financial reporting purposes.
  • Create critical reference table(s) for Finance department analysts to use.
  • Pull and manipulate data requests for ad hoc analysis as required by analysts within the team(s).
  • Mentor/train accountants/analyst on how to use and pull data from the SQL database.
  • Competencies:
  • Oracle database, SQL, PL/SQL Oracle utilities (professional skill level)
  • MS SQL Server, ANSI SQL, SSMS / SSIS and TSQL (professional skill level)
  • Microsoft Excel (intermediate level) and Access (intermediate level)
  • Must be able to create, up-date, and modify existing tables from scratch based on business requirements.
  • Must be able to write queries and stored procedures in SQL Server efficiently in order to meet reporting requirements (i.e.: actuarial studies of healthcare data, reporting to regulatory agencies, and/or internal reporting of healthcare costs). In addition, automate as many standard reports as possible.
  • Must be able to perform QA testing and data validation of output to ensure that the results are fit for business needs. The requirements include developing and writing queries to verify the accuracy of the data output.
  • Must have some healthcare business knowledge so that the Data Specialist can translate business needs into technical programming logic.
  • Ensure the privacy and security of PHI (Protected Health Information) as outlined in IEHP’s policies and procedures relating to HIPAA compliance.

    • Qualifications

    Education & Requirements

    • The following experience may be concurrent, preferably in a health care setting:
    • Five (5) plus years in database development, including analysis and design, using Microsoft Access or similar PC based relational database application
    • Two (2) years in database administration and development, using Microsoft SQL Server or similar relational database application. Two (2) years programming with Structured Query Language (SQL)
    • Must possess experience, knowledge and understanding of database development, lifecycle management, tools, and cross-functional activities
    • Bachelor's degree in Computer Science, Mathematics, Accounting, Public or Business Administration, or Health Care from an accredited institution required
      • In lieu of the required degree, a minimum of four (4) years of additional relevant work experience is required for this position
      • This experience is in addition to the minimum years listed in the Experience Requirements above

    Key Qualifications

    • Techniques of relational database analysis, design, and implementation, including database management techniques, principles and practices of project control, physical and logical security techniques, experience with Microsoft SQL Server, Windows and Novell operating systems, and client/server principles and techniques.
    • Familiarity with Crystal Reports preferred
    • Ability to estimate database development tasks given a set of requirements and assumptions

    Start your journey towards a thriving future with IEHP and apply TODAY!

    Work Model Location

    This position is on a hybrid work schedule. (Mon & Fri - remote, Tues - Thurs onsite in Rancho Cucamonga, CA.)

    Pay Range

    USD $104,041.60 - USD $137,841.60 /Yr.

    IEHP

    About IEHP

    With a mission to heal and inspire the human spirit, Inland Empire Health Plan (IEHP) is one of the top 10 largest Medicaid health plans, the largest not-for-profit Medicare-Medicaid public health plan in the country, and for the fourth year in a row, certified as A Great Place To Work®. Founded in 1996, IEHP supports more than 1.5 million Riverside and San Bernardino County residents enrolled in Medicaid or IEHP DualChoice (those with both Medi-Cal and Medicare). As of 2024, IEHP also offers Covered California plans, further ensuring health care access for even more IE residents. Today, IEHP has a robust network of quality doctors throughout our two counties and nearly 4,000 team members who are fully committed to the vision: We will not rest until our communities enjoy optimal care and vibrant health. To learn more, go to iehp.org.

    Comprehensive Benefits

    Competitive salary and a benefits package with a value estimated at 35% of the annual salary, including medical, dental, vision, team bonus, and retirement plan.

    Mission: To heal and inspire the human spirit.

    Vision: We will not rest until our communities enjoy optimal care and vibrant health.

    Values: We do the right thing by: Placing our Members at the center of our universe; unleashing our creativity and courage to improve health and well-being; bringing focus and accountability to our work; and never wavering in our commitment to our Members, Providers, Partners, and each other.

    Winning Team Culture

    Certified as A Great Place To Work® four years in a row.

    Industry
    Healthcare & Social Services
    Company Size
    1,001-5,000 employees
    Headquarters
    Rancho Cucamonga, CA
    Year Founded
    1995
    Website
    iehp.org
    Social Media