{"schemaVersion":"jobsearcher.job.v1","id":"555c302e0790cb6f13e1bfdf","url":"https://jobsearcher.com/jobs/555c302e0790cb6f13e1bfdf","canonicalUrl":"https://jobsearcher.com/jobs/555c302e0790cb6f13e1bfdf","title":"Application Development Senior Advisor","description":"Quality Apps Support\nApplication Development Sr. Advisor\n\nPosition Overview:\n\nThe job profile for this position is Application Development Sr Advisor. The Application Development Advisor role has the following components:\nResearches and evaluates alternative solutions and recommends the most efficient and cost-effective application programming solution.\nDevelops, documents, and follows standard coding practices.\nComprehensively tests, including negative/regression testing, to prevent re-work.\nProvides comprehensive consultation to business units and IT management and staff at the highest technical level on all phases of data integration processes and data management.\n\nKey Responsibilities:\n\nApplication Development team members within the Quality Apps Support team are responsible for the following:\nDesign, Develop and enhance new and existing backend application components and ETL processes including creation and modifying of stored procedures, SQL Job, SSIS packages, API's.\nWork with data from multiple sources including relational databases like SQL Server, Teradata, and flat files.\nAnalyze and enhance SQL queries to improve performance, ensuring that queries/stored procedures are efficient, scalable, and align with best practices.\nValidate data consistency, accuracy, and completeness within SQL code/Stored procedures and troubleshoot issues related to data integrity across sources.\nStrong debugging skills and able to identify and fix the issues/bugs identified in the Code/Stored Procedures.\nCreation of necessary technical documentation based on implementation details.\nConduct development work required in a comprehensive manner consistent with our best practices and standards\nCoordinate with systems analyst and other developers on technical delivery\nProactively learn ways to improve systems, reducing costs and maximizing opportunities\n\nRequired Experience / Qualifications:\n7+ years of 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.\n5+ years of functional testing and regression/negative testing\n3+ years of Intermediate to advanced SSRS (hands on dev experience with drilldowns, drillthroughs, dynamic groupings, document maps, single dataset for multiple controls etc etc)\n5+ years of intermediate to advance SSIS\nExcellent written and verbal communication skills\nLogical, detail-oriented team player who learns quickly and has the ability to handle multiple, competing priorities in a fast paced environment\n3+ years of Tableau experience\n\nDesired Experience / Qualifications:\nBachelor’s Degree\nTeradata\nMedicare / Medicaid\nMedical and coding terminology\nSNP Model of Care\nHealth Services / Medical Management / Population Health\nTableau\n\nThe Team\n\nQuality Apps Support team is responsible for:\nQuality Datamart maintenance\nAll client SNP Model of Care (MOC) and HRA reporting\nvBids WHP reporting\nCMS Universe and annual Part C reporting\nCMS Face to Face Requirements reporting\n\nNotes:\nRemote\n\nVIVA is an equal opportunity employer. All qualified applicants have an equal opportunity for placement, and all employees have an equal opportunity to develop on the job. This means that VIVA will not discriminate against any employee or qualified applicant on the basis of race, color, religion, sex, sexual orientation, gender identity, national origin, disability or protected veteran status.","company":"Viva","rawCompany":"viva","city":"Remote","state":"OR","isRemote":false,"isActive":false,"createdAt":"2026-08-04T21:31:38.332Z","occupations":[{"code":"15-1252.00","title":"Software Developers","slug":"software-developers"},{"code":"15-1211.00","title":"Computer Systems Analysts","slug":"computer-systems-analysts"},{"code":"15-1243.01","title":"Data Warehousing Specialists","slug":"data-warehousing-specialists"}],"industries":[{"code":"541511","title":"Custom Computer Programming Services","slug":"custom-computer-programming-services"},{"code":"541512","title":"Computer Systems Design Services","slug":"computer-systems-design-services"},{"code":"513210","title":"Software Publishers","slug":"software-publishers"}],"jobPosting":{"@context":"https://schema.org","@type":"JobPosting","title":"Application Development Senior Advisor","description":"Quality Apps Support\nApplication Development Sr. Advisor\n\nPosition Overview:\n\nThe job profile for this position is Application Development Sr Advisor. The Application Development Advisor role has the following components:\nResearches and evaluates alternative solutions and recommends the most efficient and cost-effective application programming solution.\nDevelops, documents, and follows standard coding practices.\nComprehensively tests, including negative/regression testing, to prevent re-work.\nProvides comprehensive consultation to business units and IT management and staff at the highest technical level on all phases of data integration processes and data management.\n\nKey Responsibilities:\n\nApplication Development team members within the Quality Apps Support team are responsible for the following:\nDesign, Develop and enhance new and existing backend application components and ETL processes including creation and modifying of stored procedures, SQL Job, SSIS packages, API's.\nWork with data from multiple sources including relational databases like SQL Server, Teradata, and flat files.\nAnalyze and enhance SQL queries to improve performance, ensuring that queries/stored procedures are efficient, scalable, and align with best practices.\nValidate data consistency, accuracy, and completeness within SQL code/Stored procedures and troubleshoot issues related to data integrity across sources.\nStrong debugging skills and able to identify and fix the issues/bugs identified in the Code/Stored Procedures.\nCreation of necessary technical documentation based on implementation details.\nConduct development work required in a comprehensive manner consistent with our best practices and standards\nCoordinate with systems analyst and other developers on technical delivery\nProactively learn ways to improve systems, reducing costs and maximizing opportunities\n\nRequired Experience / Qualifications:\n7+ years of 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.\n5+ years of functional testing and regression/negative testing\n3+ years of Intermediate to advanced SSRS (hands on dev experience with drilldowns, drillthroughs, dynamic groupings, document maps, single dataset for multiple controls etc etc)\n5+ years of intermediate to advance SSIS\nExcellent written and verbal communication skills\nLogical, detail-oriented team player who learns quickly and has the ability to handle multiple, competing priorities in a fast paced environment\n3+ years of Tableau experience\n\nDesired Experience / Qualifications:\nBachelor’s Degree\nTeradata\nMedicare / Medicaid\nMedical and coding terminology\nSNP Model of Care\nHealth Services / Medical Management / Population Health\nTableau\n\nThe Team\n\nQuality Apps Support team is responsible for:\nQuality Datamart maintenance\nAll client SNP Model of Care (MOC) and HRA reporting\nvBids WHP reporting\nCMS Universe and annual Part C reporting\nCMS Face to Face Requirements reporting\n\nNotes:\nRemote\n\nVIVA is an equal opportunity employer. All qualified applicants have an equal opportunity for placement, and all employees have an equal opportunity to develop on the job. This means that VIVA will not discriminate against any employee or qualified applicant on the basis of race, color, religion, sex, sexual orientation, gender identity, national origin, disability or protected veteran status.","datePosted":"2026-08-04T21:31:38.332Z","dateModified":"2026-08-04T21:31:38.332Z","hiringOrganization":{"@type":"Organization","name":"Viva","sameAs":"https://jobsearcher.com"},"jobLocation":{"@type":"Place","address":{"@type":"PostalAddress","addressLocality":"Remote","addressRegion":"OR","addressCountry":"US"}},"identifier":{"@type":"PropertyValue","name":"JobSearcher","value":"555c302e0790cb6f13e1bfdf"},"url":"https://jobsearcher.com/jobs/555c302e0790cb6f13e1bfdf"}}