Job Summary:
Assists junior staff members and works with other developers and production Database Administrators to ensure scalable, efficient and optimized solutions. Works closely with clients, management, business analysts, and team members to understand business requirements that drive the analysis and design of quality technical solutions. Designs, develops, maintains and improves data structures, queries, reporting solutions, extract-transform-load (ETL) processes and data warehousing strategies for all mission critical projects. Ensures solutions are aligned with business and Information Technology strategies and comply with the organization's architectural standards. Works closely with team members on the daily execution of deliverables and assists less experienced team members as needed.

Job Duties and Responsibilities:

• Works on multiple, moderately complex, enterprise-wide projects requiring technical expertise. Participates in systems and data analysis, design, development, integration, and enhancement activities, as well as related maintenance and production support.
• Assists in the development of project scope and serves as a project point of contact when necessary. Participates in project-planning sessions with clients, business analysts, and team members to analyze development requirements, provide design recommendations for complex systems, and recommend methods and assignments.
• Conducts unit tests ensuring systems meet the needs of client and line-of-business based on technical documentation. Provides ongoing maintenance of web applications and/or client/server applications or tools, depending upon previous involvement with projects.
• Manages unresolved production support issues across multiple areas of expertise. Provides design recommendations, develops application and custom integration solutions, including major enhancements and interfaces.
• Makes modifications to existing software applications and modules in accordance with technical specifications and division standards. Reviews efforts to ensure compliance to application standards.
• Follows documented and approved Systems Development Life Cycle (SDLC) process and makes recommendations toward the development of reusable routines or components, including object-oriented base class reuse.
• Translates business and technical requirements into cross-functional business application systems, providing custom integration solutions, including major system enhancements. Collaborates with team members in setting development guidelines.
• Provides application support as needed during regular and after hours.
• Remains informed and proficient regarding applicable industry technical innovations, trends, standards and new developments. Maintains current skills and remains knowledgeable regarding new tools and computer languages as applicable.
• Each team member is expected to be aware of risk within their functional area. This includes observing all policies, procedures, laws, regulations and risk limits specific to their role. Additionally, they should raise and report known or suspected violations to the appropriate Firm authority in a timely fashion.
• Performs other related duties as required.

The information on this description has been designed to indicate the general nature and level of work performed by employees within this classification. It is not designed to contain or be interpreted as a comprehensive inventory of all duties, responsibilities, and qualifications required of employees assigned to this job

Minimum Education: Bachelor's degree in computer science, information systems or a related field or an equivalent combination of education and experience.

Minimum Experience: 10 years of related experience including data design and project management, using multiple programing languages, and using and managing metadata. Regular office environment;

Required Knowledge, Skills & Abilities:

• May sit for long periods of time;
• Talk and hear regularly;
• Up to 10 pounds weight lifting/force exertion required;
• Weight/force exertion required less than 25% of the time;
• Travel required less than 25% of the time