Minimum Qualifications Education and/or Equivalent Experience: Graduation with a Bachelor’s degree from an accredited college or university with major course work in a field related to the job plus two (2) years of experience. Experience may substitute for education for up to (4) years. Licenses or Certifications: None. Notes to Applicants Position Overview: The IT Business System Analyst Sr. will be responsible for assisting with the My ATX Water program including managing project related processes and program maintenance. The person in this role with be responsible for extensive data management and analysis. This role will be responsible for coordinating with the project contractors and holding them accountable to AW expectations. This role will work closely with internal customers, external customers, and contractors. Working with Austin Water provides a number of benefits including medical, paid leave time, a great retirement plan, training opportunities and more! Click HERE for more information. When completing the City of Austin employment application: Please be sure to detail on the application all previous employment that you wish to be considered as part of your qualifications. Please include contact information from previous employers. A detailed, complete employment application is required. It helps us to better evaluate your qualifications and will be used to determine salary if you are selected for this position. Be sure to provide job title and employment dates for all jobs you wish to be considered. A resume is required but will not substitute for a complete employment application. Please do not use the phrase “see resume” or refer to other documents to complete your application. Do not leave the “Duties and Responsibilities” sections blank. These will be considered incomplete applications. Incomplete applications will not be considered. If you are selected to interview: Your skill level in some of the competency areas for this job will be assessed through an analytical presentation assessment during the interview. If you are selected for hire: Verification of your education (which may include high school graduation or GED , undergraduate and/or graduate degrees) is required. You must provide proof of education from an accredited organization or institution. You must also provide proof of your professional licenses or certifications. If you are in the military or are a military veteran, you will need to provide a copy of the Member 4 page of your DD-214 prior to confirming a start date. This position requires a criminal background investigation. Travel: If you are selected for this position and meet the Driver Safety Standards in the City of Austin Driver Safety Program , you may drive when necessary to multiple locations as part of your regular job duties. Otherwise, you are responsible for getting to and from these locations. Effective October 1, 2014, all Austin Water worksite locations are tobacco-free. Use of tobacco products and/or e-cigarettes is not permitted on any AW worksite - including construction sites, parking lot, garage or in any personal vehicle located on the premises. Pay Range $37.14 - $47.35 Hours 8:00 a.m. - 5:00 p.m. Monday-Friday, with flexibility. (Hybrid) Other hours as business needs require. Job Close Date 05/08/2024 Type of Posting External Department Austin Water Utility Regular/Temporary Regular Grant Funded or Pooled Position Not Applicable Category Professional Location Glen Bell - 3907 S. Industrial Dr., Austin, TX Preferred Qualifications Experience managing or working with data analytics programs Experience performing business analysis, developing scope and identification of requirements, and testing for a variety of software and Business Intelligence development projects including highly complex enterprise-wide projects to ensure division business needs are understood and acceptable to all impacted areas Ability to pull and analyze data from large complex database systems using Business Intelligence systems, and integrated technologies for developing specialized reports and dashboards, monitoring data quality and identifying anomalies, reviewing and developing process improvements, and providing user training Experience with writing and executing complex SQL queries to extract data from a variety of data sources Experience leading cross-functional teams through project delivery, and ongoing operation, maintenance and field support Experience using statistical methods and analysis approaches Ability to travel to more than one work location 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. 1. Partner with decision makers, system owners and end users to define business, financial and operations requirements and systems goals 2. Lead requirements gathering sessions to elicit requirements, specifications, business processes and recommendations related to potential IT solutions 3. Create more complex models, use cases, process flows, specifications, diagrams and charts to provide direction to developers, designers, and vendors 4. Develop statement of work for use in requests for proposals 5. Evaluate compatibility and interoperability of commercial off-the-shelf or in-house technology systems 6. Review and analyze the effectiveness and efficiency of existing systems and develop strategies for improving or further leveraging these systems 7. Perform cost-benefit and return-on-investment analyses to aid in making IT business decisions 8. Conduct research on software and hardware products and technology services to justify recommendations and to support purchasing efforts 9. Write and deliver reports, recommendations, or alternatives that address existing and potential trouble areas in IT applications across the organization 10. Coordinate and perform tests, including end-user reviews, for modified and new systems, training and other post-implementation support Responsibilities - Supervision and/or Leadership Exercised: May provide leadership, work assignments, evaluation, training, and guidance to others 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 concepts and principles of application programming, database and system design including Internet and network architectures • Knowledge of legacy and web-based systems interfaces • Knowledge of importing data for use in report software, spreadsheets, graphs and flow charts • Knowledge of cost-benefit analysis and total cost of ownership modeling • Skill in performing requirements development, process modeling, reporting and project management tools • Skill in developing process models and data flow diagrams using industry-standard modeling techniques • Ability to accurately identify/determine customer needs and take appropriate actions and/or steps to address identified needs • Ability to recognize, value, and include different perspectives, experiences, approaches, and cultures in achieving organizational goals • Ability to gain and maintain the trust and confidence of others and the organization through consistency and reliability • Ability to give, receive, or share thoughts, ideas, perspective, and data to create shared understanding • Ability to define, analyze, and find solutions for difficult or complex problems • Skill in selecting and using training/instructional methods and procedures appropriate for the situation when learning or teaching new concepts • Ability to view the big picture • Ability to quickly become familiar with emerging technologies • Ability to identify trends as well as isolated events Criminal Background Investigation This position has been approved for a Criminal Background Investigation. EEO/ADA 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 this position are graduation with a Bachelor’s degree from an accredited college or university with major course work in a field related to the job plus two (2) years of experience. Experience may substitute for education for up to (4) years. Do you meet this requirement? 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 CBI to be hired. I acknowledge and understand this position requires a Criminal Background Investigation. * Do you have the ability to travel to multiple sites as part of the regular job duties? Yes No * How many years' experience do you have managing or working with a data analytics program? 0 - 2 years 2 - 4 years 5 - 6 years 7+ years * How many years' experience do you have performing business analysis, identification of requirements, and testing for a variety of software and Business Intelligence development projects including highly complex enterprise-wide projects. 0 - 2 years 3 - 4 years 5 - 6 years 7+ years * How many years' experience do you have in development, business user support, and design of reports and dashboards for supporting business analysis. 0 - 2 years 3 - 4 years 5 - 6 years 7+ years * How many years of professional experience do you have developing scope and detailed requirements documents to ensure division business needs are understood and acceptable to all impacted areas? Less than 3 years 3-5 years 5-7 years 7+ years * How many years of experience do you have with writing and executing complex SQL queries to extract data from a variety of data sources. 0 - 2 years 3 - 4 years 5 - 6 years 7+ years * How many years of experience do you have leading teams through Business Intelligence integration, project delivery, and on-going operation and maintenance? Less than 3 years 3-5 years 5-7 years 7+ years * Were you referred to this opportunity by an Austin Water employee? If yes, please provide the employee’s full name. (Open Ended Question) Optional & Required Documents Required Documents Cover Letter Resume Optional Documents
Apr 25, 2024
Full Time
Minimum Qualifications Education and/or Equivalent Experience: Graduation with a Bachelor’s degree from an accredited college or university with major course work in a field related to the job plus two (2) years of experience. Experience may substitute for education for up to (4) years. Licenses or Certifications: None. Notes to Applicants Position Overview: The IT Business System Analyst Sr. will be responsible for assisting with the My ATX Water program including managing project related processes and program maintenance. The person in this role with be responsible for extensive data management and analysis. This role will be responsible for coordinating with the project contractors and holding them accountable to AW expectations. This role will work closely with internal customers, external customers, and contractors. Working with Austin Water provides a number of benefits including medical, paid leave time, a great retirement plan, training opportunities and more! Click HERE for more information. When completing the City of Austin employment application: Please be sure to detail on the application all previous employment that you wish to be considered as part of your qualifications. Please include contact information from previous employers. A detailed, complete employment application is required. It helps us to better evaluate your qualifications and will be used to determine salary if you are selected for this position. Be sure to provide job title and employment dates for all jobs you wish to be considered. A resume is required but will not substitute for a complete employment application. Please do not use the phrase “see resume” or refer to other documents to complete your application. Do not leave the “Duties and Responsibilities” sections blank. These will be considered incomplete applications. Incomplete applications will not be considered. If you are selected to interview: Your skill level in some of the competency areas for this job will be assessed through an analytical presentation assessment during the interview. If you are selected for hire: Verification of your education (which may include high school graduation or GED , undergraduate and/or graduate degrees) is required. You must provide proof of education from an accredited organization or institution. You must also provide proof of your professional licenses or certifications. If you are in the military or are a military veteran, you will need to provide a copy of the Member 4 page of your DD-214 prior to confirming a start date. This position requires a criminal background investigation. Travel: If you are selected for this position and meet the Driver Safety Standards in the City of Austin Driver Safety Program , you may drive when necessary to multiple locations as part of your regular job duties. Otherwise, you are responsible for getting to and from these locations. Effective October 1, 2014, all Austin Water worksite locations are tobacco-free. Use of tobacco products and/or e-cigarettes is not permitted on any AW worksite - including construction sites, parking lot, garage or in any personal vehicle located on the premises. Pay Range $37.14 - $47.35 Hours 8:00 a.m. - 5:00 p.m. Monday-Friday, with flexibility. (Hybrid) Other hours as business needs require. Job Close Date 05/08/2024 Type of Posting External Department Austin Water Utility Regular/Temporary Regular Grant Funded or Pooled Position Not Applicable Category Professional Location Glen Bell - 3907 S. Industrial Dr., Austin, TX Preferred Qualifications Experience managing or working with data analytics programs Experience performing business analysis, developing scope and identification of requirements, and testing for a variety of software and Business Intelligence development projects including highly complex enterprise-wide projects to ensure division business needs are understood and acceptable to all impacted areas Ability to pull and analyze data from large complex database systems using Business Intelligence systems, and integrated technologies for developing specialized reports and dashboards, monitoring data quality and identifying anomalies, reviewing and developing process improvements, and providing user training Experience with writing and executing complex SQL queries to extract data from a variety of data sources Experience leading cross-functional teams through project delivery, and ongoing operation, maintenance and field support Experience using statistical methods and analysis approaches Ability to travel to more than one work location 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. 1. Partner with decision makers, system owners and end users to define business, financial and operations requirements and systems goals 2. Lead requirements gathering sessions to elicit requirements, specifications, business processes and recommendations related to potential IT solutions 3. Create more complex models, use cases, process flows, specifications, diagrams and charts to provide direction to developers, designers, and vendors 4. Develop statement of work for use in requests for proposals 5. Evaluate compatibility and interoperability of commercial off-the-shelf or in-house technology systems 6. Review and analyze the effectiveness and efficiency of existing systems and develop strategies for improving or further leveraging these systems 7. Perform cost-benefit and return-on-investment analyses to aid in making IT business decisions 8. Conduct research on software and hardware products and technology services to justify recommendations and to support purchasing efforts 9. Write and deliver reports, recommendations, or alternatives that address existing and potential trouble areas in IT applications across the organization 10. Coordinate and perform tests, including end-user reviews, for modified and new systems, training and other post-implementation support Responsibilities - Supervision and/or Leadership Exercised: May provide leadership, work assignments, evaluation, training, and guidance to others 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 concepts and principles of application programming, database and system design including Internet and network architectures • Knowledge of legacy and web-based systems interfaces • Knowledge of importing data for use in report software, spreadsheets, graphs and flow charts • Knowledge of cost-benefit analysis and total cost of ownership modeling • Skill in performing requirements development, process modeling, reporting and project management tools • Skill in developing process models and data flow diagrams using industry-standard modeling techniques • Ability to accurately identify/determine customer needs and take appropriate actions and/or steps to address identified needs • Ability to recognize, value, and include different perspectives, experiences, approaches, and cultures in achieving organizational goals • Ability to gain and maintain the trust and confidence of others and the organization through consistency and reliability • Ability to give, receive, or share thoughts, ideas, perspective, and data to create shared understanding • Ability to define, analyze, and find solutions for difficult or complex problems • Skill in selecting and using training/instructional methods and procedures appropriate for the situation when learning or teaching new concepts • Ability to view the big picture • Ability to quickly become familiar with emerging technologies • Ability to identify trends as well as isolated events Criminal Background Investigation This position has been approved for a Criminal Background Investigation. EEO/ADA 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 this position are graduation with a Bachelor’s degree from an accredited college or university with major course work in a field related to the job plus two (2) years of experience. Experience may substitute for education for up to (4) years. Do you meet this requirement? 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 CBI to be hired. I acknowledge and understand this position requires a Criminal Background Investigation. * Do you have the ability to travel to multiple sites as part of the regular job duties? Yes No * How many years' experience do you have managing or working with a data analytics program? 0 - 2 years 2 - 4 years 5 - 6 years 7+ years * How many years' experience do you have performing business analysis, identification of requirements, and testing for a variety of software and Business Intelligence development projects including highly complex enterprise-wide projects. 0 - 2 years 3 - 4 years 5 - 6 years 7+ years * How many years' experience do you have in development, business user support, and design of reports and dashboards for supporting business analysis. 0 - 2 years 3 - 4 years 5 - 6 years 7+ years * How many years of professional experience do you have developing scope and detailed requirements documents to ensure division business needs are understood and acceptable to all impacted areas? Less than 3 years 3-5 years 5-7 years 7+ years * How many years of experience do you have with writing and executing complex SQL queries to extract data from a variety of data sources. 0 - 2 years 3 - 4 years 5 - 6 years 7+ years * How many years of experience do you have leading teams through Business Intelligence integration, project delivery, and on-going operation and maintenance? Less than 3 years 3-5 years 5-7 years 7+ years * Were you referred to this opportunity by an Austin Water employee? If yes, please provide the employee’s full name. (Open Ended Question) Optional & Required Documents Required Documents Cover Letter Resume Optional Documents
Cal State University (CSU) Fullerton
800 N State College Blvd, Fullerton, CA 92831, USA
Job Title Business Intelligence Analyst Classification Analyst/Programmer - Expert AutoReqId 537405 Department IT-Enterprise Resource Planning Sub-Division IT-ERP Operating System and Database Salary Range Classification Range $7,020 - $13,594 per month (Hiring range depending on qualifications, not anticipated to exceed $7,020 - $8,664 per month) Appointment Type Ongoing Time Base Full Time Work Schedule Monday - Friday, 8:00 AM - 5:00 PM About CSUF Standing on 241 acres in the heart of Southern California, the University was founded in 1957 and has grown into a population of over 40,000 students. As Titans, we believe that diverse perspectives deepen our understanding. We are committed to giving students the support they need to graduate, while responding to California’s revolving work force needs. At California State University, Fullerton we strive for continual improvement of students, staff, faculty, and administrators through orientations, training programs, and professional development opportunities. As part of the Titan Community, you have access to many campus facilities and services including but not limited to the Grand Central Art Center in Santa Ana, the Arboretum and Botanical Garden at Cal State Fullerton, cultural events and performances in the Clayes Performing Arts Center, Cal State Fullerton Athletics sports events, Titan Recreation Center, and the Employee Wellness Program. Job Summary It is an exciting time to join Cal State Fullerton as we are an in demand comprehensive university that is driven to shape the future of education and foster a vibrant community of diverse students, faculty, staff, and administrators who uphold values of inclusive excellence, free speech, and an environment free from discrimination. We are continuously seeking individuals from various career disciplines that share the University’s mission and core values. We warmly welcome you to consider joining the Titan Community where minds expand and opportunities flourish. About the Position: The Division of Information Technology (IT) strives to be a strategic, innovative, and best-in-class IT organization that provides a leading-edge technology environment for students, faculty, and staff to advance the University’s mission, vision, and goals. We seek an exceptional individual to join our IT-Enterprise Resource Planning team as the Business Intelligence Analyst (Analyst/Programmer - Expert). The ideal candidate in this role should have a positive attitude and an active, energetic mind characterized by highly ethical practices and a commitment to diversity, openness, flexibility, integrity, and kindness Provides independent, high-level support for analysis, design, development, implementation, and support of the Business Intelligence technical solutions, with specialization in areas of the position’s assigned partner department (i.e., Institutional Effectiveness and Planning, or Administration and Finance). Serves as the subject matter expert for campus data warehouse. Provides guidance in the design and development of dashboards and reports and serves as the primary lead for them on behalf of the partner department. Primarily responsible for developing ETL processes, loading and validating data from source systems into the data warehouse. Functions as the primary contact for user support and perform initial assessment. Research user issues and independently resolve a wide range of technical problems with diverse constituency of campus users. Interacts with a wide variety of faculty, staff, managers, and vendors to understand and address problem from a broad, interactive perspective and develop long range technical solutions that combine information and ideas in new, unprecedented ways. Other duties as assigned. Essential Qualifications Bachelor’s degree from an accredited four-year college or university in Computer Science, Computer Information Systems, Information Systems, Engineering, or a related field plus five years of relevant full-time experience. Twelve years of relevant full-time experience may be substituted for the previously listed education and experience requirement. Advanced knowledge of the work area demonstrated by an understanding and use of the advanced principles and theories. Ability to integrate and apply work related knowledge to achieve innovative solutions. Ability to anticipate the impact of problems and solutions on other systems. Ability to investigate and research new systems and technologies and develop complex information technology systems and solutions. Ability to understand problems from a broad perspective and explore, conceive, and implement solutions and ideas in new ways. Ability to predict and anticipate problems and be proactive when creating solutions. Demonstrated communication expertise using persuasion and negotiation. Ability to lead technical team efforts and assess skills within a team while working to build on individual strengths to maximize team results. Ability to teach and transfer knowledge and skills to others. A background check (including a criminal records check) must be completed satisfactorily and is required for employment. CSU will make a conditional offer of employment, which may be rescinded if the background check reveals disqualifying information, and/or it is discovered that the candidate knowingly withheld or falsified information. Failure to complete the background check satisfactorily may affect the continued employment of a current CSU employee who was conditionally offered the position. Preferred Qualifications Three years working knowledge and practical experience on high profile data warehouse projects involving Business Intelligence Solutions. A minimum of three years’ experience using SQL, R, PySparc, AWS Glue, AWS S3, AWS Athena, AWS QuickSight, AWS Redshift, Oracle DB, Tableau, Apache SuperSet, and AWS Cloud Formation. Ability to use products such as Oracle PBCS, Oracle OBIEE. Strong interpersonal communication and customer service skills, specifically to communicate technical computing related topics and solutions to a nontechnical audience and understanding the functional aspects of the overall business operations. Experience in Higher Education Environment. Experience in Oracle PeopleSoft Campus Solutions SIS and AWS Cloud Analytics solutions. Strong documentation skills. Special Working Conditions Notice of Non-Discrimination on the Basis of Gender or Sex and Contact Information for Title IX Coordinator Additional Information California State University, Fullerton celebrates all forms of diversity and is deeply committed to fostering an inclusive environment where students, staff, administrators, and faculty thrive. Individuals interested in advancing the University’s strategic diversity goals are strongly encouraged to apply. Reasonable accommodations will be provided for qualified applicants with disabilities who self-disclose. As of January 1, 2022, the CSU Out-of-State Employment Policy prohibits the hiring of employees to perform CSU-related work outside the state of California. The person holding this position is considered a limited mandated reporter under the California Child Abuse and Neglect Reporting Act and must comply with the requirement outlined in CSU Executive Order 1083, revised July 21, 2017. Multiple positions may be hired from this recruitment based on the strength of the applicant pool. If you are applying for a staff position, please note that you are not eligible to work concurrently in a staff position and an Academic Student position such as a Graduate Assistant, Teaching Associate, Instructional Student Assistant, or Student Assistant position. Regular attendance is considered an essential job function; the inability to meet attendance requirements may preclude the employee from retaining employment. Employee/applicant who applies for a position may be required to successfully complete job-related performance test(s) as part of the selection process. Online application/resume must be received by electronic submission on the final filing date by 9:00 PM (Pacific Standard Time)/midnight (Eastern Standard Time). Applicants who fail to complete all sections of the online application form will be disqualified from consideration. California State University, Fullerton is not a sponsoring agency for staff or management positions (i.e., H1-B Visas). Hiring Preference On-Campus CSUEU Employees Advertised: Mar 21 2024 Pacific Daylight Time Applications close: May 02 2024 Pacific Daylight Time Closing Date/Time:
Mar 22, 2024
Job Title Business Intelligence Analyst Classification Analyst/Programmer - Expert AutoReqId 537405 Department IT-Enterprise Resource Planning Sub-Division IT-ERP Operating System and Database Salary Range Classification Range $7,020 - $13,594 per month (Hiring range depending on qualifications, not anticipated to exceed $7,020 - $8,664 per month) Appointment Type Ongoing Time Base Full Time Work Schedule Monday - Friday, 8:00 AM - 5:00 PM About CSUF Standing on 241 acres in the heart of Southern California, the University was founded in 1957 and has grown into a population of over 40,000 students. As Titans, we believe that diverse perspectives deepen our understanding. We are committed to giving students the support they need to graduate, while responding to California’s revolving work force needs. At California State University, Fullerton we strive for continual improvement of students, staff, faculty, and administrators through orientations, training programs, and professional development opportunities. As part of the Titan Community, you have access to many campus facilities and services including but not limited to the Grand Central Art Center in Santa Ana, the Arboretum and Botanical Garden at Cal State Fullerton, cultural events and performances in the Clayes Performing Arts Center, Cal State Fullerton Athletics sports events, Titan Recreation Center, and the Employee Wellness Program. Job Summary It is an exciting time to join Cal State Fullerton as we are an in demand comprehensive university that is driven to shape the future of education and foster a vibrant community of diverse students, faculty, staff, and administrators who uphold values of inclusive excellence, free speech, and an environment free from discrimination. We are continuously seeking individuals from various career disciplines that share the University’s mission and core values. We warmly welcome you to consider joining the Titan Community where minds expand and opportunities flourish. About the Position: The Division of Information Technology (IT) strives to be a strategic, innovative, and best-in-class IT organization that provides a leading-edge technology environment for students, faculty, and staff to advance the University’s mission, vision, and goals. We seek an exceptional individual to join our IT-Enterprise Resource Planning team as the Business Intelligence Analyst (Analyst/Programmer - Expert). The ideal candidate in this role should have a positive attitude and an active, energetic mind characterized by highly ethical practices and a commitment to diversity, openness, flexibility, integrity, and kindness Provides independent, high-level support for analysis, design, development, implementation, and support of the Business Intelligence technical solutions, with specialization in areas of the position’s assigned partner department (i.e., Institutional Effectiveness and Planning, or Administration and Finance). Serves as the subject matter expert for campus data warehouse. Provides guidance in the design and development of dashboards and reports and serves as the primary lead for them on behalf of the partner department. Primarily responsible for developing ETL processes, loading and validating data from source systems into the data warehouse. Functions as the primary contact for user support and perform initial assessment. Research user issues and independently resolve a wide range of technical problems with diverse constituency of campus users. Interacts with a wide variety of faculty, staff, managers, and vendors to understand and address problem from a broad, interactive perspective and develop long range technical solutions that combine information and ideas in new, unprecedented ways. Other duties as assigned. Essential Qualifications Bachelor’s degree from an accredited four-year college or university in Computer Science, Computer Information Systems, Information Systems, Engineering, or a related field plus five years of relevant full-time experience. Twelve years of relevant full-time experience may be substituted for the previously listed education and experience requirement. Advanced knowledge of the work area demonstrated by an understanding and use of the advanced principles and theories. Ability to integrate and apply work related knowledge to achieve innovative solutions. Ability to anticipate the impact of problems and solutions on other systems. Ability to investigate and research new systems and technologies and develop complex information technology systems and solutions. Ability to understand problems from a broad perspective and explore, conceive, and implement solutions and ideas in new ways. Ability to predict and anticipate problems and be proactive when creating solutions. Demonstrated communication expertise using persuasion and negotiation. Ability to lead technical team efforts and assess skills within a team while working to build on individual strengths to maximize team results. Ability to teach and transfer knowledge and skills to others. A background check (including a criminal records check) must be completed satisfactorily and is required for employment. CSU will make a conditional offer of employment, which may be rescinded if the background check reveals disqualifying information, and/or it is discovered that the candidate knowingly withheld or falsified information. Failure to complete the background check satisfactorily may affect the continued employment of a current CSU employee who was conditionally offered the position. Preferred Qualifications Three years working knowledge and practical experience on high profile data warehouse projects involving Business Intelligence Solutions. A minimum of three years’ experience using SQL, R, PySparc, AWS Glue, AWS S3, AWS Athena, AWS QuickSight, AWS Redshift, Oracle DB, Tableau, Apache SuperSet, and AWS Cloud Formation. Ability to use products such as Oracle PBCS, Oracle OBIEE. Strong interpersonal communication and customer service skills, specifically to communicate technical computing related topics and solutions to a nontechnical audience and understanding the functional aspects of the overall business operations. Experience in Higher Education Environment. Experience in Oracle PeopleSoft Campus Solutions SIS and AWS Cloud Analytics solutions. Strong documentation skills. Special Working Conditions Notice of Non-Discrimination on the Basis of Gender or Sex and Contact Information for Title IX Coordinator Additional Information California State University, Fullerton celebrates all forms of diversity and is deeply committed to fostering an inclusive environment where students, staff, administrators, and faculty thrive. Individuals interested in advancing the University’s strategic diversity goals are strongly encouraged to apply. Reasonable accommodations will be provided for qualified applicants with disabilities who self-disclose. As of January 1, 2022, the CSU Out-of-State Employment Policy prohibits the hiring of employees to perform CSU-related work outside the state of California. The person holding this position is considered a limited mandated reporter under the California Child Abuse and Neglect Reporting Act and must comply with the requirement outlined in CSU Executive Order 1083, revised July 21, 2017. Multiple positions may be hired from this recruitment based on the strength of the applicant pool. If you are applying for a staff position, please note that you are not eligible to work concurrently in a staff position and an Academic Student position such as a Graduate Assistant, Teaching Associate, Instructional Student Assistant, or Student Assistant position. Regular attendance is considered an essential job function; the inability to meet attendance requirements may preclude the employee from retaining employment. Employee/applicant who applies for a position may be required to successfully complete job-related performance test(s) as part of the selection process. Online application/resume must be received by electronic submission on the final filing date by 9:00 PM (Pacific Standard Time)/midnight (Eastern Standard Time). Applicants who fail to complete all sections of the online application form will be disqualified from consideration. California State University, Fullerton is not a sponsoring agency for staff or management positions (i.e., H1-B Visas). Hiring Preference On-Campus CSUEU Employees Advertised: Mar 21 2024 Pacific Daylight Time Applications close: May 02 2024 Pacific Daylight Time Closing Date/Time:
Cal State University (CSU) San Jose
1 Washington Street, San Jose, CA 95192, USA
Job Summary Under limited supervision of the Senior Associate Registrar for Systems and Technical Innovation, the Registrar Systems Analyst (RSA) is responsible for providing overall functional support for the Student Records module within PeopleSoft-Campus Solutions, the student information system of record for San José State University. The RSA is an expert who understands the business processes of the Student Records module and its data structures and functional needs of the Office of the Registrar. The position serves as a Subject Matter Expert (SME) for the module, including adaptations/modifications made by the CSU’s Common Management System (CMS) or San José State. The RSA’s responsibilities include but are not limited to, the review and analysis of various functionalities in the student records module, maintenance of the university’s registration and grading systems, management of query tools, and the analysis, testing, implementation of technical updates, and continual process improvements. The Registrar Systems Analyst acts as an interface between Information Technology (IT) and the functional area, providing module configuration, testing coordination and support, and escalating technical issues and change requests as needed. The RSA works independently to coordinate projects and has the ability to adjust priorities as necessary. Key Responsibilities Serves as subject matter expert (SME) for the student records module in PeopleSoft to ensure data integrity and effective integration across all functional areas of the student information system (SIS) Performs overall business analysis and daily systems functional operations, including maintaining automated processes and scheduled processes (daily, weekly, monthly, semester, and annually) Develops, maintains, and executes a testing program for patches, fixes, bundles, releases, and upgrades prior to implementation in the production environment Uses ingenuity and innovation to conceive/develop new approaches and solutions to address complex problems and resolve issues Develops automated processes and reports to reduce human error, support accuracy, and improve data access/timeliness Participates in SIS process reviews and fit/gap analyses as needed Assists the Office of Institutional Research and Strategic Analytics in required enrollment reporting to the Chancellor’s Office Responsible for batch data reporting to the National Student Clearinghouse (NSC), ensuring accurate data submissions while minimizing required manual corrections Creates and maintains detailed and accurate documentation for the PeopleSoft module and develops business process documentation Updates and trains Office of the Registrar teams on technical changes from updates or process changes and how the changes affect the workflow of these operational teams Knowledge, Skills & Abilities Ability to communicate with constituents in a professional and respectful manner Excellent written and oral communication skills Proficiency in using computer applications, including databases, word processing, spreadsheets, and presentation software Ability to communicate technology concepts effectively with technically proficient and non-technically proficient individuals Demonstrated competence in interpreting and communicating procedures, policies, information, ideas, and instructions Excellent analytical skills to interpret written material and oral requirements, draw conclusions, and make recommendations Ability to sufficiently understand and analyze data to recognize data anomalies and problems and suggest corrective actions Thorough understanding of relational databases, specifically PeopleSoft Campus Solutions (SIS) Advanced Knowledge of SIS administration, student records module, PS query/crystal reports, and people tools Ability to troubleshoot system-related issues Ability to analyze operational and procedural problems and develop, recommend, and evaluate proposed solutions Ability to handle multiple priorities and manage multiple projects Ability to apply independent judgment, discretion, and initiative to address problems and develop practical and creative solutions Ability to exercise initiative, flexibility, good judgment/discretion, and work well both independently and as part of a team Ability to develop, train, and mentor peers in understanding data and data interpretation Required Qualifications Bachelor’s degree in computer science, information systems, educational technology, communications, or related fields, or similar certified coursework in applicable fields of study Three (3) years of experience supporting information systems and technology Preferred Qualifications Bachelor’s Degree Five (5) years of experience supporting student information systems and technology in higher education Five (5) years of work experience with PeopleSoft Campus Solutions Proven ability in creating and delivering reports from large relational database management systems Strong understanding of query tools and SQL/SQR Demonstrated ability to train end-users in imaging workflow processing and troubleshooting techniques Demonstrated ability to create documentation in workflow mapping, navigation tutorials, and web-based training formats Knowledge of networking protocols and network management principles, enterprise content management principles, network security issues and solutions, and best practices Compensation Classification: Information Technology Consultant - Career Anticipated Hiring Range: $7,162/month - $7,500/month CSU Salary Range: $4,912/month - $12,124/month San José State University offers employees a comprehensive benefits package typically worth 30-35% of your base salary. For more information on programs available, please see the Employee Benefits Summary . Application Procedure Click Apply Now to complete the SJSU Online Employment Application and attach the following documents: Resume Letter of Interest All applicants must apply within the specified application period: March 19, 2024 through April 2, 2024 . This position is open until filled; however, applications received after screening has begun will be considered at the discretion of the university. Contact Information University Personnel jobs@sjsu.edu 408-924-2252 CSU Vaccination Policy The CSU strongly recommends that all individuals who access any in-person program or activity (on- or off-campus) operated or controlled by the University follow COVID-19 vaccine recommendations adopted by the U.S. Centers for Disease Control and Prevention (CDC) and the California Department of Public Health (CDPH) applicable to their age, medical condition, and other relevant indications and comply with other safety measures established by each campus. The system wide policy can be found at https://calstate.policystat.com/policy/9779821/latest/ and questions may be sent to jobs@sjsu.edu . Additional Information Satisfactory completion of a background check (including a criminal records check) is required for employment. SJSU will issue a contingent offer of employment to the selected candidate, which may be rescinded if the background check reveals disqualifying information, and/or it is discovered that the candidate knowingly withheld or falsified information. Failure to satisfactorily complete the background check may affect the continued employment of a current CSU employee who was offered the position on a contingent basis. The standard background check includes: criminal check, employment and education verification. Depending on the position, a motor vehicle and/or credit check may be required. All background checks are conducted through the university's third party vendor, Accurate Background. Some positions may also require fingerprinting. SJSU will pay all costs associated with this procedure. Evidence of required degree(s) or certification(s) will be required at time of hire. SJSU IS NOT A SPONSORING AGENCY FOR STAFF OR MANAGEMENT POSITIONS. (e.g. H1-B VISAS) All San José State University employees are considered mandated reporters under the California Child Abuse and Neglect Reporting Act and are required to comply with the requirements set forth in CSU Executive Order 1083 as a condition of employment. Incumbent is also required to promptly report any knowledge of a possible Title IX related incident to the Title IX Office or report any discrimination, harassment, and/or retaliation to the Office of Equal Opportunity. Jeanne Clery Disclosure of Campus Security Policy and Crime Statistics Act and Campus Housing Fire Safety Notification: Pursuant to the Jeanne Clery Disclosure of Campus Security Policy and Campus Crime Statistics Act, the Annual Security Report (ASR) is also now available for viewing at https://www.sjsu.edu/clery/docs/SJSU-Annual-Security-Report.pdf. The ASR contains the current security and safety-related policy statements, emergency preparedness and evacuation information, crime prevention and Sexual Assault prevention information, and information about drug and alcohol prevention programming. The ASR also contains statistics of Clery crimes for San José State University locations for the three most recent calendar years. A paper copy of the ASR is available upon request by contacting the Office of the Clery Director by phone at 408-924-1501 or by email at clerycompliance@sjsu.edu . Pursuant to the Higher Education Opportunity Act, the Annual Fire Safety Report (AFSR) is also available for viewing at https://www.sjsu.edu/clery/docs/SJSU-Annual-Fire-Safety-Report.pdf . The purpose of this report is to disclose statistics for fires that occurred within SJSU on-campus housing facilities for the three most recent calendar years, and to distribute fire safety policies and procedures intended to promote safety on Campus. A paper copy of the AFSR is available upon request by contacting the Housing Office by phone at 408-795-5600 or by email at uhs-frontdesk@sjsu.edu . Campus Security Authority - In accordance with the Jeanne Clery Disclosure of Campus Security Policy and Campus Crime Statistics Act (Clery Act) and CSU systemwide policy, this position is subject to ongoing review for designation as a Campus Security Authority. Individuals that are designated as Campus Security Authorities are required to immediately report Clery incidents to the institution and complete Clery Act training as determined by the university Clery Director. Equal Employment Statement San José State University (SJSU) is an Equal Opportunity/Affirmative Action employer committed to nondiscrimination on the basis of age, ancestry, citizenship status, color, creed, disability, ethnicity, gender, genetic information, marital status, medical condition, national origin, race, religion or lack thereof, sex, sexual orientation, transgender, or protected veteran status consistent with applicable federal and state laws. This policy applies to all SJSU students, faculty and staff programs and activities. Title IX of the Education Amendments of 1972, and certain other federal and state laws, prohibit discrimination on the basis of sex in all education programs and activities operated by the university (both on and off campus). Advertised: Mar 19 2024 Pacific Daylight Time Applications close: Closing Date/Time:
Mar 20, 2024
Job Summary Under limited supervision of the Senior Associate Registrar for Systems and Technical Innovation, the Registrar Systems Analyst (RSA) is responsible for providing overall functional support for the Student Records module within PeopleSoft-Campus Solutions, the student information system of record for San José State University. The RSA is an expert who understands the business processes of the Student Records module and its data structures and functional needs of the Office of the Registrar. The position serves as a Subject Matter Expert (SME) for the module, including adaptations/modifications made by the CSU’s Common Management System (CMS) or San José State. The RSA’s responsibilities include but are not limited to, the review and analysis of various functionalities in the student records module, maintenance of the university’s registration and grading systems, management of query tools, and the analysis, testing, implementation of technical updates, and continual process improvements. The Registrar Systems Analyst acts as an interface between Information Technology (IT) and the functional area, providing module configuration, testing coordination and support, and escalating technical issues and change requests as needed. The RSA works independently to coordinate projects and has the ability to adjust priorities as necessary. Key Responsibilities Serves as subject matter expert (SME) for the student records module in PeopleSoft to ensure data integrity and effective integration across all functional areas of the student information system (SIS) Performs overall business analysis and daily systems functional operations, including maintaining automated processes and scheduled processes (daily, weekly, monthly, semester, and annually) Develops, maintains, and executes a testing program for patches, fixes, bundles, releases, and upgrades prior to implementation in the production environment Uses ingenuity and innovation to conceive/develop new approaches and solutions to address complex problems and resolve issues Develops automated processes and reports to reduce human error, support accuracy, and improve data access/timeliness Participates in SIS process reviews and fit/gap analyses as needed Assists the Office of Institutional Research and Strategic Analytics in required enrollment reporting to the Chancellor’s Office Responsible for batch data reporting to the National Student Clearinghouse (NSC), ensuring accurate data submissions while minimizing required manual corrections Creates and maintains detailed and accurate documentation for the PeopleSoft module and develops business process documentation Updates and trains Office of the Registrar teams on technical changes from updates or process changes and how the changes affect the workflow of these operational teams Knowledge, Skills & Abilities Ability to communicate with constituents in a professional and respectful manner Excellent written and oral communication skills Proficiency in using computer applications, including databases, word processing, spreadsheets, and presentation software Ability to communicate technology concepts effectively with technically proficient and non-technically proficient individuals Demonstrated competence in interpreting and communicating procedures, policies, information, ideas, and instructions Excellent analytical skills to interpret written material and oral requirements, draw conclusions, and make recommendations Ability to sufficiently understand and analyze data to recognize data anomalies and problems and suggest corrective actions Thorough understanding of relational databases, specifically PeopleSoft Campus Solutions (SIS) Advanced Knowledge of SIS administration, student records module, PS query/crystal reports, and people tools Ability to troubleshoot system-related issues Ability to analyze operational and procedural problems and develop, recommend, and evaluate proposed solutions Ability to handle multiple priorities and manage multiple projects Ability to apply independent judgment, discretion, and initiative to address problems and develop practical and creative solutions Ability to exercise initiative, flexibility, good judgment/discretion, and work well both independently and as part of a team Ability to develop, train, and mentor peers in understanding data and data interpretation Required Qualifications Bachelor’s degree in computer science, information systems, educational technology, communications, or related fields, or similar certified coursework in applicable fields of study Three (3) years of experience supporting information systems and technology Preferred Qualifications Bachelor’s Degree Five (5) years of experience supporting student information systems and technology in higher education Five (5) years of work experience with PeopleSoft Campus Solutions Proven ability in creating and delivering reports from large relational database management systems Strong understanding of query tools and SQL/SQR Demonstrated ability to train end-users in imaging workflow processing and troubleshooting techniques Demonstrated ability to create documentation in workflow mapping, navigation tutorials, and web-based training formats Knowledge of networking protocols and network management principles, enterprise content management principles, network security issues and solutions, and best practices Compensation Classification: Information Technology Consultant - Career Anticipated Hiring Range: $7,162/month - $7,500/month CSU Salary Range: $4,912/month - $12,124/month San José State University offers employees a comprehensive benefits package typically worth 30-35% of your base salary. For more information on programs available, please see the Employee Benefits Summary . Application Procedure Click Apply Now to complete the SJSU Online Employment Application and attach the following documents: Resume Letter of Interest All applicants must apply within the specified application period: March 19, 2024 through April 2, 2024 . This position is open until filled; however, applications received after screening has begun will be considered at the discretion of the university. Contact Information University Personnel jobs@sjsu.edu 408-924-2252 CSU Vaccination Policy The CSU strongly recommends that all individuals who access any in-person program or activity (on- or off-campus) operated or controlled by the University follow COVID-19 vaccine recommendations adopted by the U.S. Centers for Disease Control and Prevention (CDC) and the California Department of Public Health (CDPH) applicable to their age, medical condition, and other relevant indications and comply with other safety measures established by each campus. The system wide policy can be found at https://calstate.policystat.com/policy/9779821/latest/ and questions may be sent to jobs@sjsu.edu . Additional Information Satisfactory completion of a background check (including a criminal records check) is required for employment. SJSU will issue a contingent offer of employment to the selected candidate, which may be rescinded if the background check reveals disqualifying information, and/or it is discovered that the candidate knowingly withheld or falsified information. Failure to satisfactorily complete the background check may affect the continued employment of a current CSU employee who was offered the position on a contingent basis. The standard background check includes: criminal check, employment and education verification. Depending on the position, a motor vehicle and/or credit check may be required. All background checks are conducted through the university's third party vendor, Accurate Background. Some positions may also require fingerprinting. SJSU will pay all costs associated with this procedure. Evidence of required degree(s) or certification(s) will be required at time of hire. SJSU IS NOT A SPONSORING AGENCY FOR STAFF OR MANAGEMENT POSITIONS. (e.g. H1-B VISAS) All San José State University employees are considered mandated reporters under the California Child Abuse and Neglect Reporting Act and are required to comply with the requirements set forth in CSU Executive Order 1083 as a condition of employment. Incumbent is also required to promptly report any knowledge of a possible Title IX related incident to the Title IX Office or report any discrimination, harassment, and/or retaliation to the Office of Equal Opportunity. Jeanne Clery Disclosure of Campus Security Policy and Crime Statistics Act and Campus Housing Fire Safety Notification: Pursuant to the Jeanne Clery Disclosure of Campus Security Policy and Campus Crime Statistics Act, the Annual Security Report (ASR) is also now available for viewing at https://www.sjsu.edu/clery/docs/SJSU-Annual-Security-Report.pdf. The ASR contains the current security and safety-related policy statements, emergency preparedness and evacuation information, crime prevention and Sexual Assault prevention information, and information about drug and alcohol prevention programming. The ASR also contains statistics of Clery crimes for San José State University locations for the three most recent calendar years. A paper copy of the ASR is available upon request by contacting the Office of the Clery Director by phone at 408-924-1501 or by email at clerycompliance@sjsu.edu . Pursuant to the Higher Education Opportunity Act, the Annual Fire Safety Report (AFSR) is also available for viewing at https://www.sjsu.edu/clery/docs/SJSU-Annual-Fire-Safety-Report.pdf . The purpose of this report is to disclose statistics for fires that occurred within SJSU on-campus housing facilities for the three most recent calendar years, and to distribute fire safety policies and procedures intended to promote safety on Campus. A paper copy of the AFSR is available upon request by contacting the Housing Office by phone at 408-795-5600 or by email at uhs-frontdesk@sjsu.edu . Campus Security Authority - In accordance with the Jeanne Clery Disclosure of Campus Security Policy and Campus Crime Statistics Act (Clery Act) and CSU systemwide policy, this position is subject to ongoing review for designation as a Campus Security Authority. Individuals that are designated as Campus Security Authorities are required to immediately report Clery incidents to the institution and complete Clery Act training as determined by the university Clery Director. Equal Employment Statement San José State University (SJSU) is an Equal Opportunity/Affirmative Action employer committed to nondiscrimination on the basis of age, ancestry, citizenship status, color, creed, disability, ethnicity, gender, genetic information, marital status, medical condition, national origin, race, religion or lack thereof, sex, sexual orientation, transgender, or protected veteran status consistent with applicable federal and state laws. This policy applies to all SJSU students, faculty and staff programs and activities. Title IX of the Education Amendments of 1972, and certain other federal and state laws, prohibit discrimination on the basis of sex in all education programs and activities operated by the university (both on and off campus). Advertised: Mar 19 2024 Pacific Daylight Time Applications close: Closing Date/Time:
SUMMARY PURPOSE OF POSITION The Budget Analyst will perform financial, operational and budgetary analysis in support of SCRRA’s financial planning and analysis activities. TO APPLY: This is a continuous recruitment with the first review of applications beginning February 21, 2024 . Interested applicants are encouraged to apply immediately. DISTINGUISHING CHARACTERISTICS This position is a career level of the Budget Analyst series. At this level, the incumbent has some latitude for independent judgment and may vary work methods, but usually within prescribed parameters. SUPERVISION EXERCISED AND RECEIVED Receives supervision from departmental management/supervisory level roles No formal supervisory responsibilities ESSENTIAL DUTIES AND RESPONSIBILITIES The duties listed below are intended to describe the general nature and level of work being performed and are not to be interpreted as an exhaustive list of responsibilities. Assist in the design of reporting processes to enhance the analysis and correction of budget related issues. Review coding on Requisitions and ensure budget exists to support expense. Interact with Cost Centers regarding the “Budget transfer” process. Track and monitor all approved amendments to the approved annual operating and capital budgets. Provide support for the monthly and year-end close of the general ledger. Work collaboratively with department staff in analysis of departmental revenue, expenses and other financials. Assist in maintaining the cost accounting system within the Financial Information System, Oracle. Assist with the preparation and analysis of the annual operating budget, revenue and expenses. Assist in the annual cost setting process and year-end reconciliation of operating expenditures. Assist in the conversion of the budget process to a more efficient and automated environment. Provide support to Cost Centers with current financial information and any questions regarding budgets. Review budgets to monthly, quarterly and annual actual reports to monitor expenditure. Collect and analyze data, record results and make recommendations for cost savings. Create and maintain documentation files to support operating budget information for ease of retrieval and historical analysis. Provide timely explanation and analytics of variances between actual results and forecasts/budgets. Assist in the production of quarterly performance measurement reports to the appropriate Board Committee and the Board of Directors. Assist in the development of reports for internal agency management for publication. Work with department staff to coordinate various ongoing and annual special projects including but not limited to Annual Comprehensive Annual Financial Report (ACFR), Indirect Cost Allocation Plan, and internal and external audits. Perform other related duties as assigned. MINIMUM REQUIREMENTS TO PERFORM ESSENTIAL JOB FUNCTIONS Education and Experience Bachelor’s degree in Business Administration, Accounting, Finance or a related field or equivalent experience. A minimum of six (6) years’ experience accounting, finance, business intelligence and/or budget, along with experience performing complex financial analysis of operational expenditures. A combination of training, with a minimum of an Associate’s degree and/or experience that provides the required knowledge, skills, and abilities may be considered when determining minimum qualifications. Advanced relevant coursework may also substitute for a portion of required experience. Valid Class C Driver’s license with a satisfactory driving record of no more than three moving violations and no DUI’s within the last three years. Preferred Qualifications Knowledge of Six Sigma or Green / Black Belt Certification Knowledge, Skills, and Abilities Knowledge of : Accounting principles and procedures related to cost accounting, budgeting, and forecasting Principles and practices of public administration Principles and practices of administrative research and statistical analysis Skilled in : Resolving discrepancies and analyzing trends Excellent analytical and problem-solving skills Use of Microsoft Office with advanced skills in Excel Strong and effective communication skills both verbally and in writing Strong and effective organizational and time management skills Ability to : Build team cohesiveness by establishing, communicating, and reinforcing the Finance mission statement Perform complex analysis and prepare associated reports Identify, monitor and track complex trends and patterns Ability to comprehend the public service environment, SCRRA mission, objectives, and business model PHYSICAL REQUIREMENTS Transition between a stationary position at a desk or work location and move about Metrolink facilities or other work site locations Operate tools to perform the duties of the position; such as computers, office equipment and work-related machinery Transport equipment or boxes up to 25lbs Exchange ideas by means of communication Visual acuity to detect, identify and observe employees or train movement and any barriers to movement when working on or near railroad tracks Hear and perceive the nature of sounds when working on or near railroad tracks Balance, ascend/descend, climb, kneel, stoop, bend, crouch or crawl within assigned working conditions and or locations Working Conditions Hybrid work schedule may be available for this position classification. Position requires work in a normal office environment with little exposure to excessive noise, dust, or temperature. Southern California Regional Rail Authority is an Equal Opportunity Employer. In compliance with the Americans with Disabilities Act, the Authority will provide reasonable accommodations to qualified individuals with disabilities and encourages both prospective and current employees to discuss potential accommodations with the employer. SUPPLEMENTAL INFORMATION Selection Process: Following a review of resumes and/or applications, the most highly qualified candidates will be invited to continue in the selection process. Eligible applicants will be notified of the exact time and place of assessments and interview. Candidates will be interviewed to determine their relative knowledge, skills and ability in job related areas. Offers of employment may be contingent upon successful completion of a reference check, including degree verification and criminal records check provided through SCRRA. Internal Candidates: Employees with active discipline as defined in the HR Policy No. 5.3 Positive Discipline Program and/or with performance that does not meet the standard for "meets expectations" as defined in the Performance Planning and Appraisal Process may be precluded from consideration and placement in the position. In compliance with the Americans with Disabilities Act, the SCRRA will provide reasonable accommodations to qualified individuals with disabilities and encourages both prospective and current employees to discuss potential accommodations with the employer. The SCRRA is an Equal Opportunity Employer. EEO/ADA MEDICAL: SCRRA offers a choice of twelve (12) health plan options provided through the California Public Employees' Retirement System (CalPERS). You may choose from up to ten (10) Health Maintenance Organization (HMO) plans and two (2) Preferred Provider Organization (PPO) plans. Some health plans are only available in certain counties and/or zip codes. You contribute 12.5 percent of the plan premium for coverage of you and your eligible dependents. You may waive coverage if you are covered under another group health plan; you must provide proof. Once you waive coverage, you will only be allowed to enroll during Open Enrollment or within 60 days from the date on which your other coverage is no longer available (proof is required). If you elect to waive coverage, you will receive $300.00 per month taxable earnings, paid in two installments of $150 each on the first two paychecks of the month. A retiree or an employee who is a spouse, child, or any other eligible dependent of another SCRRA employee is not eligible for the opt out/cash in lieu credit if he/she is covered under a SCRRA health plan. Eligibility begins the first of the month following hire date or qualifying event. DENTAL: SCRRA offers two dental options provided by Delta Dental. Under the DeltaCare (HMO) program, you must select a contract dentist within their network to perform your dental services. If you require treatment from a specialist, your contract dentist will handle the referral. Many services are covered at no cost to you. A co-payment applies for other services. The Delta Dental PPO plan allows you to visit a dentist of your choice, change dentists at any time, go to a dental specialist of your choice, receive dental care anywhere in the world, and save on out-of-pocket expenses when you visit a PPO network dental office. SCRRA pays the full premium for coverage of you and your eligible dependents under both plans. Eligibility begins the first of the month following hire date or qualifying event. VISION: SCRRA offers two (2) vision plans through Vision Service Plan (VSP), providing coverage for eye examinations, prescription eyewear and contact lenses through network providers. You have the option of seeing out-of-network providers, but full reimbursement is not guaranteed. VSP has contracted with many laser surgery facilities and doctors, offering you a discount on PRK and LASIK surgeries. If you enroll in the VSP Basic Plan, SCRRA pays the full premium for coverage of you and your eligible dependents. If you enroll in the VSP Buy-up Plan, which offers enhanced vision benefits, you pay the difference between the cost of the Basic Plan and the Buy-up Plan. Eligibility begins the first of the month following hire date or qualifying event. FLEXIBLE SPENDING ACCOUNTS: Flexible Spending Accounts (FSA) allow for the deferral of pre-tax dollars to be used for reimbursement of eligible medical and dependent care expenses. You can set aside up to $3,050 for health care expenses and $5,000 per family for dependent care expenses annually. Eligibility begins the first of the month following hire date or a qualifying event. GROUP TERM LIFE INSURANCE: SCRRA provides for an amount equal to one (1) time your annual salary, rounded to the nearest $1,000, to a maximum of $200,000. Your life insurance benefit will reduce to 65% at age 65 and 55% at age 70. IRS regulations require that the portion of Group Term Life (“G.T.L.”) insurance benefits provided to you by SCRRA, which exceeds $50,000, be added to your Federal, State, and Medicare taxable earnings for W-2 reporting. This amount is reflected on your pay statements each pay period in the “Other Benefits and Information” section. In addition, SCRRA offers a voluntary plan, which may be purchased in increments of $10,000 to a maximum of $100,000 without evidence of insurability (initial enrollment period only) and up to 5 times your salary to a maximum of $500,000 with evidence of insurability. Dependent life options are also available. The voluntary plan is portable; you may retain it if you leave SCRRA and pay the premium. Eligibility begins the first of the month following hire date or qualifying event. ACCIDENTAL DEATH & DISMEMBERMENT: SCRRA provides for an amount equal to one (1) time your annual salary, rounded to the nearest $1,000, up to a maximum of $200,000. Your AD&D insurance benefit will reduce to 65% at age 65 and 55% at age 70. In addition, SCRRA offers a voluntary plan, which may be purchased in increments of $10,000, subject to a maximum of the lesser of 5 times your annual salary or $500,000. Dependent AD&D options are also available. Eligibility begins the first of the month following hire date or qualifying event. SHORT TERM DISABILITY: You are covered under the California State Disability Insurance (SDI) Program. Your maximum benefit amount is 52 times your weekly benefit amount or the total wages subject to SDI tax paid in your base period, whichever is less. Employees pay a mandatory contribution, through payroll deductions, for coverage under the SDI program. The contribution rate for 2023 is 0.9 percent of earnings. The SDI taxable wage limit is $153,164, with a maximum withholding of $1,378.48 per employee for calendar year 2023. LONG TERM DISABILITY : SCRRA provides for income replacement of 60 percent of monthly earnings subject to a maximum benefit of $7,500 per month up to age 65. To qualify, you must be on disability for 90 days. (Note: there is a pre-existing condition clause in this program.) Eligibility begins the first of the month following hire date or qualifying event. VOLUNTARY BENEFITS: SCRRA offers the following employee-paid voluntary benefits, provided by Aflac: Group Accident Insurance helps pay for out-of-pocket costs that arise from covered accidents, such as fractures, dislocations, and lacerations. Group Critical Illness Insurance helps pay for the expected and unexpected expenses that arise from diagnosis of a covered critical illness, such as cancer (internal or invasive), heart attack, stroke, end-stage renal failure or a major organ transplant. Group Hospital Indemnity Insurance helps pay for the out-of-pocket costs associated with a hospital stay, including benefits for hospital confinement, hospital admission, hospital intensive care and intermediate intensive care step-down unit. Group Short-Term Disability Insurance pays a monthly benefit directly to an employee who is off work due to an injury or illness for up to three (3) months after a seven (7) day waiting period. Eligibility begins the first of the month following hire date or qualifying event. 9/80 ALTERNATIVE WORK SCHEDULE: SCRRA offers a 9/80 Alternative Work Schedule (AWS). During a 10-day work period, you work eight 9-hour days, one 8-hour day and have one day off. Your day off can be Monday, Wednesday, or Friday. Approval from your supervisor, chief and HR is required to participate in the 9/80 AWS program. TELECOMMUTING SCHEDULE: SCRRA offers employees the option to telecommute up to two (2) days per week. At the CEO’s discretion, the maximum number of days per week may be increased due to a natural disaster, pandemic, civil unrest, federal/state/local stay-at-home order, or other special circumstances. Approval from your supervisor, chief and HR is required to participate in the telecommuting program. Employees on a 9/80 schedule cannot telecommute. HOLIDAYS: SCRRA observes twelve (12) holidays a year: New Year's Day, Martin Luther King Day, President’s Day, Cesar Chavez Day, Memorial Day, Juneteenth, Independence Day, Labor Day, Veterans Day, Thanksgiving Day, Day after Thanksgiving, and Christmas Day. PAID TIME OFF (PTO): SCRRA provides employees with Paid Time Off (PTO) for vacations, illnesses, injuries, medical/dental appointments, religious holidays, personal business, and emergencies as follows: 0-4 years of service - 25 days 5-6 years of service - 30 days 7th year of service - 32 days 8th year of service - 33 days 9th year of service - 34 days 10-14 years of service - 35 days 15-19 years of service - 38 days 20 or more years - 42 days At the CEO’s discretion, prior service at a public transportation or public agency, or rail transportation company may be counted towards an employee’s total service years to increase the employee’s PTO accrual rate. To be considered, Human Resources requires that a written request along with verification and confirmation of the years of service be provided prior to the start of employment with SCRRA. Human Resources will provide the final determination on behalf of the CEO. EMPLOYEE ASSISTANCE PROGRAM (EAP): SCRRA offers you and your immediate and dependent family members confidential counseling 24 hours a day, 7 days a week for family, personal, work-related and substance abuse issues through the EAP. You are entitled to a telephone session(s) with a trained EAP professional to assess the nature of the problem and provide a referral for additional assistance, if needed. Services also include three (3) face-to-face counseling sessions per family member per six (6) month period. HEALTH ADVOCACY SERVICES: SCRRA offers you and your eligible dependents free health advocacy services through Health Advocate. You are entitled to unlimited calls with trained professionals who can help you navigate the healthcare and insurance systems. RETIREMENT PLAN: The SCRRA contracts with the California Public Employees' Retirement System (CalPERS). You pay a 8.00 percent employee contribution and SCRRA pays an employer contribution, which varies each year. To be eligible for service retirement, you must be at least age 52 and have a minimum of five (5) years of CalPERS-credited service. Upon retirement you are entitled to a monthly retirement benefit based on your years of credited service, age, and average compensation during your last three (3) years of service (“final compensation”). The retirement formula for New Members is 2%@62, which means at age 62, you receive 2 percent of your final compensation for every year of service. Upon separation from employment with less than 5 years of credited service, you may request a refund of your employee contributions only, including interest, and end your membership with CalPERS, or leave it in your account and retain your service credit should you decide to work for another CalPERS-covered agency. If you are vested upon separation but do not retire, you may leave your contributions in your account until retirement or elect a refund. SOCIAL SECURITY: You do not participate in Social Security except for Medicare. You will contribute 1.45 percent of your pay to cover the hospital insurance portion of Medicare. *Additional Medicare Hospital Insurance Tax: As of January 1, 2013, employees are required to pay an additional 0.9 percent Medicare tax on earnings above $200,000 (for those who file an individual return) or $250,000 (for those who file a joint return). This additional hospital insurance tax is not reflected in the rate above. RETIREE MEDICAL: Unrepresented employees hired before 11/1/18*: You will be eligible for medical coverage when you retire if your separation date and retirement date are within 120 days of each other. SCRRA pays the same amount for retirees as it does for active employees, which is currently 87.5 percent of the applicable premium. Unrepresented employees hired on or after 11/1/18: You will be eligible for medical coverage when you retire if your separation date and retirement date are within 120 days of each other and you have a minimum of 10 years of credited CalPERS service, five of which must be performed at SCRRA. SCRRA pays a percentage of the state annuitant contribution rate** in accordance with the vesting schedule below: 10 Years of CalPERS Service - 50% 11 - 19 Years of CalPERS Service - 50%, plus 5% for each additional year of service 20+ Years of CalPERS Service - 100% *Once each year the employer may allow unrepresented employees hired before 11/1/18 the opportunity to individually elect to be subject to the vesting schedule. **The state annuitant contribution rates for 2023 are: $883 (Retiree Only); $1,699 (Retiree + 1 Dependent); $2,124 (Retiree + Family). DEFERRED COMPENSATION PLAN (457) : You are eligible to set aside a portion of your current income without paying taxes on that money until it is received later during retirement when taxes may be lower. In 2023, you can defer up to 100 percent of your gross compensation or $22,500 annually, whichever is less (“normal contribution limit”). You may make an additional $7,500 contribution to the plan if you are age 50 and older. If you are at least within three years of the age in which you are eligible to receive unreduced benefits under our CalPERS retirement plan, you may contribute up to double the normal contribution limit, or $45,000. TRANSPORTATION PASSES: You may use your employee badge for unlimited free access to all Metrolink lines and trains. Your badge cannot be used on connecting public transportation. However, if you commute to/from work on Metrolink on a regular basis and need to connect to other public transportation (e.g., Metro Red or Purple Line) you can be issued a Metrolink pass with the appropriate station pair, which will also give you access to connecting transportation. You are also eligible to receive a free transit pass to ride any greater Los Angeles area transit system other than Metrolink (such as, Metro, Foothill Transit, LADOT, and LOSSAN) for commuting purposes. The commuter transit pass has a value up to the monthly maximum tax-free transit pass amount established by the Internal Revenue Service ($300 in 2023). You are responsible for any transit fares above the IRS monthly cap. To receive this benefit, the SCRRA requires each employee to use public transportation to commute to and from work three (3) or more days per week. OTHER BENEFITS: Educational Assistance - SCRRA will reimburse an employee up to $1,000 per fiscal year for tuition, books and mandatory student fees for courses that are relevant to employment. No reimbursement is allowed for parking. Professional Memberships - SCRRA pays up to $300 per year for professional memberships. Credit Union Membership - SCRRA offers credit union services for employees and their family members, provided by Northrup Grumman Federal Credit Union. Jury Duty - SCRRA will continue an employee's salary during any non-voluntary jury service up to a maximum of ten (10) working days. Pregnancy Disability and Family and Medical Leaves - A leave of absence may be paid or unpaid and shall be granted in accordance with applicable federal and state laws, and SCRRA policy. Refer to the Human Resource Policies and Procedures Manual for more detailed information. Bereavement Leave - In the event of death in an employee’s immediate family, the agency grants up to three (3) working days, with pay, to handle family affairs and to attend the funeral. When an employee needs to travel outside the radius of the five (5) member agencies due to the death of an immediate family member, the Authority grants up to five (5) working days, with pay. Military Leave - Employees will be paid for the annually required active period. At the discretion of the Chief Executive Officer, and with Board notification, paid military leave may be granted beyond what is provided by the applicable state law. Closing Date/Time: Continuous
Mar 07, 2024
Full Time
SUMMARY PURPOSE OF POSITION The Budget Analyst will perform financial, operational and budgetary analysis in support of SCRRA’s financial planning and analysis activities. TO APPLY: This is a continuous recruitment with the first review of applications beginning February 21, 2024 . Interested applicants are encouraged to apply immediately. DISTINGUISHING CHARACTERISTICS This position is a career level of the Budget Analyst series. At this level, the incumbent has some latitude for independent judgment and may vary work methods, but usually within prescribed parameters. SUPERVISION EXERCISED AND RECEIVED Receives supervision from departmental management/supervisory level roles No formal supervisory responsibilities ESSENTIAL DUTIES AND RESPONSIBILITIES The duties listed below are intended to describe the general nature and level of work being performed and are not to be interpreted as an exhaustive list of responsibilities. Assist in the design of reporting processes to enhance the analysis and correction of budget related issues. Review coding on Requisitions and ensure budget exists to support expense. Interact with Cost Centers regarding the “Budget transfer” process. Track and monitor all approved amendments to the approved annual operating and capital budgets. Provide support for the monthly and year-end close of the general ledger. Work collaboratively with department staff in analysis of departmental revenue, expenses and other financials. Assist in maintaining the cost accounting system within the Financial Information System, Oracle. Assist with the preparation and analysis of the annual operating budget, revenue and expenses. Assist in the annual cost setting process and year-end reconciliation of operating expenditures. Assist in the conversion of the budget process to a more efficient and automated environment. Provide support to Cost Centers with current financial information and any questions regarding budgets. Review budgets to monthly, quarterly and annual actual reports to monitor expenditure. Collect and analyze data, record results and make recommendations for cost savings. Create and maintain documentation files to support operating budget information for ease of retrieval and historical analysis. Provide timely explanation and analytics of variances between actual results and forecasts/budgets. Assist in the production of quarterly performance measurement reports to the appropriate Board Committee and the Board of Directors. Assist in the development of reports for internal agency management for publication. Work with department staff to coordinate various ongoing and annual special projects including but not limited to Annual Comprehensive Annual Financial Report (ACFR), Indirect Cost Allocation Plan, and internal and external audits. Perform other related duties as assigned. MINIMUM REQUIREMENTS TO PERFORM ESSENTIAL JOB FUNCTIONS Education and Experience Bachelor’s degree in Business Administration, Accounting, Finance or a related field or equivalent experience. A minimum of six (6) years’ experience accounting, finance, business intelligence and/or budget, along with experience performing complex financial analysis of operational expenditures. A combination of training, with a minimum of an Associate’s degree and/or experience that provides the required knowledge, skills, and abilities may be considered when determining minimum qualifications. Advanced relevant coursework may also substitute for a portion of required experience. Valid Class C Driver’s license with a satisfactory driving record of no more than three moving violations and no DUI’s within the last three years. Preferred Qualifications Knowledge of Six Sigma or Green / Black Belt Certification Knowledge, Skills, and Abilities Knowledge of : Accounting principles and procedures related to cost accounting, budgeting, and forecasting Principles and practices of public administration Principles and practices of administrative research and statistical analysis Skilled in : Resolving discrepancies and analyzing trends Excellent analytical and problem-solving skills Use of Microsoft Office with advanced skills in Excel Strong and effective communication skills both verbally and in writing Strong and effective organizational and time management skills Ability to : Build team cohesiveness by establishing, communicating, and reinforcing the Finance mission statement Perform complex analysis and prepare associated reports Identify, monitor and track complex trends and patterns Ability to comprehend the public service environment, SCRRA mission, objectives, and business model PHYSICAL REQUIREMENTS Transition between a stationary position at a desk or work location and move about Metrolink facilities or other work site locations Operate tools to perform the duties of the position; such as computers, office equipment and work-related machinery Transport equipment or boxes up to 25lbs Exchange ideas by means of communication Visual acuity to detect, identify and observe employees or train movement and any barriers to movement when working on or near railroad tracks Hear and perceive the nature of sounds when working on or near railroad tracks Balance, ascend/descend, climb, kneel, stoop, bend, crouch or crawl within assigned working conditions and or locations Working Conditions Hybrid work schedule may be available for this position classification. Position requires work in a normal office environment with little exposure to excessive noise, dust, or temperature. Southern California Regional Rail Authority is an Equal Opportunity Employer. In compliance with the Americans with Disabilities Act, the Authority will provide reasonable accommodations to qualified individuals with disabilities and encourages both prospective and current employees to discuss potential accommodations with the employer. SUPPLEMENTAL INFORMATION Selection Process: Following a review of resumes and/or applications, the most highly qualified candidates will be invited to continue in the selection process. Eligible applicants will be notified of the exact time and place of assessments and interview. Candidates will be interviewed to determine their relative knowledge, skills and ability in job related areas. Offers of employment may be contingent upon successful completion of a reference check, including degree verification and criminal records check provided through SCRRA. Internal Candidates: Employees with active discipline as defined in the HR Policy No. 5.3 Positive Discipline Program and/or with performance that does not meet the standard for "meets expectations" as defined in the Performance Planning and Appraisal Process may be precluded from consideration and placement in the position. In compliance with the Americans with Disabilities Act, the SCRRA will provide reasonable accommodations to qualified individuals with disabilities and encourages both prospective and current employees to discuss potential accommodations with the employer. The SCRRA is an Equal Opportunity Employer. EEO/ADA MEDICAL: SCRRA offers a choice of twelve (12) health plan options provided through the California Public Employees' Retirement System (CalPERS). You may choose from up to ten (10) Health Maintenance Organization (HMO) plans and two (2) Preferred Provider Organization (PPO) plans. Some health plans are only available in certain counties and/or zip codes. You contribute 12.5 percent of the plan premium for coverage of you and your eligible dependents. You may waive coverage if you are covered under another group health plan; you must provide proof. Once you waive coverage, you will only be allowed to enroll during Open Enrollment or within 60 days from the date on which your other coverage is no longer available (proof is required). If you elect to waive coverage, you will receive $300.00 per month taxable earnings, paid in two installments of $150 each on the first two paychecks of the month. A retiree or an employee who is a spouse, child, or any other eligible dependent of another SCRRA employee is not eligible for the opt out/cash in lieu credit if he/she is covered under a SCRRA health plan. Eligibility begins the first of the month following hire date or qualifying event. DENTAL: SCRRA offers two dental options provided by Delta Dental. Under the DeltaCare (HMO) program, you must select a contract dentist within their network to perform your dental services. If you require treatment from a specialist, your contract dentist will handle the referral. Many services are covered at no cost to you. A co-payment applies for other services. The Delta Dental PPO plan allows you to visit a dentist of your choice, change dentists at any time, go to a dental specialist of your choice, receive dental care anywhere in the world, and save on out-of-pocket expenses when you visit a PPO network dental office. SCRRA pays the full premium for coverage of you and your eligible dependents under both plans. Eligibility begins the first of the month following hire date or qualifying event. VISION: SCRRA offers two (2) vision plans through Vision Service Plan (VSP), providing coverage for eye examinations, prescription eyewear and contact lenses through network providers. You have the option of seeing out-of-network providers, but full reimbursement is not guaranteed. VSP has contracted with many laser surgery facilities and doctors, offering you a discount on PRK and LASIK surgeries. If you enroll in the VSP Basic Plan, SCRRA pays the full premium for coverage of you and your eligible dependents. If you enroll in the VSP Buy-up Plan, which offers enhanced vision benefits, you pay the difference between the cost of the Basic Plan and the Buy-up Plan. Eligibility begins the first of the month following hire date or qualifying event. FLEXIBLE SPENDING ACCOUNTS: Flexible Spending Accounts (FSA) allow for the deferral of pre-tax dollars to be used for reimbursement of eligible medical and dependent care expenses. You can set aside up to $3,050 for health care expenses and $5,000 per family for dependent care expenses annually. Eligibility begins the first of the month following hire date or a qualifying event. GROUP TERM LIFE INSURANCE: SCRRA provides for an amount equal to one (1) time your annual salary, rounded to the nearest $1,000, to a maximum of $200,000. Your life insurance benefit will reduce to 65% at age 65 and 55% at age 70. IRS regulations require that the portion of Group Term Life (“G.T.L.”) insurance benefits provided to you by SCRRA, which exceeds $50,000, be added to your Federal, State, and Medicare taxable earnings for W-2 reporting. This amount is reflected on your pay statements each pay period in the “Other Benefits and Information” section. In addition, SCRRA offers a voluntary plan, which may be purchased in increments of $10,000 to a maximum of $100,000 without evidence of insurability (initial enrollment period only) and up to 5 times your salary to a maximum of $500,000 with evidence of insurability. Dependent life options are also available. The voluntary plan is portable; you may retain it if you leave SCRRA and pay the premium. Eligibility begins the first of the month following hire date or qualifying event. ACCIDENTAL DEATH & DISMEMBERMENT: SCRRA provides for an amount equal to one (1) time your annual salary, rounded to the nearest $1,000, up to a maximum of $200,000. Your AD&D insurance benefit will reduce to 65% at age 65 and 55% at age 70. In addition, SCRRA offers a voluntary plan, which may be purchased in increments of $10,000, subject to a maximum of the lesser of 5 times your annual salary or $500,000. Dependent AD&D options are also available. Eligibility begins the first of the month following hire date or qualifying event. SHORT TERM DISABILITY: You are covered under the California State Disability Insurance (SDI) Program. Your maximum benefit amount is 52 times your weekly benefit amount or the total wages subject to SDI tax paid in your base period, whichever is less. Employees pay a mandatory contribution, through payroll deductions, for coverage under the SDI program. The contribution rate for 2023 is 0.9 percent of earnings. The SDI taxable wage limit is $153,164, with a maximum withholding of $1,378.48 per employee for calendar year 2023. LONG TERM DISABILITY : SCRRA provides for income replacement of 60 percent of monthly earnings subject to a maximum benefit of $7,500 per month up to age 65. To qualify, you must be on disability for 90 days. (Note: there is a pre-existing condition clause in this program.) Eligibility begins the first of the month following hire date or qualifying event. VOLUNTARY BENEFITS: SCRRA offers the following employee-paid voluntary benefits, provided by Aflac: Group Accident Insurance helps pay for out-of-pocket costs that arise from covered accidents, such as fractures, dislocations, and lacerations. Group Critical Illness Insurance helps pay for the expected and unexpected expenses that arise from diagnosis of a covered critical illness, such as cancer (internal or invasive), heart attack, stroke, end-stage renal failure or a major organ transplant. Group Hospital Indemnity Insurance helps pay for the out-of-pocket costs associated with a hospital stay, including benefits for hospital confinement, hospital admission, hospital intensive care and intermediate intensive care step-down unit. Group Short-Term Disability Insurance pays a monthly benefit directly to an employee who is off work due to an injury or illness for up to three (3) months after a seven (7) day waiting period. Eligibility begins the first of the month following hire date or qualifying event. 9/80 ALTERNATIVE WORK SCHEDULE: SCRRA offers a 9/80 Alternative Work Schedule (AWS). During a 10-day work period, you work eight 9-hour days, one 8-hour day and have one day off. Your day off can be Monday, Wednesday, or Friday. Approval from your supervisor, chief and HR is required to participate in the 9/80 AWS program. TELECOMMUTING SCHEDULE: SCRRA offers employees the option to telecommute up to two (2) days per week. At the CEO’s discretion, the maximum number of days per week may be increased due to a natural disaster, pandemic, civil unrest, federal/state/local stay-at-home order, or other special circumstances. Approval from your supervisor, chief and HR is required to participate in the telecommuting program. Employees on a 9/80 schedule cannot telecommute. HOLIDAYS: SCRRA observes twelve (12) holidays a year: New Year's Day, Martin Luther King Day, President’s Day, Cesar Chavez Day, Memorial Day, Juneteenth, Independence Day, Labor Day, Veterans Day, Thanksgiving Day, Day after Thanksgiving, and Christmas Day. PAID TIME OFF (PTO): SCRRA provides employees with Paid Time Off (PTO) for vacations, illnesses, injuries, medical/dental appointments, religious holidays, personal business, and emergencies as follows: 0-4 years of service - 25 days 5-6 years of service - 30 days 7th year of service - 32 days 8th year of service - 33 days 9th year of service - 34 days 10-14 years of service - 35 days 15-19 years of service - 38 days 20 or more years - 42 days At the CEO’s discretion, prior service at a public transportation or public agency, or rail transportation company may be counted towards an employee’s total service years to increase the employee’s PTO accrual rate. To be considered, Human Resources requires that a written request along with verification and confirmation of the years of service be provided prior to the start of employment with SCRRA. Human Resources will provide the final determination on behalf of the CEO. EMPLOYEE ASSISTANCE PROGRAM (EAP): SCRRA offers you and your immediate and dependent family members confidential counseling 24 hours a day, 7 days a week for family, personal, work-related and substance abuse issues through the EAP. You are entitled to a telephone session(s) with a trained EAP professional to assess the nature of the problem and provide a referral for additional assistance, if needed. Services also include three (3) face-to-face counseling sessions per family member per six (6) month period. HEALTH ADVOCACY SERVICES: SCRRA offers you and your eligible dependents free health advocacy services through Health Advocate. You are entitled to unlimited calls with trained professionals who can help you navigate the healthcare and insurance systems. RETIREMENT PLAN: The SCRRA contracts with the California Public Employees' Retirement System (CalPERS). You pay a 8.00 percent employee contribution and SCRRA pays an employer contribution, which varies each year. To be eligible for service retirement, you must be at least age 52 and have a minimum of five (5) years of CalPERS-credited service. Upon retirement you are entitled to a monthly retirement benefit based on your years of credited service, age, and average compensation during your last three (3) years of service (“final compensation”). The retirement formula for New Members is 2%@62, which means at age 62, you receive 2 percent of your final compensation for every year of service. Upon separation from employment with less than 5 years of credited service, you may request a refund of your employee contributions only, including interest, and end your membership with CalPERS, or leave it in your account and retain your service credit should you decide to work for another CalPERS-covered agency. If you are vested upon separation but do not retire, you may leave your contributions in your account until retirement or elect a refund. SOCIAL SECURITY: You do not participate in Social Security except for Medicare. You will contribute 1.45 percent of your pay to cover the hospital insurance portion of Medicare. *Additional Medicare Hospital Insurance Tax: As of January 1, 2013, employees are required to pay an additional 0.9 percent Medicare tax on earnings above $200,000 (for those who file an individual return) or $250,000 (for those who file a joint return). This additional hospital insurance tax is not reflected in the rate above. RETIREE MEDICAL: Unrepresented employees hired before 11/1/18*: You will be eligible for medical coverage when you retire if your separation date and retirement date are within 120 days of each other. SCRRA pays the same amount for retirees as it does for active employees, which is currently 87.5 percent of the applicable premium. Unrepresented employees hired on or after 11/1/18: You will be eligible for medical coverage when you retire if your separation date and retirement date are within 120 days of each other and you have a minimum of 10 years of credited CalPERS service, five of which must be performed at SCRRA. SCRRA pays a percentage of the state annuitant contribution rate** in accordance with the vesting schedule below: 10 Years of CalPERS Service - 50% 11 - 19 Years of CalPERS Service - 50%, plus 5% for each additional year of service 20+ Years of CalPERS Service - 100% *Once each year the employer may allow unrepresented employees hired before 11/1/18 the opportunity to individually elect to be subject to the vesting schedule. **The state annuitant contribution rates for 2023 are: $883 (Retiree Only); $1,699 (Retiree + 1 Dependent); $2,124 (Retiree + Family). DEFERRED COMPENSATION PLAN (457) : You are eligible to set aside a portion of your current income without paying taxes on that money until it is received later during retirement when taxes may be lower. In 2023, you can defer up to 100 percent of your gross compensation or $22,500 annually, whichever is less (“normal contribution limit”). You may make an additional $7,500 contribution to the plan if you are age 50 and older. If you are at least within three years of the age in which you are eligible to receive unreduced benefits under our CalPERS retirement plan, you may contribute up to double the normal contribution limit, or $45,000. TRANSPORTATION PASSES: You may use your employee badge for unlimited free access to all Metrolink lines and trains. Your badge cannot be used on connecting public transportation. However, if you commute to/from work on Metrolink on a regular basis and need to connect to other public transportation (e.g., Metro Red or Purple Line) you can be issued a Metrolink pass with the appropriate station pair, which will also give you access to connecting transportation. You are also eligible to receive a free transit pass to ride any greater Los Angeles area transit system other than Metrolink (such as, Metro, Foothill Transit, LADOT, and LOSSAN) for commuting purposes. The commuter transit pass has a value up to the monthly maximum tax-free transit pass amount established by the Internal Revenue Service ($300 in 2023). You are responsible for any transit fares above the IRS monthly cap. To receive this benefit, the SCRRA requires each employee to use public transportation to commute to and from work three (3) or more days per week. OTHER BENEFITS: Educational Assistance - SCRRA will reimburse an employee up to $1,000 per fiscal year for tuition, books and mandatory student fees for courses that are relevant to employment. No reimbursement is allowed for parking. Professional Memberships - SCRRA pays up to $300 per year for professional memberships. Credit Union Membership - SCRRA offers credit union services for employees and their family members, provided by Northrup Grumman Federal Credit Union. Jury Duty - SCRRA will continue an employee's salary during any non-voluntary jury service up to a maximum of ten (10) working days. Pregnancy Disability and Family and Medical Leaves - A leave of absence may be paid or unpaid and shall be granted in accordance with applicable federal and state laws, and SCRRA policy. Refer to the Human Resource Policies and Procedures Manual for more detailed information. Bereavement Leave - In the event of death in an employee’s immediate family, the agency grants up to three (3) working days, with pay, to handle family affairs and to attend the funeral. When an employee needs to travel outside the radius of the five (5) member agencies due to the death of an immediate family member, the Authority grants up to five (5) working days, with pay. Military Leave - Employees will be paid for the annually required active period. At the discretion of the Chief Executive Officer, and with Board notification, paid military leave may be granted beyond what is provided by the applicable state law. Closing Date/Time: Continuous
City of Los Angeles
City Of Los Angeles, California, United States
DUTIES ANNUAL SALARY: $112,564 to $164,576 The salary in the Department of Water and Power is $138,058 to $171,529. NOTES : Annual salary is at the start of the pay range. The current salary range is subject to change. Please confirm the starting salary with the hiring department before accepting a job offer. For information regarding reciprocity between the City of Los Angeles departments and LADWP, go to http://per.lacity.org/Reciprocity_CityDepts_and_DWP.pdf . A Database Architect performs technical and administrative work in the development of standards, methods, techniques, policies, procedures, data analyses, data designs, database implementations, and data governance necessary for the productive integration, sharing, standardization, integrity, security, availability, consistency, and usability of data throughout the City’s on-premises and cloud-based databases; assists in the implementation, maintenance, operation, or overall management of and database-level integration between the on-premises and cloud-based databases; installs and configures database software and related administration tools and utilities; develops and implements production scripts for database maintenance tasks; tunes and optimizes SQL statements and database/system parameters; develops and conducts training; utilizes database tools to perform various types of database backups and recoveries; ensures database security and compliance with SB1386 or data privacy acts; researches current database issues and technologies; assists application developer to apply sound database technology to new application; may supervise other technical employees in the performance of this work; and performs related duties. REQUIREMENT(S)/MINIMUM QUALIFICATION(S) A bachelor’s degree from an accredited four-year college or university in information systems, software engineering, computer engineering, computer science, or a related field; AND ONE OF THE FOLLOWING : Two years of full-time paid experience installing, administering, tuning, and maintaining databases in a medium to large scale production environment in one of the following database platforms: Oracle, DB2, SQL Server, MySQL, MariaDB, or PostgreSQL in a position at the level of Senior Systems Analyst I, Systems Programmer I, or Programmer Analyst IV with the City of Los Angeles; OR Two years of full-time paid experience as a database architect or database administrator in the information technology industry installing, administering, tuning, and maintaining medium to large scale production databases in one of the following database platforms: Oracle, DB2, SQL Server, MySQL, MariaDB, or PostgreSQL; OR Two years of full-time paid experience designing, building, operationalizing, securing, monitoring, and maintaining Google Cloud Platform or comparable cloud computing platforms using applicable data infrastructure such as Google Cloud Storage, Google BigQuery, Google CloudSQL, and Google Cloud Run for data processing in a position at the level of Senior Systems Analyst I, Systems Programmer I, or Programmer Analyst IV with the City of Los Angeles; OR Two years of full-time paid experience as a database architect or database administrator in the information technology industry designing, building, operationalizing, securing, monitoring, and maintaining Google Cloud Platform or comparable cloud computing platforms using applicable data infrastructure such as Google Cloud Storage, Google BigQuery, Google CloudSQL, and Google Cloud Run for data processing. A DBA professional certification in one of the following databases may be substituted for up to one year of the required experience: Oracle Database, version 10g or higher - Any operating system, Oracle Certified Professional (OCP) DB2 Universal Database, version 11 or higher - Any operating system, IBM Certified Database Administrator Microsoft SQL Server version 2012 or higher - Microsoft Certified Database Administrator (MCDBA) MySQL 5.7 or higher - Any operating system, MySQL Certified Database Administrator MariaDB version 10 or higher - Any operating system, MariaDB Certified Database Administrator PostgreSQL, version 12 - Any operating system, PostgreSQL Professional Certification Google Certified Professional Data Engineer PROCESS NOTES: Applicants who lack six months or less of the required experience may file for this examination. However, they cannot be appointed until the full experience requirement is met. Some positions may require a valid California driver’s license. Candidates may not be eligible for appointment to these positions if their record within the last 36 months reflects three or more moving violations and/or at-fault accidents, or a conviction of a major moving violation (such as DUI). Applicants must list their school name and location, type of degree earned and major in the Education Section of the application. Applicants who fail to provide this information on their application will not be considered further in this examination and their applications will not be processed. Please note that qualifying education must be from a college or university accredited by a City of Los Angeles recognized agency. A list of approved accrediting agencies can be found at http://per.lacity.org/Accredited%20Institutions%2008-21-08.pdf . Candidates completing the examination process will be contacted by the Personnel Department to provide required proof of qualifying degree. Applicants who wish to expedite this process may attach a copy of their qualifying degree to their on-line application at the time of filing in the Attachments section. Applicants wishing to substitute a DBA professional certification for up to one year of the required experience in Requirement #2, #3, #4, or #5 must attach proof of completion of the DBA professional certification at the time of filing in the Attachments section. The copy of the document(s) must be attached to the on-line application BEFORE the application is submitted. If the document(s) is attached AFTER the on-line application has been submitted, it will not be available to the City and applicants WILL NOT be credited with having submitted the documents. The substitution will not be considered for applicants who fail to provide the information at the time of filing. Please note that the following DBA professional certifications listed under the substitution clause may be updated in future exam bulletins to: Oracle Database, version 19c or higher - Any operating system, Oracle Certified Professional (OCP) DB2 Universal Database, version 12 or higher - Any operating system, IBM Certified Database Administrator Microsoft SQL Server version 2016 or higher - Microsoft Certified Database Administrator (MCDBA) SELECTIVE CERTIFICATION: In accordance with Charter Section 1010 (b) and Civil Service Rule 5.31, selective certification will be used for some positions that require special skills and/or training. Only persons possessing the following specific professional certification(s) at the time of filing may be considered for appointment to fill such positions: AWS Certified Database-Specialty Certification Google Certified Professional Data Engineer IBM Certified Database Administrator - DB2 8 or higher (Linux, UNIX, and Windows) IBM Certified Database Administrator - DB2 9 or higher for z/OS IBM Certified Database Administrator - DB2 v12 or higher for z/OS IBM InfoSphere DataStage Badge Essentials MariaDB Certified Database Administrator - MariaDB version 10 or higher Microsoft Certified: Azure Database Administrator Associate Microsoft Certified Database Administrator (MCDBA) Microsoft Certified Solutions Associate (MCSA) Microsoft SQL 2016 Database Administration Microsoft Certified Solutions Expert (MCSE) - Data Management and Analytics Microsoft Certified Solutions Associate (MCSA) - SQL Database Administration Microsoft Certified Solutions Associate (MCSA): Data Engineering with Azure Microsoft Certified Solutions Associate (MCSA) - SQL 2016 Database Administration Microsoft Certified Solutions Associate (MSCA): SQL 2016 BI Development or more recent MySQL Certified Database Administrator - MySQL 5.7 or higher Oracle 10g Administrator Certified Associate (OCA) or higher Oracle 10g Administrator Certified Master (OCM) or higher Oracle 10g Administrator Certified Professional (OCP) or higher Oracle 12c Administrator Certified Associate (OCA) or higher Oracle 12c Administrator Certified Master (OCM) or higher Oracle 19c Administrator Certified Professional (OCP) or higher Oracle Data Integrator 11g or 12c (or higher) Certified Implementation Specialist Oracle E-Business Suite R12 PostgreSQL Professional Certification - PostgreSQL version 12 or higher PowerCenter Data Integration 10 or higher: Administrator, Specialist Certification PowerCenter Data Integration 10 or higher: Developer, Specialist Certification NOTE : Applicants must attach a copy of the certificate(s) to the on-line application at the time of filing. The certificate(s) must be attached to the on-line application BEFORE the application is submitted. If the certificate(s) is attached AFTER the on-line application has been submitted, it will not be available to the City and applicants WILL NOT be credited with having submitted the certificate(s), and will not be considered for this part of selective certification. WHERE TO APPLY & APPLICATION DEADLINE Applications will only be accepted on-line on the dates listed in the “Application Deadline” section of this bulletin. When you are viewing the on-line job bulletin of your choice, simply scroll to the top of the page and select the “Apply” icon. On-line job bulletins are also available at https://www.governmentjobs.com/careers/lacity . NOTE : Applicants are urged to apply early to ensure you have time to resolve any technical issues you may encounter. Applications will only be accepted on-line on the dates listed below: Friday, October 6, 2023 to Thursday, October 19, 2023 Friday, May 3, 2024 to Thursday, May 16, 2024 The examination may close without prior notice at any time after a sufficient number of applications have been received. Filing periods may change without prior notice or additional dates may be added, as needed, at a later date. For administrative purposes, filing will close periodically and reopen on the dates noted in the “Application Deadline” section of this bulletin. In accordance with Civil Service Rule 4.2, all applicants who apply may not be tested in this examination. To meet anticipated hiring needs, only a limited number of qualified applicants will be invited to participate in the selection process in the following order: 1) Los Angeles City promotional applicants who meet the minimum requirements. You must have received a regular appointment to a City position or be on a reserve list to apply for this examination as a promotional candidate; 2) Applicants currently employed by the City of Los Angeles on a part-time or exempt basis who meet the minimum requirements; 3) Remaining applicants who meet the minimum requirements in sufficient numbers to meet hiring needs based on a random sampling of those qualified candidates. Applicants not selected to be tested may re-apply in a subsequent filing period in order to be considered for that period’s selection process. SELECTION PROCESS Examination Weights: Technical Exercise: Advisory Interview: 100% The examination will consist entirely of an evaluation of professional and personal qualifications by interview. In the interview, the following competencies may be evaluated: Analytical Ability; Attention to Detail; Initiative; Innovation; Responsiveness and Follow-Up; Teamwork; Oral Communication; Job Knowledge, including knowledge of: high-availability, high-performance, and disaster recovery databases; data management principles, data flow, and systems design theory; database tuning methods; database design principles and conceptual modeling techniques; general query and transaction processing concepts; metadata repository concepts; data arrangement and distribution; performance trade-offs, data structures, and relative strengths and weaknesses of database management systems; programming languages; control systems software and native or third-party tools; internal systems components; various relational database management schemas; software tools and technologies necessary to move or replicate data; Google Cloud platform functionalities; and other necessary knowledge, skills, and abilities. Additional job analysis information can be obtained by going to https://per.lacity.org/jobs/job-analyses.cfm and clicking on Competencies under Database Architect. Prior to the interview, candidates will be required to prepare some technical, written material related to the duties and responsibilities of a Database Architect. This material will not be separately scored, but will be presented to the interview board for review and consideration, which may include discussion, in the overall evaluation of the candidate. Those who do not complete the advisory technical exercise will not be invited to the interview and will be considered to have failed the entire examination. To be considered complete, the advisory technical exercise must include a substantive response for each question or problem included in the advisory technical exercise for which a candidate is required to provide an answer. Please note that candidates must complete the advisory technical exercise and meet the minimum qualifications as stated on this bulletin in order to be considered further in the examination process. The advisory technical exercise will be administered on-line . Candidates invited to participate in the examination will receive an e-mail from the City of Los Angeles outlining the specific steps needed to complete the on-line advisory technical exercise. Candidates who fail to complete the advisory technical exercise as instructed may be disqualified. For candidates who apply between FRIDAY, OCTOBER 6, 2023 and THURSDAY, OCTOBER 19, 2023 , it is anticipated that the on-line advisory technical exercise will be administered between MONDAY, NOVEMBER 27, 2023 and MONDAY, DECEMBER 4, 2023 . For candidates who apply between FRIDAY, MAY 3, 2024 and THURSDAY, MAY 16, 2024 , it is anticipated that the on-line advisory technical exercise will be administered between MONDAY, JUNE 24, 2024 and MONDAY, JULY 1, 2024 . Candidates will be notified later by e-mail of the date, time, and location of the interview, which will be held in Los Angeles or on-line. For candidates who apply between FRIDAY, OCTOBER 6, 2023 and THURSDAY, OCTOBER 19, 2023 , it is anticipated that interviews will begin during the period of DECEMBER 26, 2023 to JANUARY 5, 2024 . For candidates who apply between FRIDAY, MAY 3, 2024 and THURSDAY, MAY 16, 2024 , it is anticipated that interviews will begin during the period of July 22, 2024 to August 2, 2024. NOTES : This examination is based on a validation study. As a covered entity under the Fair Employment and Housing Act and Title II of the Americans with Disabilities Act, the City of Los Angeles does not discriminate on the basis of disability and upon request, will provide reasonable accommodations to ensure equal access to its programs, services, and activities. To request a disability accommodation, please complete the Disability Accommodation Form within 14 calendar days of the submittal of the City application. The Disability Accommodation Form can be obtained at http://per.lacity.org/exams/verify_disability.pdf . Applications are accepted subject to review to ensure that minimum qualifications are met. Candidates may be disqualified at any time if it is determined that they do not possess the minimum qualifications stated on this bulletin. In conjunction with Civil Service Rules, applicants who have received a regular appointment to a City position or are on a reserve list will be considered Promotional candidates while all other applicants will be considered Open candidates. The promotional list will ordinarily be used ahead of the open competitive list. However, if open competitive candidates receive a higher score, without military credits, than the highest available promotional candidate, after adding 0.25 of a point seniority credit for each year of continuous classified City service, the Civil Service Commission, upon request of the appointing authority, may approve certification of such open competitive candidates ahead of the promotional candidates. You may take the Database Architect advisory technical exercise only once every 24 months under this bulletin. If you have taken the Database Architect advisory technical exercise within the last 24 months, you may not file for this examination at this time. Your rank on the employment list may change as scores of candidates from other administrations of this examination are merged onto one list. Your name may be removed from the open competitive list after six (6) months. A final average score of 70% or higher is required to be placed on the eligible list. In accordance with Civil Service Rule, Sec. 4.24, review periods may be combined. Candidates in the examination process may file protests as provided in Sec. 4.20, 4.22, and 4.23 as applicable and within the required time frame; however, the Personnel Department may respond to and resolve protests prior to the establishment of the eligible list. For candidates seeking initial City employment, in accordance with Los Angeles City Ordinance 187134, information regarding COVID-19 vaccination requirements as conditions of employment may be found at: https://clkrep.lacity.org/onlinedocs/2021/21-0921_ord_187134_8-24-21.pdf . Notice : If you receive and accept an offer of employment to a regular position with the City of Los Angeles, your employee benefit coverage (including health and dental coverage as well as life insurance) will commence approximately six weeks after your original regular appointment. Not all positions in the City receive benefit coverage; you should inquire regarding the availability of employee benefits prior to accepting a position. All City employees are required to be Disaster Service Workers. THIS EXAMINATION IS TO BE GIVEN BOTH ON AN INTERDEPARTMENTAL PROMOTIONAL AND OPEN COMPETITIVE BASIS The City of Los Angeles does not discriminate on the basis of race, religion, national origin, sex, age, marital status, sexual orientation, gender identity, gender expression, disability, creed, color, ancestry, medical condition (cancer), or Acquired Immune Deficiency Syndrome. AN EQUAL EMPLOYMENT OPPORTUNITY EMPLOYER For additional information and FAQs regarding the City's hiring process, please go to: https://per.lacity.org/faqs/employment-testing-process.html There are many things to consider in a new employer. Visit the following webpage to view benefits the City of Los Angeles offers its employees: http://per.lacity.org/bens/index.html Closing Date/Time: Continuous
Mar 07, 2024
Full Time
DUTIES ANNUAL SALARY: $112,564 to $164,576 The salary in the Department of Water and Power is $138,058 to $171,529. NOTES : Annual salary is at the start of the pay range. The current salary range is subject to change. Please confirm the starting salary with the hiring department before accepting a job offer. For information regarding reciprocity between the City of Los Angeles departments and LADWP, go to http://per.lacity.org/Reciprocity_CityDepts_and_DWP.pdf . A Database Architect performs technical and administrative work in the development of standards, methods, techniques, policies, procedures, data analyses, data designs, database implementations, and data governance necessary for the productive integration, sharing, standardization, integrity, security, availability, consistency, and usability of data throughout the City’s on-premises and cloud-based databases; assists in the implementation, maintenance, operation, or overall management of and database-level integration between the on-premises and cloud-based databases; installs and configures database software and related administration tools and utilities; develops and implements production scripts for database maintenance tasks; tunes and optimizes SQL statements and database/system parameters; develops and conducts training; utilizes database tools to perform various types of database backups and recoveries; ensures database security and compliance with SB1386 or data privacy acts; researches current database issues and technologies; assists application developer to apply sound database technology to new application; may supervise other technical employees in the performance of this work; and performs related duties. REQUIREMENT(S)/MINIMUM QUALIFICATION(S) A bachelor’s degree from an accredited four-year college or university in information systems, software engineering, computer engineering, computer science, or a related field; AND ONE OF THE FOLLOWING : Two years of full-time paid experience installing, administering, tuning, and maintaining databases in a medium to large scale production environment in one of the following database platforms: Oracle, DB2, SQL Server, MySQL, MariaDB, or PostgreSQL in a position at the level of Senior Systems Analyst I, Systems Programmer I, or Programmer Analyst IV with the City of Los Angeles; OR Two years of full-time paid experience as a database architect or database administrator in the information technology industry installing, administering, tuning, and maintaining medium to large scale production databases in one of the following database platforms: Oracle, DB2, SQL Server, MySQL, MariaDB, or PostgreSQL; OR Two years of full-time paid experience designing, building, operationalizing, securing, monitoring, and maintaining Google Cloud Platform or comparable cloud computing platforms using applicable data infrastructure such as Google Cloud Storage, Google BigQuery, Google CloudSQL, and Google Cloud Run for data processing in a position at the level of Senior Systems Analyst I, Systems Programmer I, or Programmer Analyst IV with the City of Los Angeles; OR Two years of full-time paid experience as a database architect or database administrator in the information technology industry designing, building, operationalizing, securing, monitoring, and maintaining Google Cloud Platform or comparable cloud computing platforms using applicable data infrastructure such as Google Cloud Storage, Google BigQuery, Google CloudSQL, and Google Cloud Run for data processing. A DBA professional certification in one of the following databases may be substituted for up to one year of the required experience: Oracle Database, version 10g or higher - Any operating system, Oracle Certified Professional (OCP) DB2 Universal Database, version 11 or higher - Any operating system, IBM Certified Database Administrator Microsoft SQL Server version 2012 or higher - Microsoft Certified Database Administrator (MCDBA) MySQL 5.7 or higher - Any operating system, MySQL Certified Database Administrator MariaDB version 10 or higher - Any operating system, MariaDB Certified Database Administrator PostgreSQL, version 12 - Any operating system, PostgreSQL Professional Certification Google Certified Professional Data Engineer PROCESS NOTES: Applicants who lack six months or less of the required experience may file for this examination. However, they cannot be appointed until the full experience requirement is met. Some positions may require a valid California driver’s license. Candidates may not be eligible for appointment to these positions if their record within the last 36 months reflects three or more moving violations and/or at-fault accidents, or a conviction of a major moving violation (such as DUI). Applicants must list their school name and location, type of degree earned and major in the Education Section of the application. Applicants who fail to provide this information on their application will not be considered further in this examination and their applications will not be processed. Please note that qualifying education must be from a college or university accredited by a City of Los Angeles recognized agency. A list of approved accrediting agencies can be found at http://per.lacity.org/Accredited%20Institutions%2008-21-08.pdf . Candidates completing the examination process will be contacted by the Personnel Department to provide required proof of qualifying degree. Applicants who wish to expedite this process may attach a copy of their qualifying degree to their on-line application at the time of filing in the Attachments section. Applicants wishing to substitute a DBA professional certification for up to one year of the required experience in Requirement #2, #3, #4, or #5 must attach proof of completion of the DBA professional certification at the time of filing in the Attachments section. The copy of the document(s) must be attached to the on-line application BEFORE the application is submitted. If the document(s) is attached AFTER the on-line application has been submitted, it will not be available to the City and applicants WILL NOT be credited with having submitted the documents. The substitution will not be considered for applicants who fail to provide the information at the time of filing. Please note that the following DBA professional certifications listed under the substitution clause may be updated in future exam bulletins to: Oracle Database, version 19c or higher - Any operating system, Oracle Certified Professional (OCP) DB2 Universal Database, version 12 or higher - Any operating system, IBM Certified Database Administrator Microsoft SQL Server version 2016 or higher - Microsoft Certified Database Administrator (MCDBA) SELECTIVE CERTIFICATION: In accordance with Charter Section 1010 (b) and Civil Service Rule 5.31, selective certification will be used for some positions that require special skills and/or training. Only persons possessing the following specific professional certification(s) at the time of filing may be considered for appointment to fill such positions: AWS Certified Database-Specialty Certification Google Certified Professional Data Engineer IBM Certified Database Administrator - DB2 8 or higher (Linux, UNIX, and Windows) IBM Certified Database Administrator - DB2 9 or higher for z/OS IBM Certified Database Administrator - DB2 v12 or higher for z/OS IBM InfoSphere DataStage Badge Essentials MariaDB Certified Database Administrator - MariaDB version 10 or higher Microsoft Certified: Azure Database Administrator Associate Microsoft Certified Database Administrator (MCDBA) Microsoft Certified Solutions Associate (MCSA) Microsoft SQL 2016 Database Administration Microsoft Certified Solutions Expert (MCSE) - Data Management and Analytics Microsoft Certified Solutions Associate (MCSA) - SQL Database Administration Microsoft Certified Solutions Associate (MCSA): Data Engineering with Azure Microsoft Certified Solutions Associate (MCSA) - SQL 2016 Database Administration Microsoft Certified Solutions Associate (MSCA): SQL 2016 BI Development or more recent MySQL Certified Database Administrator - MySQL 5.7 or higher Oracle 10g Administrator Certified Associate (OCA) or higher Oracle 10g Administrator Certified Master (OCM) or higher Oracle 10g Administrator Certified Professional (OCP) or higher Oracle 12c Administrator Certified Associate (OCA) or higher Oracle 12c Administrator Certified Master (OCM) or higher Oracle 19c Administrator Certified Professional (OCP) or higher Oracle Data Integrator 11g or 12c (or higher) Certified Implementation Specialist Oracle E-Business Suite R12 PostgreSQL Professional Certification - PostgreSQL version 12 or higher PowerCenter Data Integration 10 or higher: Administrator, Specialist Certification PowerCenter Data Integration 10 or higher: Developer, Specialist Certification NOTE : Applicants must attach a copy of the certificate(s) to the on-line application at the time of filing. The certificate(s) must be attached to the on-line application BEFORE the application is submitted. If the certificate(s) is attached AFTER the on-line application has been submitted, it will not be available to the City and applicants WILL NOT be credited with having submitted the certificate(s), and will not be considered for this part of selective certification. WHERE TO APPLY & APPLICATION DEADLINE Applications will only be accepted on-line on the dates listed in the “Application Deadline” section of this bulletin. When you are viewing the on-line job bulletin of your choice, simply scroll to the top of the page and select the “Apply” icon. On-line job bulletins are also available at https://www.governmentjobs.com/careers/lacity . NOTE : Applicants are urged to apply early to ensure you have time to resolve any technical issues you may encounter. Applications will only be accepted on-line on the dates listed below: Friday, October 6, 2023 to Thursday, October 19, 2023 Friday, May 3, 2024 to Thursday, May 16, 2024 The examination may close without prior notice at any time after a sufficient number of applications have been received. Filing periods may change without prior notice or additional dates may be added, as needed, at a later date. For administrative purposes, filing will close periodically and reopen on the dates noted in the “Application Deadline” section of this bulletin. In accordance with Civil Service Rule 4.2, all applicants who apply may not be tested in this examination. To meet anticipated hiring needs, only a limited number of qualified applicants will be invited to participate in the selection process in the following order: 1) Los Angeles City promotional applicants who meet the minimum requirements. You must have received a regular appointment to a City position or be on a reserve list to apply for this examination as a promotional candidate; 2) Applicants currently employed by the City of Los Angeles on a part-time or exempt basis who meet the minimum requirements; 3) Remaining applicants who meet the minimum requirements in sufficient numbers to meet hiring needs based on a random sampling of those qualified candidates. Applicants not selected to be tested may re-apply in a subsequent filing period in order to be considered for that period’s selection process. SELECTION PROCESS Examination Weights: Technical Exercise: Advisory Interview: 100% The examination will consist entirely of an evaluation of professional and personal qualifications by interview. In the interview, the following competencies may be evaluated: Analytical Ability; Attention to Detail; Initiative; Innovation; Responsiveness and Follow-Up; Teamwork; Oral Communication; Job Knowledge, including knowledge of: high-availability, high-performance, and disaster recovery databases; data management principles, data flow, and systems design theory; database tuning methods; database design principles and conceptual modeling techniques; general query and transaction processing concepts; metadata repository concepts; data arrangement and distribution; performance trade-offs, data structures, and relative strengths and weaknesses of database management systems; programming languages; control systems software and native or third-party tools; internal systems components; various relational database management schemas; software tools and technologies necessary to move or replicate data; Google Cloud platform functionalities; and other necessary knowledge, skills, and abilities. Additional job analysis information can be obtained by going to https://per.lacity.org/jobs/job-analyses.cfm and clicking on Competencies under Database Architect. Prior to the interview, candidates will be required to prepare some technical, written material related to the duties and responsibilities of a Database Architect. This material will not be separately scored, but will be presented to the interview board for review and consideration, which may include discussion, in the overall evaluation of the candidate. Those who do not complete the advisory technical exercise will not be invited to the interview and will be considered to have failed the entire examination. To be considered complete, the advisory technical exercise must include a substantive response for each question or problem included in the advisory technical exercise for which a candidate is required to provide an answer. Please note that candidates must complete the advisory technical exercise and meet the minimum qualifications as stated on this bulletin in order to be considered further in the examination process. The advisory technical exercise will be administered on-line . Candidates invited to participate in the examination will receive an e-mail from the City of Los Angeles outlining the specific steps needed to complete the on-line advisory technical exercise. Candidates who fail to complete the advisory technical exercise as instructed may be disqualified. For candidates who apply between FRIDAY, OCTOBER 6, 2023 and THURSDAY, OCTOBER 19, 2023 , it is anticipated that the on-line advisory technical exercise will be administered between MONDAY, NOVEMBER 27, 2023 and MONDAY, DECEMBER 4, 2023 . For candidates who apply between FRIDAY, MAY 3, 2024 and THURSDAY, MAY 16, 2024 , it is anticipated that the on-line advisory technical exercise will be administered between MONDAY, JUNE 24, 2024 and MONDAY, JULY 1, 2024 . Candidates will be notified later by e-mail of the date, time, and location of the interview, which will be held in Los Angeles or on-line. For candidates who apply between FRIDAY, OCTOBER 6, 2023 and THURSDAY, OCTOBER 19, 2023 , it is anticipated that interviews will begin during the period of DECEMBER 26, 2023 to JANUARY 5, 2024 . For candidates who apply between FRIDAY, MAY 3, 2024 and THURSDAY, MAY 16, 2024 , it is anticipated that interviews will begin during the period of July 22, 2024 to August 2, 2024. NOTES : This examination is based on a validation study. As a covered entity under the Fair Employment and Housing Act and Title II of the Americans with Disabilities Act, the City of Los Angeles does not discriminate on the basis of disability and upon request, will provide reasonable accommodations to ensure equal access to its programs, services, and activities. To request a disability accommodation, please complete the Disability Accommodation Form within 14 calendar days of the submittal of the City application. The Disability Accommodation Form can be obtained at http://per.lacity.org/exams/verify_disability.pdf . Applications are accepted subject to review to ensure that minimum qualifications are met. Candidates may be disqualified at any time if it is determined that they do not possess the minimum qualifications stated on this bulletin. In conjunction with Civil Service Rules, applicants who have received a regular appointment to a City position or are on a reserve list will be considered Promotional candidates while all other applicants will be considered Open candidates. The promotional list will ordinarily be used ahead of the open competitive list. However, if open competitive candidates receive a higher score, without military credits, than the highest available promotional candidate, after adding 0.25 of a point seniority credit for each year of continuous classified City service, the Civil Service Commission, upon request of the appointing authority, may approve certification of such open competitive candidates ahead of the promotional candidates. You may take the Database Architect advisory technical exercise only once every 24 months under this bulletin. If you have taken the Database Architect advisory technical exercise within the last 24 months, you may not file for this examination at this time. Your rank on the employment list may change as scores of candidates from other administrations of this examination are merged onto one list. Your name may be removed from the open competitive list after six (6) months. A final average score of 70% or higher is required to be placed on the eligible list. In accordance with Civil Service Rule, Sec. 4.24, review periods may be combined. Candidates in the examination process may file protests as provided in Sec. 4.20, 4.22, and 4.23 as applicable and within the required time frame; however, the Personnel Department may respond to and resolve protests prior to the establishment of the eligible list. For candidates seeking initial City employment, in accordance with Los Angeles City Ordinance 187134, information regarding COVID-19 vaccination requirements as conditions of employment may be found at: https://clkrep.lacity.org/onlinedocs/2021/21-0921_ord_187134_8-24-21.pdf . Notice : If you receive and accept an offer of employment to a regular position with the City of Los Angeles, your employee benefit coverage (including health and dental coverage as well as life insurance) will commence approximately six weeks after your original regular appointment. Not all positions in the City receive benefit coverage; you should inquire regarding the availability of employee benefits prior to accepting a position. All City employees are required to be Disaster Service Workers. THIS EXAMINATION IS TO BE GIVEN BOTH ON AN INTERDEPARTMENTAL PROMOTIONAL AND OPEN COMPETITIVE BASIS The City of Los Angeles does not discriminate on the basis of race, religion, national origin, sex, age, marital status, sexual orientation, gender identity, gender expression, disability, creed, color, ancestry, medical condition (cancer), or Acquired Immune Deficiency Syndrome. AN EQUAL EMPLOYMENT OPPORTUNITY EMPLOYER For additional information and FAQs regarding the City's hiring process, please go to: https://per.lacity.org/faqs/employment-testing-process.html There are many things to consider in a new employer. Visit the following webpage to view benefits the City of Los Angeles offers its employees: http://per.lacity.org/bens/index.html Closing Date/Time: Continuous