Software Engineer II

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

Responsible for building and maintaining SQL artifacts such as queries, stored procedures, etc. In addition, they will develop new API functionality on existing and new applications.

Expectations

• Create new web services as well as debug and improve the existing libraries and frameworks that support web services.
• Translate requirements into a programming language, develop system design and programming specifications on assigned projects, and implement design standards using a structured methodology.
• Deliver and maintain web-based secure, robust and service oriented architectures.
• Deliver high-quality systems that meet/exceed customer expectations using the full software development lifecycle, including analysis, design, implementation, maintenance, and planning.
• Conducts detailed design, documentation, and overall code review.

• Analyze, define, and document system requirements for data, workflow, logical processes, interfaces with other systems, auditing, reporting requirements, and production configuration.
• Enforces uniform adherence to established standards and procedures for the department. Reviews documentation submitted by programmers to ensure conformity to standards.
• Ensure that each data flow has robust audit, data validation, error handling, monitoring and reporting steps to ensure accuracy and completeness of loaded data at all times.
• 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.

Competencies

• Skills and hands-on experience of the following:
  • SQL (Microsoft SQL Server) including experience with CTE's and temporal tables
  • SQL Server Reporting Services (SSRS)
  • SQL Server Integration Services (SSIS)
• Experience with APIs, C# and .NET
• Experience with Power BI is a plus
• Experience with cloud platforms such as Azure is a plus
• Experience with the Insurance industry is a plus
• Microsoft certifications related to SQL Server and Data are a plus
• Certification in .NET development or related technologies is a plus

Requisites

• Bachelor's Degree or equivalent work experience in .Net software development
• Experience with database technologies such as SQL Server - 2 to 3 years
• MS SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS) - 1 to 2 years
• Experience in developing APIs using C# and the .NET framework - 1 to 2 years
• Strong understanding of RESTful principles and API design patterns - 1+ years
• Knowledge of data integration and ETL solutions - 1 year
• Great 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 PASSAGE OF A DRUG SCREEN AND BACKGROUND CHECK.