Business Analyst

Position

Description:

Business Analyst/Data Analyst - The candidate is primarily responsible for analyzing data and producing various reports using SQL, MS office 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. The candidate is responsible for:

A) Producing annual report exhibits and visualizations, statistical reports, projections and forecast analysis by using multiple databases.

B) Researching quality measure specifications, validating denominators, numerators and final rates which are generated and submitted to the regulatory agency.

C) Preparing and analyzing cost report information (nursing homes, hospitals and other providers) into comparative reports to assess profitability and solvency.

D) Developing agency short and long-term forecasting models, accounting for significant variables which influence outcomes.

E) Facilitate data integration from financial systems, claim systems, eligibility systems and third-party sources into adhoc and standardized reports for the agency.

F) Providing accurate reports in a timely manner for all the share-point requests.

Skills Required: Advanced professional level role. Advanced Microsoft Excel, SQL querying and Tableau visualization skills 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.

Skills Preferred: Data visualization and preferably Tableau visualization

Experience

Required:

Has 5 to 7 years of Analytics work experience in healthcare industry/insurance/finance/economics/statistics industry. Demonstrated aptitude and experience in using computer tools (excel, SQL, Tableau, SAS) to develop analytic models and perform analysis. Familiarity with building and maintaining management reporting systems.

Experience Preferred:

Education Required: Bachelor's Degree in Computer Science, Information Systems, Business Administration, Health administration or other related field.

Education Preferred:

Additional Information: This is 100% onsite position; no remote work is allowed. Strongly prefer an in-person one step interview
- Analytics homework assignment will be sent out before the interview and the candidates are expected to present the analysis during the interview time.