SQL SSIS Developer

April 26

KCare

WebsiteLinkedInAll Job Openings

KCare offers intuitive case management and behavioral health EHR solutions for modern social service agencies

foster care • software • child welfare • family services • residential treatment centers

51 - 200

Description

• Architect, develop, and provide production support for complex SSIS packages • Support the continued evolution of the data warehouse by creating tables, indexes, views, functions, triggers, stored procedures, and tuning complex SQL queries • Provides production support as required to ensure the availability and performance of enterprise data and BI environments for both external and internal users • Conducts code reviews of ETL and SQL processes

Requirements

• 5+ years of Microsoft SQL Server database development (TSQL) experience • 5+ years of experience with SQL Server/T-SQL programming in creation and optimization of stored procedures, triggers, and user-defined functions • 5+ years of experience developing and architecting complex SSIS packages • Experience and knowledge of the pitfalls of data integration using Excel files as the primary data source • Experience with the KingswaySoft Dynamics 365 Integration toolset preferred • Dynamics 365 and Power Platform experience a significant plus • Experience in lift-and-shift SSIS to Azure Data Factory a plus • Human Services background a plus

Benefits

• 4-day work week • 401k matching • Medical, dental, and vision healthcare coverage • Competitive PTO • 15 paid holidays • Volunteer Time Off • 12 weeks of paid parental leave