Software Engineer III/SSIS and SSRS Developer

A Software Engineer III/SSIS and SSRS Developer at Horace Mann is responsible for designing, developing, and maintaining ETL processes and reporting solutions. This includes creating data extraction, transformation, and loading workflows using SSIS, as well as developing custom reports and dashboards with SSRS. The role also involves optimizing ETL workflows for performance and ensuring data integrity.

To qualify for the Software Engineer III/SSIS and SSRS Developer position at Horace Mann, candidates should have 3-5+ years of experience with SSIS, SSRS, and C# development. Strong proficiency in SQL Server, T-SQL, and experience with ETL processes and data warehousing is essential. Additionally, strong problem-solving skills and effective communication abilities are important for collaborating with cross-functional teams.

The Software Engineer III/SSIS and SSRS Developer at Horace Mann will work on a variety of projects involving the extraction, transformation, and loading of large datasets from various sources. This includes optimizing ETL processes and developing insightful reports that support business decision-making, all while playing a crucial role in maintaining and enhancing reporting systems.

Yes, the Software Engineer III/SSIS and SSRS Developer position at Horace Mann offers the flexibility to work remotely. This allows you to contribute to our mission of supporting educators from the comfort of your own home, as well as from our offices in Springfield, Madison, or Addison.

The Software Engineer III/SSIS and SSRS Developer position at Horace Mann offers a competitive salary range of $84,200.00 to $124,100.00. Salary is commensurate with experience, location, and other factors, ensuring that your contributions are fairly recognized.

In answering this question, provide specific examples of projects where you designed and developed ETL processes using SSIS. Highlight your roles, the challenges you faced, and how you overcame them to optimize performance and ensure data accuracy.

To answer this, outline your systematic approach to troubleshooting, which could include checking error logs, analyzing data sources, and verifying connections. Mention any tools you use to track and resolve these issues efficiently.

Explain your strategies for maintaining data integrity, such as implementing validation checks, using transaction logs, or performing regular audits to ensure data remains accurate and consistent across systems.

When responding, detail the steps you take from determining reporting requirements to designing the layout in SSRS. Discuss how you ensure reports are both user-friendly and meet the specified business needs.

Here, you can discuss methods you've employed for performance tuning, such as indexing strategies, query optimizations, and the use of execution plans. Provide specific examples illustrating your success in improving query performance.

Discuss your familiarity with various data sources such as APIs, flat files, and databases. Include an explanation of how you extract, transform, and load data from these sources using SSIS and any challenges you have faced.

Share the debugging tools you find most effective when working with SSIS packages, such as logging features and visual studio for debugging. Explain how these tools aid you in ensuring package reliability and functionality.

Provide a specific example of a challenging project, what made it difficult, and how you successfully completed it. Focus on your role, the skills you applied, and the positive impact it had on the business or project outcomes.

Explain your approach to time management and prioritization, potentially mentioning methodologies you follow, such as Agile. Emphasize your ability to adjust priorities based on project needs or urgency.

Highlight how you've utilized C# in SSIS projects, such as creating custom scripts for additional transformations or tasks. Provide examples to showcase your coding skills and how they benefited your ETL processes.