• Job Description

  Req#: 4071681
  The County of Yolo is recruiting to fill two regular, full-time positions in the class of Systems Software Specialist at the Innovation and Technology Services Department. The selected candidate will be placed at either the Systems Software Specialist I or II level depending on their qualifications and experience. The salary range for the classification level I and II are as follows:
  

  Systems Software Specialist I: $94,286 – $114,608 Annually

  Systems Software Specialist II: $103,646 – $125,985 Annually

  
  We are seeking a highly skilled and experienced data & analytics specialist to join our team. As a Systems Software Specialist, you will be responsible for managing and optimizing our Data Lake/Warehouse, Business Intelligence, reports, and data analytics systems. The ideal candidate will have a strong background in Data Lake/Warehousing technologies, Business Intelligence tools, and data analytics, with expertise in Amazon Data Lake, Infor Birst, Microsoft Power BI, Microsoft SQL and Oracle Database Systems.
  
  Primary responsibilities fall within four broad areas at differing levels of individual responsibility.
  
  Data Architecture:
  - Knowledge of building data orchestration and pipelines.
  - Understanding of metadata management, data modeling & design, data integration, data lineage, data catalog and related tools.
  - Design, develop, and maintain the Data Lake/Warehouse infrastructure, ensuring data integrity and performance optimization.
  - Implement data modeling techniques and data integration processes to support efficient data extraction, transformation, and loading (ETL) operations.
  - Collaborate with stakeholders to define data requirements and ensure data quality and consistency.
  - Monitor and troubleshoot Data Lake/Warehouse performance issues, implementing necessary optimizations.
  
  Business Intelligence (BI) Development:
  - Develop and maintain interactive reports, dashboards, and data visualizations using Microsoft Power BI, Infor Birst or other BI tools.
  - Ability to understand the data needs of data users and quickly translate complex technical concepts into simplified business terms.
  - Ability to transform complex data into easy-to-understand visual insights that are aligned to business objectives.
  - Implement data cubes, data mining, and advanced analytics techniques to support decision-making processes.
  - Collaborate with business users to understand their analytical needs and provide training and support on BI tools.
  
  Data Analytics:
  - Perform data analysis, data mining, and statistical modeling to identify trends, patterns, and correlations.
  - Proficiency in SQL query language and able to use many query tools
  - Utilize data visualization techniques to communicate analytical findings and insights effectively.
  - Identify opportunities for process improvements and data-driven decision-making.
  - Develop predictive models and implement machine learning algorithms to support forecasting and predictive analytics.
  
  Report Generation:
  - Design and generate reports based on business requirements using various reporting tools.
  - Extract and manipulate data from multiple sources to generate accurate and meaningful reports.
  - Automate report generation processes and ensure timely delivery of reports to stakeholders.
  - Perform data analysis on reports to identify trends, patterns, and opportunities for improvement.
  
  Technical Expertise:
  - Possess a deep understanding of Amazon Data Lake, Infor Birst, Microsoft Power BI, Microsoft SQL, and Oracle Database Systems to effectively leverage these technologies.
  - Stay up to date with the latest trends and advancements in Data Lake/Warehouse, Business Intelligence, and data analytics fields.
  - Provide technical guidance and expertise to the team and other stakeholders.
  
  This recruitment is open until filled, and applications will be reviewed on a continuous basis. Interested applicants should submit an online County of Yolo Employment Application, a detailed resume, and a completed supplemental questionnaire.
  

  For important and detailed information regarding the application and selection process for this recruitment, please see the APPLICATION AND SELECTION PROCESS section of this job announcement below.

  
  To view a full job description for Systems Software Specialist I, click here .
  
  To view a full job description for Systems Software Specialist II, click here .

  Systems Software Specialist I

  Experience: Three years experience configuring, installing, upgrading, maintaining, diagnosing, analyzing and resolving problems relating to network software systems.
  
  

  Systems Software Specialist II

  Experience: Four years of experience configuring, installing, upgrading, maintaining, diagnosing, analyzing and resolving problems relating to network software systems.
  
  Background Requirements
  Incumbents in this class may have access to Federal Tax Information and are subject to confidentiality and safeguarding requirements of Internal Revenue Code 6103(p)(4). As such, an individual selected for this position is subject to a thorough background investigation as stipulated in Section 5.1.1 of Internal Revenue Service Publication 1075, which includes the following:

  1. Review of Federal Bureau of Investigation (FBI) fingerprint results;
  2. Check of local law enforcement agencies where the subject has lived, worked and/or attended school within the last five (5) years and, if applicable, of the appropriate agency for any identified arrests; and
  3. Verification of an employee's eligibility to work in the United States.

  Background investigations are conducted upon hire and every ten (10) years of employment thereafter.
  
  License
  Positions in this classification require incumbents to possess and maintain a valid California driver's license, Class C or higher, to carry out job related duties. Individuals who do not meet this requirement due to a physical or mental disability may request a reasonable accommodation.

  It is highly recommended that you print this job bulletin for future reference.
  
  Your application should highlight all relevant education, training, and experience, and clearly indicate how you meet the minimum qualifications for the position as of the closing date. Application information must be current, concise, and related to the requirements in this job announcement. A resume may be included with your application; however, it will not substitute for the information requested on the application. In addition to a completed application and resume, applicants are required to submit a completed supplemental questionnaire for this position. Incomplete applications will be disqualified.
  
  Additional documents may be submitted to the Yolo County Human Resources Office in any one or more of the following ways:

  • As an attachment to the online application
  • By e-mail to jobs@yolocounty.org
  • By fax to (530) 666-8049
  • By hand-delivery to 625 Court Street, Room 101, Woodland, CA 95695. Office hours are Monday through Friday, 8:00 a.m. to 5:00 p.m.

  All required documents must be received by the Human Resources Office. Human Resources is not responsible for the untimely delivery of materials sent via U.S./specialized mail, or County interoffice mail.
  
  Selection Procedure
  The following is a tentative schedule of events that will occur as part of the selection process. The selection process steps may change with or without notice.
  * Screen for Minimum Qualifications
  * Screening for Best Qualified
  * Department Selection Interviews
  * DOJ Livescan and Background Investigation
  • Conditional Job Offer, pending:
  * Medical Examination (Drug & Alcohol Screening)
  
  Screening for Best Qualified
  The supplemental questions are designed to elicit specific information regarding a candidate’s experience, education, and training. Responses should be consistent with the information on your application and are subject to verification. If a job included responsibilities applicable to several questions, separate the different functions of the job to answer all the questions completely. Resumes or referral to the application or other questionnaire responses will not be accepted in lieu of completing each question. If you have no experience, write "no experience" for the appropriate question. Based upon responses to the supplemental questionnaire, the applicant’s education, training, and experience will be evaluated to determine those applicants that are best qualified.
  
  Contact Information
  For questions about the position or about employment with the County, please contact Human Resources by e-mail at jobs@yolocounty.org or by phone at (530) 666-8055.
  
  Equal Employment Opportunity : It is the policy of the County of Yolo to provide equal employment opportunity for all qualified persons, regardless of sex, sexual orientation, race, color, ancestry, religious creed, national origin, physical disability (Including HIV and AIDS), mental disability, medical condition (cancer or genetic characteristics/information), age (40 or over), marital status, pregnancy, childbirth and related medical conditions, or any other classification protected by federal, state or local laws or ordinance. The County will comply with all of its obligations under State and Federal laws regarding the provision of reasonable accommodations to applicants. Reasonable testing arrangements may be made to accommodate applicants with disabilities or who are unable to attend a scheduled test due to religious reasons in accordance with the Fair Employment and Housing Act and the Americans with Disabilities Act. Please call the County of Yolo Human Resources Office at (530) 666-8055 at least five (5) business days prior to the scheduled test date to request accommodation. Documentation from a medical doctor, rehabilitation counselor, or other qualified professional will be required.
  
  

  Yolo County, a place where YOU belong!

  The average person spends one third of their life at work. Why not spend that time in an environment where you are seen for who you are, celebrated for the diversity you bring, and valued for your potential to contribute to an innovative and dynamic workforce? Yolo County is committed to creating and sustaining an inclusive and equitable workplace which supports and values our diverse community.

  Come join us! This is where YOU belong.

• About the company

  Yolo County, officially the County of Yolo, is a county located in the northern portion of the US state of California.

Notice