Financial Data Analyst

Employer: Southwest Behavioral Health Services Inc.

Position Location: Phoenix, AZ

Position: Financial Data Analyst

Job Duties:

1. Assist in the collection, reporting and analysis of financial data including charts, tables, and other exhibits of SBHS performance against historical forecast, and strategic planning results to facilitate decision making.
2. Analyze and test the data contained in new or existing information systems and utility programs using Microsoft SQL.
3. Provide statistical reporting to management on a consistent basis including clinical/outcome reporting.
4. Design and implement new or revised methods that effectively meet the needs of the company.
5. Assist in the development of financial processes and claims data analysis
6. Create company reports using Power BI, Excel, among others and ensure all reports are well documented and up to date.
7. Assure data integrity throughout data systems and reports as well as notifying supervisors of all upgrades and modifications made to the systems.
8. Troubleshoot application problems using Jira, test software, collaborate with software vendors, and provide application support to all application users.

Job Requirements:         

Education Requirements: Bachelor’s degree in Engineering in Financial Mathematics, Applied Mathematics and Statistics, or closely related. Employer will accept an advance degree if in the same field.

Experience Requirements: 24 months of experience in job offered, Data Analyst, or closely related.

Special skills requirements:

1. Conduct data analysis, identify issues, present results to management to improve business processes and decisions, as well as working with applications to remedy them.
2. Create and maintain process automation related to data maintenance using Python/R.
3. Assist in the development of financial processes and data analysis using Microsoft SQL, Excel, among others.
4. Review pricing models and methodologies using quantitative techniques, such as statistical analysis and scenario-based forecasting.
5. Design and develop multiple reports, interfaces, and consequently independently automate the process using SAS/SQL.
6. Validate high-priority data quality rules using SQL queries in databases such as Netezza, present issues found to risk and technology departments, and successfully correct the rules.
7. Analyze discrepancies between development and production datasets in a Hadoop-based relational database, focusing on population, attributes, and values to develop reconciliation solutions.

Salary: Available upon request

Work Schedule: 40 hours/week

Qualified applicants send cover letter and resumes to: Southwest Behavioral Health Services Inc., Xue Yang, Director of Talent, xuey@sbhservices.org, ref job#JZ01.  EOE.  Standard Benefits. #LI-DNI #FB-DNI #IN-DNI #TW-DNI #GD-DNI