AI Summary
Review, align, and standardize existing documentation library. Develop, maintain, and optimize SQL Server queries and SSIS packages. Strong hands-on experience with SQL Server and SSIS required.
Key Highlights
Review and standardize documentation library
Develop and maintain SQL Server queries and SSIS packages
Strong hands-on experience with SQL Server and SSIS required
Key Responsibilities
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
Technical Skills Required
Benefits & Perks
Salary Range: $130,000-$150,000+
Comprehensive benefit package; Cigna Medical, Cigna Dental, Vision, 401k w/ ADP, PTO, paid holidays, sick Leave as required by law
Job Description
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
Interested in remote work opportunities in Development & Programming? Discover Development & Programming Remote Jobs featuring exclusive positions from top companies that offer flexible work arrangements.
- 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
Browse our curated collection of remote jobs across all categories and industries, featuring positions from top companies worldwide.
- 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
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
Similar Jobs
Explore other opportunities that match your interests
Visa Sponsorship
Relocation
Remote
Job Type
Full-time
Experience Level
Mid-Senior level
university of washington
United State
Senior Manager of Communications, LATAM & Canada
••••••
••••••
••••••
Job Type
••••••
Experience Level
••••••
Blizzard Entertainment
United State
Visa Sponsorship
Relocation
Remote
Job Type
Contract
Experience Level
Mid-Senior level
IT Resource Hunter
United State