Search Jobs

FINAL FILING DATE:                        We are accepting applications until closing at 5:00 pm, August 21, 2020

IT IS MANDATORY THAT YOU COMPLETE THE SUPPLEMENTAL QUESTIONNAIRE. YOUR APPLICATION WILL BE REJECTED IF YOU DO NOT PROVIDE ALL NECESSARY INFORMATION.

THE POSITION

The Human Resources Department is accepting applications for the Regular and full-time position of Data Management Specialist II in the Electric Department. The current vacancy is in the Finance Division of the Electric Department and will primarily support electric utility financial and operational reporting. The normal work schedule is Monday through Friday, 8:00 am –5:00 pm; a flex schedule may be available. The current vacancy is in the Electric department which does not specifically desire experience in a 24 hour industrial process environment.

The City of Roseville promotes a no smoking atmosphere.

THE CITY

The City of Roseville (COR) incorporates the following Core Competencies as part of the City’s culture:

• Focus on people: Develop and deliver service-oriented solutions that meet or exceed expectations.
• Build trust: Ensure honesty and integrity to gain confidence and support of others.
• Ensure accountability: Take responsibility for the outcomes of one’s own work and foster a sense of ownership in others.
• Communicate effectively: Deliver clear, concise messages and actively listen to ideas and questions.
• Collaborate inclusively:  Build effective working partnerships, alliances, and teams.
• Make quality decisions: Make sound, timely decisions and recommendations.

Be adaptable/agile: Change approach or methods to best fit the situation and effectively balance competing priorities.

DEFINITION

To perform technical and professional duties involving the analysis, design, development, programming, and maintenance of information systems related to the operations of an assigned department, including but not limited to, water and wastewater treatment or electric energy management, distribution, and generation processes and facilities; and to provide information technology support related to department specific operations and systems.

DISTINGUISHING CHARACTERISTICS

This is the journey level class within the Data Management Specialist series and is distinguished from the I level by the assignment of the full range of duties. Employees at this level receive only occasional instruction or assistance as new, unusual or unique situations arise and are fully aware of the operating procedures and policies within the work unit. Positions in this class are flexibly staffed and are normally filled by advancement from the I level.

SUPERVISION RECEIVED AND EXERCISED

• Receives direction from an assigned supervisor.
• May exercise technical supervision over clerical, maintenance and/or technical staff as assigned.

EXAMPLES OF ESSENTIAL DUTIES - Duties may include, but are not limited to, the following:

• Implement and maintain electronic data management, collection/storage, and related systems in support of assigned department operations and processes.
• Design, develop, program, deploy, maintain and troubleshoot a variety of electronic databases related to department operations including large Relational Database Management Systems (RDBMS) such as Oracle, SQL Server, integrated development environments, Internet application server, and/or web host software.
• Develop, install and maintain Web-based applications.
• Perform daily data analysis; maintain data integrity and accuracy by running and analyzing various programs and reports; perform database backup and recovery operations; implement and test backup and recovery policy.
• Monitor and maintain security of database systems by writing procedures, functions and triggers to control the flow of data, monitoring logs and reviewing system access privileges, allocating disk space for users, creating and maintaining users, user permissions, system privileges, and passwords, and performing other administrative tasks at the operating system level.
• Perform database back-up and recovery operations; implement and test back-up and recovery policies and procedures.
• Design, develop, maintain and troubleshoot server management tools, Internet application servers, and forms, reports and report development suite in support of department operations, requirements, and staff needs.
• Set up and maintain logical storage, channels, virtual disks and partitions; create data files, tablespaces, tables and indexes as needed.
• Work with various internal users to develop programs that meet business needs; develop, test, review, and de-bug related prototypes; create documentation of final programs; develop and conduct end user training and program roll out.
• Provide system administration services; set up and install new servers and operations systems; install system upgrades and/or apply patches; hard code and/or implement programs in anticipation of upgrades.
• Design and develop forms and reports in support of department operations, requirements, and staff needs.
• Prepare periodically-required internal and external regulatory reports related to department operations.
• Build and maintain positive working relationships with co-workers, other City employees, and the public using principles of good customer service.
• Perform related duties as assigned.

MINIMUM QUALIFICATIONS

