Senior Application Development Engineer

Position Purpose: Designs, develops, and implements complex enterprise software solutions. Collaborates closely with technical and non-technical roles such as data modelers, architects, business analysts, data stewards, and subject matter experts (SMEs) to provide design, technical analysis, development/configuration, testing, implementation, and support expertise representing the interest of the business across the enterprise. Create, optimize, and re-engineer Microsoft SQL Server (T-SQL) stored procedures, functions, views, and tables that stage and transform claim, authorization, member, and provider data for correspondence. Own, maintain, and enhance the in-house letter application, which stages data in SQL Server, uses C# to produce Word documents, and uses a third-party component within SSIS to convert Word documents to PDF. Develop and support SSIS packages for ETL, file processing, and document conversion workflows. Schedule, monitor, and troubleshoot jobs using ActiveBatch.· Perform data analysis, testing, and production support; research and resolve data, performance, and letter-generation issues. Create and maintain technical documentation, including designs, data flows, and support procedures. Clearly articulate issues to business and technical stakeholders and design/model solutions. Contribute as needed to data mart development, EDI X12 processes, Enterprise Data Warehouse (EDW) feeds, and report development. Performs other duties as assigned Complies with all p