[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.ResponsibilitiesParticipate in end-to-end user requirements discussionsCoordinate with business partners to be able to translate business process/workflows to technical process/workflowCoordinate with developers on technical deliverySuggest design for and test code changesDesign ways to improve systems, reducing costs and maximizing opportunitiesDocumentation of all calls, business requirements and team itemsScrum 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 requirementsCreates comprehensive functional requirementsDevelops complex SSRS reports – new and updatesExecutes functional and regression testing of code changes for ongoing break fixes and enhancementsAssists in User Acceptance Testing of code changes for ongoing breaks fixes and enhancementsReviews all existing processes and data and recommends / documents / implements improvementsSkills3+ 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 required3+ years of functional testing and regression/negative testing3+ 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 mining5+ years of requirements gathering in Agile environments3+ years Tableau experienceExcellent written and verbal communication skillsLogical, detail-oriented team player who learns quickly and has the ability to handle multiple, competing priorities in a fast-paced environmentBachelor's DegreeMedicare / MedicaidMedical and coding terminologySNP Model of CareHealth Services / Medical Management / Population HealthScrum master experienceCompany OverviewConexess Group is an information technology company providing IT staffing and project management services. It was founded in 2009, and is headquartered in Nashville, Tennessee, USA, with a workforce of 201-500 employees. Its website is http://conexess.com.