[Remote] Systems Analyst (T-SQL, SSRS, SSIS) Remote
Note: The job is a remote job and is open to candidates in USA. Conexess Group is aiding a large healthcare client in their search for a Healthcare Systems Analyst. This role involves participating in user requirements discussions, coordinating with business partners and developers, and designing improvements to systems. The position requires strong skills in T-SQL, SSRS, and SSIS, along with experience in data analysis and requirements gathering.
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
Skills
- 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
- Bachelor's Degree
- Medicare / Medicaid
- Medical and coding terminology
- SNP Model of Care
- Health Services / Medical Management / Population Health
- Scrum master experience
Company Overview