Knowledge of:

• Principles and practices of Oracle and SQL Server databases, Local Area Networks (LAN), Storage Area Networks (SAN), computer systems and related analysis.
• Principles and techniques of SQL, PL/SQL, and JAVA scripting, report writing, programming, electronic data processing and application documentation.
• Principles and practices related to the programming, maintenance, and use of computer systems and applications such as Oracle, Microsoft Word, Excel, Access, WHIMS and web development software.
• Basic principles and practices associated with the operations of assigned department systems and facilities.
• Pertinent local, State and Federal laws, ordinances/rules, and department procedures.

Ability to:

• Learn to perform technical duties in the analysis, design, and maintenance of information systems related to the processes and operations of the assigned department.
• On a continuous basis, know and understand operations, and observe safety rules; analyze problem equipment and/or procedures; know and apply techniques and terminology; communicate and explain test results to others.
• Intermittently, sit while studying or preparing reports; bend, squat, climb, kneel and twist when performing various field site sampling duties; perform simple and power grasping, pushing, pulling, and fine manipulation; use telephone, computer or communicate through written means; and lift or carry weight of 25 pounds or less.
• Learn to apply basic principles of business processes related to the assigned department’s operations and information management.
• Communicate clearly and concisely, both orally and in writing.
• Establish and maintain effective working relationships with those contacted in the course of work.
• Independently perform technical duties in the analysis, design, and maintenance of information systems related to the processes and operations of the assigned department.
• Apply basic principles of business processes related to the assigned department’s operations and information management.

Experience and Training

Experience:

Two years of professional experience performing duties similar to that of a Data Management Specialist I with the City of Roseville (performing technical and professional duties involving the analysis, design, development, programming, and maintenance of information systems related to the operations of an assigned department, including but not limited to, water and wastewater treatment or electric energy management, distribution, and generation processes and facilities; and to provide information technology support related to department specific operations and systems).

AND

Training:

A Bachelor’s degree from an accredited college or university, preferably with major course work in computer science, information systems or a related field.

License or Certificate

• Possession of a valid California driver’s license by date of appointment.
• Possession of a Database Administrator (DBA) certificate is desirable. 

SUPPLEMENTAL QUESTIONNAIRE

1. Your responses to questions 2-3, the applicant’s education, training and experience, will be scored using a pre-determined formula.  Your responses to these questions must be consistent with your employment application information.  This experience must also be described in the “Work Experience" section of this application.  Responses to the supplemental questionnaire that are inconsistent from your “Work Experience” section in the application will not be scored.  I understand and agree with the above instructions.

• Yes
• No

2. Was any of the work experience listed on your application an unpaid internship, or volunteer work?  If so, please list below which ones.

3. How many years do you have of professional experience performing duties similar to that of a Data Management Specialist I with the City of Roseville (performing technical and professional duties involving the analysis, design, development, programming, and maintenance of information systems related to the operations of an assigned department, including but not limited to, water and wastewater treatment or electric energy management, distribution, and generation processes and facilities; and to provide information technology support related to department specific operations and systems.)?

• Less than 2 years
• 2-3 Years
• 3-5 Years
• 5+ Years

4. How many years of work experience do you have with Data Visualization software?

• Less than 1 Year
• 1-3 Years
• 3-5 Years
• 5+ Years

5. How many years of work experience do you have in Programming Languages?

• Less than 1 Year
• 1-3 Years
• 3-5 Years
• 5+ Years

6. How many years of work experience do you have in Structured Query Language?

• Less than 1 Year
• 1-3 Years
• 3-5 Years
• 5+ Years

7. What knowledge and/or experience do you have designing and managing large databases and reporting using MS Excel, SQL, JAVA, or any cloud based application development, etc.?

8. Please describe your experience with functional, integration, and end-to-end user testing.

SELECTION PROCESS

All candidates meeting the minimum qualifications will have their application scored in a Formula Rate Examination.  The applicant’s experience and education will be evaluated using a pre-determined formula.  Scores from this evaluation will determine applicant ranking and placement on the Employment List.  Supplemental questions will be utilized by the department hiring authority to make interview and selection determinations.  Final appointment is contingent upon a check of past employment references, passing a City-paid fingerprint check and depending on position applied for a pre-employment medical exam and a drug and alcohol screening test.

