Provide support to all phases of the application development process to include business analysis, application, architecture, design, development, integration and delivery for those business applications that support the administrative or operational functions of the company, or the business applications needed to serve customers effectively. Provide business application maintenance and support. * Work closely with clients, business analysts and team members on complex programming projects. Define business processes and gather project requirements. * Write software code, test, debug, and document and maintain computer applications. Identify coding errors through informal and formal testing methods. Ensure application integrity by applying SDLC concepts. * Provide ongoing maintenance of applications. * Document functions and changes to new or modified modules and test activities/results and other areas such as error handling and backup/recovery procedures. Assist in the development of user guides and training documentation for systems. * Identify technical requirements, as needed. Create technical design specifications and assist in sizing technical requirements, as needed. * Support identification of sources of data feeds and interfaces, as needed. * Design new reports and interfaces using advance queries and software solutions. Maintain existing reports and process automation tools. * Adhere to standards and procedures. * Evaluate existing applications and platforms and provides recommendations for improving application performance by conducting gap analysis, identifying feasible alternative solutions, and assisting in the scope of modifications. Participate on teams that outline the process and scope out the improvements that can be realized through the application solutions. * Evaluate new application packages and tools and perform research on best practices and provide recommendations for solutions, as needed. * Provide technical coaching and mentoring to less-experienced team members * Participate in project planning processes. Develop work plan timelines and manages workflows to meet project timeframes, as needed. * Adhere to standards and procedures, check for compliance. May assists in defining development guidelines and standards. Review modules for quality assurance. * Other duties as assigned. Key Responsibilities: * Design, develop, and maintain SQL Server solutions to support business applications and reporting needs. * Build and enhance SSIS packages for robust ETL and data integration processes. * Support and eventually own reporting deliverables using SSRS (training will be provided if necessary). * Collaborate with business stakeholders to extract specifications and deliver scalable technical solutions. * Maintain and enhance legacy systems, including Microsoft Access-based applications and Visual Basic components. * Develop and maintain batch (.bat) files for automated system tasks. * Ensure accurate documentation of newly built or previously undocumented processes. * Work with other corporate teams to manage delivery and integration of external data files into OGACC servers. * Participate in version control practices; familiarity with Enterprise GitHub is a strong plus. * Contribute to a collaborative team environment while demonstrating the ability to work independently. Departmental Preferences: * Detailed understanding of claims, inquiries, and/or enrollment workflows and working with Operational data. * At least 5 years of experience with Microsoft SQL Server, including advanced development and database management. * Proven experience with SSIS; SSRS experience is a plus and will be required to learn. * Familiarity with version control systems, preferably Git; Enterprise GitHub experience is a plus. * Some experience using Python for automation or data processing tasks. "Qualifications" * Bachelor's degree in related field preferred. * Five (5) years of application programming and analysis experience required. * Broad level of understanding surrounding information systems and application architecture standards required. * Experience designing, developing and testing applications using proven or emerging technologies required. * Project management and experience leading projects preferred. * Demonstrated ability to analyze and interpret complex problems or processes that span multiple business areas, identify and understand requirements, and develop alternate solutions. * Understand the necessity and value of accuracy and attention to detail ability to process information with high levels of accuracy. * Expertise in multiple technical environments and possesses business knowledge that spans one or more business areas. * Written and verbal communication skills. * Ability to work independently, or within a team environment. * Other related skills and/or abilities may be required to perform this job.
To view the full job description, click here
