Senior Office Specialist - Database Management

Description

Under direction, to perform a wide variety of complex and responsible assignments; to function as a top technical expert in specialized departmental knowledge or competency.

This Senior Office Specialist position reports to a Program Manager II within the Housing and Community Development (HCD) division of the Office of Supportive Housing (OSH). The position works closely with other OSH managers, housing developers, and other stakeholders.

The primary role of this position is to support the OSH and its managers by ensuring that key data in the OSH’s new loan portfolio database is current and of high quality. Additionally, this position entails collecting data, data entry, and running reports from the database as requested by OSH managers. Finally, this position will support OSH operations via other administrative and analytical assignments.

The OSH is tasked with increasing the supply of affordable housing for special needs populations served by the County, as well as implementing the County’s efforts to make homelessness rare, brief, and non-recurring. Qualified candidates will possess the knowledge, skills, and abilities as described in this job bulletin.

As this is a specialized recruitment with a focus on database management, in addition to the employment standards, candidates must possess in-depth knowledge of database software. Based on this knowledge, a qualified candidate can create database files, modify and manipulate large volumes of collected data, analyze and research information stored in a variety of databases and provide instruction/training to other personnel relative to the operation and access of databases.

Candidates must have work experience in the following competency area:

• Entering data into databases and at least one (1) year of clerical experience with database management

COVID-19 Risk Tier - Lower Risk

Note: The following tasks are typical of those performed by incumbents in this classification. Specific duties assigned may depend on the specialized competency assigned to the position.

• Provides information regarding departmental functions to public, clients, departments and agencies including explanations of laws, mandates and ordinances in person, telephone or by correspondence; researches difficult inquiries or cases and guides or assists clientele in solving problems and achieving their business needs;
• Creates and/or prepares a variety of correspondence, forms, legal documents, reports, articles, technical specifications, memoranda, resolutions, minutes of meetings or hearings from a variety of mediums, where knowledge of format and presentation is necessary;
• Collects and compiles a variety of information regarding work activity of unit, technical data, etc., and generates regular statistical reports; may make recommendations to management based on information gathered and reported;
• Provides technical training and guidance in designated area of expertise to lower level clerical, seasonal or volunteer staff in area of specialized knowledge or competency;
• Researches and keeps apprised of legislative changes in area of specialized knowledge and disseminates information to staff;
• Prepares work schedules of regular, floater, temporary, per diem or registry staff; inspects and confirms accuracy of the staffing schedule; completes weekly staffing variance projection forms and schedules staff accordingly; maintains required registry personnel documentation;
• Creates and maintains computer databases for case tracking, retrieval of information, and maintenance of computer files; performs research to complete database as needed;
• Coordinates billing, accounts payable and inventory; maintains records of transactions by issuing receipts, permits, passes, releases, and licenses; checks, computes and collects fees, and may maintain control over petty cash;
• Designs, formats, edits and creates content and layouts for departmental booklets, flyers and websites;
• Reviews documents, records, and forms for accuracy, completeness, and conformance to applicable rules and regulations; communicates problems and advises on corrections to ensure acceptability;
• Operates standard…