Sr. Financial Database Specialist

Date: Sep 14, 2021

Location: Rancho Cucamonga, CA, US

Company: Inland Empire Health Plans

Job Requisition ID: 5861 

 

Position Summary/Position

 

The Senior Financial Database Specialist must be able to work independently to produce financial and database documentation, communicate effectively (in both oral and written form) with end business users, create ad-hoc reports and database tables, create dash boards for tracking purposes, and automate complex financial and/or data reports. This position requires working knowledge of finance/accounting concepts. 

Major Functions (Duties and Responsibilities)

 

1. Develop and maintain financial database tables for regular report requests and reference data.
2. Develop ad-hoc report using programming logic based on business requirements in order to extract healthcare and membership data for financial reporting purposes.
3. Create critical reference table(s) for Finance department analysts to use.
4. Lead data projects from development phase to final report output.
5. Pull and manipulate data requests for ad hoc analysis as required by analysts within the team(s).
6. Mentor/train accountants/analyst on how to use and pull data from the SQL database.
7. Competencies:
  a. Oracle database, SQL, PL/SQL Oracle utilities (professional skill level)
  b. MS SQL Server, ANSI SQL, SSMS / SSIS and TSQL (professional skill level)
  c. Microsoft Excel (intermediate level) and Access (intermediate level)
8. Must be able to create, up-date, and modify existing tables from scratch based on business requirements.
9. Must be able to write queries and stored procedures in SQL Server efficiently in order to meet reporting requirements (ie: actuarial studies of healthcare data, reporting to regulatory agencies, and/or internal reporting of healthcare costs). In addition, automate as many standard financial reports as possible.
10. 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.
11. Must have strong healthcare business knowledge in order to translate business needs into technical programming logic.

Supervisory Responsibilities

Leading: Self

Experience Qualifications

 

The following experience may be concurrent:

Over four (4) years of experience in database development, including analysis and design, using Microsoft Access or similar PC based relational database application. 

A minimum of two (2) years in database administration and development, using Microsoft SQL Server or similar relational database application.

Over three (3) years of programming experience with Structured Query Language. Experience with Microsoft SQL Server.

Preferred Experience

 

Experience Qualificiations preferably in a health care setting.

Education Qualifications

 

Bachelor's Degree in Computer Science, Mathematics, Accounting, Public or Business Administration, or Healthcare from an accredited institution required.

 

Significant experience may be considered in lieu of degree: In lieu of a degree, a minimum of 12 years of relevant work experience is required.

Preferred Education

Professional Certification

Professional Licenses

Drivers License Required

No

Knowledge Requirement

 

Techniques of relational database analysis, design, and implementation, including database management techniques, principles and practices of project control, physical and logical security techniques.  

Ability to estimate database development tasks given a set of requirements and assumptions.

Must possess experience, knowledge and understanding of database development, lifecycle management, tools, and cross-functional activities.

Skills Requirement

Abilities Requirement

Commitment to Team Culture

 

The IEHP Team environment requires a Team Member to participate in the IEHP Team Culture. A Team Member demonstrates support of the Culture by developing professional and effective working relationships that include elements of respect and cooperation with Team Members, Members and associates outside of our organization.

Working Conditions

 

Intensive data entry involving computer keyboard and screens.

Physical Requirements

 

Starting Salary: $85,841.60  - $109,449.60  

Pay rate will commensurate with experience

 

Inland Empire Health Plan (IEHP) is the largest not-for-profit Medi-Cal and Medicare health plan in the Inland Empire. We are also one of the largest employers in the region. With a provider network of more than 6,000 and a team of more than 2,000 employees, IEHP provides quality, accessible healthcare services to more than 1.2 million members. And our mission and core values help guide us in the development of innovative programs and the creation of an award winning workplace. As the healthcare landscape is transformed, we’re ready to make a difference today and in the years to come. Join our Team and Make a Difference with us! IEHP offers a Competitive salary and a benefit package with a value estimated at 35% of the annual salary, including medical, dental, vision, team bonus, and retirement plan.

 


Nearest Major Market: Riverside
Nearest Secondary Market: Los Angeles