Software Engineer IV

Advantage Tech is looking for a Software Engineer for our Kansas City, MO Client. Position Summary The Software Engineer is responsible for working with complex data, stored procedures, reports, and integration processes using MS SQL Server, MS SQL Server Integration Services (SSIS) SQL Server Reporting Services (SSRS), and Azure services. This role will work closely 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 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 • Current duties involve SSIS/SSRS, but moving towards Azure Data Factory and Azure Logic Apps Competencies • Skills and hands-on experience of the following o SQL (Microsoft SQL Server) including experience with temporary tables o SQL Server Reporting Services (SSRS) o SQL Server Integration Services (SSIS) o SQL Server Profiler o Azure Data Factory o Azure Logic Apps • 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 Power BI is a plus • Experience with C# API development is a plus • Experience with the Insurance industry is a plus • Microsoft certifications related to SQL Server and Data are a plus Requisites • Bachelor's Degree or equivalent work experience in the data warehouse field • SQL development in SQL Server 2014 and above - 5 to 8 years • SSRS reports in SQL Server 2014 and above - 5 to 8 years • SSIS development in SQL Server 2014 and above - 5 to 8 years • Proficient in SQL Server Profiler • Developing data integration and ETL solutions - 5 to 8 years • Great understanding of databases and data processing • General knowledge of SCRUM methodology • Good understanding of business requirements gathering and documentation advantagetech