> Markdown version of [/jobs/ext/1277582-application-development-senior-advisor](https://www.wearedevelopers.com/jobs/ext/1277582-application-development-senior-advisor). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md).

---

# Application Development Senior Advisor

- **Company:** THE VIVA PARTNERSHIP, INC.
- **Location:** United States (Remote available)
- **Experience:** Expert
- **Salary:** $35,360.0 - $45,760.0
- **Contract:** Temporary contract
- **Skills:** Java (Programming Language), Application Programming Interfaces (APIs), Component-Based Software Engineering, Data Integration, Data Integrity, Extract Transform Load (ETL), Data Mart, Relational Databases, Software Debugging, IT Management, Microsoft SQL Server, Query Optimization, Regression Testing, Standard Sql, Software Engineering, SQL Stored Procedures, SQL Databases, SQL Server Reporting Services, SQL Server Integration Services, Tableau (Software), Teradata SQL, Transact-SQL, Backend, Data Management
- **Published:** July 15, 2026
- **Apply:** https://www.indeed.com/viewjob?jk=4ee659394ad8c829

## About the Role

7+ 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.
5+ 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)
5+ years of intermediate to advance SSIS
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
3+ years of Tableau experience

## Description

The job profile for this position is Application Development Sr Advisor. The Application Development Advisor role has the following components:
Researches and evaluates alternative solutions and recommends the most efficient and cost-effective application programming solution.
Develops, documents, and follows standard coding practices.
Comprehensively tests, including negative/regression testing, to prevent re-work.
Provides 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., Application Development team members within the Quality Apps Support team are responsible for the following:
Design, 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.
Work with data from multiple sources including relational databases like SQL Server, Teradata, and flat files.
Analyze and enhance SQL queries to improve performance, ensuring that queries/stored procedures are efficient, scalable, and align with best practices.
Validate data consistency, accuracy, and completeness within SQL code/Stored procedures and troubleshoot issues related to data integrity across sources.
Strong debugging skills and able to identify and fix the issues/bugs identified in the Code/Stored Procedures.
Creation of necessary technical documentation based on implementation details.
Conduct development work required in a comprehensive manner consistent with our best practices and standards
Coordinate with systems analyst and other developers on technical delivery
Proactively learn ways to improve systems, reducing costs and maximizing opportunities, Bachelor's Degree
Teradata
Medicare / Medicaid
Medical and coding terminology
SNP Model of Care
Health Services / Medical Management / Population Health
Tableau

The Team

Quality Apps Support team is responsible for:
Quality Datamart maintenance
All client SNP Model of Care (MOC) and HRA reporting
vBids WHP reporting
CMS Universe and annual Part C reporting
CMS Face to Face Requirements reporting

Notes:
Remote

VIVA 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.


## Related Videos

- [Developing the Backend with Stefan Lingler, CTO at Shpock](https://www.wearedevelopers.com/videos/100360-developing-the-backend-with-stefan-lingler-cto-at-shpock)
- [Enjoying SQL data pipelines with dbt](https://www.wearedevelopers.com/videos/823-enjoying-sql-data-pipelines-with-dbt)
- [Nest.js - TypeScript in the backend can also be clean](https://www.wearedevelopers.com/videos/1033-nest-js-typescript-in-the-backend-can-also-be-clean)
- [You’re a great coder? That alone won’t get you far: The soft skills secret in IT success](https://www.wearedevelopers.com/videos/1076-you-re-a-great-coder-that-alone-won-t-get-you-far-the-soft-skills-secret-in-it-success)
- [Navigating the Corporate Jungle: Life as a Developer in a large Company](https://www.wearedevelopers.com/videos/621-navigating-the-corporate-jungle-life-as-a-developer-in-a-large-company)
- [Meet Your New BFF: Backend to Frontend without the Duct Tape](https://www.wearedevelopers.com/videos/682-meet-your-new-bff-backend-to-frontend-without-the-duct-tape)

## Related Articles

- [What’s the Difference between a Junior, Mid, and Senior Developer?](https://www.wearedevelopers.com/magazine/238-what-s-the-difference-between-a-junior-mid-and-senior-developer)
- [7 Important Tips That Every Software Developer Should Know](https://www.wearedevelopers.com/magazine/101-7-important-tips-that-every-software-developer-should-know)
- [What Are The Top Skills Required For Azure Developers?](https://www.wearedevelopers.com/magazine/77-what-are-the-top-skills-required-for-azure-developers)
- [The 8 Best Code Testing Tools](https://www.wearedevelopers.com/magazine/402-the-8-best-code-testing-tools)
- [The Most Popular IT Jobs on the Market](https://www.wearedevelopers.com/magazine/376-the-most-popular-it-jobs-on-the-market)
- [93 Java Interview Questions You Should Prepare For](https://www.wearedevelopers.com/magazine/14-93-java-interview-questions-you-should-prepare-for)