Database Modeling and Design Business Analyst, Public Works-IT Applications (1054 IS Business Analyst-Principal)

Job Description

1. Optimize system designs through review and analysis of user needs; customize systems through design and administration.

2. Identify opportunities for improvements in business processes through automation; make recommendations for new procedures and applications.

3. Analyze the feasibility of 'and develop requirements for new systems and enhancements to existing systems; prepare cost estimates and schedules for modifications; set scope, boundaries and objectives for system' functions and interfaces based on departmental needs.

4. Design, develop and implement new systems to support departmental activities.

5. Define system requirements; design, code, test and debug systems; train users on new applications.

6. Develop or modify system design: write detailed design specifications.

7. Provide advice on the functionality of new programs and compatibility of modifications to ensure user needs are met.

8. Evaluate software and hardware products on multiple platforms; make recommendations for compatibility, based on user requirements and systems analysis.

9. Provide analysis and technical support for highly complex systems; troubleshoot systems problems; implement solutions.

10. Support and maintain highly technical systems or networks; analyze and evaluate systems for cost effective and efficient performance; recommend modifications.

11. Coordinate the efforts of analysts, engineers and operators in the implementation of projects spanning multiple systems and sites; multiple platforms.

12. Manage and monitor the progress of contractors and vendors; resolve problems.

Qualifications

1. An associate degree in computer science or a closely related field from an accredited college or university OR its equivalent in terms of total course credits/units [i.e., at least sixty (60) semester or ninety (90) quarter credits/units with a minimum of twenty (20) semester or thirty (30) quarter credits/units in computer science or a closely-related field].

2. Five (5) years of experience in the information systems field, including system analysis, business process design, development and implementation of business application solutions or IT project management.

3.

• Five (5) years of Database Modeling and Design Experience performing key management and thought leadership role in the areas of: data techniques, including data modeling, data access, data integration, data visualization, database design and implementation;
  AND
• Five (5) years of SQL server database applications experience designing relational SQL database structures and processes in at least one of the following environments: Oracle or Microsoft Server.

1.One-year full-time employment is considered equivalent to 2000 hours (2000 hours of qualifying work experience is based on a 40 hour work week). Any overtime hours that you work above forty (40) hours per week are not included in the calculation to determine full-time employment.

2. Applicants must meet the minimum qualification requirement by the final filing date unless otherwise noted.

Applicants are strongly encouraged to fill out each portion of the employment application. Any experience or education field that lists "see resume" will not be accepted.

Applicants may be required to submit verification of the qualifying experience and education, at any point in the application, examination or departmental selection process. Resumes will NOT be accepted in lieu of verification of qualifying experience and education. More information can be found at:http://sfdhr.org/information-about-hiring-process#verification

Additional Information

Knowledge of:Requirements, installation procedures, hardware, software and maintenance of systems; practices and techniques of supervision and of project management; training techniques; interactive and macro-based applications; functional requirements, structured systems or procedures analysis; systems analysis and design; coding, testing and implementing complexprograms; script/procedure languages; common operating systems software and relational database systems; data modeling; electronic data processing methods; network management and coordination; project cost estimating; contracts negotiation and management; long range planning techniques; practices and techniques of project management; systems development life cycle; business applications development; and technical writing.

Ability and Skill to:Manage and direct a group of workers, including the ability to provide counseling and mediation; persuade, convince and train others; communicate effectively both orally and in writing; communicate clear expectations to subordinates and motivate them to perform effectively; establish and maintain good working relations with department personnel, staff, vendors, peers and management; understand and learn a variety of business procedures and processes; exercise the judgement, decisiveness and creativity required in situations involving the direction, control and planning of a program or multiple programs; use logic and analysis to solve computer and systems problems; translate functional requirements into systems specifications; decide the time, place and sequence of operations within an organizational framework, as well as the ability to oversee their execution; read and understand professional journals and literature; coordinate highly technical procedures and complex reporting requirements;prioritize competing requests for service; develop network design; conduct cost/benefit analyses; prepare technical specifications; produce complex reports, coordinate highly technical procedures and complex reporting requirements; develop new approaches and solutions outside of existing theories and principles, and engage in high level consulting.

In line with the Official Public Health Order to slow the spread of COVID-19, “shelter-in-place” has been issued for all San Francisco residents that is expected to be in effect until further notice. As a result, Department of Human Resources (DHR)’s office (located at 1 South Van Ness Avenue, 4th Floor, San Francisco, CA 94103) is currently closed to the general public. If you have any questions, please feel free to email the Human Resources Analyst listed on this announcement.

The terms of this announcement may be appealed under Civil Service Rule 111A.35.1. The standard for the review of such appeals is ‘abuse of discretion’ or ‘no rational basis’ for establishing the position description, the minimum qualifications and/or the certification rule. Appeals must include a written statement of the item(s) being contested and the specific reason(s) why the cited item(s) constitute(s) abuse of discretion by the Human Resources Director. Appeals must be submitted directly to the Executive Officer of the Civil Service Commission within five business days of the announcement issuance date.

• Application Opening- November 15, 2021

• Application Deadline- November 29, 2021

• Examination Planfor this recruitment consists of an Supplemental Questionnaire weighted at 100% of the candidates exam score. Candidates must pass all phases of exams to be ranked on the eligible list (PBT-1054-114193).

• Eligible List Durationresulting from this examination process will be six (6)months.

• Certification Rulefor the eligible list resulting from this examination will be Rule of Three Scores
  pending agreement with the Union.

• Exam Type:Combined Entrance and Promotive (CPE)

• Information About The Hiring Process
• Conviction History
• Employee Benefits Overview
• Equal Employment Opportunity
• Disaster Service Worker
• ADA Accommodation
• Seniority Credit in Promotional Exams
• Veterans Preference
• Right to Work
• Copies of Application Documents
• Diversity Statement