SQL & SSIS Documentation Specialist

Piper Companies is currently looking for an SQL & SSIS Documentation Specialist to work remotely for a well established non-profit organization, responsible for reviewing, aligning, and standardizing an existing documentation library that was developed by multiple teams and individuals using varying approaches. This role is slated for 6 months originally but has potential to extend or convert.

Responsibilities for the SQL & SSIS Documentation Specialist:

• Design, develop, maintain, and optimize SQL Server queries, stored procedures, views, and functions
• Develop, troubleshoot, and enhance SSIS packages to support ETL processes and data workflows
• Identify inconsistencies, gaps, redundancies, and misalignments in documentation structure, terminology, and standards
• Retroactively update, consolidate, and normalize documentation to ensure consistency and usability

Qualifications for the SQL & SSIS Documentation Specialist:

• Bachelor's degree and 6+ years experience in the field preferred
• Strong hands-on experience with SQL Server (advanced querying, performance optimization)
• Proven experience developing and maintaining SSIS packages
• Experience with document control
• Experience in Healthcare IT, including familiarity with healthcare data, systems, or workflows

Compensation for the SQL & SSIS Documentation Specialist:

• Salary Range: $130,000-$150,000+ (depending on experience)
• Comprehensive benefit package; Cigna Medical, Cigna Dental, Vision, 401k w/ ADP, PTO, paid holidays, sick Leave as required by law

This job opens for applications on 4/7/26. Applications for this job will be accepted for at least 30 days from the posting date

#LI-BM2

#LI-REMOTE

SQL Server, T-SQL, Advanced SQL Querying, Query Optimization, Performance Tuning, Indexing Strategies, Stored Procedures, Views, Functions, Common Table Expressions (CTEs), Temporary Tables, Data Modeling, Relational Databases, ETL Development, SSIS, SQL Server Integration Services, SSIS Package Development, Data Pipelines, Data Integration, Data Transformation, Data Validation, Data Quality, Error Handling, Logging, Job Scheduling, SQL Agent, Deployment Management, Version Control, Source Control, Git, Change Management, Legacy Systems, Technical Debt, System Remediation, Documentation Standardization, Technical Documentation, Data Dictionaries, Metadata Management, Naming Conventions, Documentation Templates, Knowledge Base Management, Process Standardization, Governance Frameworks, Data Architecture, Enterprise Data Systems, Cross-Functional Collaboration, Stakeholder Interviews, Requirements Gathering, Systems Analysis, Root Cause Analysis, Process Improvement, Continuous Improvement, Healthcare IT, Healthcare Data Systems, Clinical Data, Administrative Data, HIPAA Awareness, Regulated Environments, Data Governance, Compliance Standards, Audit Readiness, Remote Collaboration, Distributed Teams, Asynchronous Communication, Problem Solving, Analytical Thinking, Attention to Detail, Communication Skills, Technical Writing, Knowledge Transfer, Onboarding Support, Integration Strategy, Platform Cohesion, System Interoperability, Data Lineage, Impact Analysis, Risk Mitigation, Bachelor’s Degree in Related Field, Information Systems, Computer Science, Health Informatics, Business Intelligence, Reporting Systems, Data Warehousing, Operational Databases, Agile Collaboration, Independent Work, Time Management