Professional Programmer Analyst SSIS
Location: 100% Remote Diversified Systems is searching for a Programmer Analyst SSIS who, under general direction, 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.
Contractors 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.
- Ability to automate the execution of SSIS packages using SQL Server Agent Jobs.
- Formulate and document ETL process design based on business requirements and system specification including source to target mapping and transformations.
- Proactively engage in 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.
Required Skills & Experience: - 4+ years of experience using Microsoft SQL Server BI Suite and SSIS/SSRS
- Analytical skills in a SQL environment
- Ability to build complex queries and reports using Microsoft SQL.
- Analytical and data analysis skills using Microsoft SQL (required)
- Excellent verbal and written communication skills
Recommended Additional Skills/Experience: - 4+ years of experience with MS-SQL scripting (required)
- 4+ years SQL Server version 2014 or higher (required)
- Experience in a Healthcare IT working with claims, member and provider data strongly desired.
- Experience with QNXT or FACETS Healthcare Payer Platforms preferred.
- Previous team leadership with analyzing, mentoring, monitoring 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.
- Knowledge of Payment Reform methodologies under the Affordable Care Act and related initiatives in the Medicaid space.
- Healthcare knowledge within a claims processing environment preferably in Medicaid.
- Ability to abide by clientpolicies.
- 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.
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