Financial Software Engineer III

Posted Yesterday
Be an Early Applicant
Kansas City, MO, USA
In-Office
Mid level
Insurance • Financial Services
The Role
Designs, develops, tests, and maintains database, reporting, and data integration solutions supporting financial and accounting operations. Responsibilities include SQL Server development, SSIS and SSRS implementation, data quality controls, auditability, performance tuning, testing, troubleshooting, and documentation. The role collaborates with Finance, Accounting, Administration, IT, and project teams to deliver accurate, scalable, and secure financial data solutions.
Summary Generated by Built In

Forrest T. Jones & Company, Inc., and its affiliates (“FTJ”), provide insurance and insurance related services to clients, corporations, employers and individuals. These services include providing benefits through innovative life and health insurance plans, financial services, and customized insurance products for niche markets. 

Position Summary

The Financial Software Engineer III is responsible for designing, developing, maintaining, and optimizing databases and reporting solutions that support financial and accounting operations. This role partners closely with Finance, Accounting, Admin, and IT teams to develop reliable data integrations, financial reporting, reconciliations, and data quality initiatives that ensure the accuracy, integrity, and availability of critical business data.

The ideal candidate combines strong technical expertise with a solid understanding of financial systems, data governance, and software development best practices. This position plays a key role in supporting business decision-making through scalable, auditable, and high-performance data solutions.

Expectations

  • Analyze, define, and document system requirements for data, workflow, logical processes, interfaces with other systems, auditing, reporting requirements, and production configuration
  • Design, develop, test, implement, and maintain database and reporting solutions that support financial and operational objectives
  • Develop and support data integration processes between internal and external systems, ensuring data accuracy, consistency, and completeness
  • Adhere to established coding standards and procedures, including participation in the peer review process 
  • Ensure that each data flow has robust audit, data validation, error handling, monitoring, and reporting steps to always ensure accuracy and completeness of loaded data
  • Provide accurate effort estimates to the Team Lead and/or Project Manager and project teams as appropriate
  • Deliver testing support including the design and execution and documentation of test scripts
  • Strong analytical and problem-solving skills
  • Strong communication, presentation, and relationship management skills
  • Experience working in a team-oriented, collaborative environment
  • Ability to work with diverse teams
  • Ability to maintain confidentiality
  • Performs other related duties as assigned and required

Competencies

  • Strong understanding of accounting and financial data, concepts, and principles
  • Advanced analytical, troubleshooting, and problem-solving skills
  • Excellent verbal and written communication skills with the ability to communicate technical concepts to both technical and non-technical audiences
  • Strong organizational and time-management skills with the ability to manage multiple priorities and deadlines
  • Ability to build effective working relationships across business and technical teams
  • Demonstrated commitment to quality, accuracy, and continuous improvement
  • Ability to work independently while contributing effectively within a collaborative team environment

Technical Qualifications

  • Advanced proficiency in Microsoft SQL Server development and database design
  • Experience developing complex T-SQL queries, stored procedures, views, functions, and performance optimization techniques
  • Hands-on experience with: SQL Server Integration Services (SSIS)
  • SQL Server Reporting Services (SSRS)
  • Data warehouse and ETL development concepts
  • Database performance tuning and troubleshooting
  • Source control and change management processes
  • The ability to work accurately and diligently under pressure, on multiple projects within your project timeframes
  • Experience with CTE’s and temporal tables is a plus
  • Experience with Power BI is a plus
  • Experience documenting and following specifications with complex business logic 
  • Experience with the Insurance industry is a plus
  • Experience with IAS (Insurance Accounting Software) is a plus
  • Experience with ADF is a plus

Requisites

  • Bachelor’s Degree in Computer Science, similar degree, or equivalent work experience
  • Financial and accounting reporting and data – 3 to 5 years
  • SQL development in SQL Server 2014 and above – 3 to 5 years
  • SSRS reports in SQL Server 2014 and above – 2 to 3 years
  • SSIS development in SQL Server 2014 and above – 2 to 3 years
  • Solid understanding of databases and data processing


