Systems Analysis Senior Advisor

Systems Analysis Senior Advisor

Remote, Illinois

Job Reference ID: - 49289

Category: - Engineering - IT

Job Type: - Contract

Location: - Remote, Illinois

Pay Rate: - $61.82

Position Overview:

The job profile for this position is Systems Analysis Sr. Advisor. The System Analysis Sr. Advisor role has the following major components:

• Works with business partners to develop complete and accurate business requirements
• Creates comprehensive functional requirements
• Develops complex SSRS reports – new and updates
• Executes functional and regression testing of code changes for ongoing break fixes and enhancements
• Assists in User Acceptance Testing of code changes for ongoing breaks fixes and enhancements
• Reviews all existing processes and data and recommends / documents / implements improvements

Key Responsibilities:

System Analysis team members within the Quality Apps Support team are responsible for the following:

• Participate in end-to-end user requirements discussions
• Coordinate with business partners to be able to translate business process/workflows to technical process/workflow
• Coordinate with developers on technical delivery
• Suggest design for and test code changes
• Design ways to improve systems, reducing costs and maximizing opportunities
• Documentation of all calls, business requirements and team items
• Scrum Master – assist with leading scrum, entering items into Jira and assisting with management of projects (this year we had 23)

Required Experience / Qualifications:

• 3+ years of intermediate to advanced T-SQL (complex JOINs, subqueries, stored procedures, indexes, temp tables and CTEs, query optimization is a MUST). MS SQL is a must. TD SQL is desired but not required.
• 3+ years of functional testing and regression/negative testing
• 3+ years of Intermediate to advanced SSRS (hands on dev experience with drilldowns, drillthroughs, dynamic groupings, document maps, single dataset for multiple controls etc etc)
• 3+ years of intermediate SSIS (must be able to review / debug / suggest design for SSIS packages, must understand SSIS metadata rules, various SSIS properties, etc)
• 5+ years of data analysis and mining
• 5+ years of requirements gathering in Agile environments
• Excellent written and verbal communication skills
• Logical, detail-oriented team player who learns quickly and can handle multiple, competing priorities in a fast-paced environment
• 3+ years of Tableau experience - Must have

Desired Experience / Qualifications:

• Bachelor's Degree
• Medicare / Medicaid
• Medical and coding terminology
• SNP Model of Care
• Health Services / Medical Management / Population Health
• Scrum master experience
• Tableau

The Team

The Quality Apps Support team is responsible for:

• Quality Datamart maintenance
• All Cigna MA SNP Model of Care (MOC) and HRA reporting
• vBids WHP reporting
• CMS Universe and annual Part C reporting
• CMS Face to Face Requirements reporting