Job Summary:
Under general supervision conducts analysis, proposes solutions, develops applications within Access, writes system documentation and implements and supports custom applications.  Provides automated solutions to meet the changing needs to Mutual Fund and Securities Operations departments including producing reports, creating screens, and performing computations.
 
Essential Duties and Responsibilities:

• Creates and develops new programs and custom applications, based upon need.


• Redefines data and converts it to programmable form for electronic data processing.


• Establishes and maintains integrated Excel and/or Access databases.


• Maintains working knowledge of business processes and interface with end-users to gather system requirements as needed; analyzes and reviews information requirements for ongoing reports and comparison as needed. 


• Creates and develops adhoc reports under short timeframes and with minimal direction and supervision.  


• Reviews reports for accuracy and reasonableness, and determines when information needs further review. 


• Collects/creates programming test material to test and ensure integrity of custom applications.


• Evaluates existing data systems and recommends improvements in functionality, efficiency, consistency, and workflow to ensure the most cost-effective system is being utilized. 


• Identifies and corrects program defects.


• Confers with department personnel and IT to provide technical advice and to assist in solving problems.


• Provides daily follow-up with internal clients regarding completed tasks to ensure client satisfaction.


• May serve as a back-up to other department staff to meet deadlines; utilizing knowledge of systems and processes.


• Performs other duties and responsibilities as assigned.

Knowledge, Skills, and Abilities:

• Company's working structure, policies, mission, and strategies.


• Principles, practices, and procedures of internal systems and processes.


• Key internal and/or external contacts to request assistance from or utilize expertise.

• Operating standard office equipment and using required software applications to produce correspondence, reports, electronic communication, spreadsheets, and databases at an intermediate level.


• Keyboard/typing and 10-key data entry.


• Strong analytical and problem solving skills sufficient to recognize and detect work errors and correct them, or offer resolution.


• Strong detail-orientation.

• Plan, organize, manage, and track multiple detailed work assignments with constantly changing priorities and close deadlines in a fast-paced work environment.


• Constructively work under stress and pressure and produce a high volume of assignments using strong organizational and time management skills to meet deadlines.


• Be self-motivated with strong sense of creativity and ability to work independently with confidence.


• Promote team cohesiveness, cooperation and effectiveness.


• Use appropriate interpersonal styles and communicate effectively, both orally and in writing, with all organizational levels.


• Think logically and to analyze and solve problems.