
Forrest T Jones
Software Engineer III
Kansas City, Missouri, United States
Position Summary
The Software Engineer III is responsible for designing reporting and data integration processes using SQL, MS SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS). 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
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
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 (Microsoft SQL Server) including experience with CTE’s and temporal tables
SQL Server Reporting Services (SSRS)
SQL Server Integration Services (SSIS)
The ability to work accurately and diligently under pressure, on multiple projects within your project timeframes
Experience documenting and following specifications and challenging business logic where appropriate
Experience with application development using C# or .NET
Experience with Power BI is a plus
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 report/software development
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
Developing data integration and ETL solutions – 2 to 3 years
C# or .NET – 1 year
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.