THE CITY OF ROSEVILLE IS AN EQUAL OPPORTUNITY EMPLOYER.  IF YOU REQUIRE AN ACCOMMODATION DUE TO A DISABILITY, PLEASE CONTACT THE HUMAN RESOURCES DEPARTMENT AT LEAST 5 WORKING DAYS BEFORE A SCHEDULED INTERVIEW/EXAMINATION PROCESS.  MEDICAL DISABILITY VERIFICATION MAY BE REQUIRED PRIOR TO ACCOMMODATION.

SALARY:                                              $5,180 to $7,289 monthly (26 pay periods annually)

FINAL FILING DATE:                        We are accepting applications until closing at 5:00 pm, August 21, 2020

IT IS MANDATORY THAT YOU COMPLETE THE SUPPLEMENTAL QUESTIONNAIRE. YOUR APPLICATION WILL BE REJECTED IF YOU DO NOT PROVIDE ALL NECESSARY INFORMATION.

THE POSITION

The Human Resources Department is accepting applications for the Regular and full-time position of Data Management Specialist I in the Electric Department. The current vacancy is in the Finance Division of the Electric Department and will primarily support electric utility financial and operational reporting. The normal work schedule is Monday through Friday, 8:00 am –5:00 pm; a flex schedule may be available. The current vacancy is in the Electric department which does not specifically desire experience in a 24 hour industrial process environment.

The City of Roseville promotes a no smoking atmosphere.

THE CITY

The City of Roseville (COR) incorporates the following Core Competencies as part of the City’s culture:

• Focus on people: Develop and deliver service-oriented solutions that meet or exceed expectations.
• Build trust: Ensure honesty and integrity to gain confidence and support of others.
• Ensure accountability: Take responsibility for the outcomes of one’s own work and foster a sense of ownership in others.
• Communicate effectively: Deliver clear, concise messages and actively listen to ideas and questions.
• Collaborate inclusively:  Build effective working partnerships, alliances, and teams.
• Make quality decisions: Make sound, timely decisions and recommendations.
• Be adaptable/agile: Change approach or methods to best fit the situation and effectively balance competing priorities.

DEFINITION

To perform technical and professional duties involving the analysis, design, development, programming, and maintenance of information systems related to the operations of an assigned department, including but not limited to, water and wastewater treatment or electric energy management, distribution, and generation processes and facilities; and to provide information technology support related to department specific operations and systems.

DISTINGUISHING CHARACTERISTICS

This is the entry level in the Data Management Specialist series. This class is distinguished from the journey level by the performance of the more routine tasks and duties assigned to positions within the series. Employees at this level are not expected to perform with the same independence of direction and judgment on matters allocated to the journey level. Since this class is typically used as a training class, employees may have only limited or no directly related work experience. Employees work under general supervision while learning job tasks.

SUPERVISION RECEIVED AND EXERCISED

• Receives general supervision from an assigned supervisor.
• May exercise technical supervision over clerical, maintenance and/or technical staff as assigned.

EXAMPLES OF ESSENTIAL DUTIES - Duties may include, but are not limited to, the following:

• Implement and maintain electronic data management, collection/storage, and related systems in support of assigned department operations and processes.
• Design, develop, program, deploy, maintain and troubleshoot a variety of electronic databases related to department operations including large Relational Database Management Systems (RDBMS) such as Oracle, SQL Server, integrated development environments, Internet application server, and/or web host software.
• Develop, install and maintain Web-based applications.
• Perform daily data analysis; maintain data integrity and accuracy by running and analyzing various programs and reports; perform database backup and recovery operations; implement and test backup and recovery policy.
• Monitor and maintain security of database systems by writing procedures, functions and triggers to control the flow of data, monitoring logs and reviewing system access privileges, allocating disk space for users, creating and maintaining users, user permissions, system privileges, and passwords, and performing other administrative tasks at the operating system level.
• Perform database back-up and recovery operations; implement and test back-up and recovery policies and procedures.
• Design, develop, maintain and troubleshoot server management tools, Internet application servers, and forms, reports and report development suite in support of department operations, requirements, and staff needs.
• Set up and maintain logical storage, channels, virtual disks and partitions; create data files, tablespaces, tables and indexes as needed.
• Work with various internal users to develop programs that meet business needs; develop, test, review, and de-bug related prototypes; create documentation of final programs; develop and conduct end user training and program roll out.
• Provide system administration services; set up and install new servers and operations systems; install system upgrades and/or apply patches; hard code and/or implement programs in anticipation of upgrades.
• Design and develop forms and reports in support of department operations, requirements, and staff needs.
• Prepare periodically-required internal and external regulatory reports related to department operations.
• Build and maintain positive working relationships with co-workers, other City employees, and the public using principles of good customer service.
• Perform related duties as assigned.

