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 Software Engineer III is responsible for designing reporting and data integration processes using SQL, MS SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), and Power BI. This role will partner with other team members and business stakeholders to deliver reporting and analytical solutions.

Expectations

• Analyze, define, and document system requirements for data, workflow, logical processes, interfaces with other systems, auditing, reporting requirements, and production configuration
• Enforce uniform adherence to established standards and procedures for the department. Review 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 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

• Skills and hands-on experience of the following
• SQL Server Reporting Services (SSRS)
• SQL Server Integration Services (SSIS)
• Power BI
• The ability to work accurately and diligently under pressure, on multiple projects within your project timeframes
• Experience with SQL (Microsoft SQL Server) including CTE’s and temporal tables is a plus
• Experience documenting and following specifications and challenging business logic where appropriate
• Experience with application development using C# or .NET
• Experience creating solutions using tools such as Azure Data Factory, Azure Pipelines, and Azure Logic Apps
• Experience with the Insurance industry is a plus
• Microsoft certifications related to SQL Server and Data are a plus
• Understanding of Accounting is a plus
  

Requisites

• Bachelor’s Degree or equivalent work experience in the data warehouse field
• SQL development in SQL Server 2014 and above – 2 to 3 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
• Power BI – 1 to 2 years
• Developing data integration and ETL solutions – 2 to 3 years
• C# or .NET – 1 to 2 years
• Great understanding of databases and data processing
• General knowledge of SCRUM methodology
• Good understanding of business requirements gathering and documentation
  
  

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.