Software Engineer III/SSIS and SSRS Developer

Posted 3 Days Ago
4 Locations
Remote
Mid level
Insurance
The Role
Design, develop, and maintain ETL processes and reporting solutions using SSIS and SSRS, optimizing workflows and generating reports for business insights.
Summary Generated by Built In

Software Engineer III

We are seeking a skilled SSIS and SSRS Developer to design, develop, and maintain ETL processes and reporting solutions. The ideal candidate will have expertise in SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS), with a strong background in SQL development, data warehousing, and business intelligence. The role involves working with large datasets, optimizing ETL workflows, and developing insightful reports to support business decision-making.

Key Responsibilities:

SSIS (SQL Server Integration Services) 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.

SSRS (SQL Server Reporting Services) Responsibilities:

  • 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.

Required Skills & Qualifications:

  • 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.

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.

$84,200.00 - $124,100.00  

Salary is commensurate to experience, location, etc.

#VIZI

#LI-NW1



Horace Mann was founded in 1945 by two Springfield, Illinois, teachers who saw a need for quality, affordable auto insurance for teachers. Since then, we’ve broadened our mission to helping all educators protect what they have today and prepare for a successful tomorrow.  And with our broadened mission has come corporate growth:  We serve more than 4,100 school districts nationwide, we’re publicly traded on the New York Stock Exchange (symbol: HMN) and we have more than $12 billion in assets.

We’re motivated by the fact that educators take care of our children’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. Our tailored offerings include special rates and benefits for educators.

EOE/Minorities/Females/Veterans/Disabled. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability or protected veteran status

For applicants that are California residents, please review our California Consumer Privacy Notice

All applicants should review our Horace Mann Privacy Policy

Top Skills

C#
SQL Server
Ssis
Ssrs
T-Sql
Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
HQ: Springfield, IL
1,189 Employees
On-site Workplace
Year Founded: 1945

What We Do

Horace Mann was founded in 1945 by two educators in Springfield, Ill., who believed teachers deserved affordable auto insurance. Originally called the Illinois Education Association Mutual Insurance Company, our name was changed to honor the father of the American public education system, Horace Mann. We are proud to share his name.

At Horace Mann, the hard work, commitment and dedication of our employees are the foundation of our success. And today we are the largest, national multiline insurance company dedicated to serving America’s educators and their families.

Our purpose is to provide lifelong financial well-being for educators and their families through personalized service, advice, and a full range of tailored insurance and financial products. Through our professional agents and their staff, we offer insurance and financial products to the educational community across the United States.

Similar Jobs

Pluralsight Logo Pluralsight

Intern - Hourly

Cloud • Edtech • Information Technology • Software
Remote
Hybrid
USA
1500 Employees

GitLab Logo GitLab

Senior Backend Engineer, Software Supply Chain Security: Pipeline Security

Cloud • Security • Software • Cybersecurity • Automation
Easy Apply
Remote
United States
2350 Employees
118K-252K Annually

Hometap Logo Hometap

Principal Software Engineer

Fintech • Real Estate • Software • Financial Services • PropTech
Easy Apply
Remote
Hybrid
Boston, MA, USA
235 Employees

eClinical Solutions Logo eClinical Solutions

Remote Senior Software Engineer

Cloud • Healthtech • Professional Services • Software • Pharmaceutical
Easy Apply
Remote
Hybrid
United States

Similar Companies Hiring

Flume Health Thumbnail
Software • Insurance • Healthtech
US
22 Employees
Spark Advisors Thumbnail
Software • Sales • Other • Insurance • Healthtech
New York, NY
89 Employees
MassMutual India Thumbnail
Insurance • Information Technology • Fintech • Financial Services • Big Data
Hyderabad, Telangana

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account