**Position Overview:** The job profile for this position is Application Development Sr Advisor. The Application Development Sr. 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. **Key Responsibilities:** 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 **Required Experience / Qualifications:** + 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 **Desired Experience / Qualifications:** + Bachelor’s Degree + Teradata + Medicare / Medicaid + Medical and coding terminology + SNP Model of Care + Health Services / Medical Management / Population Health The Team Quality Apps Support team is responsible for: + Quality Datamart maintenance + All Cigna MA SNP Model of Care (MOC) and HRA reporting + vBids WHP reporting + CMS Universe and annual Part C reporting + CMS Face to Face Requirements reporting If you will be working at home occasionally or permanently, the internet connection must be obtained through a cable broadband or fiber optic internet service provider with speeds of at least 10Mbps download/5Mbps upload. **About Cigna Healthcare** Cigna Healthcare, a division of The Cigna Group, is an advocate for better health through every stage of life. We guide our customers through the health care system, empowering them with the information and insight they need to make the best choices for improving their health and vitality. Join us in driving growth and improving lives. _Qualified applicants will be considered without regard to race, color, age, disability, sex, childbirth (including pregnancy) or related medical conditions including but not limited to lactation, sexual orientation, gender identity or expression, veteran or military status, religion, national origin, ancestry, marital or familial status, genetic information, status with regard to public assistance, citizenship status or any other characteristic protected by applicable equal employment opportunity laws._ _If you require reasonable accommodation in completing the online application process, please email:_ _SeeYourself@cigna.com_ _for support. Do not email_ _SeeYourself@cigna.com_ _for an update on your application or to provide your resume as you will not receive a response._ _The Cigna Group has a tobacco-free policy and reserves the right not to hire tobacco/nicotine users in states where that is legally permissible. Candidates in such states who use tobacco/nicotine will not be considered for employment unless they enter a qualifying smoking cessation program prior to the start of their employment. These states include: Alabama, Alaska, Arizona, Arkansas, Delaware, Florida, Georgia, Hawaii, Idaho, Iowa, Kansas, Maryland, Massachusetts, Michigan, Nebraska, Ohio, Pennsylvania, Texas, Utah, Vermont, and Washington State._ _Qualified applicants with criminal histories will be considered for employment in a manner_ _consistent with all federal, state and local ordinances._