JOB SUMMARY:
Responsible for understanding the business and business requirements in relation to applications / systems, reporting, and processes. Research system / application issues, recommends solutions, and coordinate system / application modifications to correct issue. Works with business units to clarify new requests and interpret needs. Provides functional system /application knowledge. The job includes significant or complex system configuration, process design, data analysis and issue resolution.
Job Responsibility and Core Competencies:
Provides internal ad-hoc reports in a manner that is accurate, timely and consistent. Write queries, views, tables, stored procedures, and schedule jobs in SQL Server
Management Studio based on user specifications. Develop automated reports and schedule subscriptions using SQL Server Reporting Services and Microsoft Power
BI. Create and maintain tabular models using SQL Server Analysis Services to facilitate enterprise reporting.
Utilize statistical models (CDPS, CMS Risk Adjustment, 3M) to identify trends in utilization and performance over time. Utilize geographic information system tools
(e.g. ArcGIS, Quest Analytics) to perform network adequacy and spatial analyses. Review, analyze, and evaluate financial, medical, and member data to determine
trends, issues, or opportunities for improvement. Perform statistical analyses to develop recommendations to business owners that improve workflows, processes,
and compliance. Educate departments on current business processes and their effects on reported measurements.
Actively contributes to achievement of departmental goals, as identified in Department’s annual business plan, including specific departmental process improvement plans.
MINIMUM QUALIFICATIONS:
Education/Specialized Training/Licensure:
- Bachelor’s degree in business, Information Technology, Computer Information Systems, Systems Engineering,
- related fields or four (4) years of related work experience may substitute for the bachelor’s degree.
Work Experience (Years and Area):
- 2 years of experience in information systems.
SPECIAL REQUIREMENTS:
Communication Skills:
Work Schedule: Flexible
Other Requirements: Knowledge:
Knowledge of technical and business analysis.
- Knowledge of Microsoft technologies, troubleshooting application issues and errors with SQL Server experience.
- Knowledge of the healthcare industry in general and specifically of the health insurance environment is preferred.
- Familiarity with a variety of hardware and software environments.
- Knowledge of T-SQL and database designs
- Process mapping.
Skills:
- Perform troubleshooting and recommend appropriate action.
- Apply application analyst techniques.
- Develop and run T-SQL basic queries.
Written and verbal communication
- Microsoft Office suite, with strengths in Excel, Word, and Visio
- Preferred Skills:
- Report Development
- Web Browser Settings
- Microsoft SharePoint
- Microsoft Team Foundation.
RESPONSIBLE TO:
Manager