Systems Analyst (T-SQL, SSRS, SSIS) Remote

Conexess Group is aiding a large healthcare client in their search for a Healthcare Systems Analyst. This is a long-term opportunity with a competitive compensation package.

Please note we are unable to provide sponsorship or work c2c for this role.

Responsibilities:

• 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 21)
• 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

Requirements:

• 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)
• 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
• 3+ years Tableau experience ​
• Excellent written and verbal communication skills
• Logical, detail-oriented team player who learns quickly and has the ability to handle multiple, competing priorities in a fast-paced environment

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