Job Description and Duties
RESEARCH DATA SPECIALIST II - STRATEGIC PLANNING & RECREATION SERVICES / GIS ENTERPRISE/ HEADQUARTERS
The reporting location for this position is Headquarters located at 715 P Street in Sacramento, CA - Monday through Friday. Partial telework is an option . This position will work under the general direction of the Research Data Supervisor II.
This position offers the opportunity to work in a team environment dedicated to the mission of the Department of Parks and Recreation. Under the direction of the Research Data Supervisor II, Statewide GIS Enterprise Section of the Strategic Planning and Recreation Services Division, the Research Data Specialist II will serve as the Senior Data Warehouse Specialist.
The successful candidate will possess current knowledge and shall be familiar with protocol, procedures, policies, and regulations pertaining to California State Parks. Additionally, the successful candidate will perform the more complex data analysis in response to ad-hoc research and reporting requests utilizing business intelligence software programs to query, validate, format, and organize structured and unstructured data to forecast trends and assess potential impact in areas where changes are being implemented and a body of knowledge or experience does not exist. Incumbents have responsibility for coordinating the more complex research projects or activities, which involves defining and creating new data models and visualizations to ensure information needs are met. Incumbents have responsibility for designing and directing major complex research projects or activities.
The incumbent is expected to perform all functions and duties with integrity, quality communication and cooperation. The incumbent must exercise a high degree of initiative, demonstrate tact, and exercise sound judgment that exemplifies the best interests of the state and of the Department.
Training and Development Assignments may be considered.
State housing is not available. For further information regarding this position, please contact Seth Paine at (916) 539-1912 or at Seth.Paine@parks.ca.gov .
This recruitment may be used to fill identical vacancies which may occur within 180 days of the Final Filing Date of this job posting.
You will find additional information about the job in the
Duty Statement .
Working Conditions
Office environment located in a high-rise building.
Minimum Requirements
You will find the Minimum Requirements in the Class Specification.
- RESEARCH DATA SPECIALIST II
Additional Documents
- Job Application Package Checklist
- Duty Statement
Position Details
Job Code #: JC-425618
Position #(s): 549-336-5758-906
Working Title: SENIOR DATA WAREHOUSE SPECIALIST Classification: RESEARCH DATA SPECIALIST II
$7,201.00 - $9,013.00 A
# of Positions: Multiple
Work Location: Sacramento County
Telework: In Office
Job Type: Permanent, Full Time
Department Information
The mission of California State Parks is to provide for the health, inspiration, and education of the people of California by helping to preserve the state's extraordinary biological diversity, protecting its most valued natural and cultural resources, and creating opportunities for high-quality outdoor recreation.
All employees are responsible for contributing to an inclusive, safe, and secure work environment that values diverse cultures, perspectives, and experiences, and is free from discrimination.
Department Website: http://www.parks.ca.gov
Special Requirements
Applicants must submit State Examination/Employment Application (STD 678), cover letter, and a Supplemental Questionnaire (see questions below). Only those applicants who submit all required documents by the final filing date will be considered for an interview.
This non-confidential Supplemental Questionnaire is designed to elicit information regarding each applicant’s abilities, knowledge, and experience in relation to the Research Data Specialist II position. If there is a question regarding experience that you do not have, include examples of similar experience that would demonstrate your ability or potential to perform the specific function. Please limit your answers to one paragraph per question. Your response must be typewritten, using 12-point Arial font, single spaced, and no more than two pages in total length. Please provide the name and telephone number of two references who can verify the work and/or experience you describe in each of the following questions:
Describe your experience with developing collaborative, cooperative relationships with peers and management. Provide an example of a task that required you to use communication, planning, and problem-solving skills. Describe your experience developing, managing, and administering large and complex SQL databases and developing custom applications such as PowerBI dashboards to communicate statistical information and trends with decision makers. Describe a situation or problem for which you were required to research and propose a technological solution. What steps did you take? How did you communicate proposal requirements, benefits, and hurdles with non-technical associates and managers? What was the outcome?
Candidates that believe they meet the Minimum qualifications based on a pattern of education from the classification description (specifications) must provide a copy of your degree/transcripts and/or license along with your application (STD. 678) to be considered for this position.
If selected for the position official sealed transcripts will be required prior to appointment.
DO NOT include any confidential information to your application or supporting documents (i.e., Social Security Number, birthdate, marital status, medical information, examination results, method of eligibility, etc.)
SROA/SURPLUS Applicants: You must check the SROA/Surplus as your claimed method of eligibility and attach your SROA/Surplus letter as an additional document.
Application Instructions
Completed applications and all required documents must be received or postmarked by the Final Filing Date in order to be considered. Dates printed on Mobile Bar Codes, such as the Quick Response (QR) Codes available at the USPS, are not considered Postmark dates for the purpose of determining timely filing of an application.
Final Filing Date: 5/1/2024
Who May Apply
Individuals who are currently in the classification, eligible for lateral transfer, eligible for reinstatement, have list eligibility, are in the process of obtaining list eligibility, or have SROA and/or Surplus eligibility (please attach your letter, if available). SROA and Surplus candidates are given priority; therefore, individuals with other eligibility may be considered in the event no SROA or Surplus candidates apply. Individuals who are eligible for a Training and Development assignment may also be considered for this position(s).
Applications will be screened and only the most qualified applicants will be selected to move forward in the selection process. Applicants must meet the Minimum Qualifications stated in the Classification Specification(s).
How To Apply
Complete Application Packages (including your Examination/Employment Application (STD 678) and applicable or required documents) must be submitted to apply for this Job Posting. Application Packages may be submitted electronically through your CalCareer Account at www.CalCareers.ca.gov. When submitting your application in hard copy, a completed copy of the Application Package listing must be included. If you choose to not apply electronically, a hard copy application package may be submitted through an alternative method listed below:
Address for Mailing Application Packages
You may submit your application and any applicable or required documents to:
Department of Parks & Recreation
Attn: Certification Unit
P.O. Box 942896
Sacramento , CA 94296-0001
Address for Drop-Off Application Packages
You may drop off your application and any applicable or required documents at:
Department of Parks & Recreation
Class & Hiring
715 P Street
Sacramento , CA 95814
M-F Excluding Weekends and State Holidays
08:00 AM - 05:00 PM
Required Application Package Documents
The following items are required to be submitted with your application. Applicants who do not submit the required items timely may not be considered for this job:
- Current version of the State Examination/Employment Application STD Form 678 (when not applying electronically), or the Electronic State Employment Application through your Applicant Account at www.CalCareers.ca.gov. All Experience and Education relating to the Minimum Qualifications listed on the Classification Specification should be included to demonstrate how you meet the Minimum Qualifications for the position.
- Resume is optional. It may be included, but is not required.
- Statement of Qualifications -
“Please see "Special Requirements"
- Other - Cover Letter Is Required.
Applicants requiring reasonable accommodations for the hiring interview process must request the necessary accommodations if scheduled for a hiring interview. The request should be made at the time of contact to schedule the interview. Questions regarding reasonable accommodations may be directed to the EEO contact listed on this job posting.
Desirable Qualifications
In addition to evaluating each candidate's relative ability, as demonstrated by quality and breadth of experience, the following factors will provide the basis for competitively evaluating each candidate:
- Plan, develop, and implement the design and construction of State Parks’ data warehouse. Serves as lead for database design.
- Performs analysis of business and technical requirements, architectural design specifications, solution implementation.
- Analyze technical problems, service requests, proposals, and work with developers to design innovative technical platform solutions.
- Provide technical expertise in the design, development, and implementation on data exploration and visualization applications, including integration with other enterprise applications.
- Performs the highest levels of database administration and operations administration for performance optimization and capacity planning.
- Applies creative and critical reasoning to analyze complex problems, weigh multiple solutions, and carefully select solutions appropriate to business needs, project scopes, and available resources.
- Writes Structured Query Language (SQL) procedures, triggers, functions, and views.
- Design custom analytics and Power BI dashboards for analysis of trends affecting State Parks.
- Ensure business and technical requirements and design standards are best represented in the final deliverables.
- Create architectural documentation.
- Plan for enterprise system capacity growth. Perform problem diagnoses, recommending solutions, and resolving systemic problems.
- Perform technical evaluation of new software systems.
- Lead the establishment and maintenance of standards and workflow processes for integration and deployment.
- Provides technical expertise in the integration of GIS system components with other enterprise applications.
- Prepares recommendations, presentations, product demonstrations, and decision-making analysis to upper management. Serves as a consultant in the development and maintenance of effective standards and templates to support technical service delivery.
- Conducts or attends meetings with applications development staff and other technical staff and prepares technical documentation and project status reports.
- Participates in special projects and prepares general administrative documents by performing technical research and developing issue papers as necessary.
- Communicates effectively and displays strong verbal, writing, and active listening skills.
- Possess strong time management, organizational skills, and is focused and detail oriented.
- Ability to manage and prioritize multiple assignments and meet deadlines.
- Possess professionalism, desire to learn and positive attitude. Fast learner, dependable and models the highest degree of integrity and ethics.
- Practices and maintains a strong work ethic; adaptable, flexible, and self-motivated; excellent attendance and punctuality.
- Works independently and also supports/follows the chain of command.
Benefits
Benefit information can be found on the CalHR website and the CalPERS website.
Contact Information
The Hiring Unit Contact is available to answer questions regarding the position or application process.
Department Website: http://www.parks.ca.gov
Hiring Unit Contact:
Seth Paine
(916) 539-1912
Seth.Paine@parks.ca.gov
Please direct requests for Reasonable Accommodations to the interview scheduler at the time the interview is being scheduled. You may direct any additional questions regarding Reasonable Accommodations or Equal Employment Opportunity for this position(s) to the Department's EEO Office.
EEO Contact:
Sharon Comas - Human Rights Office
(916) 653-9990
California Relay Service: 1-800-735-2929 (TTY), 1-800-735-2922 (Voice) TTY is a Telecommunications Device for the Deaf, and is reachable only from phones equipped with a TTY Device.
Additional Instructions
If submitting your completed Application Package by mail or hand delivery, you
must include the Position # 549-336-5758-906 and the Job Control # JC-425618 in the “Examination or Job Title for which you are applying” section on the STD. 678.
Note: If you are applying for multiple positions, you
must complete a STD. 678 for each position separately. Incomplete applications or applications received with multiple positions listed on one application will not be considered.
Employment History on the STD 678 must be complete and include dates, accurate hours per week, total time worked, duties and responsibilities, and contact names and phone numbers of supervisors. Failure to submit a completed STD 678 may result in you being screened out. Only the most qualified candidates will be invited to an interview.
Eligibility Information
To be appointed you must satisfy one of the following requirements:
List Eligibility - Successfully complete the civil service exam for Research Data Specialist II. Click here for more information on how to apply for the exam. NOTE: Please refer to the exam bulletin for the frequency of administration of this exam. Transfer Eligibility - Must have current employment with the State of California in the same classification or in a classification that is comparable. If in a different classification, you must meet the minimum qualifications (see Minimum Qualifications section and associated links above). Reinstatement Eligibility - Previously obtained permanent employment with the State of California in the same classification or in a classification that is comparable. If in a different classification, you must meet the minimum qualifications (see Minimum Qualifications section and associated links above).
In some special circumstances, candidates who meet the Minimum Qualifications for the position, but who do not have one of the types of eligibility listed above, may be hired. However, this is rare, and the preferred method of appointment is through eligibility as described above.
Equal Opportunity Employer
The State of California is an equal opportunity employer to all, regardless of age, ancestry, color, disability (mental and physical), exercising the right to family care and medical leave, gender, gender expression, gender identity, genetic information, marital status, medical condition, military or veteran status, national origin, political affiliation, race, religious creed, sex (includes pregnancy, childbirth, breastfeeding and related medical conditions), and sexual orientation.
It is an objective of the State of California to achieve a drug-free work place. Any applicant for state employment will be expected to behave in accordance with this objective because the use of illegal drugs is inconsistent with the law of the State, the rules governing Civil Service, and the special trust placed in public servants.
Closing Date/Time: 5/1/2024
