California State Polytechnic University Pomona
3801 West Temple Avenue, Pomona, CA 91768, USA
Type of Appointment : Full-Time, Probationary Collective Bargaining Unit : California State University Employees Union - Unit 9 Job Classification : Analyst/Programmer - Expert Anticipated Hiring Amount: $7,000 - 8,333 per month Work Hours : Monday - Friday 8:00am-5:00pm THE DEPARTMENT This position is in the Enterprise Applications - Data Architecture & Analytics (DAA) area, within the Information Technology & Institutional Planning (IT&IP) Division. Under the direction of the Executive Director, DAA serves the university by providing leadership and support for data architecture, visualization, and analytics. The office provides action-oriented data that helps decision-makers throughout the university to foster student success and institutional effectiveness. DUTIES AND RESPONSIBILITIES Contribute to the design and enhancement of Business Intelligence (BI) Architecture Develop and maintain existing and new data models that form the foundation for accurate and timely reporting across the university. Create ETL (Extract, Transform, and Load) scripts to move data from source systems into the Business Intelligence reporting environment. Develop and maintain appropriate processing schedules. Troubleshoot in the event of load errors or system failures. Perform data validation and sanitation to ensure quality, accuracy, and relevance of the BI Architecture. Participate in the planning and implementing of migration from outdated to new data systems and tools. Proactively engage in ongoing professional development in order to stay abreast of emerging tools and approaches in this fast-changing field. Recommend new strategies based upon best practices. Work closely with the Department Leads and Director to research and develop solutions to integrate existing data sources into the campus-wide comprehensive reporting solution. Inform emerging campus data governance policies and practices and take these into consideration in the ongoing development of data and reporting sources. Utilize data integration tools to design, develop, and maintain data integration solutions to enable the efficient and effective exchange of data between disparate sources. Develop BI Reports and Dashboards Gather user requirements and develop solutions for campus-wide dashboards and reports based on campus reporting standards. Develop campus-wide dashboards by applying Tableau development skills and knowledge about best practices for effective data visualization. Develop standards and processes behind the migration of reports/dashboards from development to production environments. Processes include, but are not limited to: code review for adherence to standards; impact on performance; and the administration of security related to dashboards/reports and data. Apply accessible technology (ATI) guidelines to data visualizations. Work with end-users to troubleshoot and solve issues. Collaborate with department (DAA) colleagues in advocating for effective utilization of campus data by facilitating access, training, and use by faculty and staff throughout the campus community. Provide training for users in one-on-one and group settings. Develop documentation and data dictionaries for users. Seek and review exemplary models of dashboards used at other universities and suggest ways to adapt them for local use as appropriate. Lead in new development, enhancement, release, upgrade, or implementation projects, including developing and maintaining project plans in coordination with other team participants; managing project issues; collaborating with other project participants in accomplishing tasks, communicating issues to management and other project participants to ensure resolution Lead project management on sub-projects within an overall campus or department project. Coordinate task assignment and completion with staff members this position leads. Collaborate with multiple constituents (consultants, faculty, staff, and management) to address technical and functional issues, as well as implement new products and services or enhance existing services to meet campus and/or department needs. Communication and coordinate maintenance, support, and changes to the enterprise applications across a diverse audience, including technical staff (DBAs, developers, server administrators), functional departments (including Student Administration, Academic Affairs and Administrative Affairs), IT management, and CSU/CMS to plan changes, identify issues, and to mitigate unintended impacts. Coordinate technical testing to ensure end-to-end testing across interdependent groups. Provide technical expertise to developers, system administration, and end-users to ensure comprehensive testing. Document and communicate results of testing. Track issues to resolution. Demonstrate strong analytical, problem-solving, and interpersonal skills to effectively lead the DAA team. Lead the DAA team in the successful development and implementation of dashboard/visualization solutions and data integration solutions that enhance the user experience and empower informed decision-making across the organization. QUALIFICATIONS To enter this classification, a basic foundation of knowledge and skills in applications programming and systems analysis and related programming support functions is a prerequisite. This foundation would normally be obtained through a bachelor’s degree, preferably in computer science or business, or equivalent training and applied experience. Foundation knowledge and skills for the Analyst/Programmer, depending on the position assignment, may include working knowledge of a specific industry standard applications programming language and knowledge of standard systems Incumbents at the expert level work almost completely independently on the most complex problems and work assignments. They possess an advanced and comprehensive knowledge of the technical specialty and a working knowledge of related specialties and are able to apply this extensive expertise as a generalist or specialist. Experts are proactive and understand problems from broad, interactive perspective and are able to develop solutions that combine information and ideas in new, unprecedented ways. Incumbents at this level are capable of leading teams and implementation efforts for assigned projects using advanced communication and listening skills. Depth/Level of Knowledge - Functional/working knowledge of the specialty area demonstrated by an understanding and use of the general principles, practices and theories pertinent to the specialty. Integration/Scope of Knowledge - Able to integrate knowledge and skill from other specialties to address problems. Technical Capabilities & Judgment - Demonstrated competency in applying standard and non-standard technology applications and exploring and adapting changing technology. Demonstrated ability to independently apply technical judgment to achieve desired results. Able to work from specifications, with multiple systems and platforms. Problem Solving & Reasoning - Recognizes problems, uses reasoning and logic to establish possible causes, interprets and applies theories and principles, generates, and evaluates alternative solutions, devises, and implements a plan of action for the best resolution within organizational constraints. Able to develop solutions where precedents do not always exist. Future Thinking - Able to be proactive demonstrated by recognizing needs, anticipating outcomes and consequences of different approaches, and making necessary modifications to action plans to achieve desired results. Ability to Acquire Knowledge - Able to independently recognize and use various learning techniques to apply and adapt new knowledge and skills in related, different, and changing situations. Communication Skills - Demonstrated competence at interpreting and communicating information, ideas, and instructions. Able to select appropriate information and best method or format for presenting it. Listening Skills - Demonstrated reflective listening skills in working with others to interpret and identify needs and requirements and develop successful solutions. Leading/Teaching Skills - Demonstrated ability to assist others in completing assignments and to provide basic work direction. Able to train others on new skills and procedures. Team Skills - Able to plan and work on shared projects to achieve established objectives. Preferred Qualifications Minimum of five (5) years’ experience in data reporting and report developing, preferably in a higher education environment. Working knowledge of ETL (Extract/Translate/Load) tool. Experience in dimensional data modeling. Five years of experience in business intelligence, preferably in a higher education environment. Knowledge of data warehouse and business intelligence tools and best practices. Demonstrated competence in relational databases and structured programming design, ability to write and edit SQL queries. Experience in dimensional data modeling. Experience with PeopleSoft tables and data. Experience with data visualization tools (eg. Tableau). Working knowledge of Oracle RDBMS. ODI (Oracle Data Integrator) - ETL tool Software release and system change management experience. Data analysis and programming languages (e.g. R, Python) Comprehensive knowledge, skills and abilities to perform requirements analysis. Expertise and skills with technical and functional problems identification, resolving and tracking. Advanced experience with using PC tools (Word processing, diagramming and spreadsheets). Effective communication of technical issues and solutions to faculty, staff, and management. Ability to work with shifting and demanding deadlines and workload. Ability to research multiple sources and recommended solutions to problems. Experience working in higher education Out of State Work The California State University (CSU) system is a network of twenty-three public universities providing access to a quality education through the support of California taxpayers. Part of CSU’s mission is to prepare educated, responsible individuals to contribute to California’s schools, economy, culture, and future. As an agency of the State of California, the CSU’s business operations almost exclusively reside within California. The CSU Out-of-State Employment Policy prohibits hiring employees to perform CSU-related work outside California. For more information, go to https://calstate.policystat.com/policy/10899725/latest/ . Background Check Cal Poly Pomona will make a conditional offer of employment to final job candidates, pending the satisfactory completion of a background check (including a criminal records check). The conditional offer of employment may be rescinded if the background check reveals disqualifying information, and/or it is discovered that the candidate knowingly withheld or falsified information. In determining the suitability of the candidate for the position, Cal Poly Pomona will give an individualized assessment to any information that the applicant submits for consideration regarding the criminal conviction history such as the nature, gravity and recency of the conviction, the candidate’s conduct, performance or rehabilitation efforts since the conviction and the nature of the job applied for. For more information, go to https://calstate.policystat.com/policy/13813878/latest/ . CSU Classification Salary Range This position is part of the CSUEU bargaining unit. The CSU Classification Standards for this position are located on the following site: https://www.calstate.edu/csu-system/careers/compensation/Pages/Classification-Standards.aspx . The CSU Salary Schedule is located on the following site: https://www.calstate.edu/csu-system/careers/compensation/Pages/salary-schedule-documents.aspx . The classification salary range for this position according to the respective skill level is: minimum $7,020 and maximum $13,594 per month. Please refer to the anticipated hiring range for the appropriate salary rate for this particular position. Employment Eligibility Verification Cal Poly Pomona hires only individuals lawfully authorized to work in the United States. In compliance with federal law, all persons hired will be required to verify identity and eligibility to work in the United States and to complete the required employment eligibility verification form upon hire. For more information, go to https://www.uscis.gov/i-9-central/form-i-9-acceptable-documents . Security & Fire Safety In compliance with state and federal crime awareness and campus security legislation, including The Jeanne Clery Disclosure of Campus Security Policy and Crime Statistics Act, California Education Code section 67380, and the Higher Education Opportunity Act (HEOA), Cal Poly Pomona’s Annual Security Report and Annual Fire Safety Report are available for viewing at: https://www.cpp.edu/pdfs/annual_security_report.pdf and https://www.cpp.edu/housing/documents/fire_safety_report.pdf. Pay Transparency Nondiscrimination As a federal contractor, Cal Poly Pomona will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. For more information, see the Pay Transparency Nondiscrimination Provision poster . Reasonable Accommodation We provide reasonable accommodations to applicants and employees with disabilities. Applicants with questions about access or requiring a reasonable accommodation for any part of the application or hiring process should contact the ADA Coordinator by email at ADACoordinator@cpp.edu . For more information, go to Employment Notices . Equal Employment Opportunity Cal Poly Pomona is an Equal Opportunity Employer, committed to promoting an inclusive and diverse workforce. The university subscribes to all state and federal regulations that prohibit discrimination based on race, color, religion, national origin, sex, gender identity/gender expression, sexual orientation, marital status, pregnancy, age, disability, genetic information, medical condition, and veteran or military status. We engage the talents of all qualified workers, regardless of their background. More information is available at Equal Employment Opportunity statement . Other Notices For other important employment notices, we invite you to visit Cal Poly Pomona’s Employment Notices web page. Advertised: Mar 27 2024 Pacific Daylight Time Applications close: Apr 10 2024 Pacific Daylight Time Closing Date/Time:
Mar 28, 2024
Type of Appointment : Full-Time, Probationary Collective Bargaining Unit : California State University Employees Union - Unit 9 Job Classification : Analyst/Programmer - Expert Anticipated Hiring Amount: $7,000 - 8,333 per month Work Hours : Monday - Friday 8:00am-5:00pm THE DEPARTMENT This position is in the Enterprise Applications - Data Architecture & Analytics (DAA) area, within the Information Technology & Institutional Planning (IT&IP) Division. Under the direction of the Executive Director, DAA serves the university by providing leadership and support for data architecture, visualization, and analytics. The office provides action-oriented data that helps decision-makers throughout the university to foster student success and institutional effectiveness. DUTIES AND RESPONSIBILITIES Contribute to the design and enhancement of Business Intelligence (BI) Architecture Develop and maintain existing and new data models that form the foundation for accurate and timely reporting across the university. Create ETL (Extract, Transform, and Load) scripts to move data from source systems into the Business Intelligence reporting environment. Develop and maintain appropriate processing schedules. Troubleshoot in the event of load errors or system failures. Perform data validation and sanitation to ensure quality, accuracy, and relevance of the BI Architecture. Participate in the planning and implementing of migration from outdated to new data systems and tools. Proactively engage in ongoing professional development in order to stay abreast of emerging tools and approaches in this fast-changing field. Recommend new strategies based upon best practices. Work closely with the Department Leads and Director to research and develop solutions to integrate existing data sources into the campus-wide comprehensive reporting solution. Inform emerging campus data governance policies and practices and take these into consideration in the ongoing development of data and reporting sources. Utilize data integration tools to design, develop, and maintain data integration solutions to enable the efficient and effective exchange of data between disparate sources. Develop BI Reports and Dashboards Gather user requirements and develop solutions for campus-wide dashboards and reports based on campus reporting standards. Develop campus-wide dashboards by applying Tableau development skills and knowledge about best practices for effective data visualization. Develop standards and processes behind the migration of reports/dashboards from development to production environments. Processes include, but are not limited to: code review for adherence to standards; impact on performance; and the administration of security related to dashboards/reports and data. Apply accessible technology (ATI) guidelines to data visualizations. Work with end-users to troubleshoot and solve issues. Collaborate with department (DAA) colleagues in advocating for effective utilization of campus data by facilitating access, training, and use by faculty and staff throughout the campus community. Provide training for users in one-on-one and group settings. Develop documentation and data dictionaries for users. Seek and review exemplary models of dashboards used at other universities and suggest ways to adapt them for local use as appropriate. Lead in new development, enhancement, release, upgrade, or implementation projects, including developing and maintaining project plans in coordination with other team participants; managing project issues; collaborating with other project participants in accomplishing tasks, communicating issues to management and other project participants to ensure resolution Lead project management on sub-projects within an overall campus or department project. Coordinate task assignment and completion with staff members this position leads. Collaborate with multiple constituents (consultants, faculty, staff, and management) to address technical and functional issues, as well as implement new products and services or enhance existing services to meet campus and/or department needs. Communication and coordinate maintenance, support, and changes to the enterprise applications across a diverse audience, including technical staff (DBAs, developers, server administrators), functional departments (including Student Administration, Academic Affairs and Administrative Affairs), IT management, and CSU/CMS to plan changes, identify issues, and to mitigate unintended impacts. Coordinate technical testing to ensure end-to-end testing across interdependent groups. Provide technical expertise to developers, system administration, and end-users to ensure comprehensive testing. Document and communicate results of testing. Track issues to resolution. Demonstrate strong analytical, problem-solving, and interpersonal skills to effectively lead the DAA team. Lead the DAA team in the successful development and implementation of dashboard/visualization solutions and data integration solutions that enhance the user experience and empower informed decision-making across the organization. QUALIFICATIONS To enter this classification, a basic foundation of knowledge and skills in applications programming and systems analysis and related programming support functions is a prerequisite. This foundation would normally be obtained through a bachelor’s degree, preferably in computer science or business, or equivalent training and applied experience. Foundation knowledge and skills for the Analyst/Programmer, depending on the position assignment, may include working knowledge of a specific industry standard applications programming language and knowledge of standard systems Incumbents at the expert level work almost completely independently on the most complex problems and work assignments. They possess an advanced and comprehensive knowledge of the technical specialty and a working knowledge of related specialties and are able to apply this extensive expertise as a generalist or specialist. Experts are proactive and understand problems from broad, interactive perspective and are able to develop solutions that combine information and ideas in new, unprecedented ways. Incumbents at this level are capable of leading teams and implementation efforts for assigned projects using advanced communication and listening skills. Depth/Level of Knowledge - Functional/working knowledge of the specialty area demonstrated by an understanding and use of the general principles, practices and theories pertinent to the specialty. Integration/Scope of Knowledge - Able to integrate knowledge and skill from other specialties to address problems. Technical Capabilities & Judgment - Demonstrated competency in applying standard and non-standard technology applications and exploring and adapting changing technology. Demonstrated ability to independently apply technical judgment to achieve desired results. Able to work from specifications, with multiple systems and platforms. Problem Solving & Reasoning - Recognizes problems, uses reasoning and logic to establish possible causes, interprets and applies theories and principles, generates, and evaluates alternative solutions, devises, and implements a plan of action for the best resolution within organizational constraints. Able to develop solutions where precedents do not always exist. Future Thinking - Able to be proactive demonstrated by recognizing needs, anticipating outcomes and consequences of different approaches, and making necessary modifications to action plans to achieve desired results. Ability to Acquire Knowledge - Able to independently recognize and use various learning techniques to apply and adapt new knowledge and skills in related, different, and changing situations. Communication Skills - Demonstrated competence at interpreting and communicating information, ideas, and instructions. Able to select appropriate information and best method or format for presenting it. Listening Skills - Demonstrated reflective listening skills in working with others to interpret and identify needs and requirements and develop successful solutions. Leading/Teaching Skills - Demonstrated ability to assist others in completing assignments and to provide basic work direction. Able to train others on new skills and procedures. Team Skills - Able to plan and work on shared projects to achieve established objectives. Preferred Qualifications Minimum of five (5) years’ experience in data reporting and report developing, preferably in a higher education environment. Working knowledge of ETL (Extract/Translate/Load) tool. Experience in dimensional data modeling. Five years of experience in business intelligence, preferably in a higher education environment. Knowledge of data warehouse and business intelligence tools and best practices. Demonstrated competence in relational databases and structured programming design, ability to write and edit SQL queries. Experience in dimensional data modeling. Experience with PeopleSoft tables and data. Experience with data visualization tools (eg. Tableau). Working knowledge of Oracle RDBMS. ODI (Oracle Data Integrator) - ETL tool Software release and system change management experience. Data analysis and programming languages (e.g. R, Python) Comprehensive knowledge, skills and abilities to perform requirements analysis. Expertise and skills with technical and functional problems identification, resolving and tracking. Advanced experience with using PC tools (Word processing, diagramming and spreadsheets). Effective communication of technical issues and solutions to faculty, staff, and management. Ability to work with shifting and demanding deadlines and workload. Ability to research multiple sources and recommended solutions to problems. Experience working in higher education Out of State Work The California State University (CSU) system is a network of twenty-three public universities providing access to a quality education through the support of California taxpayers. Part of CSU’s mission is to prepare educated, responsible individuals to contribute to California’s schools, economy, culture, and future. As an agency of the State of California, the CSU’s business operations almost exclusively reside within California. The CSU Out-of-State Employment Policy prohibits hiring employees to perform CSU-related work outside California. For more information, go to https://calstate.policystat.com/policy/10899725/latest/ . Background Check Cal Poly Pomona will make a conditional offer of employment to final job candidates, pending the satisfactory completion of a background check (including a criminal records check). The conditional offer of employment may be rescinded if the background check reveals disqualifying information, and/or it is discovered that the candidate knowingly withheld or falsified information. In determining the suitability of the candidate for the position, Cal Poly Pomona will give an individualized assessment to any information that the applicant submits for consideration regarding the criminal conviction history such as the nature, gravity and recency of the conviction, the candidate’s conduct, performance or rehabilitation efforts since the conviction and the nature of the job applied for. For more information, go to https://calstate.policystat.com/policy/13813878/latest/ . CSU Classification Salary Range This position is part of the CSUEU bargaining unit. The CSU Classification Standards for this position are located on the following site: https://www.calstate.edu/csu-system/careers/compensation/Pages/Classification-Standards.aspx . The CSU Salary Schedule is located on the following site: https://www.calstate.edu/csu-system/careers/compensation/Pages/salary-schedule-documents.aspx . The classification salary range for this position according to the respective skill level is: minimum $7,020 and maximum $13,594 per month. Please refer to the anticipated hiring range for the appropriate salary rate for this particular position. Employment Eligibility Verification Cal Poly Pomona hires only individuals lawfully authorized to work in the United States. In compliance with federal law, all persons hired will be required to verify identity and eligibility to work in the United States and to complete the required employment eligibility verification form upon hire. For more information, go to https://www.uscis.gov/i-9-central/form-i-9-acceptable-documents . Security & Fire Safety In compliance with state and federal crime awareness and campus security legislation, including The Jeanne Clery Disclosure of Campus Security Policy and Crime Statistics Act, California Education Code section 67380, and the Higher Education Opportunity Act (HEOA), Cal Poly Pomona’s Annual Security Report and Annual Fire Safety Report are available for viewing at: https://www.cpp.edu/pdfs/annual_security_report.pdf and https://www.cpp.edu/housing/documents/fire_safety_report.pdf. Pay Transparency Nondiscrimination As a federal contractor, Cal Poly Pomona will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. For more information, see the Pay Transparency Nondiscrimination Provision poster . Reasonable Accommodation We provide reasonable accommodations to applicants and employees with disabilities. Applicants with questions about access or requiring a reasonable accommodation for any part of the application or hiring process should contact the ADA Coordinator by email at ADACoordinator@cpp.edu . For more information, go to Employment Notices . Equal Employment Opportunity Cal Poly Pomona is an Equal Opportunity Employer, committed to promoting an inclusive and diverse workforce. The university subscribes to all state and federal regulations that prohibit discrimination based on race, color, religion, national origin, sex, gender identity/gender expression, sexual orientation, marital status, pregnancy, age, disability, genetic information, medical condition, and veteran or military status. We engage the talents of all qualified workers, regardless of their background. More information is available at Equal Employment Opportunity statement . Other Notices For other important employment notices, we invite you to visit Cal Poly Pomona’s Employment Notices web page. Advertised: Mar 27 2024 Pacific Daylight Time Applications close: Apr 10 2024 Pacific Daylight Time Closing Date/Time:
California Polytechnic State University
1 Grand Avenue, San Luis Obispo, CA 93407, USA
Job Summary Under general supervision of the Executive Director of Customer and Business Services, the Facilities Business Intelligence Analyst is responsible for Facilities’ data management around data analytics and mining; business intelligence design solutions; create easy to access metrics for the department and campus; and being the departments first point of contact with technology troubleshooting (specifically the department’s Integrated Workplace Management System (IWMS) called Planon). Department Summary Facilities Management and Development (FMD), a unit within the Administration and Finance Division (AFD), is responsible for the planning, design, construction, operations, maintenance, and repair of university facilities, grounds, and infrastructure. FMD consists of five critical and interdependent support departments, including Customer & Business Services; Environmental Health & Safety; Facilities Planning & Capital Projects; Energy, Utilities, and Sustainability; and Facilities Operations. In support of the Cal Poly mission, the FMD department is committed to sustainability, responsible stewardship of natural resources, and promoting an inclusive culture that values individual and organizational integrity, civility, equity, and diversity. Key Qualifications Thorough knowledge of data information systems, data mining and analytics, business intelligence software, associated reporting software, and the relationships between data elements. Thorough working knowledge of Odata, Power BI Analytics, and SQL. Demonstrated ability to independently analyze and evaluate software functionality through technical documents and testing, perform fit-gap analyses, and design and document efficient and effective business practices. Expertise in administrative survey techniques, operations and systems analysis, statistical and research methods, and the ability to interpret and evaluate results to drop sound conclusions and recommend new or revised policies, procedures, or solutions. Demonstrated ability to analyze facilities software modules and data requirements and research data availability and access methods. Education and Experience Equivalent to graduation from a four-year college or university. Four years of technical or administrative experience. A graduate degree in a related field may be substituted for one year of the required experience. Additional qualifying experience may be substituted for the required education on a year-for-year basis. Salary and Benefits Anticipated Hiring Range: $78,795 - $95,000 Classification Range: $63,276 - $114,444 per year Cal Poly offers a best-in-class benefits program, including health, dental and vision insurance, retirement participation in the Public Employees' Retirement System, and educational benefits for eligible employees. See our benefits website for additional information. Cal Poly Cal Poly is a nationally-ranked public university located in San Luis Obispo, California, and known for its Learn by Doing philosophy. Each year more than 20,000 top-tier students come to San Luis Obispo to put knowledge into action, taking their learning outside the classroom as they prepare for careers in engineering, agriculture, science, business, humanities and the built environment. Cal Poly’s hands-on philosophy, small class sizes and close student-faculty mentorships result in graduates ready from day one to impact their communities, California and the world. For more information, visit calpoly.edu . Diversity Statement At Cal Poly, we believe that cultivating an environment that embraces and promotes diversity is fundamental to the success of our students, our employees and our community. Bringing people together from different backgrounds, experiences and value systems fosters the innovative and creative thinking that exemplifies Cal Poly's values of free inquiry, cultural and intellectual diversity, mutual respect, civic engagement, and social and environmental responsibility. Cal Poly's commitment to diversity informs our efforts in recruitment, hiring and retention. Cal Poly is an equal opportunity employer. Supplemental Information Following a conditional offer of employment, a background check (including a criminal records check) must be completed satisfactorily before any candidate may start work with Cal Poly. Failure to satisfactorily complete the background check may result in the withdrawal of the offer of employment. Current employees who are offered positions on campus will be required to undergo a background check for any position where a background check is required by law or that Cal Poly has designated as sensitive. The person holding this position is considered a 'mandated reporter' under the California Child Abuse and Neglect Reporting Act and is required to comply with the requirements set forth in CSU Executive Order 1083 as a condition of employment. Cal Poly, San Luis Obispo is not a sponsoring agency for staff positions (i.e. H-1B visas). Positions are posted for a minimum of 14 calendar days. Advertised: Mar 19 2024 Pacific Daylight Time Applications close: Closing Date/Time:
Mar 20, 2024
Job Summary Under general supervision of the Executive Director of Customer and Business Services, the Facilities Business Intelligence Analyst is responsible for Facilities’ data management around data analytics and mining; business intelligence design solutions; create easy to access metrics for the department and campus; and being the departments first point of contact with technology troubleshooting (specifically the department’s Integrated Workplace Management System (IWMS) called Planon). Department Summary Facilities Management and Development (FMD), a unit within the Administration and Finance Division (AFD), is responsible for the planning, design, construction, operations, maintenance, and repair of university facilities, grounds, and infrastructure. FMD consists of five critical and interdependent support departments, including Customer & Business Services; Environmental Health & Safety; Facilities Planning & Capital Projects; Energy, Utilities, and Sustainability; and Facilities Operations. In support of the Cal Poly mission, the FMD department is committed to sustainability, responsible stewardship of natural resources, and promoting an inclusive culture that values individual and organizational integrity, civility, equity, and diversity. Key Qualifications Thorough knowledge of data information systems, data mining and analytics, business intelligence software, associated reporting software, and the relationships between data elements. Thorough working knowledge of Odata, Power BI Analytics, and SQL. Demonstrated ability to independently analyze and evaluate software functionality through technical documents and testing, perform fit-gap analyses, and design and document efficient and effective business practices. Expertise in administrative survey techniques, operations and systems analysis, statistical and research methods, and the ability to interpret and evaluate results to drop sound conclusions and recommend new or revised policies, procedures, or solutions. Demonstrated ability to analyze facilities software modules and data requirements and research data availability and access methods. Education and Experience Equivalent to graduation from a four-year college or university. Four years of technical or administrative experience. A graduate degree in a related field may be substituted for one year of the required experience. Additional qualifying experience may be substituted for the required education on a year-for-year basis. Salary and Benefits Anticipated Hiring Range: $78,795 - $95,000 Classification Range: $63,276 - $114,444 per year Cal Poly offers a best-in-class benefits program, including health, dental and vision insurance, retirement participation in the Public Employees' Retirement System, and educational benefits for eligible employees. See our benefits website for additional information. Cal Poly Cal Poly is a nationally-ranked public university located in San Luis Obispo, California, and known for its Learn by Doing philosophy. Each year more than 20,000 top-tier students come to San Luis Obispo to put knowledge into action, taking their learning outside the classroom as they prepare for careers in engineering, agriculture, science, business, humanities and the built environment. Cal Poly’s hands-on philosophy, small class sizes and close student-faculty mentorships result in graduates ready from day one to impact their communities, California and the world. For more information, visit calpoly.edu . Diversity Statement At Cal Poly, we believe that cultivating an environment that embraces and promotes diversity is fundamental to the success of our students, our employees and our community. Bringing people together from different backgrounds, experiences and value systems fosters the innovative and creative thinking that exemplifies Cal Poly's values of free inquiry, cultural and intellectual diversity, mutual respect, civic engagement, and social and environmental responsibility. Cal Poly's commitment to diversity informs our efforts in recruitment, hiring and retention. Cal Poly is an equal opportunity employer. Supplemental Information Following a conditional offer of employment, a background check (including a criminal records check) must be completed satisfactorily before any candidate may start work with Cal Poly. Failure to satisfactorily complete the background check may result in the withdrawal of the offer of employment. Current employees who are offered positions on campus will be required to undergo a background check for any position where a background check is required by law or that Cal Poly has designated as sensitive. The person holding this position is considered a 'mandated reporter' under the California Child Abuse and Neglect Reporting Act and is required to comply with the requirements set forth in CSU Executive Order 1083 as a condition of employment. Cal Poly, San Luis Obispo is not a sponsoring agency for staff positions (i.e. H-1B visas). Positions are posted for a minimum of 14 calendar days. Advertised: Mar 19 2024 Pacific Daylight Time Applications close: Closing Date/Time:
Minimum Qualifications Education and/or Equivalent Experience: Graduation with a Bachelor’s degree from an accredited college or university with major coursework in Business Administration, Public Administration, Social Sciences or related field, to include six (6) semester hours involving or related to statistics and two (2) years of experience in a research field. Or Master’s Degree in Business Administration, Public Administration, Social Sciences or related field and one (1) year of experience. Licenses or Certifications: None. Notes to Applicants The Research Analyst Sr position within the Planning and Research team will analyze data to create actionable reports to respond to request for information, collaborate on strategic initiatives, and provide timely analytic support to department tactical and strategic operations. Austin Police Department continues to develop its data driven strategy to shape the organization and mission. We are looking for partners who share that vision. City of Austin Application: A complete and detailed City of Austin employment application is required to help us better evaluate your qualifications. For each position, please describe your specific experience as it relates to the minimum and preferred qualifications. Please be thorough in completing the employment application and list all experience and education that is relevant to this position. Starting salary will be based on overall relevant experience and education. Application must include job titles, job duties performed, full or part time status. Your work history should include the duties you performed, any supervisory or lead responsibilities, and any equipment or computer software used. CBI : Must pass a Criminal Justice Information Systems ( CJIS ) fingerprint-based background check and maintain CJIS eligibility. Due to CJIS requirements related to system access, the following will result in being disqualified for this position: Felony Convictions, Felony Deferred Adjudication, Class A & B Misdemeanor Deferred Adjudication, Class B Misdemeanor Convictions, an Open Arrest for Any Criminal Offense (Felony or Misdemeanor), and Family Violence Convictions. Please Click here to find more information. Secondary Employment: All Austin Police employees are prohibited from accepting or engaging in any secondary employment that might conflict or interfere with an employee’s duty and responsibility to the Department. APD must review all secondary employment. Employees are required to submit a Secondary Employment Application for review and approval upon being hired with APD , as well as current APD employees considering Secondary employment. Benefits: Working with the Austin Police Department provides a number of health and welfare benefits, such as medical, paid leave time, retirement plan, training opportunities and more. Please click here to find more information. To learn more about working with the City of Austin, click here to watch a short video! EEO /AA statement: The City of Austin is committed to compliance with the Americans with Disabilities Act. If you require reasonable accommodation during the application process or have a question regarding an essential job function, please call (512) 974-3210 or Texas Relay by dialing 7-1-1. The City of Austin will not discriminate against any applicant or employee based on race, creed, color, national origin, sex, gender identity, age, religion, veteran status, disability, or sexual orientation. In addition, the City will not discriminate in employment decisions on the basis of an individual’s AIDS , AIDS Related Complex, or HIV status; nor will the City discriminate against individuals who are perceived to be at risk of HIV infection, or who associate with individuals who are believed to be at risk. Pay Range $26.26 - $31.45hr Hours Monday-Friday 8:00 AM-5:00PM Job Close Date 04/08/2024 Type of Posting External Department Police Regular/Temporary Regular Grant Funded or Pooled Position Not Applicable Category Professional Location 715 E. 8th Street, APD HQ Preferred Qualifications Preferred Experience: Experience with Geographic Information Systems ( GIS ). Experience using Business Intelligence (BI) Solutions (Qlik, Tableau, Power BI, MicroStrategy, Crystal Reports, etc.) Duties, Functions and Responsibilities Essential duties and functions, pursuant to the Americans with Disabilities Act, may include the following. Other related duties may be assigned. Determines issues and identifies parameters for gathering information for a specific project. Plans, designs, and tests research instrumentation and evaluate data to assess reliability and validity of data. Conducts research studies using questionnaires, surveys, interviews, observation methods, case readings. Analyzes trends, policies, procedures using statistical data. Designs methodology for tracking data using various software programs. 6. Authors, edits technical reports using details to support research findings. Consults, makes presentations and makes recommendations using statistical data. Coordinates issues with management and other targeted audiences, serves on committees working with specific research projects. Exchanges results of research data with other departments, agencies or specific technical groups. Reviews legislation, regulations, and policies to determine impact of research results. Formulates strategy for managing issues using statistical data. Responsibilities - Supervision and/or Leadership Exercised: May lead other employees. Knowledge, Skills and Abilities Must possess required knowledge, skills, abilities, and experience and be able to explain and demonstrate, with or without reasonable accommodations, that the essential functions of the job can be performed. Knowledge of statistical methodology. Knowledge of city practice, policy and procedures. Skill in oral and written communications. Skill in handling multiple tasks and prioritizing. Skill in the use of computers and related software. Skill in data analysis and problem solving. Skill in planning and organizing. Ability to assess information and summarize findings. Ability to establish database to maintain or track data. Ability to conduct presentations. Ability to author technical documents. Ability to identify variables and utilizing various resources to gather data. Ability to work with frequent interruptions and changes in priorities. Ability to lead others. Ability to establish and maintain good working relationships with other city employees and the public. Criminal Background Investigation This position has been approved for a Criminal Background Investigation. EEO/ADA The City of Austin is committed to compliance with the Americans with Disabilities Act. If you require reasonable accommodation during the application process or have a question regarding an essential job function, please call (512) 974-3210 or Texas Relay by dialing 7-1-1. The City of Austin will not discriminate against any applicant or employee based on race, creed, color, national origin, sex, gender identity, age, religion, veteran status, disability, or sexual orientation. In addition, the City will not discriminate in employment decisions on the basis of an individual’s AIDS , AIDS Related Complex, or HIV status; nor will the City discriminate against individuals who are perceived to be at risk of HIV infection, or who associate with individuals who are believed to be at risk. Information For City Employees: If you are an employee within the department, are in good standing and meet both the minimum and preferred qualifications, then you will receive an initial interview. Supplemental Questions Required fields are indicated with an asterisk (*). * The minimum qualifications of the Research Analyst Senior position are: Graduation with a Bachelor’s degree from an accredited college or university with major coursework in Business Administration, Public Administration, Social Sciences or related field, to include six (6) semester hours involving or related to statistics and two (2) years of experience in a research field. Or Master's Degree in Business Administration, Public Administration, Social Sciences or related field and one (1) year of experience. Do you meet the minimum qualifications of this position? Yes No * This position requires a criminal background investigation (CBI). By selecting the following, you are acknowledging that you understand if you are selected as a top candidate for this position, you will need a successful Criminal Justice Information System (CJIS) to be hired. I acknowledge and understand this position requires a Criminal Justice Information System (CJIS-Criminal Background Investigation). * Please describe your experience creating and designing informative maps, including any experience with Geographic Information Systems (GIS). (Open Ended Question) * Please describe your experience using Business Intelligence (BI) Solutions (Qlik, Tableau, Power BI, MicroStrategy, Crystal Reports, etc.) (Open Ended Question) Optional & Required Documents Required Documents Resume Optional Documents
Mar 18, 2024
Full Time
Minimum Qualifications Education and/or Equivalent Experience: Graduation with a Bachelor’s degree from an accredited college or university with major coursework in Business Administration, Public Administration, Social Sciences or related field, to include six (6) semester hours involving or related to statistics and two (2) years of experience in a research field. Or Master’s Degree in Business Administration, Public Administration, Social Sciences or related field and one (1) year of experience. Licenses or Certifications: None. Notes to Applicants The Research Analyst Sr position within the Planning and Research team will analyze data to create actionable reports to respond to request for information, collaborate on strategic initiatives, and provide timely analytic support to department tactical and strategic operations. Austin Police Department continues to develop its data driven strategy to shape the organization and mission. We are looking for partners who share that vision. City of Austin Application: A complete and detailed City of Austin employment application is required to help us better evaluate your qualifications. For each position, please describe your specific experience as it relates to the minimum and preferred qualifications. Please be thorough in completing the employment application and list all experience and education that is relevant to this position. Starting salary will be based on overall relevant experience and education. Application must include job titles, job duties performed, full or part time status. Your work history should include the duties you performed, any supervisory or lead responsibilities, and any equipment or computer software used. CBI : Must pass a Criminal Justice Information Systems ( CJIS ) fingerprint-based background check and maintain CJIS eligibility. Due to CJIS requirements related to system access, the following will result in being disqualified for this position: Felony Convictions, Felony Deferred Adjudication, Class A & B Misdemeanor Deferred Adjudication, Class B Misdemeanor Convictions, an Open Arrest for Any Criminal Offense (Felony or Misdemeanor), and Family Violence Convictions. Please Click here to find more information. Secondary Employment: All Austin Police employees are prohibited from accepting or engaging in any secondary employment that might conflict or interfere with an employee’s duty and responsibility to the Department. APD must review all secondary employment. Employees are required to submit a Secondary Employment Application for review and approval upon being hired with APD , as well as current APD employees considering Secondary employment. Benefits: Working with the Austin Police Department provides a number of health and welfare benefits, such as medical, paid leave time, retirement plan, training opportunities and more. Please click here to find more information. To learn more about working with the City of Austin, click here to watch a short video! EEO /AA statement: The City of Austin is committed to compliance with the Americans with Disabilities Act. If you require reasonable accommodation during the application process or have a question regarding an essential job function, please call (512) 974-3210 or Texas Relay by dialing 7-1-1. The City of Austin will not discriminate against any applicant or employee based on race, creed, color, national origin, sex, gender identity, age, religion, veteran status, disability, or sexual orientation. In addition, the City will not discriminate in employment decisions on the basis of an individual’s AIDS , AIDS Related Complex, or HIV status; nor will the City discriminate against individuals who are perceived to be at risk of HIV infection, or who associate with individuals who are believed to be at risk. Pay Range $26.26 - $31.45hr Hours Monday-Friday 8:00 AM-5:00PM Job Close Date 04/08/2024 Type of Posting External Department Police Regular/Temporary Regular Grant Funded or Pooled Position Not Applicable Category Professional Location 715 E. 8th Street, APD HQ Preferred Qualifications Preferred Experience: Experience with Geographic Information Systems ( GIS ). Experience using Business Intelligence (BI) Solutions (Qlik, Tableau, Power BI, MicroStrategy, Crystal Reports, etc.) Duties, Functions and Responsibilities Essential duties and functions, pursuant to the Americans with Disabilities Act, may include the following. Other related duties may be assigned. Determines issues and identifies parameters for gathering information for a specific project. Plans, designs, and tests research instrumentation and evaluate data to assess reliability and validity of data. Conducts research studies using questionnaires, surveys, interviews, observation methods, case readings. Analyzes trends, policies, procedures using statistical data. Designs methodology for tracking data using various software programs. 6. Authors, edits technical reports using details to support research findings. Consults, makes presentations and makes recommendations using statistical data. Coordinates issues with management and other targeted audiences, serves on committees working with specific research projects. Exchanges results of research data with other departments, agencies or specific technical groups. Reviews legislation, regulations, and policies to determine impact of research results. Formulates strategy for managing issues using statistical data. Responsibilities - Supervision and/or Leadership Exercised: May lead other employees. Knowledge, Skills and Abilities Must possess required knowledge, skills, abilities, and experience and be able to explain and demonstrate, with or without reasonable accommodations, that the essential functions of the job can be performed. Knowledge of statistical methodology. Knowledge of city practice, policy and procedures. Skill in oral and written communications. Skill in handling multiple tasks and prioritizing. Skill in the use of computers and related software. Skill in data analysis and problem solving. Skill in planning and organizing. Ability to assess information and summarize findings. Ability to establish database to maintain or track data. Ability to conduct presentations. Ability to author technical documents. Ability to identify variables and utilizing various resources to gather data. Ability to work with frequent interruptions and changes in priorities. Ability to lead others. Ability to establish and maintain good working relationships with other city employees and the public. Criminal Background Investigation This position has been approved for a Criminal Background Investigation. EEO/ADA The City of Austin is committed to compliance with the Americans with Disabilities Act. If you require reasonable accommodation during the application process or have a question regarding an essential job function, please call (512) 974-3210 or Texas Relay by dialing 7-1-1. The City of Austin will not discriminate against any applicant or employee based on race, creed, color, national origin, sex, gender identity, age, religion, veteran status, disability, or sexual orientation. In addition, the City will not discriminate in employment decisions on the basis of an individual’s AIDS , AIDS Related Complex, or HIV status; nor will the City discriminate against individuals who are perceived to be at risk of HIV infection, or who associate with individuals who are believed to be at risk. Information For City Employees: If you are an employee within the department, are in good standing and meet both the minimum and preferred qualifications, then you will receive an initial interview. Supplemental Questions Required fields are indicated with an asterisk (*). * The minimum qualifications of the Research Analyst Senior position are: Graduation with a Bachelor’s degree from an accredited college or university with major coursework in Business Administration, Public Administration, Social Sciences or related field, to include six (6) semester hours involving or related to statistics and two (2) years of experience in a research field. Or Master's Degree in Business Administration, Public Administration, Social Sciences or related field and one (1) year of experience. Do you meet the minimum qualifications of this position? Yes No * This position requires a criminal background investigation (CBI). By selecting the following, you are acknowledging that you understand if you are selected as a top candidate for this position, you will need a successful Criminal Justice Information System (CJIS) to be hired. I acknowledge and understand this position requires a Criminal Justice Information System (CJIS-Criminal Background Investigation). * Please describe your experience creating and designing informative maps, including any experience with Geographic Information Systems (GIS). (Open Ended Question) * Please describe your experience using Business Intelligence (BI) Solutions (Qlik, Tableau, Power BI, MicroStrategy, Crystal Reports, etc.) (Open Ended Question) Optional & Required Documents Required Documents Resume Optional Documents
Introduction THIS IS A NEW ASSEMBLED EXAMINATION. The eligible list resulting from this examination will cancel any existing list and may last approximately one year, but can be extended. Applications must be in the possession of the Human Resource Services Department by 5:00 p.m. on the Last Day for Filing. Supplemental Questionnaire: A properly completed Supplemental Questionnaire must be submitted with each application. Applications and Supplemental Questionnaires must be in the possession of the Human Resource Services Department by 5:00 p.m. on the Last Day for Filing. Applications will only be accepted online. Failure to submit the Application and Supplemental Questionnaire will result in disqualification. Applications and Supplemental Questionnaires will only be accepted online. DESCRIPTION ABOUT ALAMEDA COUNTY Alameda County is the seventh most populous county in California and is characterized by its rich diversityand culture as one of the most ethnically diverse regions in the Bay Area and the nation. It is home to over 1.6 million people living in 14 incorporated cities as well as six unincorporated communities and rural areas throughout the 821 square miles of the County. The County enjoys a varied geography ranging from urban marinas to rolling open spaces to hillside lakes and streams. THE POSITION Under general direction, to analyze department business system needs, and produce, maintain and update software systems to meet those needs. Information Systems Analysts are responsible for gathering requirements, defining problems and recommending solutions, writing program and database design specifications, modifying existing systems and providing production support for users and their systems. Information Systems Analysts may also prepare instructional material for department staff, act as project manager on projects; and performs related duties as required. CURRENT VACANCIES Thereare immediate full-time vacancies for this position located within the Health Care Services Agency , Probation Department ,and the County Library .However,the eligible list resulting from this recruitmentmay be used to fill future vacancies in other county departments/agencies. IDEAL CANDIDATE In addition to meeting the minimum qualifications stated below, the ideal candidate will have demonstrated a track record of success in the following areas: Performing data administration by creating, maintaining, and defining database structures, data and security management; Strategic problem solving skills; capable of identifying and understanding issues, problems, and opportunities; adept at comparing data from different sources to draw conclusions and choosing an appropriate course of action or solution; and skilled at resolving problems by taking action consistent with known facts, constraints, and probable consequences; Excellent project management skills; able to design, implement, manage and prepare reports for ongoing projects; and coordinate the related resources, personnel and activities for successful project completion; Strong technical knowledge and skill in the areas of information systems technology with the desire and drive to keep up with current developments and trends in related technology systems; Possess understanding of information security, including software and hardware; identifies issues and takes initiative to resolve all security issues; Successfully develops and maintains effective relationships with others; and relates well to people with diverse cultures, interpersonal styles, abilities, motivations, or backgrounds; Excellent interpersonalskills; possesses the ability to interact with key stakeholders, executive management, and leaders, both internally and externally; Possesses political astuteness; shows commitment and the ability to understand diverse interest groups and power bases within an organization; uses the knowledge of the organizational culture in making decisions and perceives implications of such decisions; Experience with relational databases, MS SQL, PostgreSQL, MS Office suite includingMS Access, HTML 5, DHTML, ASP, .Net, Share Point, Oracle, Citrix, Python, Java, Java scripting, visual basic, visual studios, electronic content management like Drupal word press & MS SharePoint, social media development architecture, mobile applications & development technology, TCP/IP networks, VMware virtualization technologies, windows 2008 and onward active directory is highly desirable; Experience with Business Intelligence Reporting Software and Systems such as Business Objects, Yellow Fin, Tableau, r,SPSS, MS Power BI and SSRS (Sql Server Reporting Service); Experience with designing and creating operational and analytical reports. Ability to use reporting requirement received from stakeholders to extract data from source systems, query for desired solution datasets and develop reports to present the results in operational form for day to day usage and analytical form for prediction of trends; and Experience with Salesforce Software; designing and developing application within the Salesforce platform. TRAINING AND EXPERIENCE QUESTIONNAIRE SUBMISSION INSTRUCTIONS : Your completed application, supplemental questionnaire, and the Information Systems Analyst Training and Experience Questionnaire must be submitted by 5pm on the filing deadline ; Application and Supplemental Questionnaire must be submitted online only; Your completed Training and Experience Questionnaire must be submitted by e-mail . E-mail address: Angelica.Cuevas@acgov.org Subjectline:YourFirstName_YourLastName_ISAin the subject line of your e-mail (example:Angelica_Cuevas_ISA). To access the Information Systems Analyst Training and Experience Questionnaire click on the below link: Training and Experience Questionnaire MINIMUM QUALIFICATIONS Education: The equivalent to graduation from an accredited four-year college or university (120 semester units or 180 quarter units) with a major in MIS, Computer Science, Computer Engineering or equivalent. AND Experience: The equivalent of two years of full-time experience in planning, developing and administering complex information technology systems and applications. OR II Experience: The equivalent of three years of full time experience in planning, developing and administering multiple, complex information technology systems and applications. Certification: Professional Certification as a Microsoft Certified Solution Developer, Sun Certified Java Programmer, Sun Certified Java Developer or equivalent can be substituted for one year of experience. NOTE: The Civil Service Commission may modify the above Minimum Qualifications in the announcement of an examination. KNOWLEDGE AND SKILLS The most suitably qualified candidates will possess the following competencies: Knowledge of: Modern computer technology used to plan, develop and administer computers and network systems. Information technology concepts. Methodologies for analyzing systems, procedures and workflow. Office software applications. Functions and capabilities of database systems. World Wide Web technology. Principles of network infrastructure. Software programming languages such as Visual Studio.NET, Visual C++, C#, Visual Basic, ASP.NET, VB.NET, XML, XSL, ASP, JavaScript, CSS, DHTML, Java / J2EE, JSP, Struts, Oracle, SQL server, IBM WebSphere, BEA WebLogic, Jboss. Specific programming languages may be selectively required for individual positions as needed by the recruiting departments. Ability to: Function as a system(s) administrator. Maintain and modify existing office software applications. Analyze and problem solve. Make effective decisions. Plan and organize. Identify and correct problems with computers and related equipment. Analyze problems related to database design, system interactions and cross platform issues. Prepare and maintain documentation, records and logs. Communicate effectively both orally and in writing. Interface with users at all levels of the organization. EXAMINATION COMPONENTS THE EXAMINATION WILL CONSIST OF THE FOLLOWING STEPS: A review of applicants' applications to verify possession of minimum requirements. Those applicants who possess the minimum requirements for the class will move on to the next step in the examination process; A review of candidates’ Supplemental Questionnaires a nd Training and Experience Questionnaires to determine the best qualified. Those candidates considered the best qualified will move on to the final step in the examination process. An oral interview which will be weighted as 100% of the candidate's final examination score. The oral interview may contain situational exercises. ** CANDIDATES MUST ATTAIN A QUALIFYING RATING ON EACH PORTION OF THIS EXAMINATION. ** We reserve the right to make changes to the announced examination components. Alameda County utilizes a Civil Service Selection System founded on merit. Such a system is competitive and based on broad recruitment efforts and equal opportunity for qualified applicants to test in an examination process designed to determine the qualifications, fitness and ability of competitors to perform duties of the vacant position. Many of our recruitments are targeted and specific to the needs of a current vacant position, in which case, the eligible list may be exclusively used for that current vacant position. Other recruitments may be more broadly used for both current and future vacancies, or for other alternate jobs with comparable scopes of work. To learn more about our recruitment and selection process, please visit the “What You Need to Know” section of our website, www.acgov.org/hrs RECRUITMENT AND SELECTION PLAN Applicants will be informed via email with reasonable notice in advance of any examination process which will require their attendance. The following dates are tentative and subject to change based on the needs of the Agency. TENTATIVE RECRUITMENT PLAN: Deadline for Filing: 5:00:00 PM Thursday, April 11, 2024 Review of Minimum Qualifications: Monday, April 22, 2024 Review of Supplemental Questionnaire for Best Qualified Week of May 6, 2024 Virtual Civil Service Pre-Recorded Oral Examination: Week of May 20, 2024 Notification of Results: Week of June 17, 2024 TENTATIVE SELECTION PLAN: Departmental Hiring Interviews: TBD WE RESERVE THE RIGHT TO MAKE CHANGES TO THE ANNOUNCED RECRUITMENT & SELECTION PLAN Alameda County and the Human Resource Services Department will make reasonable efforts in the examination and/or selection process to accommodate qualified individuals with disabilities and/or medical conditions in accordance/compliance with the State Fair Employment and Housing Act (FEHA), Federal Americans with Disabilities Act (ADA) Alameda County’s Reasonable Accommodation Policy and applicable statutes. To request an accommodation due to a disability/medical condition during this or other phases of the examination/selection process, please contact the assigned Human Resources Representative listed on the job announcement before the last date of filing . Alameda County requires applicants to provide supporting documentation to substantiate a request for reasonable accommodation. In order to qualify for a reasonable accommodation, applicants must have a disability/medical condition pursuant to the ADA, FEHA and applicable statutes. For more information regarding our Reasonable Accommodation procedures, please visit our website, www.acgov.org/hrs . BENEFITS Alameda County offers a comprehensive and competitive benefits package that affords wide-ranging health care options to meet the different needs of a diverse workforce and their families. We also sponsor many different employee discount, fitness and health screening programs focused on overall well being. These benefits include but are not limited to*: For your Health & Well-Being Medical - HMO & PPO Plans Dental - HMO & PPO Plans Vision or Vision Reimbursement Share the Savings Basic Life Insurance Supplemental Life Insurance (with optional dependent coverage for eligible employees) Accidental Death and Dismemberment Insurance County Allowance Credit Flexible Spending Accounts - Health FSA, Dependent Care and Adoption Assistance Short-Term Disability Insurance Long-Term Disability Insurance Voluntary Benefits - Accident Insurance, Critical Illness, Hospital Indemnity and Legal Services Employee Assistance Program For your Financial Future Retirement Plan - (Defined Benefit Pension Plan) Deferred Compensation Plan (457 Plan or Roth Plan) For your Work/Life Balance 12 paid holidays Floating Holidays Vacation and sick leave accrual Vacation purchase program Management Paid Leave** Catastrophic Sick Leave Group Auto/Home Insurance Pet Insurance Commuter Benefits Program Guaranteed Ride Home Employee Wellness Program (e.g. At Work Fitness, Incentive Based Programs, Gym Membership Discounts) Employee Discount Program (e.g. theme parks, cell phone, etc.) Child Care Resources 1 st United Services Credit Union *Eligibility is determined by Alameda County and offerings may vary by collective bargaining agreement. This provides a brief summary of the benefits offered and can be subject to change. ** Non-exempt management employees are entitled to up to three days of management paid leave. Exempt management employees are entitled to up to seven days of management paid leave. Conclusion All notices related to County recruitments for which you have applied will be sent/delivered via email. Please add @jobaps.com, @acgov.org, Noreplyalamedacountyhr@acgov.org and Noreply@jobaps.com as accepted addresses to any email blocking or spam filtering program you may use. If you do not do this, your email blocking or spam filtering program may block receipt of the notices regarding your application for recruitments. You are also strongly advised to regularly log into your County of Alameda online application account to check for notices that may have been sent to you. All email notices that will be sent to you will also be kept in your personal online application account. You will be able to view all of your notices in your online application account by clicking on the "My applications" button on the Current Job Openings page. Please take the steps recommended above to ensure you do not miss any notices about a recruitment for which you have applied. The County of Alameda is not responsible for notices that are not read, received or accessed by any applicant for a County recruitment. NOTE: All notices are generated through an automated email notification system. Replies to the email boxes Noreply@jobaps.com and noreplyalamedacountyhr@acgov.org are routed to unmonitored mailboxes. If you have questions, please go to our website at www.acgov.org/hrs . You may also contact the Human Resources Analyst listed on the job announcement for the recruitment for which you have applied. Angelica Cuevas, HR Analyst Human Resource Services, County of Alameda (510) 271-5154 or email Angelica.Cuevas@acgov.org www.acgov.org/hrs DISASTER SERVICE WORKER All Alameda County employees are designated Disaster Service Workers through state and local law. Employment with the County requires the affirmation of a loyalty oath to this effect. Employees are required to report to work as ordered in the event of an emergency. EQUAL EMPLOYMENT OPPORTUNITY Alameda County has a diverse workforce, that is representative of the communities we serve, and is proud to be an equal opportunity employer. All aspects of employment are based on merit, competence, performance and business need. Alameda County does not discriminate in employment on the basis of, race, color, religion, sex (including pregnancy and gender identity), national origin, political affiliation, sexual orientation, marital status, disability, genetic information, age, membership in an employee organization, retaliation, parental status, military service, or other non-merit factors protected under federal, state and local law. Alameda County celebrates diversity and is committed to creating an inclusive, and welcoming workplace environment. Closing Date/Time: 4/11/2024 5:00:00 PM
Mar 19, 2024
Full Time
Introduction THIS IS A NEW ASSEMBLED EXAMINATION. The eligible list resulting from this examination will cancel any existing list and may last approximately one year, but can be extended. Applications must be in the possession of the Human Resource Services Department by 5:00 p.m. on the Last Day for Filing. Supplemental Questionnaire: A properly completed Supplemental Questionnaire must be submitted with each application. Applications and Supplemental Questionnaires must be in the possession of the Human Resource Services Department by 5:00 p.m. on the Last Day for Filing. Applications will only be accepted online. Failure to submit the Application and Supplemental Questionnaire will result in disqualification. Applications and Supplemental Questionnaires will only be accepted online. DESCRIPTION ABOUT ALAMEDA COUNTY Alameda County is the seventh most populous county in California and is characterized by its rich diversityand culture as one of the most ethnically diverse regions in the Bay Area and the nation. It is home to over 1.6 million people living in 14 incorporated cities as well as six unincorporated communities and rural areas throughout the 821 square miles of the County. The County enjoys a varied geography ranging from urban marinas to rolling open spaces to hillside lakes and streams. THE POSITION Under general direction, to analyze department business system needs, and produce, maintain and update software systems to meet those needs. Information Systems Analysts are responsible for gathering requirements, defining problems and recommending solutions, writing program and database design specifications, modifying existing systems and providing production support for users and their systems. Information Systems Analysts may also prepare instructional material for department staff, act as project manager on projects; and performs related duties as required. CURRENT VACANCIES Thereare immediate full-time vacancies for this position located within the Health Care Services Agency , Probation Department ,and the County Library .However,the eligible list resulting from this recruitmentmay be used to fill future vacancies in other county departments/agencies. IDEAL CANDIDATE In addition to meeting the minimum qualifications stated below, the ideal candidate will have demonstrated a track record of success in the following areas: Performing data administration by creating, maintaining, and defining database structures, data and security management; Strategic problem solving skills; capable of identifying and understanding issues, problems, and opportunities; adept at comparing data from different sources to draw conclusions and choosing an appropriate course of action or solution; and skilled at resolving problems by taking action consistent with known facts, constraints, and probable consequences; Excellent project management skills; able to design, implement, manage and prepare reports for ongoing projects; and coordinate the related resources, personnel and activities for successful project completion; Strong technical knowledge and skill in the areas of information systems technology with the desire and drive to keep up with current developments and trends in related technology systems; Possess understanding of information security, including software and hardware; identifies issues and takes initiative to resolve all security issues; Successfully develops and maintains effective relationships with others; and relates well to people with diverse cultures, interpersonal styles, abilities, motivations, or backgrounds; Excellent interpersonalskills; possesses the ability to interact with key stakeholders, executive management, and leaders, both internally and externally; Possesses political astuteness; shows commitment and the ability to understand diverse interest groups and power bases within an organization; uses the knowledge of the organizational culture in making decisions and perceives implications of such decisions; Experience with relational databases, MS SQL, PostgreSQL, MS Office suite includingMS Access, HTML 5, DHTML, ASP, .Net, Share Point, Oracle, Citrix, Python, Java, Java scripting, visual basic, visual studios, electronic content management like Drupal word press & MS SharePoint, social media development architecture, mobile applications & development technology, TCP/IP networks, VMware virtualization technologies, windows 2008 and onward active directory is highly desirable; Experience with Business Intelligence Reporting Software and Systems such as Business Objects, Yellow Fin, Tableau, r,SPSS, MS Power BI and SSRS (Sql Server Reporting Service); Experience with designing and creating operational and analytical reports. Ability to use reporting requirement received from stakeholders to extract data from source systems, query for desired solution datasets and develop reports to present the results in operational form for day to day usage and analytical form for prediction of trends; and Experience with Salesforce Software; designing and developing application within the Salesforce platform. TRAINING AND EXPERIENCE QUESTIONNAIRE SUBMISSION INSTRUCTIONS : Your completed application, supplemental questionnaire, and the Information Systems Analyst Training and Experience Questionnaire must be submitted by 5pm on the filing deadline ; Application and Supplemental Questionnaire must be submitted online only; Your completed Training and Experience Questionnaire must be submitted by e-mail . E-mail address: Angelica.Cuevas@acgov.org Subjectline:YourFirstName_YourLastName_ISAin the subject line of your e-mail (example:Angelica_Cuevas_ISA). To access the Information Systems Analyst Training and Experience Questionnaire click on the below link: Training and Experience Questionnaire MINIMUM QUALIFICATIONS Education: The equivalent to graduation from an accredited four-year college or university (120 semester units or 180 quarter units) with a major in MIS, Computer Science, Computer Engineering or equivalent. AND Experience: The equivalent of two years of full-time experience in planning, developing and administering complex information technology systems and applications. OR II Experience: The equivalent of three years of full time experience in planning, developing and administering multiple, complex information technology systems and applications. Certification: Professional Certification as a Microsoft Certified Solution Developer, Sun Certified Java Programmer, Sun Certified Java Developer or equivalent can be substituted for one year of experience. NOTE: The Civil Service Commission may modify the above Minimum Qualifications in the announcement of an examination. KNOWLEDGE AND SKILLS The most suitably qualified candidates will possess the following competencies: Knowledge of: Modern computer technology used to plan, develop and administer computers and network systems. Information technology concepts. Methodologies for analyzing systems, procedures and workflow. Office software applications. Functions and capabilities of database systems. World Wide Web technology. Principles of network infrastructure. Software programming languages such as Visual Studio.NET, Visual C++, C#, Visual Basic, ASP.NET, VB.NET, XML, XSL, ASP, JavaScript, CSS, DHTML, Java / J2EE, JSP, Struts, Oracle, SQL server, IBM WebSphere, BEA WebLogic, Jboss. Specific programming languages may be selectively required for individual positions as needed by the recruiting departments. Ability to: Function as a system(s) administrator. Maintain and modify existing office software applications. Analyze and problem solve. Make effective decisions. Plan and organize. Identify and correct problems with computers and related equipment. Analyze problems related to database design, system interactions and cross platform issues. Prepare and maintain documentation, records and logs. Communicate effectively both orally and in writing. Interface with users at all levels of the organization. EXAMINATION COMPONENTS THE EXAMINATION WILL CONSIST OF THE FOLLOWING STEPS: A review of applicants' applications to verify possession of minimum requirements. Those applicants who possess the minimum requirements for the class will move on to the next step in the examination process; A review of candidates’ Supplemental Questionnaires a nd Training and Experience Questionnaires to determine the best qualified. Those candidates considered the best qualified will move on to the final step in the examination process. An oral interview which will be weighted as 100% of the candidate's final examination score. The oral interview may contain situational exercises. ** CANDIDATES MUST ATTAIN A QUALIFYING RATING ON EACH PORTION OF THIS EXAMINATION. ** We reserve the right to make changes to the announced examination components. Alameda County utilizes a Civil Service Selection System founded on merit. Such a system is competitive and based on broad recruitment efforts and equal opportunity for qualified applicants to test in an examination process designed to determine the qualifications, fitness and ability of competitors to perform duties of the vacant position. Many of our recruitments are targeted and specific to the needs of a current vacant position, in which case, the eligible list may be exclusively used for that current vacant position. Other recruitments may be more broadly used for both current and future vacancies, or for other alternate jobs with comparable scopes of work. To learn more about our recruitment and selection process, please visit the “What You Need to Know” section of our website, www.acgov.org/hrs RECRUITMENT AND SELECTION PLAN Applicants will be informed via email with reasonable notice in advance of any examination process which will require their attendance. The following dates are tentative and subject to change based on the needs of the Agency. TENTATIVE RECRUITMENT PLAN: Deadline for Filing: 5:00:00 PM Thursday, April 11, 2024 Review of Minimum Qualifications: Monday, April 22, 2024 Review of Supplemental Questionnaire for Best Qualified Week of May 6, 2024 Virtual Civil Service Pre-Recorded Oral Examination: Week of May 20, 2024 Notification of Results: Week of June 17, 2024 TENTATIVE SELECTION PLAN: Departmental Hiring Interviews: TBD WE RESERVE THE RIGHT TO MAKE CHANGES TO THE ANNOUNCED RECRUITMENT & SELECTION PLAN Alameda County and the Human Resource Services Department will make reasonable efforts in the examination and/or selection process to accommodate qualified individuals with disabilities and/or medical conditions in accordance/compliance with the State Fair Employment and Housing Act (FEHA), Federal Americans with Disabilities Act (ADA) Alameda County’s Reasonable Accommodation Policy and applicable statutes. To request an accommodation due to a disability/medical condition during this or other phases of the examination/selection process, please contact the assigned Human Resources Representative listed on the job announcement before the last date of filing . Alameda County requires applicants to provide supporting documentation to substantiate a request for reasonable accommodation. In order to qualify for a reasonable accommodation, applicants must have a disability/medical condition pursuant to the ADA, FEHA and applicable statutes. For more information regarding our Reasonable Accommodation procedures, please visit our website, www.acgov.org/hrs . BENEFITS Alameda County offers a comprehensive and competitive benefits package that affords wide-ranging health care options to meet the different needs of a diverse workforce and their families. We also sponsor many different employee discount, fitness and health screening programs focused on overall well being. These benefits include but are not limited to*: For your Health & Well-Being Medical - HMO & PPO Plans Dental - HMO & PPO Plans Vision or Vision Reimbursement Share the Savings Basic Life Insurance Supplemental Life Insurance (with optional dependent coverage for eligible employees) Accidental Death and Dismemberment Insurance County Allowance Credit Flexible Spending Accounts - Health FSA, Dependent Care and Adoption Assistance Short-Term Disability Insurance Long-Term Disability Insurance Voluntary Benefits - Accident Insurance, Critical Illness, Hospital Indemnity and Legal Services Employee Assistance Program For your Financial Future Retirement Plan - (Defined Benefit Pension Plan) Deferred Compensation Plan (457 Plan or Roth Plan) For your Work/Life Balance 12 paid holidays Floating Holidays Vacation and sick leave accrual Vacation purchase program Management Paid Leave** Catastrophic Sick Leave Group Auto/Home Insurance Pet Insurance Commuter Benefits Program Guaranteed Ride Home Employee Wellness Program (e.g. At Work Fitness, Incentive Based Programs, Gym Membership Discounts) Employee Discount Program (e.g. theme parks, cell phone, etc.) Child Care Resources 1 st United Services Credit Union *Eligibility is determined by Alameda County and offerings may vary by collective bargaining agreement. This provides a brief summary of the benefits offered and can be subject to change. ** Non-exempt management employees are entitled to up to three days of management paid leave. Exempt management employees are entitled to up to seven days of management paid leave. Conclusion All notices related to County recruitments for which you have applied will be sent/delivered via email. Please add @jobaps.com, @acgov.org, Noreplyalamedacountyhr@acgov.org and Noreply@jobaps.com as accepted addresses to any email blocking or spam filtering program you may use. If you do not do this, your email blocking or spam filtering program may block receipt of the notices regarding your application for recruitments. You are also strongly advised to regularly log into your County of Alameda online application account to check for notices that may have been sent to you. All email notices that will be sent to you will also be kept in your personal online application account. You will be able to view all of your notices in your online application account by clicking on the "My applications" button on the Current Job Openings page. Please take the steps recommended above to ensure you do not miss any notices about a recruitment for which you have applied. The County of Alameda is not responsible for notices that are not read, received or accessed by any applicant for a County recruitment. NOTE: All notices are generated through an automated email notification system. Replies to the email boxes Noreply@jobaps.com and noreplyalamedacountyhr@acgov.org are routed to unmonitored mailboxes. If you have questions, please go to our website at www.acgov.org/hrs . You may also contact the Human Resources Analyst listed on the job announcement for the recruitment for which you have applied. Angelica Cuevas, HR Analyst Human Resource Services, County of Alameda (510) 271-5154 or email Angelica.Cuevas@acgov.org www.acgov.org/hrs DISASTER SERVICE WORKER All Alameda County employees are designated Disaster Service Workers through state and local law. Employment with the County requires the affirmation of a loyalty oath to this effect. Employees are required to report to work as ordered in the event of an emergency. EQUAL EMPLOYMENT OPPORTUNITY Alameda County has a diverse workforce, that is representative of the communities we serve, and is proud to be an equal opportunity employer. All aspects of employment are based on merit, competence, performance and business need. Alameda County does not discriminate in employment on the basis of, race, color, religion, sex (including pregnancy and gender identity), national origin, political affiliation, sexual orientation, marital status, disability, genetic information, age, membership in an employee organization, retaliation, parental status, military service, or other non-merit factors protected under federal, state and local law. Alameda County celebrates diversity and is committed to creating an inclusive, and welcoming workplace environment. Closing Date/Time: 4/11/2024 5:00:00 PM
CITY OF ORLANDO, FL
Orlando, Florida, United States
Description Who We Are Orlando, The City Beautiful For most of Orlando’s history we’ve been the place everyone wants to visit. Today, we’re also the place where everyone wants to live and do business. List after list has Orlando as one of the fastest growing cities in America. We’re transitioning from our role as the young upstart to a more mature, global city. This didn’t happen by accident. Together as a community, we developed a shared vision for our city focused on creating partnerships and we’ve transformed Orlando from a place that was packed with potential into a city on the rise. Our vision ensures we are an inclusive, compassionate community that is generating jobs, becoming the most sustainable city in the nation, keeping our community safe, making it easier to get around, and increasing the quality of life. Together, we can continue realizing all our city’s potential. Come be part of our community with the City of Orlando. Nature of Work Develops, maintains, and enhances new and existing reporting systems according to customer feedback and independent understanding of business operations. Data is turned into information and information into insights that directly influence and advance organizational capability. Performs professional and administrative work and provides direct Business Intelligence support to all levels and disciplines of Economic Development, with emphasis on Building and Development functions that are of key interest to City of Orlando customers. Prepares and delivers presentations that articulate business results to diverse audiences. Capable of leading changes to business processes, systems and technology, and driving faster adoption and higher proficiency amongst staff. Work is performed under the general direction of the Information Platforms Manager and is reviewed through discussions and reports submitted.. Minimum Requirements Minimum Requirements Bachelor's degree in Information Management, Computer Science, Statistics, Finance/Economics or related field required and three (3) or more years experience in data analysis and/or custom report development for end users required ; or an equivalent combination of education, training, and experience. Direct experience creating SQL queries, tables, stored procedures, and views in relational database environment required. Direct experience with business intelligence applications such as Power BI or Tableau preferred. Valid Florida driver’s license is required. IMPORTANT: To be eligible to proceed forward in the application process, applicants must meet the minimum qualifications listed in the position description. Please ensure your application provides details of all relevant experience related to the position. If you have questions or need clarification concerning the position or application process, please contact Human Resources at jobs@orlando.gov or 407.246.2062. Supplemental Information City of Orlando Benefits If this posting indicates a degree is required, the following experience will apply in lieu of any degree as follows: Two (2) years of direct experience for an associate degree; Four (4) years of direct experience for a bachelor's degree; Six (6) years of direct experience for a master's degree; or Nine (9) years of direct experience for a doctoral degree Closing Date/Time: 3/29/2024 5:00 PM Eastern
Mar 16, 2024
Full Time
Description Who We Are Orlando, The City Beautiful For most of Orlando’s history we’ve been the place everyone wants to visit. Today, we’re also the place where everyone wants to live and do business. List after list has Orlando as one of the fastest growing cities in America. We’re transitioning from our role as the young upstart to a more mature, global city. This didn’t happen by accident. Together as a community, we developed a shared vision for our city focused on creating partnerships and we’ve transformed Orlando from a place that was packed with potential into a city on the rise. Our vision ensures we are an inclusive, compassionate community that is generating jobs, becoming the most sustainable city in the nation, keeping our community safe, making it easier to get around, and increasing the quality of life. Together, we can continue realizing all our city’s potential. Come be part of our community with the City of Orlando. Nature of Work Develops, maintains, and enhances new and existing reporting systems according to customer feedback and independent understanding of business operations. Data is turned into information and information into insights that directly influence and advance organizational capability. Performs professional and administrative work and provides direct Business Intelligence support to all levels and disciplines of Economic Development, with emphasis on Building and Development functions that are of key interest to City of Orlando customers. Prepares and delivers presentations that articulate business results to diverse audiences. Capable of leading changes to business processes, systems and technology, and driving faster adoption and higher proficiency amongst staff. Work is performed under the general direction of the Information Platforms Manager and is reviewed through discussions and reports submitted.. Minimum Requirements Minimum Requirements Bachelor's degree in Information Management, Computer Science, Statistics, Finance/Economics or related field required and three (3) or more years experience in data analysis and/or custom report development for end users required ; or an equivalent combination of education, training, and experience. Direct experience creating SQL queries, tables, stored procedures, and views in relational database environment required. Direct experience with business intelligence applications such as Power BI or Tableau preferred. Valid Florida driver’s license is required. IMPORTANT: To be eligible to proceed forward in the application process, applicants must meet the minimum qualifications listed in the position description. Please ensure your application provides details of all relevant experience related to the position. If you have questions or need clarification concerning the position or application process, please contact Human Resources at jobs@orlando.gov or 407.246.2062. Supplemental Information City of Orlando Benefits If this posting indicates a degree is required, the following experience will apply in lieu of any degree as follows: Two (2) years of direct experience for an associate degree; Four (4) years of direct experience for a bachelor's degree; Six (6) years of direct experience for a master's degree; or Nine (9) years of direct experience for a doctoral degree Closing Date/Time: 3/29/2024 5:00 PM Eastern
City of Grand Prairie, TX
Grand Prairie, Texas, United States
Job Summary We are looking for a Crime Analyst for the Police Department to join our team! We offer competitive salaries, comprehensive benefits, and opportunities for career growth and development. Our team is committed to fostering a diverse and inclusive workplace culture, where all employees feel valued and respected. The purpose of this position is to provide timely and pertinent information relative to crime patterns and trends; to assist operational and administrative personnel in planning the deployment of resources for the prevention and suppression of criminal activities; aiding the investigative process by providing information which helps increase the timely apprehension of offenders and the clearance of cases. Essential Job Functions ESSENTIAL FUNCTIONS: Tactical analysis: develops and maintains methods to identify emergent crime patterns and series; analyzes these activities and contributes to intervention efforts; supports the investigative functions of the police department; uses unrestricted access to information concerning police calls for service, crime reports, cases, arrest records, field interviews, citations, known offender files and other internal police data and resources to identify, analyze and assist in resolving criminal activity. Strategic analysis: develops, maintains, and analyzes internal measurements and forecasting of long-term public safety related activity for use in problem solving, intervention and reduction efforts of the police department. Operational analysis: by provides information and analysis to officers, supervisors and commanders including decision-supporting intelligence and information which improves police awareness and judgment in a timely and reliable manner. Administrative analysis: provides information and analysis regarding police resources including manpower and resource allocation and redistricting; provides forecasts and interpretations of future crime statistics; identifies and recommends methods to develop agency tactics, strategies, and long range plans for crime control and prevention. Researches, complies, analyzes and interprets statistical data from a variety of sources including offense and arrest reports, census, economic and demographic reports and related data; researches and tracks modus operandi factors and discerns crime series or patterns by studying and linking common spatial and temporal factors and follows up by reporting information at patrol briefings and to departments, command staff, city council and in public forums; Regular and dependable attendance is required. All other duties as assigned by a supervisor/manager within your department/division. PREFERRED SKILLS: Professional experience performing research by way of analyzing data, producing statistics, and creating products of findings and/or recommendations; Crime Analysis experience is preferred. Ability to use SQL Server Management Studio to design and build relational database queries. Ability to design, develop, and distribute interactive reports using business intelligence applications (such as Crystal Reports and/or Power BI), connect to databases, and create formulas and functions. Familiarity in creating crime data maps and graphical analysis using Geographic Information Systems. Familiarity with commonly used law enforcement or public safety software, CAD/RMS applications, and databases. Scripting language knowledge is a plus (Python, JavaScript, Crystal Syntax). Minimum Qualifications Education: Bachelor's degree in Criminal Justice or other closely related field OR Any combination of related education, experience, certifications and licenses that will result in a candidate successfully performing the essential functions of the job Experience: At least six months of experience in performing administrative duties; experience in Crime Analysis is preferred. Licenses : Valid Driver's License required Certifications Required: None. Additional Information Candidate will be required to pass pre-employment screening which includes drug screen, polygraph, psychological, and background investigation. The City offers a full range of benefits for full time employees, including, but not limited to the plans as defined in the Benefits Guide. Summary of Benefits Closing Date/Time: 4/26/2024 5:00 PM Central
Mar 08, 2024
Full Time
Job Summary We are looking for a Crime Analyst for the Police Department to join our team! We offer competitive salaries, comprehensive benefits, and opportunities for career growth and development. Our team is committed to fostering a diverse and inclusive workplace culture, where all employees feel valued and respected. The purpose of this position is to provide timely and pertinent information relative to crime patterns and trends; to assist operational and administrative personnel in planning the deployment of resources for the prevention and suppression of criminal activities; aiding the investigative process by providing information which helps increase the timely apprehension of offenders and the clearance of cases. Essential Job Functions ESSENTIAL FUNCTIONS: Tactical analysis: develops and maintains methods to identify emergent crime patterns and series; analyzes these activities and contributes to intervention efforts; supports the investigative functions of the police department; uses unrestricted access to information concerning police calls for service, crime reports, cases, arrest records, field interviews, citations, known offender files and other internal police data and resources to identify, analyze and assist in resolving criminal activity. Strategic analysis: develops, maintains, and analyzes internal measurements and forecasting of long-term public safety related activity for use in problem solving, intervention and reduction efforts of the police department. Operational analysis: by provides information and analysis to officers, supervisors and commanders including decision-supporting intelligence and information which improves police awareness and judgment in a timely and reliable manner. Administrative analysis: provides information and analysis regarding police resources including manpower and resource allocation and redistricting; provides forecasts and interpretations of future crime statistics; identifies and recommends methods to develop agency tactics, strategies, and long range plans for crime control and prevention. Researches, complies, analyzes and interprets statistical data from a variety of sources including offense and arrest reports, census, economic and demographic reports and related data; researches and tracks modus operandi factors and discerns crime series or patterns by studying and linking common spatial and temporal factors and follows up by reporting information at patrol briefings and to departments, command staff, city council and in public forums; Regular and dependable attendance is required. All other duties as assigned by a supervisor/manager within your department/division. PREFERRED SKILLS: Professional experience performing research by way of analyzing data, producing statistics, and creating products of findings and/or recommendations; Crime Analysis experience is preferred. Ability to use SQL Server Management Studio to design and build relational database queries. Ability to design, develop, and distribute interactive reports using business intelligence applications (such as Crystal Reports and/or Power BI), connect to databases, and create formulas and functions. Familiarity in creating crime data maps and graphical analysis using Geographic Information Systems. Familiarity with commonly used law enforcement or public safety software, CAD/RMS applications, and databases. Scripting language knowledge is a plus (Python, JavaScript, Crystal Syntax). Minimum Qualifications Education: Bachelor's degree in Criminal Justice or other closely related field OR Any combination of related education, experience, certifications and licenses that will result in a candidate successfully performing the essential functions of the job Experience: At least six months of experience in performing administrative duties; experience in Crime Analysis is preferred. Licenses : Valid Driver's License required Certifications Required: None. Additional Information Candidate will be required to pass pre-employment screening which includes drug screen, polygraph, psychological, and background investigation. The City offers a full range of benefits for full time employees, including, but not limited to the plans as defined in the Benefits Guide. Summary of Benefits Closing Date/Time: 4/26/2024 5:00 PM Central
Sacramento County, CA
Sacramento, California, United States
The Position Come join one of Forbes Magazine's Best Employers ! This is a continuous filing exam. Next filing cut-offs are at 5:00 pm on: 3/18/24, 6/18/24, 9/18/24, 12/18/24 Level 1 - $6,721.62- $8,579.92/month Level 2 - $7,464.58 - $9,526.50/month Information Technology Applications Analyst I/IIperforms professional duties related to the analysis, design, development, maintenance and administration of computer applications to meet business needs. Incumbents may perform duties within Application Development and/or Database Architecture. The Information Technology (IT) Applications Analyst is a single class with two salary levels. Positions in this class are flexibly staffed and the level at which appointments are made are at the discretion of the appointing authority. Examples of Knowledge and Abilities Knowledge Of: General operations, services, concepts, terms and activities common to a comprehensive, state-of-the-art information systems program Principles, methods and techniques used in designing, developing, testing, implementing, and maintaining computer software systems Software systems development lifecycle Data processing techniques, including the types of hardware and software currently used to process data with different levels of complexity Basic project management principles and techniques such as organizing and managing a project, developing schedules, identifying critical paths, and breaking down a project into individual tasks Structured analysis and database concepts Industry standard hardware, software , operating systems and database software Tools and equipment used in testing the functionality of computer applications Principles, practices, and techniques of troubleshooting computer software problems and of providing quality customer service Methods and techniques of developing and presenting technical documentation and training materials Principles and practices of technical documentation Modern office procedures, methods and equipment Various programming and scripting languages Program design and analysis Test plan and test case development and use The software development lifecycle which includes planning the application layers, designing distributed applications, configuring state management, and designing a caching strategy Mobile and web application design and development Database architecture and administration; design methods and techniques; security methods, procedures and best practices Related data/file management tools Techniques for defining logical relationships among data, processes or events Installing and configuring databases Maintaining databases (backups, restores, configuration, integrity, snapshots, maintenance plans), server instances and security Data management tasks (import and export data, manage partitions, data compression, maintain indexes, manage collations) Optimizing databases for performance Implementing high availability, data warehousing and business intelligence platforms Ability To: Recognize problems; gather, analyze and evaluate data and information in order to reason logically; draw valid conclusions; take appropriate actions and/or make appropriate recommendations Research, design, implement and maintain various software technology solutions, including new technology, in order to improve County processes or services Communicate technical information to a wide variety of users Interpret and explain pertinent County and Department policies and procedures Explain the values and limitations of services requested Recognize that changes made on a local level can affect services and equipment at the system wide level and take appropriate precautions Plan, organize, and prioritize multiple projects/assignments to ensure that deadlines are met Learn and utilize specialized terminology if needed by the specific assignment Interpret and apply technical information pertaining to computer and network systems Adapt quickly to changes in policies, procedures, assignments and work locations including the environment Communicate effectively, both verbally and in writing Establish and maintain effective working relationships with those encountered during the course of the work; promote and maintain a team environment Prepare and maintain documentation for procedures, processes, and tables related to area of assignment Read, comprehend, apply, and retain technical publications and documentation Read and interpret source code from the County's commonly used programming languages; develop a working knowledge of new programming languages Write, revise, and maintain computer programs based on established specifications, using various computer languages and/or database platforms Work with source code control systems to store and retrieve application's source code Troubleshoot and repair a variety of application issues using appropriate program testing methods and tools Troubleshoot database related problems Ensure maximum database availability and that data integrity is maintained Design and modify database structures Manage complex databases and develop queries for common purpose Use Enterprise Database Management Studios Employment Qualifications Minimum Qualifications: Either: 1. A Bachelor's Degree or higher from an accredited college or university in Computer Science, Information Technology, or other field closely related to the intent of the class. Or: 2. Four (4) years of full-time, paid technical experience that demonstrates the ability to perform duties in design, development, maintenance or administration of computer applications and/or database architecture. Or: 3. Four (4) years of full-time, paid experience in Sacramento County service providing user support in technology; system, software/application and legacy troubleshooting; problem resolution; review of business processes and communication of user requirements/problems to a vendor or statewide system. Note: Education from an accredited college or university with major course work in Computer Science, Information Technology, or other field closely related to the intent of the class, may be substituted for the required experience on a year-for-year basis; 30 semester units (45 quarter units) equal one year experience. Note: If the word "experience" is referenced in the minimum qualifications, it means full-time paid experience unless the minimum qualification states that volunteer experience is acceptable. Part-time paid experience may be accumulated and pro-rated to meet the total experience requirements. Note: If the minimum qualifications include an educational or certificate/license requirement, applicants must submit proof of requirements with the application. Failure to submit proof of requirements may result in disqualification from the examination. Unofficial transcripts are acceptable. For guidelines on submitting acceptable proof of educational requirements, please click here or speak to someone in our office before the cut-off date listed in this notice. GENERAL QUALIFICATIONS Criminal History and Background Checks: The County may access criminal history information on candidates who have accepted a conditional offer of appointment for this class consistent with the provisions of Board of Supervisors Resolution No. 82-602, Personnel Policies and Procedures B-5, and applicable federal and state laws. The County shall not consider for employment any candidate who has been convicted of a felony or misdemeanor that relates to or impacts the candidate's ability to perform the job duties of this class unless it is determined that mitigating circumstances exist. For purposes of accessing criminal history information, the candidate will be fingerprinted. A subsequent arrest notification may be obtained. The County may also conduct a background check on the candidate prior to appointment to a position within this class. The background check may include personal and professional reference checks, credit history checks where authorized by Labor Code section 1024.5, Social Security Number verification, professional license/registration verification, military service information and driving history. Information obtained in the course of this background check will be considered by the appointing authority in the selection process. In obtaining such information, the County will comply with applicable consent and disclosure practices in the Fair Credit Reporting Act and the California Investigative Consumer Reporting Agencies Act. License Requirement: A valid California Driver License, Class C or higher, may be required at the time of appointment. Failure to obtain or maintain the appropriate California Driver License may constitute cause for personnel action in accordance with Civil Service Rules or applicable bargaining agreement. Individuals who do not meet this requirement due to disability will be reviewed on a case-by-case basis. Physical Requirements: Some positions in this class may require the incumbent to be able to: Distinguish between different colors. Lift equipment that weighs up to 50 pounds. Individuals who do not meet these requirements due to disability will be reviewed on a case-by-case basis. Working Conditions: Some positions in this class may require the incumbent to: Work weekends, holidays, and non-routine hours. Travel occasionally. Probationary Period The probationary period for this classification is twelve (12) months. Application and Testing Information APPLICATION Qualified applicants are encouraged to apply immediately. All applicants must complete and submit an online County of Sacramento employment application by 5:00 PM on the posted cut-off date. Click here to apply. County of Sacramento Department of Personnel Services Employment Services Division 700 H Street, Room 4667 Sacramento, CA 95814 Phone (916) 874-5593; 7-1-1 California Relay Service Email EmployOffice@Saccounty.net Inter-Office Mail Code: 09-4667 www.SacCountyJobs.net Employment applications and all documentation requested in this announcement must be submitted by 5:00 p.m. on the cut-off date. Employment Services is not responsible for any issues or delays caused by an applicant's computer or web browser. Applicants will be automatically logged out if they have not submitted their applications and all documentation prior to 5:00 p.m. on the cut-off date. 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 cut-off date. Application information must be current, concise and related to the requirements in this job announcement. You may only apply for this recruitment once. Duplicate and incomplete applications will be disqualified. A resume may be included with your application, however it will not substitute for the information requested on the application. SUPPLEMENTAL QUESTIONNAIRE Applicants are required to provide a full and complete response to each supplemental question. The Supplemental Questionnaire is located in the tab marked "Supplemental Questions". Please be descriptive in your response. Note: Responses of "See Resume" or "See Application", or copy and paste of work experience are not qualifying responses and will not be considered. Supplemental Questionnaires must be submitted by 5:00 p.m. on the cut-off date. Employment Services is not responsible for any issues or delays caused by an applicant's computer or web browser. Applicants will be automatically logged out if they have not submitted their applications and all documentation prior to 5:00 p.m. on the cut-off date. 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. Please provide place of employment, pertinent dates, and concise, descriptive and detailed information for each question. 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. For many individuals, it is more efficient to develop responses to the supplemental questions in a word processing document and then paste them into the final document to be submitted. Changes or corrections to your Supplemental Questionnaire cannot be made once your application packet has been submitted. If the Supplemental Questionnaire is used in the Formula Rate exam, failure to complete all of the questions or incomplete responses will result in a lower score. While scoring the Supplemental Questionnaire, the candidate's application and/or attachments will not be reviewed , therefore, a candidate's responses to the questions should be accurate, thorough, detailed, and complete. FORMULA RATE EXAMINATION (Weighted 100%) All candidates meeting the minimum qualifications by the cut-off date will have their Supplemental Questionnaire scored in the Formula Rate Examination. This examination will evaluate the relevance, level, recency, progression and quality of candidate's education, training and experience. The candidate's application or other materials will not be included in this examination. Therefore, the candidate's responses to the supplemental questionnaire should be thorough, detailed and complete. The score from the Formula Rate Examination will determine the ranking on the eligible/employment list for this job. All candidates competing in the testing process will receive written notice of their examination results by email. Notices can also be accessed in their governmentjobs.com inbox. Applicants achieving a passing score will be placed on the eligible list in rank order. The rank is determined by the test score attained from the examination. FREQUENTLY ASKED QUESTIONS Click here for Frequently Asked Questions (FAQ's) For information regarding County jobs: www.saccountyjobs.net EMPLOYEE BENEFITS As an employee of the County of Sacramento, there will be a variety of benefits available to you. These benefits currently include: health, dental and life insurance; flexible spending account options for dependent care and unreimbursed dental and/or medical cost; and an employee assistance program (EAP). GENERAL BENEFITS: Most employee benefits are similar to the following for all County employees. However, some benefits differ, depending on the employee representation unit to which the employee's job classification is assigned. Information about the exact benefits applicable to a particular job classification may be obtained from the Sacramento County Department of Benefits or by visiting www.saccountyjobs.net. TEMPORARY POSITIONS: Most benefits do not apply to temporary positions. The explanations of benefits applies to employees in regular positions. SALARY STEP INCREASES: The beginning salary and the top of the salary range are usually shown on the job announcement. Upon satisfactory service, salary increases of approximately 5% are given annually until the top of the salary range has been attained. PAY: All employees are paid bi-weekly via direct deposit into the employee's bank account. The pay period covers fourteen (14) calendar days, starting on a Sunday and ending on the second Saturday thereafter. Salaries are generally paid on the Friday following the end of the pay period. Employees can set up their direct deposit and access their pay information via Employee Self Service in MySacCounty. VACATION: Generally, vacation with pay begins at 10 days annually. With increase over a period of years, the maximum annual vacation with pay is 25 days. HOLIDAYS: 14.5 holidays per year as recognized. SICK LEAVE: Equivalent to 15 days annually, unlimited accumulation. Upon retirement, unused sick leave is converted to retirement service credit. PARENTAL LEAVE: Entitles a regular County employee, with at least one year of continuous employment, to schedule a paid parental leave of up to 160 hours upon the birth or during the process of an adoption of a minor child. Parental leave shall be approved by the employee's appointing authority, except where the granting of the parental leave request would unduly interfere with or cause severe hardship upon department operations. TUITION REIMBURSEMENT: Dependent upon union agreements, regular County employees may be eligible to receive Tuition Reimbursement. The costs for course tuition/registration fees and required books/supplies are eligible for reimbursement. Tuition reimbursement amounts may vary depending upon union agreement. RETIREMENT: Social Security and Sacramento County Employees' Retirement System coverage. HEALTH INSURANCE: The County offers a variety of health plan design options to fit individual needs. DENTAL INSURANCE: The County provides a comprehensive dental benefit program for regular full-time and part-time employees and their eligible dependents. This plan pays on a set fee schedule that varies by procedure. Any amount over the fee schedule is the employee's responsibility. The yearly maximum is $2,000 per person, not including orthodontia. The orthodontic benefit is 50% of covered charges with a lifetime maximum of $1,000 per person. LIFE INSURANCE: The County of Sacramento provides a basic life insurance benefit of $15,000 to all eligible employees at no cost. Additional coverage may be purchased through payroll deduction. DEFERRED COMPENSATION: The County offers a Deferred Compensation Program which enables employees to save in a systematic way without paying income tax on either the payroll deduction or the earned interest, prior to withdrawal. EMPLOYEE ASSISTANCE PROGRAM: The County of Sacramento provides an Employee Assistance Program (EAP) for employees and their eligible dependents. The EAP offers confidential, professional counseling services in areas such as: Legal Advice/Difficult Decisions Marriage or Family Relationships Financial or Credit Worries/Elder Care Alcohol and Drug Abuse WELLNESS INCENTIVE PROGRAM: The County will recognize and award time off to eligible employees who maintain an excellent attendance record. FLEXIBLE SPENDING ACCOUNT: The County offers regular employees two separate Flexible Spending Accounts (FSA's). These accounts allow employees to set money aside, on a pre-tax basis via payroll deduction, to pay for medical, dental or dependent care expenses. DEPENDENT CARE REIMBURSEMENT ACCOUNT: Employees may set aside pre-tax dollars to pay for qualified childcare or dependent care expenses that are necessary for the employee and/or spouse to continue working. MEDICAL REIMBURSEMENT ACCOUNT: The Medical Reimbursement Account allows pre-tax dollars to be set aside to pay for out-of-pocket expenses that are not paid by insurance or reimbursed by any other benefit plan. WORKERS' COMPENSATION: In case of injury while on the job, each employee is protected under the Workers' Compensation laws of California. SACRAMENTO CREDIT UNION: The credit union offers loan facilities and systematic saving plans through payroll deduction. SELECTION AND PLACEMENT Sacramento County encourages applications from all persons regardless of race, color, ancestry, religious creed, national origin, gender, disability, political affiliation, or age. Certain age limits may be required by law, ordinance, or Civil Service direction for specific classifications such as those identified with hazardous occupations. FOR APPLICANTS WITH DISABILITIES ONLY: Every effort is made to provide reasonable accommodations to disabled applicants such as in the selection of test sites, aides, or other equipment which permits the disabled applicants to compete in the examination process. Applicants with disabilities requesting an applicable ADA testing accommodation must complete a Reasonable Accommodation Request Form filled out and signed by the applicant and their doctor. This form must be submitted to the Disability Compliance Office, 700 H Street, Room 5720, Sacramento, CA 95814, by the cut-off date or final filing date as listed in this job announcement. Download the Reasonable Accommodation Request Form by clicking here or contact by mail or in person the Sacramento County Employment Services Division or Disability Compliance Office. MINIMUM QUALIFICATIONS: Please read carefully the "Minimum Qualifications" section of your announcement. You must meet those qualifications by the application deadline date unless otherwise specified. Your application must clearly show you meet the minimum qualifications by the application deadline date, or it will not be accepted. All statements are subject to verification. "Experience" means full-time paid experience unless the announcement states that volunteer experience is acceptable. Part-time paid experience may be accumulated and pro-rated to meet the total experience requirements. PROMOTIONAL EXAMINATIONS: If the announcement indicates the examination is given on a promotional basis, candidates must hold permanent status in Sacramento County Civil Service by the application deadline date and must meet the minimum qualifications. OPEN EXAMINATIONS: Any person who meets the minimum qualifications may apply. CONTINUOUS FILING EXAMINATIONS: Applicants are eligible to reapply to and retake a continuous filing exam after 6 months from the date the previous exam results was received. ELIGIBLE LISTS: Names of qualified persons who made a passing score on an examination are entered, in order of their final grades, on an eligible list. To fill each vacancy, the hiring department will make a selection from among the top three ranks on the employment lists. EXAMINATION RATINGS: Unless otherwise stated on the announcement: To be successful, candidates must obtain a rating of at least 70% on each part of the examination. This may be an adjusted score or an arithmetic 70% of the total possible score as determined by the Director. APPEAL PROCESS: Persons who believe their applications have been improperly rejected may request the Employment Services Division to review its decision to reject the application. If the applicant desires to submit additional proof of qualifications, such proof must be received by Personnel Services not less than two (2) calendar days prior to the scheduled date for the examination. Persons who are disqualified in any phase of the examination may appeal such adverse action, in writing, to the Civil Service Commission, 700 H Street, Room 2640, Sacramento, CA 95814, telephone: (916) 874-5586 . Such appeals must be filed within thirty (30) calendar days after notice of the adverse action was mailed to the candidate. FOR MORE INFORMATION PLEASE VISIT OUR FREQUENTLY ASKED QUESTIONS (FAQs): https://personnel.saccounty.net/Pages/EmploymentServicesFAQs.aspx OTHER INFORMATION VETERAN'S PREFERENCE: Military veterans who have served during wartime shall be given preference in initial appointment to County service. Such preference shall apply, provided the veteran has first achieved a minimum passing score in the examination. The passing score of a veteran shall be annotated to indicate the veteran's score shall be regarded as 5 points or higher, OR 10 points higher for disabled veterans, only for the purpose of determining the three ranks along with which the veteran's name shall be certified. No score shall actually be changed and no new rank shall be created as a result of application of veteran's preference for certification purposes. "Disabled Veteran" means any veteran who has served during wartime and, who, as of the final filing date for an examination is declared by the United States Veterans Administration or military service department to be 10% or more disabled as a result of his/her military service. Persons claiming eligibility for disabled veteran's preference must submit to the employment office, on or before the application deadline date, a certification from the United States Veterans Administration or a military service department, dated within 1 year, which certifies the present existence of a service related disability of 10% or more, or other acceptable proof of such disability as a result of his/her military service. Persons claiming eligibility for veterans preference must submit a copy of Form DD 214 or other acceptable proof of veteran's status on or before the final filing date for the examination. For purpose of this rule "reserve" status does not constitute active duty. CITIZENSHIP OR AUTHORIZED ALIEN REQUIREMENT: As required by the Immigration Reform and Control Act, all County employees must be United States citizens or aliens lawfully authorized to work in the United States. Proof of citizenship or authorized status will be required prior to appointment. CONFLICT OF INTEREST CODE: Some County Civil Service positions are covered by financial disclosure requirements intended to identify potential conflicts of interest. CONCURRENT EMPLOYMENT: No employee may concurrently occupy more than one County position. SPECIAL SKILL QUALIFICATIONS (WHEN SPECIFIED ON THE APPLICATION): Persons who have special skills required by some (but not all) positions in a class may be certified ahead of others provided that: Such special skills are based on the duties and requirements of the positions and are in conformance with merit system and equal opportunity principles, and The certification of eligibles who possess special skills have been approved by the Civil Service Commission. PRE-EMPLOYMENT MEDICAL EXAMINATION & DRUG TESTING: The County of Sacramento is committed to maintaining a drug and alcohol free workplace. All persons selected for appointment to positions must pass a medical examination and a drug test, administered by the County at no cost to the applicant. DRIVER LICENSE: Possession of a valid California Driver License may be required for some positions. PROBATIONARY PERIOD: Regular positions are subject to a probationary period which is an extension of the selection process. Unless otherwise indicated on the announcement, the probationary period is six (6) months. AGENCY SHOP/FAIR SHARE FEE: Some positions require, as a condition of continued employment, that the person either: 1. Become a union member; 2. Pay a fair share fee to the union; or, 3. Meet specific requirements under which an equivalent amount must be paid to a charity. FINGERPRINTING AND CRIMINAL RECORD CHECKS: Fingerprinting and criminal record checks are required for some positions. Closing Date/Time: Continuous
Mar 05, 2024
The Position Come join one of Forbes Magazine's Best Employers ! This is a continuous filing exam. Next filing cut-offs are at 5:00 pm on: 3/18/24, 6/18/24, 9/18/24, 12/18/24 Level 1 - $6,721.62- $8,579.92/month Level 2 - $7,464.58 - $9,526.50/month Information Technology Applications Analyst I/IIperforms professional duties related to the analysis, design, development, maintenance and administration of computer applications to meet business needs. Incumbents may perform duties within Application Development and/or Database Architecture. The Information Technology (IT) Applications Analyst is a single class with two salary levels. Positions in this class are flexibly staffed and the level at which appointments are made are at the discretion of the appointing authority. Examples of Knowledge and Abilities Knowledge Of: General operations, services, concepts, terms and activities common to a comprehensive, state-of-the-art information systems program Principles, methods and techniques used in designing, developing, testing, implementing, and maintaining computer software systems Software systems development lifecycle Data processing techniques, including the types of hardware and software currently used to process data with different levels of complexity Basic project management principles and techniques such as organizing and managing a project, developing schedules, identifying critical paths, and breaking down a project into individual tasks Structured analysis and database concepts Industry standard hardware, software , operating systems and database software Tools and equipment used in testing the functionality of computer applications Principles, practices, and techniques of troubleshooting computer software problems and of providing quality customer service Methods and techniques of developing and presenting technical documentation and training materials Principles and practices of technical documentation Modern office procedures, methods and equipment Various programming and scripting languages Program design and analysis Test plan and test case development and use The software development lifecycle which includes planning the application layers, designing distributed applications, configuring state management, and designing a caching strategy Mobile and web application design and development Database architecture and administration; design methods and techniques; security methods, procedures and best practices Related data/file management tools Techniques for defining logical relationships among data, processes or events Installing and configuring databases Maintaining databases (backups, restores, configuration, integrity, snapshots, maintenance plans), server instances and security Data management tasks (import and export data, manage partitions, data compression, maintain indexes, manage collations) Optimizing databases for performance Implementing high availability, data warehousing and business intelligence platforms Ability To: Recognize problems; gather, analyze and evaluate data and information in order to reason logically; draw valid conclusions; take appropriate actions and/or make appropriate recommendations Research, design, implement and maintain various software technology solutions, including new technology, in order to improve County processes or services Communicate technical information to a wide variety of users Interpret and explain pertinent County and Department policies and procedures Explain the values and limitations of services requested Recognize that changes made on a local level can affect services and equipment at the system wide level and take appropriate precautions Plan, organize, and prioritize multiple projects/assignments to ensure that deadlines are met Learn and utilize specialized terminology if needed by the specific assignment Interpret and apply technical information pertaining to computer and network systems Adapt quickly to changes in policies, procedures, assignments and work locations including the environment Communicate effectively, both verbally and in writing Establish and maintain effective working relationships with those encountered during the course of the work; promote and maintain a team environment Prepare and maintain documentation for procedures, processes, and tables related to area of assignment Read, comprehend, apply, and retain technical publications and documentation Read and interpret source code from the County's commonly used programming languages; develop a working knowledge of new programming languages Write, revise, and maintain computer programs based on established specifications, using various computer languages and/or database platforms Work with source code control systems to store and retrieve application's source code Troubleshoot and repair a variety of application issues using appropriate program testing methods and tools Troubleshoot database related problems Ensure maximum database availability and that data integrity is maintained Design and modify database structures Manage complex databases and develop queries for common purpose Use Enterprise Database Management Studios Employment Qualifications Minimum Qualifications: Either: 1. A Bachelor's Degree or higher from an accredited college or university in Computer Science, Information Technology, or other field closely related to the intent of the class. Or: 2. Four (4) years of full-time, paid technical experience that demonstrates the ability to perform duties in design, development, maintenance or administration of computer applications and/or database architecture. Or: 3. Four (4) years of full-time, paid experience in Sacramento County service providing user support in technology; system, software/application and legacy troubleshooting; problem resolution; review of business processes and communication of user requirements/problems to a vendor or statewide system. Note: Education from an accredited college or university with major course work in Computer Science, Information Technology, or other field closely related to the intent of the class, may be substituted for the required experience on a year-for-year basis; 30 semester units (45 quarter units) equal one year experience. Note: If the word "experience" is referenced in the minimum qualifications, it means full-time paid experience unless the minimum qualification states that volunteer experience is acceptable. Part-time paid experience may be accumulated and pro-rated to meet the total experience requirements. Note: If the minimum qualifications include an educational or certificate/license requirement, applicants must submit proof of requirements with the application. Failure to submit proof of requirements may result in disqualification from the examination. Unofficial transcripts are acceptable. For guidelines on submitting acceptable proof of educational requirements, please click here or speak to someone in our office before the cut-off date listed in this notice. GENERAL QUALIFICATIONS Criminal History and Background Checks: The County may access criminal history information on candidates who have accepted a conditional offer of appointment for this class consistent with the provisions of Board of Supervisors Resolution No. 82-602, Personnel Policies and Procedures B-5, and applicable federal and state laws. The County shall not consider for employment any candidate who has been convicted of a felony or misdemeanor that relates to or impacts the candidate's ability to perform the job duties of this class unless it is determined that mitigating circumstances exist. For purposes of accessing criminal history information, the candidate will be fingerprinted. A subsequent arrest notification may be obtained. The County may also conduct a background check on the candidate prior to appointment to a position within this class. The background check may include personal and professional reference checks, credit history checks where authorized by Labor Code section 1024.5, Social Security Number verification, professional license/registration verification, military service information and driving history. Information obtained in the course of this background check will be considered by the appointing authority in the selection process. In obtaining such information, the County will comply with applicable consent and disclosure practices in the Fair Credit Reporting Act and the California Investigative Consumer Reporting Agencies Act. License Requirement: A valid California Driver License, Class C or higher, may be required at the time of appointment. Failure to obtain or maintain the appropriate California Driver License may constitute cause for personnel action in accordance with Civil Service Rules or applicable bargaining agreement. Individuals who do not meet this requirement due to disability will be reviewed on a case-by-case basis. Physical Requirements: Some positions in this class may require the incumbent to be able to: Distinguish between different colors. Lift equipment that weighs up to 50 pounds. Individuals who do not meet these requirements due to disability will be reviewed on a case-by-case basis. Working Conditions: Some positions in this class may require the incumbent to: Work weekends, holidays, and non-routine hours. Travel occasionally. Probationary Period The probationary period for this classification is twelve (12) months. Application and Testing Information APPLICATION Qualified applicants are encouraged to apply immediately. All applicants must complete and submit an online County of Sacramento employment application by 5:00 PM on the posted cut-off date. Click here to apply. County of Sacramento Department of Personnel Services Employment Services Division 700 H Street, Room 4667 Sacramento, CA 95814 Phone (916) 874-5593; 7-1-1 California Relay Service Email EmployOffice@Saccounty.net Inter-Office Mail Code: 09-4667 www.SacCountyJobs.net Employment applications and all documentation requested in this announcement must be submitted by 5:00 p.m. on the cut-off date. Employment Services is not responsible for any issues or delays caused by an applicant's computer or web browser. Applicants will be automatically logged out if they have not submitted their applications and all documentation prior to 5:00 p.m. on the cut-off date. 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 cut-off date. Application information must be current, concise and related to the requirements in this job announcement. You may only apply for this recruitment once. Duplicate and incomplete applications will be disqualified. A resume may be included with your application, however it will not substitute for the information requested on the application. SUPPLEMENTAL QUESTIONNAIRE Applicants are required to provide a full and complete response to each supplemental question. The Supplemental Questionnaire is located in the tab marked "Supplemental Questions". Please be descriptive in your response. Note: Responses of "See Resume" or "See Application", or copy and paste of work experience are not qualifying responses and will not be considered. Supplemental Questionnaires must be submitted by 5:00 p.m. on the cut-off date. Employment Services is not responsible for any issues or delays caused by an applicant's computer or web browser. Applicants will be automatically logged out if they have not submitted their applications and all documentation prior to 5:00 p.m. on the cut-off date. 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. Please provide place of employment, pertinent dates, and concise, descriptive and detailed information for each question. 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. For many individuals, it is more efficient to develop responses to the supplemental questions in a word processing document and then paste them into the final document to be submitted. Changes or corrections to your Supplemental Questionnaire cannot be made once your application packet has been submitted. If the Supplemental Questionnaire is used in the Formula Rate exam, failure to complete all of the questions or incomplete responses will result in a lower score. While scoring the Supplemental Questionnaire, the candidate's application and/or attachments will not be reviewed , therefore, a candidate's responses to the questions should be accurate, thorough, detailed, and complete. FORMULA RATE EXAMINATION (Weighted 100%) All candidates meeting the minimum qualifications by the cut-off date will have their Supplemental Questionnaire scored in the Formula Rate Examination. This examination will evaluate the relevance, level, recency, progression and quality of candidate's education, training and experience. The candidate's application or other materials will not be included in this examination. Therefore, the candidate's responses to the supplemental questionnaire should be thorough, detailed and complete. The score from the Formula Rate Examination will determine the ranking on the eligible/employment list for this job. All candidates competing in the testing process will receive written notice of their examination results by email. Notices can also be accessed in their governmentjobs.com inbox. Applicants achieving a passing score will be placed on the eligible list in rank order. The rank is determined by the test score attained from the examination. FREQUENTLY ASKED QUESTIONS Click here for Frequently Asked Questions (FAQ's) For information regarding County jobs: www.saccountyjobs.net EMPLOYEE BENEFITS As an employee of the County of Sacramento, there will be a variety of benefits available to you. These benefits currently include: health, dental and life insurance; flexible spending account options for dependent care and unreimbursed dental and/or medical cost; and an employee assistance program (EAP). GENERAL BENEFITS: Most employee benefits are similar to the following for all County employees. However, some benefits differ, depending on the employee representation unit to which the employee's job classification is assigned. Information about the exact benefits applicable to a particular job classification may be obtained from the Sacramento County Department of Benefits or by visiting www.saccountyjobs.net. TEMPORARY POSITIONS: Most benefits do not apply to temporary positions. The explanations of benefits applies to employees in regular positions. SALARY STEP INCREASES: The beginning salary and the top of the salary range are usually shown on the job announcement. Upon satisfactory service, salary increases of approximately 5% are given annually until the top of the salary range has been attained. PAY: All employees are paid bi-weekly via direct deposit into the employee's bank account. The pay period covers fourteen (14) calendar days, starting on a Sunday and ending on the second Saturday thereafter. Salaries are generally paid on the Friday following the end of the pay period. Employees can set up their direct deposit and access their pay information via Employee Self Service in MySacCounty. VACATION: Generally, vacation with pay begins at 10 days annually. With increase over a period of years, the maximum annual vacation with pay is 25 days. HOLIDAYS: 14.5 holidays per year as recognized. SICK LEAVE: Equivalent to 15 days annually, unlimited accumulation. Upon retirement, unused sick leave is converted to retirement service credit. PARENTAL LEAVE: Entitles a regular County employee, with at least one year of continuous employment, to schedule a paid parental leave of up to 160 hours upon the birth or during the process of an adoption of a minor child. Parental leave shall be approved by the employee's appointing authority, except where the granting of the parental leave request would unduly interfere with or cause severe hardship upon department operations. TUITION REIMBURSEMENT: Dependent upon union agreements, regular County employees may be eligible to receive Tuition Reimbursement. The costs for course tuition/registration fees and required books/supplies are eligible for reimbursement. Tuition reimbursement amounts may vary depending upon union agreement. RETIREMENT: Social Security and Sacramento County Employees' Retirement System coverage. HEALTH INSURANCE: The County offers a variety of health plan design options to fit individual needs. DENTAL INSURANCE: The County provides a comprehensive dental benefit program for regular full-time and part-time employees and their eligible dependents. This plan pays on a set fee schedule that varies by procedure. Any amount over the fee schedule is the employee's responsibility. The yearly maximum is $2,000 per person, not including orthodontia. The orthodontic benefit is 50% of covered charges with a lifetime maximum of $1,000 per person. LIFE INSURANCE: The County of Sacramento provides a basic life insurance benefit of $15,000 to all eligible employees at no cost. Additional coverage may be purchased through payroll deduction. DEFERRED COMPENSATION: The County offers a Deferred Compensation Program which enables employees to save in a systematic way without paying income tax on either the payroll deduction or the earned interest, prior to withdrawal. EMPLOYEE ASSISTANCE PROGRAM: The County of Sacramento provides an Employee Assistance Program (EAP) for employees and their eligible dependents. The EAP offers confidential, professional counseling services in areas such as: Legal Advice/Difficult Decisions Marriage or Family Relationships Financial or Credit Worries/Elder Care Alcohol and Drug Abuse WELLNESS INCENTIVE PROGRAM: The County will recognize and award time off to eligible employees who maintain an excellent attendance record. FLEXIBLE SPENDING ACCOUNT: The County offers regular employees two separate Flexible Spending Accounts (FSA's). These accounts allow employees to set money aside, on a pre-tax basis via payroll deduction, to pay for medical, dental or dependent care expenses. DEPENDENT CARE REIMBURSEMENT ACCOUNT: Employees may set aside pre-tax dollars to pay for qualified childcare or dependent care expenses that are necessary for the employee and/or spouse to continue working. MEDICAL REIMBURSEMENT ACCOUNT: The Medical Reimbursement Account allows pre-tax dollars to be set aside to pay for out-of-pocket expenses that are not paid by insurance or reimbursed by any other benefit plan. WORKERS' COMPENSATION: In case of injury while on the job, each employee is protected under the Workers' Compensation laws of California. SACRAMENTO CREDIT UNION: The credit union offers loan facilities and systematic saving plans through payroll deduction. SELECTION AND PLACEMENT Sacramento County encourages applications from all persons regardless of race, color, ancestry, religious creed, national origin, gender, disability, political affiliation, or age. Certain age limits may be required by law, ordinance, or Civil Service direction for specific classifications such as those identified with hazardous occupations. FOR APPLICANTS WITH DISABILITIES ONLY: Every effort is made to provide reasonable accommodations to disabled applicants such as in the selection of test sites, aides, or other equipment which permits the disabled applicants to compete in the examination process. Applicants with disabilities requesting an applicable ADA testing accommodation must complete a Reasonable Accommodation Request Form filled out and signed by the applicant and their doctor. This form must be submitted to the Disability Compliance Office, 700 H Street, Room 5720, Sacramento, CA 95814, by the cut-off date or final filing date as listed in this job announcement. Download the Reasonable Accommodation Request Form by clicking here or contact by mail or in person the Sacramento County Employment Services Division or Disability Compliance Office. MINIMUM QUALIFICATIONS: Please read carefully the "Minimum Qualifications" section of your announcement. You must meet those qualifications by the application deadline date unless otherwise specified. Your application must clearly show you meet the minimum qualifications by the application deadline date, or it will not be accepted. All statements are subject to verification. "Experience" means full-time paid experience unless the announcement states that volunteer experience is acceptable. Part-time paid experience may be accumulated and pro-rated to meet the total experience requirements. PROMOTIONAL EXAMINATIONS: If the announcement indicates the examination is given on a promotional basis, candidates must hold permanent status in Sacramento County Civil Service by the application deadline date and must meet the minimum qualifications. OPEN EXAMINATIONS: Any person who meets the minimum qualifications may apply. CONTINUOUS FILING EXAMINATIONS: Applicants are eligible to reapply to and retake a continuous filing exam after 6 months from the date the previous exam results was received. ELIGIBLE LISTS: Names of qualified persons who made a passing score on an examination are entered, in order of their final grades, on an eligible list. To fill each vacancy, the hiring department will make a selection from among the top three ranks on the employment lists. EXAMINATION RATINGS: Unless otherwise stated on the announcement: To be successful, candidates must obtain a rating of at least 70% on each part of the examination. This may be an adjusted score or an arithmetic 70% of the total possible score as determined by the Director. APPEAL PROCESS: Persons who believe their applications have been improperly rejected may request the Employment Services Division to review its decision to reject the application. If the applicant desires to submit additional proof of qualifications, such proof must be received by Personnel Services not less than two (2) calendar days prior to the scheduled date for the examination. Persons who are disqualified in any phase of the examination may appeal such adverse action, in writing, to the Civil Service Commission, 700 H Street, Room 2640, Sacramento, CA 95814, telephone: (916) 874-5586 . Such appeals must be filed within thirty (30) calendar days after notice of the adverse action was mailed to the candidate. FOR MORE INFORMATION PLEASE VISIT OUR FREQUENTLY ASKED QUESTIONS (FAQs): https://personnel.saccounty.net/Pages/EmploymentServicesFAQs.aspx OTHER INFORMATION VETERAN'S PREFERENCE: Military veterans who have served during wartime shall be given preference in initial appointment to County service. Such preference shall apply, provided the veteran has first achieved a minimum passing score in the examination. The passing score of a veteran shall be annotated to indicate the veteran's score shall be regarded as 5 points or higher, OR 10 points higher for disabled veterans, only for the purpose of determining the three ranks along with which the veteran's name shall be certified. No score shall actually be changed and no new rank shall be created as a result of application of veteran's preference for certification purposes. "Disabled Veteran" means any veteran who has served during wartime and, who, as of the final filing date for an examination is declared by the United States Veterans Administration or military service department to be 10% or more disabled as a result of his/her military service. Persons claiming eligibility for disabled veteran's preference must submit to the employment office, on or before the application deadline date, a certification from the United States Veterans Administration or a military service department, dated within 1 year, which certifies the present existence of a service related disability of 10% or more, or other acceptable proof of such disability as a result of his/her military service. Persons claiming eligibility for veterans preference must submit a copy of Form DD 214 or other acceptable proof of veteran's status on or before the final filing date for the examination. For purpose of this rule "reserve" status does not constitute active duty. CITIZENSHIP OR AUTHORIZED ALIEN REQUIREMENT: As required by the Immigration Reform and Control Act, all County employees must be United States citizens or aliens lawfully authorized to work in the United States. Proof of citizenship or authorized status will be required prior to appointment. CONFLICT OF INTEREST CODE: Some County Civil Service positions are covered by financial disclosure requirements intended to identify potential conflicts of interest. CONCURRENT EMPLOYMENT: No employee may concurrently occupy more than one County position. SPECIAL SKILL QUALIFICATIONS (WHEN SPECIFIED ON THE APPLICATION): Persons who have special skills required by some (but not all) positions in a class may be certified ahead of others provided that: Such special skills are based on the duties and requirements of the positions and are in conformance with merit system and equal opportunity principles, and The certification of eligibles who possess special skills have been approved by the Civil Service Commission. PRE-EMPLOYMENT MEDICAL EXAMINATION & DRUG TESTING: The County of Sacramento is committed to maintaining a drug and alcohol free workplace. All persons selected for appointment to positions must pass a medical examination and a drug test, administered by the County at no cost to the applicant. DRIVER LICENSE: Possession of a valid California Driver License may be required for some positions. PROBATIONARY PERIOD: Regular positions are subject to a probationary period which is an extension of the selection process. Unless otherwise indicated on the announcement, the probationary period is six (6) months. AGENCY SHOP/FAIR SHARE FEE: Some positions require, as a condition of continued employment, that the person either: 1. Become a union member; 2. Pay a fair share fee to the union; or, 3. Meet specific requirements under which an equivalent amount must be paid to a charity. FINGERPRINTING AND CRIMINAL RECORD CHECKS: Fingerprinting and criminal record checks are required for some positions. Closing Date/Time: Continuous