MINIMUM QUALIFICATIONS

Knowledge of:

• Principles and practices of Oracle and SQL Server databases, Local Area Networks (LAN), Storage Area Networks (SAN), computer systems and related analysis.
• Principles and techniques of SQL, PL/SQL, and JAVA scripting, report writing, programming, electronic data processing and application documentation.
• Principles and practices related to the programming, maintenance, and use of computer systems and applications such as Oracle, Microsoft Word, Excel, Access, WHIMS and web development software.

Ability to:

• Learn to perform technical duties in the analysis, design, and maintenance of information systems related to the processes and operations of the assigned department.
• On a continuous basis, know and understand operations, and observe safety rules; analyze problem equipment and/or procedures; know and apply techniques and terminology; communicate and explain test results to others.
• Intermittently, sit while studying or preparing reports; bend, squat, climb, kneel and twist when performing various field site sampling duties; perform simple and power grasping, pushing, pulling, and fine manipulation; use telephone, computer or communicate through written means; and lift or carry weight of 25 pounds or less.
• Learn to apply basic principles of business processes related to the assigned department’s operations and information management.
• Communicate clearly and concisely, both orally and in writing.
• Establish and maintain effective working relationships with those contacted in the course of work.

Experience and Training

Experience:

One year of responsible experience in computer systems operations and programming related to the implementation or maintenance of large Relational Database Management Systems (RDBMS) such as Oracle servers and automated data systems and information management; experience in a 24 hour industrial process environment, such as water or wastewater treatment is desirable.

AND

Training:

A Bachelor’s degree from an accredited college or university, preferably with major course work in computer science, information systems or a related field.

License or Certificate

• Possession of a valid California driver’s license by date of appointment.
• Possession of a Database Administrator (DBA) certificate is desirable. 

SUPPLEMENTAL QUESTIONNAIRE

1. Your responses to questions 2-3, the applicant’s education, training and experience, will be scored using a pre-determined formula.  Your responses to these questions must be consistent with your employment application information.  This experience must also be described in the “Work Experience" section of this application.  Responses to the supplemental questionnaire that are inconsistent from your “Work Experience” section in the application will not be scored.  I understand and agree with the above instructions.

• Yes
• No

2. Was any of the work experience listed on your application an unpaid internship, or volunteer work?  If so, please list below which ones.

3. How many years do you have of responsible experience in computer systems operations and programming related to the implementation or maintenance of large Relational Database Management Systems (RDBMS) such as Oracle servers and automated data systems and information management?

• Less than 1 year
• 1-3 Years
• 3-5 Years
• 5+ Years

4. How many years of work experience do you have with Data Visualization software?

• Less than 1 Year
• 1-3 Years
• 3-5 Years
• 5+ Years

5. How many years of work experience do you have in Programming Languages?

• Less than 1 Year
• 1-3 Years
• 3-5 Years
• 5+ Years

6. How many years of work experience do you have in Structured Query Language?

• Less than 1 Year
• 1-3 Years
• 3-5 Years
• 5+ Years

7. What knowledge and/or experience do you have designing and managing large databases and reporting using MS Excel, SQL, JAVA, or any cloud based application development, etc.?

8. Please describe your experience with functional, integration, and end-to-end user testing.

SELECTION PROCESS

