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 Pacifica is recruiting for a Wastewater Operator-In-Training (OIT) at the Calera Creek Water Recycling Plant. Under the direct supervision of a certified Wastewater Treatment Operator, the Operator-In-Training (OIT) will assist in monitoring the operation of the Calera Creek Water Recycling Plant.

The City of Pacifica is a beautiful coastal community, just south of San Francisco with an exciting opportunity. At the City of Pacifica, we are an equal opportunity employer and value diversity. All aspects of employment including the decision to hire, promote, discipline, or discharge, will be based on merit, competence, performance, and business needs. To us, equal opportunity employment is not just about compliance, it’s about who you are, how you can help our City and who you want to be. We are committed to creating an inclusive environment for all employees and residents.

This is a part-time, at-will, non-benefited position. Hours are typically limited to less than 1,000 hours per year.

BASIC EXAMPLE OF DUTIES

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

• Assists in operating and maintaining treatment facility equipment and operation system, such as sequencing batch reactor tanks, pumps, activated sludge processes, digester, centrifuge, gravity belt thickener, ultra violet disinfection system;
• Assists in monitoring gauges, dials, meters and control panels, and other recording instruments, and interpreting results to determine processing requirements;
• Performs general Plant maintenance work, such as sweeping, cleaning, sanding, painting, and weeding. The duties described in this job announcement are intended only as illustrations of the basic types of work that may be performed. The omission of specific statements of duties does not exclude them from the position if the work is similar, related or a logical assignment to the position. 

The duties described in this job announcement are intended only as illustrations of the various types of work that may be performed. The omission of specific statements of duties does not exclude them from the position if the work is similar, related or a logical assignment to the position. 

The job description is currently under review.

DISTINGUISHING CHARACTERISTICS

Public Safety Dispatcher-In-Training is the entry and trainee level in the public safety dispatcher series. Under close supervision, incumbents are trained in dispatching techniques, equipment and protocols. Work assignments change frequently in order to facilitate training. Employees are subject to daily and weekly observation reports until they demonstrate the ability to perform independently. This classification is distinguished from the higher level Public Safety Dispatcher in that the latter is the fully trained, journey level classification in the series.

This is an alternately staffed classification. Public Safety Dispatcher-In-Training incumbents are required to achieve the knowledge, skills and abilities necessary to advance to the Public Safety Dispatcher level within the twelve month probationary period.

The minimum qualifications for education and experience can be met in the following way: Graduation from high school or tested equivalent, AND One year of work experience providing customer service to the public.

The City of Sunnyvale provides an excellent benefits package. A complete application packet will consist of a City of Sunnyvale employment application, responses to the required supplemental questions and a current (dated within one year of application) typing certificate verifying 35 or more net words per minute (online typing certificates will not be accepted). The position opens July 29, 2020 and is open continuous.

For complete information regarding this current opportunity, please visit: Sunnyvale.ca.gov and click on JOBS.

Salary $38.95 - $42.95 Hourly

Job Announcement URL: https://www.governmentjobs.com/careers/sunnyvale/jobs/2824947/public-safety-dispatcher-in-training?pagetype=jobOpportunitiesJobs 

THE POSITION

Tri-City is recruiting for an individual to serve as a Clinical Therapist I/II for the Access to Care (ATC) Team. The Clinical Therapist I/II position will appeal to individuals who are inspired by challenges and opportunities presented in working with an engaged and active community.  The Clinical Therapist I/II will report to a Program Supervisor or Clinical Program Manager.

This position is responsible for a variety of ongoing responsibilities including, but not limited to:

• Conduct same day biopsychosocial assessments with both adults and children;

• Will formulate a differential diagnosis concerning the nature of the mental health challenge;

• Create treatment plans and complete all necessary Electronic Health Record documentation;

• Perform screenings, linkage to resources and provide crisis interventions and crisis assessments;

• Work on a multidisciplinary team to promote recovery and ensure Network Adequacy;

• Ability to work in a fast-paced environment and must have excellent attendance;

• Collaborate with outside agencies to coordinate care for individuals seeking services.

• Perform other duties as assigned, etc.

A complete job description is available upon request.

THE POSITION

Tri-City is actively recruiting for a Clinical Supervisor I for the School Partnership Program. The Clinical Supervisor I will appeal to individuals who are inspired by challenges and opportunities presented in working with children in an engaged and active community. The Clinical Supervisor I will report to the Children’s Clinical Program Manager.

This position is responsible for a variety of ongoing responsibilities including, but not limited to:

• Will oversee the School Partnership Program coordinating, supervising, directing and providing clinical supervision to school-based staff;

• Complete LPS assessments, oversee and provide services for the Pomona, La Verne and Claremont school districts;

• Will provide guidance to subordinates on Agency philosophy, goals, objectives, policies and procedures through casework conferences, staff meetings, and work review;

• Will assist and participate in the development and coordination of in-service training and staff development programs;

• Will supervise, train, evaluate, and participate in the selection of subordinate staff; and initiate and participate in personnel actions in accordance with the Agency’s human resources practices and procedures;

• Will analyze existing caseloads and forecast resource needs;

• Will provide or arrange for clinical supervision of unlicensed staff;

• Will implement and ensure compliance with mandated documentation and quality assurance requirements to ensure efficient and effective operation of the unit in compliance with federal and state regulations;

•  Work on an On-call rotation & other duties as assigned.

A complete job description is available upon request.

THE POSITION

Tri-City is looking for a creative and project-oriented individual to serve as a Mental Health Services Act (MHSA) Program Coordinator for the Innovation Program. The MHSA Program Coordinator will appeal to those who are passionate about project design, implementation and management and has the ability to work independently with limited oversight.  This position will be responsible for implementing Tri-City’s current Innovation project, The Tech Suite, consisting of web-based platforms and mobile therapy applications. The MHSA Program Coordinator will report to the MHSA Projects Manager.

This position is responsible for a variety of ongoing responsibilities including, but not limited to:

• Responsible for collaborating with supervision on the development, implementation and management of Innovation projects;

• Responsible for all required project reports, annual updates, and other analyses and evaluations for assigned MHSA Programs;

• Responsible for developing and coordinating meetings and trainings in relation to the Innovation projects; Creating and writing  Innovation plans and reports;

• Function as a liaison representative to other departments, community groups, agencies and stakeholders and making presentations to various groups;

• Maintain up-to-date on MHSA regulations, policies and procedures that govern program operations; disseminate knowledge to staff and ensure compliance on a continuous basis;

• Maintain records and documentation of assigned MHSA program activities and events; ensure and comply with PHI and HIPAA requirements; perform other duties as assigned, etc.

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).