Software Engineer III, SSIS And SSRS Developer

Summary

Join Horace Mann as a Software Engineer III, specializing in SSIS and SSRS development. You will design, develop, and maintain ETL processes and reporting solutions using SQL Server technologies. This role requires expertise in SQL, data warehousing, and business intelligence, working with large datasets and optimizing workflows. You will create insightful reports to support business decisions and collaborate with cross-functional teams. The ideal candidate possesses 3-5+ years of experience in SSIS, SSRS, and C# development, along with strong SQL Server proficiency. This position offers a competitive salary and the opportunity to contribute to a company dedicated to serving educators.

Requirements

• 3-5+ years of experience in SSIS, SSRS and C# development
• Strong proficiency in SQL Server, T-SQL, stored procedures, functions, and query optimization
• Experience working with ETL processes, data warehouses
• Familiarity with data modeling, relational database design
• Strong problem-solving skills and ability to work independently
• Excellent communication skills and ability to collaborate with cross-functional teams

Responsibilities

• Design, develop, and maintain ETL (Extract, Transform, Load) processes using SSIS
• Create data extraction, transformation, and loading workflows from various data sources, including databases, APIs, and flat files
• Optimize ETL performance, troubleshoot failures, and implement error-handling mechanisms
• Develop SSIS packages for data migration, integration, and transformation
• Ensure data integrity, accuracy, and consistency across systems
• Develop custom reports, dashboards, and visualizations using SSRS
• Design and optimize SQL queries, stored procedures, and functions to support reporting needs
• Maintain and enhance existing SSRS reports for performance and usability
• Implement automated scheduling and delivery of reports

Preferred Qualifications

• Familiarity with data modeling, star/snowflake schema, and relational database design
• Knowledge of how to create SSIS toolbox controls
• Background in Supplemental, Life, Group Insurance is a plus