Job description

• Responsible for analysis, design, modeling and architecture for application systems and domains. Manages the maintenance and support of assigned application system(s). May participate in development, maintenance and support activities. • Leads or participates in the project planning process with clients, business analysts, and team members. Manages and/or participates in technical and business planning for future direction of application domain. • Manages or participates in short- and long-term planning sessions with clients to improve business processes. Generally involves using and improving information systems. Documents discussion and agreements. • Receives high-level business requirements and develops detailed requirements. Prioritizes efforts. • Refines resource requirements and forms project teams. Further defines estimates for financial, physical or human resources to support long-term projects and programs. • Leads small to medium-sized, moderately complex projects as assigned. Provides work direction and leadership to assigned projects following HMSA's project management methodology. • Reviews and provides input to the requirements for the implementation of business solutions. Provides technical assistance to help in problem resolution. • Identifies system requirements. Devises or modifies procedures to solve problems considering computer equipment capacity and limitations, operating time, form of desired results, and integration of components. • Responsible for the overall health of all applications assigned. Manages the maintenance and support of assigned application system(s). Application assignments differ in complexity, scope, and business impact from the Application Lead assignments. • Complies with application architecture processes, principles, policies and standards. Provides input to architecture policies and standards for application systems and domains. • Makes buy vs. build recommendations. May provide input into evaluation of system options, risk, cost versus benefits, and impacts on business processes and goals. • Leads or participates in the evaluation and selection process for application packages within area of responsibility. • Designs complex solutions for application systems and domains. Participates in the identification of system requirements and works with the Application Lead to solve application problems considering computer equipment capacity and limitations. • Develops technical specifications for applications. Serves as technical subject matter expert for development of new code or reuse of existing code. • Identifies best sources of data and works with data architects to ensure feasibility with corporate data sources, when needed. • May analyze integrated performance across multiple ETL components. May recommend improvements to system processes to maximize efficiency of applications. Participates in the identification of best sources of data. • Researches, recommends and applies middleware to facilitate the portability and scalability of applications. Utilizes middleware tools for designing and developing solutions when required. • Develops or modifies application components using disciplined software development processes. May participate in code walk-through occurring as needed on projects or if system problems require it. • Complies with quality standards and procedures. Participates in software inspections and quality reviews. Participates in defining development guidelines and standards to be utilized in software development and integration. • Conducts unit testing to ensure application meets specifications. Creates integration test plans. Designs and consults on test plans at all levels within an application domain. • Documents changes to application architecture, integration and conversion plans. Maintains architecture diagrams within application domain. • Provides ongoing maintenance of applications. • Analyzes existing application domain to identify and document opportunities for improvements. • Makes integrated components production ready by moving them to libraries, completing forms, following procedures, completing version control documents, etc. • Provides Tier II (application) support. May provide Tier III support. Troubleshoots existing systems to identify errors or deficiencies and develops solutions. • Provides application support as required in the absence of the Application Lead. • May provide technical leadership, coaching, and mentoring to team members. Provides technical guidance. Develops reports and presentations for senior management, as needed. May be assigned the role of Team Lead which involves resource planning and making work assignments. • Mentors junior positions to increase core systems knowledge and HMSA IT best practices. • For applications systems assigned, participates in technical planning. #LI-Hybrid • Bachelor's degree or its equivalent in Information Technology, Computer Science, or related computer or engineering field and five years of systems analysis and programming experience. May substitute a higher level of degree in Information Technology, Computer Science or related computer or engineer field and and less work experience. • Must be fluent in SQL server, T-SQL, SSIS, C#/.NET. • Must be able to troubleshoot production incidents, maintain data interfaces, analyze stored procedures, support scheduled batch processing, perform integration and regression testing, and work with packaged-software vendors. • A broad level of understanding surrounding information systems and application architecture standards is desirable. • Advanced to expert level of application and systems design is desirable. Advanced levels of programming techniques and knowledge of distributed system architecture, middleware or object oriented analysis and design is desirable. • Typically requires three years of application development and support work experience. Project management experience is desirable. • Expert level knowledge of multiple technologies and detailed knowledge of multiple segments of the business is desirable.

Requirements

Must-haves

Leads or participates in the project planning process with clients, business analysts, and team members. Manages and/or participates in technical and business planning for future direction of application domain.
Manages or participates in short- and long-term planning sessions with clients to improve business processes. Generally involves using and improving information systems. Documents discussion and agreements.
Receives high-level business requirements and develops detailed requirements. Prioritizes efforts.
Refines resource requirements and forms project teams. Further defines estimates for financial, physical or human resources to support long-term projects and programs.
Leads small to medium-sized, moderately complex projects as assigned. Provides work direction and leadership to assigned projects following HMSA's project management methodology.
Reviews and provides input to the requirements for the implementation of business solutions. Provides technical assistance to help in problem resolution.
Identifies system requirements. Devises or modifies procedures to solve problems considering computer equipment capacity and limitations, operating time, form of desired results, and integration of components.
Complies with application architecture processes, principles, policies and standards. Provides input to architecture policies and standards for application systems and domains.
Makes buy vs. build recommendations. May provide input into evaluation of system options, risk, cost versus benefits, and impacts on business processes and goals.
Leads or participates in the evaluation and selection process for application packages within area of responsibility.
Develops technical specifications for applications. Serves as technical subject matter expert for development of new code or reuse of existing code.
Identifies best sources of data and works with data architects to ensure feasibility with corporate data sources, when needed.
May analyze integrated performance across multiple ETL components. May recommend improvements to system processes to maximize efficiency of applications. Participates in the identification of best sources of data.
Researches, recommends and applies middleware to facilitate the portability and scalability of applications. Utilizes middleware tools for designing and developing solutions when required.
Develops or modifies application components using disciplined software development processes. May participate in code walk-through occurring as needed on projects or if system problems require it.
Conducts unit testing to ensure application meets specifications. Creates integration test plans. Designs and consults on test plans at all levels within an application domain.
Documents changes to application architecture, integration and conversion plans. Maintains architecture diagrams within application domain.
Provides ongoing maintenance of applications.
Analyzes existing application domain to identify and document opportunities for improvements.
Makes integrated components production ready by moving them to libraries, completing forms, following procedures, completing version control documents, etc.
Provides Tier II (application) support. May provide Tier III support. Troubleshoots existing systems to identify errors or deficiencies and develops solutions.
Provides application support as required in the absence of the Application Lead.
Mentors junior positions to increase core systems knowledge and HMSA IT best practices.
For applications systems assigned, participates in technical planning.

Nice-to-haves

None flagged.

Application prep

Use the role’s language and application details while tailoring your materials.

Keywords to mirror

sql

Platform: adp-recruiting
Effort: medium