All candidates meeting the minimum qualifications will have their application scored in a Formula Rate Examination.  The applicant’s experience and education will be evaluated using a pre-determined formula.  Scores from this evaluation will determine applicant ranking and placement on the Employment List.  Supplemental questions will be utilized by the department hiring authority to make interview and selection determinations.  Final appointment is contingent upon a check of past employment references, passing a City-paid fingerprint check and depending on position applied for a pre-employment medical exam and a drug and alcohol screening test.

THE CITY OF ROSEVILLE IS AN EQUAL OPPORTUNITY EMPLOYER.  IF YOU REQUIRE AN ACCOMMODATION DUE TO A DISABILITY, PLEASE CONTACT THE HUMAN RESOURCES DEPARTMENT AT LEAST 5 WORKING DAYS BEFORE A SCHEDULED INTERVIEW/EXAMINATION PROCESS.  MEDICAL DISABILITY VERIFICATION MAY BE REQUIRED PRIOR TO ACCOMMODATION.

The City of San Mateo invites applications for the following per diem opportunity: 

Position:          Development Review Arborist

Salary:              $51.83 - $61.85/hr. (Dependent on Qualifications)

Location:         City of San Mateo City Hall

                           330 W. 20th Ave.

                           San Mateo, CA 94403

Hours:               12-18 hours per week

Timeframe:     Open until filled, resumes will be reviewed as received

THE POSITION:  The Community Develop Department at the City of San Mateo has an opportunity for a per diem Arborist position to perform Planning application and Building permit review, arborist report review based on SMMC heritage tree ordinances, and perform site visits as required.

MINIMUM QUALIFICATIONS: 

• Two years of college study/job experience in horticulture, arboriculture and landscaping related fields.
• Certified Arborist (International Society of Arboriculture) status.
• Possession of a valid class C California driver’s license is required.
• Able to work independently with direction from Plan Check Supervisor.

Examples of DUTIES:

Duties may include, but are not limited to the following:

• Review plans and arborist reports submitted for development proposals; identify any missing or inaccurate information and request additional information or clarifications if necessary to provide recommendations based on the City of San Mateo’s tree ordinance, General Plan policies and best management practices.
• Review project plans for potential impacts to Street and Heritage Trees; advise and comment on impacts with the goal of enhancing and preserving the valuable landscapes.
• Review Planning Applications and Building Permits consistent with Chapters 13.35, 13.52, 23.70 and 27.71 of the San Mateo Municipal Code.
• Review Arborist Reports and evaluate Project Arborist recommendations to ensure proper protection of Street and Heritage Trees.
• When necessary, conduct site visits to verify accuracy of tree data presented and tree protection measures are in place prior to issuance of a building permit.
• Provide accurate information to the public at the public counter, on the phone, video conference or by email.
• Perform regular monitoring site inspections to ensure tree protection measures are in place and adequate.
• Ensure that development projects are adhering to the Best Management Practices. That review of projects is completed judiciously and within the timeframe needed.
• Attend public hearings, as necessary.
• Develop guidelines as needed to make the tree protection process smoother for residents, developers and City staff.

HOW TO APPLY: Interested candidates should submit an official City of San Mateo employment application and supplemental questionnaire on-line on CalOpps.org.

or

Submit an official City of San Mateo application and supplemental questionnaire to the City of San Mateo Human Resources Department, 330 W. 20th Avenue, San Mateo, CA 94403

This recruitment is open until filled or upon receipt of the first 100 applications, résumés(required), and supplemental questionnaires, whichever occurs first.

SUPPLEMENTAL QUESTIONNAIRE:

1. Describe how your education and training have prepared you for the Development Review Arborist position. Be specific.
2. Describe your experience with plan review and reading/interpreting construction drawings. And, also provide your experience regarding preparing or reviewing arborist reports.
    
    
   For additional information, contact Alice Chen at 650-522-7193 or by email at achen@cityofsanmateo.org.

The City of San Mateo is an equal employment opportunity employer.

The Public Works Department is looking to fill two (2) Air Conditioning Mechanic vacancies. The Air Conditioning Mechanic position is responsible for performing HVAC duties at more than 200 civic building sites across San Jose. The position will be responsible for performing the operational support, adjustment, troubleshooting, repair and preventative maintenance of heating, ventilating, air conditioning systems and auxiliary equipment.

This position will require controls experience, mechanical equipment experience, and water treatment experience.

