Software Engineer III/ SSIS and SSRS Developer

<strong>We&rsquo;re motivated by the fact that educators take care of our children&rsquo;s future, and we believe they deserve someone to look after theirs. We help educators identify their financial goals and develop plans to achieve them. This includes insurance to protect what they have today and financial products to help them prepare for their future.</strong>

Addison, TX; Madison, WI

Horace Mann

<h4>We&rsquo;re motivated by the fact that educators take care of our children&rsquo;s future, and we believe they deserve someone to look after theirs.&nbsp; We help educators identify their financial goals and develop plans to achieve them.&nbsp; This includes insurance to protect what they have today and financial products to help them prepare for their future. Our tailored offerings include special rates and benefits for educators.</h4> https://boards.greenhouse.io/horacemannservicecorporation

keywords: job description,ssis responsibilities,ssrs responsibilities,experience,skills,preferred

Solutions Delivery

$84,200.00 - $124,100.00

Overview: <p><strong>This position will be hybrid out of the Addison, TX or Madison, WI office. It is not a remote position.<br /><br />Software Engineer III<br /><br /></strong>We are seeking a skilled <strong>SSIS and SSES Developer</strong> to design, develop, and maintain ETL processes and reporting solutions. The ideal candidate will have expertise in <strong>SQL Server Integration Services (SSIS)</strong> and <strong>SQL Server Reporting Services (SSRS)</strong>, with a strong background in <strong>SQL development, data warehousing, and business intelligence</strong>. The role involves working with large datasets, optimizing ETL workflows, and developing insightful reports to support business decision-making.</p> <p>&nbsp;</p>
Responsibilities: <p><strong>SSIS (SQL Server Integration Services) Responsibilities:</strong></p> <ul> <li>Design, develop, and maintain&nbsp;<strong>ETL (Extract, Transform, Load) processes</strong>&nbsp;using SSIS.</li> <li>Create&nbsp;<strong>data extraction, transformation, and loading workflows</strong>&nbsp;from various data sources, including databases, APIs, and flat files.</li> <li>Optimize&nbsp;<strong>ETL performance, troubleshoot failures, and implement error-handling mechanisms</strong>.</li> <li>Develop&nbsp;<strong>SSIS packages</strong>&nbsp;for data migration, integration, and transformation.</li> <li>Ensure&nbsp;<strong>data integrity, accuracy, and consistency</strong>&nbsp;across systems.</li> </ul> <br /> <p><strong>SSRS (SQL Server Reporting Services) Responsibilities:</strong></p> <ul> <li>Develop&nbsp;<strong>custom reports, dashboards, and visualizations</strong>&nbsp;using SSRS.</li> <li>Design and optimize&nbsp;<strong>SQL queries, stored procedures, and functions</strong>&nbsp;to support reporting needs.</li> <li>Maintain and enhance&nbsp;<strong>existing SSRS reports</strong>&nbsp;for performance and usability.</li> <li>Implement&nbsp;<strong>automated scheduling and delivery of reports</strong>.</li> </ul>
Requirements: <ul> <li><strong>3-5+ years</strong>&nbsp;of experience in SSIS, SSRS, and C# development.</li> <li>Strong proficiency in&nbsp;<strong>SQL Server, T-SQL, stored procedures, functions, and query optimization.</strong></li> <li>Experience working with&nbsp;<strong>ETL processes,</strong>&nbsp;<strong>data warehouses.</strong></li> <li>Familiarity with&nbsp;<strong>data modeling, relational database design.</strong></li> <li>Strong problem-solving skills and ability to work independently.</li> <li>Excellent communication skills and ability to collaborate with cross-functional teams.</li> </ul> <br /> <p><strong>Preferred Qualifications:</strong></p> <ul> <li>Familiarity with data modeling, star/snowflake schema, and relational database design.</li> <li>Knowledge of how to create SSIS toolbox controls.</li> <li>Background in Supplemental, Life, Group Insurance is a plus.</li> </ul> <br /> <p>$84,200.00 - $124,100.00&nbsp;&nbsp;</p> <p>Salary is commensurate to experience, location, etc.</p> <p>&nbsp;</p>