We offer comprehensive benefits to full-time employees including company-paid medical, STD, LTD and life insurance plus voluntary dental, vision, life/AD&D insurance, 401(k) with company matching, generous paid time off and much more. 

We encourage applicants of all ages and experience, as we do not discriminate on the basis of an applicant’s age. 

ALL OFFERS OF EMPLOYMENT ARE CONTINGENT UPON THE PASSING OF A DRUG SCREEN AND BACKGROUND CHECK.

Skills Required

  • Bachelor's degree in Computer Science, a similar degree, or equivalent work experience
  • Three to five years of financial and accounting reporting and data experience
  • Three to five years of SQL development using SQL Server 2014 or later
  • Two to three years of SSRS report development using SQL Server 2014 or later
  • Two to three years of SSIS development using SQL Server 2014 or later
  • Solid understanding of databases and data processing
  • Advanced proficiency in Microsoft SQL Server development and database design
  • Experience developing complex T-SQL queries, stored procedures, views, functions, and performance optimization techniques
  • Experience with data warehouse and ETL development concepts
  • Experience with database performance tuning and troubleshooting
  • Experience with source control and change management processes
  • Experience with CTEs and temporal tables
  • Experience with Power BI
  • Experience with insurance industry systems
  • Experience with IAS Insurance Accounting Software
  • Experience with Azure Data Factory
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: Kansas City, MO
240 Employees
Year Founded: 1953

What We Do

Forrest T. Jones & Company (FTJ) is an insurance agency and administrator that was established in 1953 to provide insurance products and other financial services to members of associations and other affinity groups. FTJ currently provides insurance programs to more than 80 national associations and employer groups with more than 1.5 million members. We work with more than 30 of the nation’s leading insurance companies to provide members / employees with access to high quality insurance plans—many with special features and benefits not readily available elsewhere—at favorable group rates. As the flagship of an enterprise that includes two life insurance companies, a reinsurance company, and a FINRA broker/dealer, FTJ offers an exceptional level of strength and flexibility for our association and affinity group clients. Throughout the years, FTJ has worked hand-in-hand with its clients in adding value to member and customer programs through quality insurance products. FTJ has been family owned and managed since its inception, and we pride ourselves on maintaining close, personal relationships with our clients. We strive to meet their needs in a dynamic environment by applying the latest technology, marketing expertise, and our relationships in the insurance industry to attain the best possible insurance plans for their members and support those plans with old-fashioned, high-touch personal service. The company is headquartered in Kansas City, Missouri.

Similar Jobs

Liberty Mutual Insurance Logo Liberty Mutual Insurance

Inside Sales Representative

Artificial Intelligence • Fintech • Insurance • Marketing Tech • Software • Analytics
Remote or Hybrid
12 Locations
40000 Employees
45K-85K Annually
Remote or Hybrid
US
15100 Employees

Wipfli Logo Wipfli

Manager, Accounting Advisory Services - Nonprofit Industry Clients

Cloud • Fintech • Software • Business Intelligence • Consulting • Financial Services
Remote or Hybrid
Clayton, MO, USA
2900 Employees

Wipfli Logo Wipfli

Manager, Financial Reporting - Nonprofit Clients

Cloud • Fintech • Software • Business Intelligence • Consulting • Financial Services
Remote or Hybrid
United States
2900 Employees
97K-145K Annually

Similar Companies Hiring

Hanover Park Thumbnail
Artificial Intelligence • Fintech • Software • Financial Services
New York, New York
42 Employees
Onshore Thumbnail
Artificial Intelligence • Fintech • Software • Financial Services
New York, New York
85 Employees
Vega Thumbnail
Artificial Intelligence • Automotive • Insurance • Transportation
US
65 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account