Duties include but are not limited to:

• • Inspecting, repairing, performing preventative maintenance and routine testing of heating, cooling, air-conditioning, ventilating equipment and controls; and chiller and low pressure boiler maintenance.   
  • Operating, diagnosing, and programming HVAC equipment and systems via computer controlled LON/BACKNET Energy Management Controls, such as Schneider Electric, Alerton, Johnson Metasys.
  • Servicing DX refrigerant and hydronic chilled/hot water distribution piping systems and components and HVAC units for commercial facilities.
  • Repairing/replacing actuators, valves, compressors, controls, etc. in a refrigerant or hydronic piping system or HVAC unit.
  • Using safe job practices, including wearing the proper PPE and making the job area safe before proceeding to work.
  • Conducting chemical tests on water and determining potential issues and causes of HVAC piping and connected components.
  • Maintains cooling towers and sump basins as well as filtration systems.
  • Responds to calls for emergency repair service.
  • Maintains operating logs and related records.
  • Replaces sub-assembly units; inspects safety cut controls.
  • Performs other related work as required.  

Incumbents are expected to work independently and exercise judgment and initiative. Incumbents should possess ability to lift, carry, push, and pull materials and objects averaging a weight of 50 pounds, or heavier weights, in all cases with the use of proper equipment.

Selected candidate will need to successfully complete a background check.

This recruitment may be used to fill multiple positions in this, or other divisions or departments. If you are interested in employment in this classification, you should apply to ensure you are considered for additional opportunities that may utilize the applicants from this recruitment.

PROJECT SPECIALIST

$6,113 - $7,430/mo. + excellent benefits

DEFINITION: Under general direction, the Project Specialist assists in the administration and monitoring of a wide variety of City/Agency/Authority programs, projects and activities in conjunction with pro-active delivery of the Housing strategies. The Project Specialist will provide advice and recommendations regarding program objectives and funding availability in providing Housing opportunities throughout the community.

EXAMPLES OF DUTIES: The Project Specialist has responsibility for the development of programs, projects and activities designed to pro-actively implement various elements of the Housing Strategies; promotes City/Agency/Authority programs through public speaking and seminars; conducts lender and realtor training/information sessions; participates in the evaluation of various policies for effectiveness; assists in the development of new financing mechanisms and develops new program components; monitors programs and agreements for compliance; monitors funds and prepares reports; assists in the preparation of annual goals and budget objectives; researches housing issues and prepares documents relating to the implementation of programs and projects.

ESSENTIAL FUNCTIONS: The employee must have the ability to:

• Develop, coordinate, and pro-actively implement programs, projects and activities in conjunction with the Housing Strategies.
• Identify and seek housing related funding through grants from federal, state, local, and private sources; facilitate and monitor the implementation of said funding.
• Analyze and evaluate federal, state, and regional housing programs for the purpose of developing plans and procedures to implement changes and/or new programs.
• Collect, analyze, and evaluate data to assess local housing needs.
• Prepare detailed and comprehensive reports, as required.
• Make presentations to the City Council, outside agencies, the public and business community.
• Assist in the implementation, management and coordination of Department goals and objectives.
• Establish and maintain cooperative working relationships with those contacted in the course of work.
• Communicate clearly and concisely, both orally and in writing.
• Perform any other tasks or functions deemed necessary to the daily operations of the employer.

THE ABOVE LIST OF ESSENTIAL FUNCTIONS IS NOT EXHAUSTIVE AND MAY BE SUPPLEMENTED AS NECESSARY BY THE EMPLOYER.

WORKING CONDITIONS: Position requires prolonged sitting, standing, walking, reaching, twisting, turning, kneeling, bending, and stooping in the performance of daily activities. The position also requires grasping, repetitive hand movement and fine coordination in preparing reports using a computer keyboard. Additionally, the position requires near and far vision when preparing and reading written reports and other work related documents. Acute hearing is also required when providing phone and counter assistance.

