Advisor Programmer Analyst

Job Title: Advisor App Designer SSIS  
Location: Remote 
 
Diversified Systems is searching for an Advisor App Designer SSIS who will be responsible for designing and/or creating, maintaining, deploying, and managing SSIS packages 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. 
 

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) 

1. Ability to build complex queries and reports using Microsoft SQL 

1. Analytical and data analysis skills using Microsoft SQL (required) 

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

1. 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 client 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. 
   

Note: All candidates must have valid work authorization in the United States without need for visa-sponsorship. 

 

About Diversified Systems
Founded in 1990, Diversified Systems is an award-winning Technology Services corporation providing all levels of IT project consulting services nationwide. DSI is headquartered in Columbus, Ohio with regional offices in the American Midwest and East Coast. We offer our consultants a number of flexible and competitive compensation benefit packages.

Diversified Systems is committed to the principles of equal employment. We are committed to complying with all federal, state, and local laws providing equal employment opportunities, and all other employment laws and regulations.

Diversity, Equity and Inclusion
DSI values authenticity and is committed to making sure our employees and partners are valued and respected. At DSI, we believe building a diverse culture is important because we know when people work together, we can achieve better results as a team. DSI realizes that everyone comes from various backgrounds. We celebrate these differences because our employees are our greatest asset as we strive to best meet the needs of those we serve. As part of our ongoing efforts, DSI is focused on advancing equality, diversity, and inclusion by setting high standards to continually evolve our culture. This includes but is not limited to recruiting, community involvement, client delivery, and career development. •

Last updated on Nov 1, 2023