JOB SUMMARY
The Financial Analyst II-Regulatory Reporting leads the review, analysis, and reporting of medical claims, pharmacy, Non-Fee for Service, and Capitation Premium Revenue. Candidate must display proficiency with Microsoft Excel and Microsoft Access as well as general Health Information Management principles and experience with creating and reviewing SQL queries and extracting large amounts of data and turning it into digestible metrics. The Financial Analyst II-Regulatory Reporting duties also include routine and ad hoc reporting and database management support. This role requires an analytical mindset, great attention to detail and the ability to clearly communicate verbally and in writing outcomes from various financial analysis that will be delivered to various levels of management.

JOB SPECIFICATIONS AND CORE COMPETENCIES
Participate in the Month End Close Process for STAR, STAR+PLUS, CHIP, CHIP Perinatal, DSNP, and Marketplace. Research and resolve data discrepancies. Review reports for accuracy.
Participate in completion of deliverables to maintain compliance with the production of all State of Texas deliverables or other governing body in a timely manner.

Create queries to support the needs to the business and review current queries and processes to ensure correctness and best practice creation.
Data Maintenance, Ad-hoc analysis and reconciliation

Respond to data requests from Community's Actuary, Auditors, HHSC Finance, and HHSC Health Plan Management.
Stays informed on latest Federal Legislation and Regulation (e.g. HHSC, CMS, etc.

Assist teammates and completes other duties assigned by the Director of Financial Planning & Analysis, Controller, or CFO.
Actively contributes to achievement of departmental goals, as identified in Department's annual business plan, including specific departmental process, improvement plans, and other duties as assigned.

Reports to Position Title: Manager, State Financial Reporting

QUALIFICATIONS:
Education/Specialized Training/Licensure: Bachelor's degree in finance, Accounting, Economics, Healthcare Administration, Business Administration, Computer Science or related field required.

Work Experience (Years and Area):

3+ years financial analysis required

1+ Healthcare/Managed Care preferred

Management Experience (Years and Area): N/A

Software Proficiencies: Advanced proficiency in Excel, SQL Server Management Studio Relational Databases and basic knowledge of Microsoft Word, Outlook, Power Point.

QNXT preferred.