EXPERIENCE AND TRAINING GUIDELINES: A combination of experience and training that would likely provide the required knowledge and abilities is qualifying. The employee must have the knowledge of Federal and State funded development programs such as Community Development Block Grant (CDBG), Home and other housing and economic development (business development and retention) programs; housing finance, banking and underwriting procedures and guidelines; bond financing techniques and requirements; California Redevelopment Law with respect to housing requirements; research methods, techniques and practices; principles, practices and techniques of housing and community development grant administration; effective customer service techniques and principles. EXPERIENCE: Three (3) years of increasingly responsible experience in Housing experience. EDUCATION: A Bachelor’s Degree from a recognized college or university with major coursework in planning, public administration, business administration, economics or a closely related field. Additional qualifying experience may be substituted for the required education. LICENSES/CERTIFICATIONS: Possession of, and continuously throughout employment, a valid CA Class “C” Driver’s License.

The Office of the Assessor-County Clerk-Recorder and Chief Elections Officer is seeking highly qualified candidates for the position of Departmental Systems Analyst. 

In general, the Departmental Systems Analyst:

• Provides subject matter expertise on legacy data conversion and migration of data from various sources like AS/400, MS Access, MySQL, Excel sheets etc.
• Provides complex analytical support to the maintenance and/or modification of existing systems and development of new systems. 
• Serves as liaison between business users and information technology staff, vendors and service providers.
• Performs other related duties as required and/or assigned.

Incumbents in the position of Departmental Systems Analyst (DSA) will have: a general knowledge of both departmental and program operations and information system capabilities, which will enable effective interactions between technical and non-technical staff; the ability to explain and document the needs and requirements of each to the other; and the ability to participate in the development of systems that effectively support department and program operations.

The Office of the Assessor-County Clerk-Recorder and Chief Elections Officer (ACRE) is involved in multiple technology initiatives aimed at replacing legacy systems, upgrading applications, and implementing new technologies.  A major project undertaken by ACRE is the development of a new Assessor Property Assessment System (APAS) based on the Salesforce platform. A second major effort is the cleansing and migrating of legacy data. 

Below are the specific requirements for this DSA position:
 
Data Cleansing and Migration Project
 
The DSA will:

• Work closely with business subject matter experts (SMEs) to analyze the legacy data from various sources and translate/interpret the data to the Vendor team. Legacy data resides in AS/400, MS Access, MS Excel and MySQL.
• Have a strong understanding of the legacy data and the target data model in order to create data mapping in collaboration with the SMEs and the Vendor.
• Perform various types of analysis for data extraction and data profiling such as uniqueness analysis, range analysis, etc.
• Document the detailed Data Cleansing Requirements, Business Rules, Data Rules, and list of standard data values based on the findings from Data Profiling.
• Devise data cleansing strategies and procedures.
• Oversee both manual and automated cleansing activities.
• Test the data extraction, data profiling, and data cleansing process standardization and load process thoroughly to make sure requirements are met.
• Produce data cleansing results reports and error/exception reports for the business SMEs.
• Review the error/exception reports and take any necessary actions to correct the data and improve data quality.
• Develop and implement data migration strategies and processes.
• Implement Data Governance by incorporating processes, policies, guidelines, and responsibilities for administering Assessor's entire data in compliance with policy and/or regulatory obligations.

 
The ideal candidate for this position will have:

• Worked as a Lead Data Analyst and completed at least two (2) medium to large legacy data cleansing and conversion projects.
• Extensive experience in Data Mapping, Data Cleansing, Data Analysis, Data Testing, Data Validation, Data Flow, Reporting, and Presentation.
• Technical expertise with data models, database design development, and data profiling techniques.
• Project management, leadership, initiative, and technical skills including data modelling/analysis/migration experience.
• A data-oriented personality and an excellent eye for details.
• Knowledge of data governance standards and principles.

 
This position is a full-time position, which includes medical, dental, vision, vacation, and holiday benefits and a retirement plan.  

QUALIFICATIONS

Education and Experience: Any combination of education and experience that would likely provide the required knowledge, skills and abilities is qualifying. A typical way to qualify is: 

• Education: Equivalent to graduation from a four-year college with major coursework in public administration, business administration, information systems, or a closely related field.
• Experience: The ideal candidate will have eight (8) to ten (10) years of responsible experience in a position that would provide knowledge of department-specific programs, processes and/or operations, including at least three years of experience in data analysis, modeling, design, and legacy data conversion/migration from various sources.

 
Knowledge of:

