What are the responsibilities and job description for the DATA SYSTEMS ANALYST position at Hawthorn Bank?
SUMMARY
This position is responsible for providing technical support and parameter configuration to the core banking platform. This position will assist in the oversight of all loan and deposit software programs and data coordination, queries, and data controls. This position has a dotted line report to operations. Work is performed within the framework of standard program guidelines; however, a high level of independent judgment and discretion is required in performing assigned tasks.
ESSENTIAL DUTIES AND RESPONSIBILITIES include the following. Other duties may be assigned.
Perform data analysis for complex systems.
Responsible for the administration of all bank software systems, including Jack Henry Silverlake maintenance, new branch buildouts, deposit and loan user applications, and product parameters.
Maintain and administer eSign, including user creation, troubleshooting and document maintenance.
Maintain systems, access groups, products, and change logs. Develop and maintain operating controls to ensure changes are authorized and tested.
Work closely with IT and Operations partners.
Test new software features; develop new functions to assist in workflows.
Monitor operations admin and data query ticketing system, including fulfilling requests.
Coordinate between systems and departments to ensure all systems work to the end user benefit.
Work with operations and product design teams to onboard new, and maintain existing, products and conversions.
Coordinate with the training department to ensure information regarding systems and system changes are distributed.
Coordinate with Jack Henry & Associates on cases as necessary.
Support target state data model for managing and reporting data quality concerns in alignment with the desired operating model.
Coordinate implementation of data controls framework in partnership with the end-to-end data governance team.
Design and draft requirements for controls monitoring solutions and coordinate with process teams to define ongoing monitoring processes.
Facilitate the transition of data consumption from existing models to the enhanced data management framework, including defining consumption points, trusted sources, and technology enablers.
Facilitate or contribute to status meetings (recurring and ad-hoc) with required departments by preparing materials and updates, summarizing issues and risks, and defining agreed action items and next steps.
Create project artifacts including, but not limited to business and functional requirements, user acceptance test plans, and operational readiness documents.
Conduct Systems Integrated Testing (SIT) and User Acceptance Testing (UAT).
Contribute to development and maintenance of data lineage, process maps, data concepts and glossaries.
Comply with all banking regulations, policies and procedures.
NON-ESSENTIAL DUTIES & RESPONSIBILITIES include the following. Other duties may be assigned.
Maintain educational and professional expertise through attendance at job related seminars, conferences, and workshops.
SUPERVISORY RESPONSIBILITIES
None.
QUALIFICATIONS
To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonable accommodation may be made to enable individuals with disabilities to perform the essential functions.
EDUCATION and/or EXPERIENCE
Possess a four-year bachelor’s degree from an accredited university or institution in computer information systems, or closely related coursework, plus additional education and/or training. Professional work experience in relevant areas may be substituted on a year-for-year basis for the required education.
Possess a minimum of five (5) years professional work experience in financial services, banking industry, financial data management, or financial data remediation.
Strong SQL knowledge required, including data query, analysis and troubleshooting.
Experience with business process reengineering and business modeling concepts and systems development lifecycle.
Proven record of strong interpersonal skills with evidence of working in collaboration across organizations, including a proactive approach to communicating issues and requests and leading change through creative thinking.
Experience with Jack Henry Core platform experience is a plus.
Experience in data governance programs with knowledge of data governance principles, practical experience of data management and data remediation, operational/technology functions within banking organizations, and project management skills a plus.
LANGUAGE SKILLS
Ability to read and interpret documents such as safety rules, operating and maintenance instructions, and procedure manuals. Ability to write routine reports and correspondence. Ability to speak effectively before groups of customers or employees of organization. Ability to extract information by questioning and active listening. Advanced written and verbal communication skills.
MATHEMATICAL SKILLS
Ability to add, subtract, multiply, and divide in all units of measure, using whole numbers, common fractions, and decimals. Ability to compute rate, ratio, and percent and to draw and interpret bar graphs.
REASONING ABILITY
Ability to apply common sense understanding to carry out instructions furnished in written, oral, or diagram form. Ability to deal with problems involving several concrete variables in standardized situations. Ability to understand strategic direction and translate to results; possess analytical, strategic, and problem-solving skills with the ability to break challenges into component parts.
OTHER SKILLS AND ABILITIES
Must have the ability to operate PC and printer, copy and fax machines and telephone. Must have proficiency in Microsoft Word, Excel, Visio and PowerPoint.
KEY CONTACTS--Internal and External
Has frequent contact with all departments.
CERTIFICATES, LICENSES, REGISTRATIONS
Valid driver’s license.
PHYSICAL DEMANDS
The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodation may be made to enable individuals with disabilities to perform the essential functions.
While performing the duties of this job, the employee is regularly required to sit and talk or hear. The employee frequently is required to use hands to finger, handle, or feel and reach with hands and arms. The employee is occasionally required to stand; walk; climb or balance; and stoop, kneel, crouch, or crawl. The employee must occasionally lift and/or move up to 10 pounds. Specific vision abilities required by this job include close vision, and ability to adjust focus.
WORK ENVIRONMENT
The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
The noise level in the work environment is usually moderate.
COMMENTS
Position may require occasional overnight travel to attend various training sessions. Position requires the ability to work before or after normal business hours to attend various meetings and meet with clients. May be required to occasionally work after hours for system upgrades and changes.
This position is responsible for providing technical support and parameter configuration to the core banking platform. This position will assist in the oversight of all loan and deposit software programs and data coordination, queries, and data controls. This position has a dotted line report to operations. Work is performed within the framework of standard program guidelines; however, a high level of independent judgment and discretion is required in performing assigned tasks.
ESSENTIAL DUTIES AND RESPONSIBILITIES include the following. Other duties may be assigned.
Perform data analysis for complex systems.
Responsible for the administration of all bank software systems, including Jack Henry Silverlake maintenance, new branch buildouts, deposit and loan user applications, and product parameters.
Maintain and administer eSign, including user creation, troubleshooting and document maintenance.
Maintain systems, access groups, products, and change logs. Develop and maintain operating controls to ensure changes are authorized and tested.
Work closely with IT and Operations partners.
Test new software features; develop new functions to assist in workflows.
Monitor operations admin and data query ticketing system, including fulfilling requests.
Coordinate between systems and departments to ensure all systems work to the end user benefit.
Work with operations and product design teams to onboard new, and maintain existing, products and conversions.
Coordinate with the training department to ensure information regarding systems and system changes are distributed.
Coordinate with Jack Henry & Associates on cases as necessary.
Support target state data model for managing and reporting data quality concerns in alignment with the desired operating model.
Coordinate implementation of data controls framework in partnership with the end-to-end data governance team.
Design and draft requirements for controls monitoring solutions and coordinate with process teams to define ongoing monitoring processes.
Facilitate the transition of data consumption from existing models to the enhanced data management framework, including defining consumption points, trusted sources, and technology enablers.
Facilitate or contribute to status meetings (recurring and ad-hoc) with required departments by preparing materials and updates, summarizing issues and risks, and defining agreed action items and next steps.
Create project artifacts including, but not limited to business and functional requirements, user acceptance test plans, and operational readiness documents.
Conduct Systems Integrated Testing (SIT) and User Acceptance Testing (UAT).
Contribute to development and maintenance of data lineage, process maps, data concepts and glossaries.
Comply with all banking regulations, policies and procedures.
NON-ESSENTIAL DUTIES & RESPONSIBILITIES include the following. Other duties may be assigned.
Maintain educational and professional expertise through attendance at job related seminars, conferences, and workshops.
SUPERVISORY RESPONSIBILITIES
None.
QUALIFICATIONS
To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonable accommodation may be made to enable individuals with disabilities to perform the essential functions.
EDUCATION and/or EXPERIENCE
Possess a four-year bachelor’s degree from an accredited university or institution in computer information systems, or closely related coursework, plus additional education and/or training. Professional work experience in relevant areas may be substituted on a year-for-year basis for the required education.
Possess a minimum of five (5) years professional work experience in financial services, banking industry, financial data management, or financial data remediation.
Strong SQL knowledge required, including data query, analysis and troubleshooting.
Experience with business process reengineering and business modeling concepts and systems development lifecycle.
Proven record of strong interpersonal skills with evidence of working in collaboration across organizations, including a proactive approach to communicating issues and requests and leading change through creative thinking.
Experience with Jack Henry Core platform experience is a plus.
Experience in data governance programs with knowledge of data governance principles, practical experience of data management and data remediation, operational/technology functions within banking organizations, and project management skills a plus.
LANGUAGE SKILLS
Ability to read and interpret documents such as safety rules, operating and maintenance instructions, and procedure manuals. Ability to write routine reports and correspondence. Ability to speak effectively before groups of customers or employees of organization. Ability to extract information by questioning and active listening. Advanced written and verbal communication skills.
MATHEMATICAL SKILLS
Ability to add, subtract, multiply, and divide in all units of measure, using whole numbers, common fractions, and decimals. Ability to compute rate, ratio, and percent and to draw and interpret bar graphs.
REASONING ABILITY
Ability to apply common sense understanding to carry out instructions furnished in written, oral, or diagram form. Ability to deal with problems involving several concrete variables in standardized situations. Ability to understand strategic direction and translate to results; possess analytical, strategic, and problem-solving skills with the ability to break challenges into component parts.
OTHER SKILLS AND ABILITIES
Must have the ability to operate PC and printer, copy and fax machines and telephone. Must have proficiency in Microsoft Word, Excel, Visio and PowerPoint.
KEY CONTACTS--Internal and External
Has frequent contact with all departments.
CERTIFICATES, LICENSES, REGISTRATIONS
Valid driver’s license.
PHYSICAL DEMANDS
The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodation may be made to enable individuals with disabilities to perform the essential functions.
While performing the duties of this job, the employee is regularly required to sit and talk or hear. The employee frequently is required to use hands to finger, handle, or feel and reach with hands and arms. The employee is occasionally required to stand; walk; climb or balance; and stoop, kneel, crouch, or crawl. The employee must occasionally lift and/or move up to 10 pounds. Specific vision abilities required by this job include close vision, and ability to adjust focus.
WORK ENVIRONMENT
The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
The noise level in the work environment is usually moderate.
COMMENTS
Position may require occasional overnight travel to attend various training sessions. Position requires the ability to work before or after normal business hours to attend various meetings and meet with clients. May be required to occasionally work after hours for system upgrades and changes.
