What are the responsibilities and job description for the Advisor Programmer Analyst position at V R Della Infotech Inc?
Description :
Job Title : Advisor App Designer SSIS Remote
Be part of a team that unleashes the power of leading-edge technologies to help improve the health and well-being of those most vulnerable in our country and communities. Working at Gainwell carries its rewards. You ll have an incredible opportunity to grow your career in a company that values work flexibility, learning, and career development. You ll add to your technical credentials and certifications while enjoying a generous, flexible vacation policy and educational assistance. We also have comprehensive leadership and technical development academies to help build your skills and capabilities.
Under general direction, responsible for designing and / or creating, maintaining, deploying, and managing SSIS and SQL applications for internal business teams and our customers. Candidates will work collaboratively with IT staff, and business stakeholders to create, maintain, and support ETL packages in a compliant, regulated environment. Escalate concerns to project management or Team Lead, assist in determining best practices and provide suggestions on how to improve current practices.
Summary
The Advisor App Designer SSIS at Gainwell, you can contribute your skills as we harness the power of technology to help our clients improve the health and well-being of the members they serve a community s most vulnerable. Connect your passion with purpose, teaming with people who thrive on finding innovative solutions to some of healthcare s biggest challenges.
Your role in our mission
Participate in JAD (Joint Application Design), RAD (Rapid Application Development) and DSD (Design Specifications Document) sessions to define and understand the business requirements and present detailed systems design documentation for reports, data interface files, data conversion and any other method of data exchange.
Develop, test, manage and implement SSIS Packages from development server to production server using package configuration.
Work on maintenance and Administration of SSIS by creating Jobs, Alerts, SQL Mail Agent, and schedule DTS / SSIS Packages.
Design and guide other developers on complicated interfaces and should have strong debugging skills.
Ability to automate the execution of SSIS packages using SQL Server Agent Jobs.
Proactively engage on continuous improvement efforts.
Diagnose and resolve incident tickets and errors.
Develop ETL specifications, data mapping and other documentation required for ETL development.
Use SQL, data models, data element dictionary and schema to perform data and business analysis.
Understand business data and perform quality assurance testing to ensure the data presented is correct.
Ability to establish and maintain positive and effective work relationships with coworkers, clients, members, providers and customers.
Support Unit Testing, System Integration Testing, End-to-End System Testing, and User Acceptance Testing.
What we're looking for (top 5 only)
1. 9 years of experience with SQL Server / MS-SQL scripting and SSIS (required)
2. Ability to build complex queries and reports using Microsoft SQL.
3. Analytical and data analysis skills using Microsoft SQL (required)
4. Previous team leadership with analyzing, mentoring, monitoring preferably healthcare plan data focusing on medical claim and financial processing, member eligibility processing, provider networks and MCO contract details, auditing and reporting in compliance with Federal and State requirements.
5. Excellent verbal and written communication skills
What you should expect in this role
This position is remote.
This position is part of a rotating on-call team.
Recommended Additional Skills / Experience
Experience with QNXT or FACETS Healthcare Payer Platforms preferred
Experience in Healthcare IT working with claims, member and provider data strongly desired.
Ability to abide by Gainwell policies.
Ability to maintain attendance to support required quality and quantity of work.
Maintain confidentiality and comply with Health Insurance Portability and Accountability Act (HIPAA)
Ability to establish and maintain positive and effective work relationships with coworkers, clients, and customers.
Design and guide other developers on complicated interfaces and should have strong debugging skills.
Dress Code
Additional Details
- Dress Code : Business Casual
- Client Interface Required : Yes
- Overtime Required : No
- Min Compliance Pay Rate : NA
- Max Compliance Pay Rate : 1001