• Data Architecture and database design.
• Data Conversion Methodology.
• Talend Data Management Platform, Microsoft SQL, Microsoft Access, Microsoft Excel, and other MS office products (advanced level).

Under general direction, plans, organizes, oversees, coordinates, and manages the staff and programs of the Division, including plan review, building inspection, enforcement, and permit processing and the public counter staff; ensures compliance with standards to safeguard public safety and property related to construction, design, quality of material, use, occupancy, location, and maintenance of structures; manages the effective use of division resources to improve organizational productivity and customer service; provides complex and responsible support to the Director of Community Development in areas of expertise; and performs related duties as assigned. 

About the Responsibilities
Specific responsibilities of this position include but are not limited to:
• Plans, manages, and oversees the daily functions, operations, and activities of the Building Division, including plan review, building inspection, enforcement, and permit processing and the public counter staff.
• Participates in the development and implementation of goals, objectives, policies, and priorities for the division; recommends within division policy, appropriate service and staffing levels; recommends and administers policies and procedures.
• Participates in the development, administration, and oversight of division budget; determines funding needed for staffing, equipment, materials and supplies; ensures compliance with budgeted funding.
• Develops and standardizes procedures and methods to improve and continuously monitor the efficiency and effectiveness of assigned programs, service delivery methods, and procedures; assesses and monitors workload, administrative, and support
systems, and internal reporting relationships; identifies opportunities and makes recommendations for improvement.
• Participates in the selection of, trains, motivates, and evaluates assigned personnel; works with employees to correct deficiencies; recommends and implements discipline and termination procedures.
• Develops and manages requests for proposals for professional and/or contracted services; prepares scope of work and any technical specifications; evaluates proposals and recommends award; negotiates contracts; administers contracts to ensure compliance with Town specifications and service quality.
• Advises staff on interpretation and application of state and local codes and regulations, plans, and specifications to safeguard public safety and property related to construction, design, quality of material, use, occupancy, location, and maintenance of structures.
• Serves as source of information for property owners, developers, architects, engineers, contractors, and the general public regarding plan review, building inspection, enforcement, and permitting programs and functions; represents the division, department, and Town in disputes and litigations; facilitates community participation through a continual dialogue with residents on major projects.
• Assists with difficult field inspections, reviews inspections and decisions when unusual circumstances exist; meets with customers to interpret and explain the plan review, permitting, and inspection processes; provides clarification and responds to questions pertaining to plans review comments and inspection results.
• Prepares and presents staff reports and other necessary correspondence related to assigned activities and services; presents reports to various commissions, committees, and boards.

Specific responsibilities of this position include but are not limited to:
• Conducts field inspections of residential and commercial sites at various stages of construction, alteration, and repair for conformance to state and local building, plumbing, electrical, housing, energy conservation, and wastewater codes, plans, specifications, standards, and drawings.
• Inspects construction framing, foundations, grading, mechanical systems, and electrical, plumbing, and sanitary sewer installations on new construction and alterations to verify code compliance.
• Inspects setbacks from property lines and boundary determinations to ensure compliance with approved plans, construction codes, and zoning ordinances.
• Issues correction notices, stop-work notices, and citations according to established building inspection policies and procedures.
• Conducts follow-up inspections to ensure compliance; conducts and approves final inspections.
• Reviews construction and/or alteration plans of residential and commercial structures and septic system to determine compliance of plans to established codes and regulations; reviews proposed subdivisions for code compliance.
• Performs surface water and ground water sampling.
• Investigates complaints regarding existing buildings or new construction to determine if code violations or problem conditions exist.
• Maintains files, databases, and records related to building inspection activities.
• Prepares a variety of written reports, memoranda, and correspondence.
• Advises and provides information to property owners, developers, architects, engineers, and contractors regarding building inspection requirements, in person and over the counter and telephone; assists the public in the permit application and issuance processes, coordinating and scheduling inspections, plan review, and other developmental processes; responds to questions, complaints, and inquiries.
• Enforces business license, business occupancy, and related codes and regulations as referred by the Finance Department.
• Monitors and interprets changes in building code requirements and new construction techniques.
• Performs related duties as assigned.