Job Description
Please note that this position is onsite
Pay rate range: $38.00/hr - $47.00/hr
Requirements and skills
- Bachelor's Degree in Math, Computer Science, Information Systems, Business Administration, Health Administration or other related fields.
- Has 5 to 7 years of Analytics work experience.
- Demonstrated aptitude and experience in excel, SQL, Tableau, and SAS to perform analysis and present results.
- Familiarity with building and maintaining management reporting systems
- Advanced professional level role. Advanced Microsoft Excel, SQL programming to query data and Tableau visualization skills are required.
- Proficiency with MS office tools, strong analytical and problem-solving skills, ability to set and meet deadlines, good reporting and data visualization skills, excellent attention to details and ability to work in high pressure situations.
- Works on multiple projects as a project team member, occasionally as a project leader.
- Demonstrated intellectual curiosity in identifying new problems/issues/concerns and then using analytical modeling techniques to develop relevant information.
- Healthcare industry/insurance/finance/economics/statistics industry.
- Developing projection/forecasting models.
- Other programming languages, like SAS, R, Python,
- The candidate is primarily responsible for analyzing data and producing various reports using SQL, Excel and Tableau.
- The candidate will be working with the Agency's leadership team to understand the goals and will create various visualizations and presentations that transform data into the basis for the agency's financial decisions.
- Producing annual report exhibits and visualizations, statistical reports, projections and forecast analysis by using multiple databases.
- Researching quality measure specifications, validating denominators, numerators and final rates which are generated and submitted to the regulatory agency.
- Preparing and analyzing cost report information (nursing homes, hospitals and other providers) into comparative reports to assess profitability and solvency.
- Developing agency short and long-term forecasting models, accounting for significant variables which influence outcomes.
- Facilitate data integration from financial systems, claim systems, eligibility systems and third-party sources into adhoc and standardized reports for the agency.
- Providing accurate reports in a timely manner for all the share-point requests.