California State Polytechnic University Pomona
3801 West Temple Avenue, Pomona, CA 91768, USA
Type of Appointment : Full-Time, Probationary Collective Bargaining Unit : California State University Employees Union - Unit 9 Job Classification : Analyst/ Programmer Anticipated Hiring Amount: $4,912 - $6,200 per month Work Hours : Monday - Friday 8:00am-5:00pm THE DEPARTMENT Enrollment Management & Services (EM&S) advances the educational mission of the University by providing leadership for the University's enrollment planning and management efforts. The department is responsible for providing comprehensive services and programs that promote the recruitment, matriculation, financial support and academic success of students. Specific responsibilities include: enrollment management and providing associated services to a variety of stakeholders utilizing the PeopleSoft enterprise system, supplemental software applications, and comprehensive reporting systems which support the enrollment planning process with critical data for student, academic, and financial planning. The Office of Student Systems and Operations (SSO) was formed to provide ongoing coordination and continuity between Enrollment Management & Services and the University’s central enterprise systems support teams. SSO supports EM&S administrative offices, academic departments, faculty, staff, and students in their use of PeopleSoft Campus Solutions and related student systems. SSO objectives are to maximize the benefits of PeopleSoft; interact with the university’s Division of Information Technology and other central systems support organizations; advise and alert other administrative areas on potential impacts; coordinate system usage and changes; manage system upgrades; and create, support, and maintain EM&S ancillary systems. DUTIES AND RESPONSIBILITIES Division and University Reports and Data Sets: Provide assistance and support to the Sr. Analyst Programmer. Develop proficiency in understanding student data elements and reporting tools (including PeopleSoft queries and reports). Write PeopleSoft queries as needed. Develop proficiency in data warehouse data tables. Perform data validation across a variety of key metrics. Analyze and verify reports to ensure data integrity. Create data sets for use by others. Plan, extract, generate and web-publish select university reports over a range of topics including FTES taught, FTEF by type, student/faculty ratios (SFR), major-faculty ratios (MFR), demographic profiles, and others. Develop data project specifications and seek to improve information delivery systems as well as delivery based on specified reporting schedules. Develop validated data models and reports for class schedule; faculty workload, diversity, salary, and tenure density; and instructional productivity and efficiency. Develop data models, validation methods, reporting templates, automated data delivery methods, and standard operating procedures for long-term sustainability and consistency of data and reports. Working from often vague specifications provided by users unfamiliar with the wide range of data possibilities, analyze reporting requirements, timeframe, complexity, and priority. Consult as needed to clarify requirements, supporting users with knowledge of data elements and typical reporting standards. Determine the appropriate data extraction and information delivery methodology. Meet immediate needs and leverage work to improve long-term ability to address future requests. Utilize multiple platforms in data work including (but not limited to): Oracle databases, SQL, Tableau, and Data warehouses. Dashboard development and Maintenance: Collaborate in the development of standard data models with report developers, programmers, and data architects in Institutional Research, Planning and Analytics (IRPA) and Business Intelligence. Provide knowledge transfer from other standard reporting to dashboard efforts. Make recommendations on method and source of data extraction. Coordinate with senior programmers in conversions of existing static reports to appropriate data dashboard presentations through independent and collaborative dashboard programming projects. Work with data end users to develop established and understood schedules for automated data delivery and notifications. Develop new and enhance existing dashboards utilizing the Tableau platform. Coordinate on the development of a roadmap for data dashboard development and deployment in alignment with University Strategic Plan and Academic Master Plan. Respond to dashboard maintenance requests and develop timetable and methodology for regular updates or improvements to existing dashboards. Systems Design and Support In collaboration with the Sr. Analyst Programmer analyze user system and application needs, determine and evaluate alternative solutions and approaches to meeting those needs, and select the optimal technology solution. Develop specifications and requirements for the optimal integration and implementation of systems and equipment. Design and support application programs to meet user requirements that optimize the use of available resources. Provide continual support of systems utilized by Academic Affairs including (but not limited to): Catalog and Curriculum Support (Curriculog/Acalog), Expanded Course Outlines (ECO), and other cloud/web based solutions including department websites. CSU APDB Reporting: In collaboration with Sr. Analyst Programmer, Academic Programs scheduling team and Research Analyst, support reporting of information to the CSU Academic Planning Database (APDB). For each term, collaborate in the execution of the APDB and Faculty Workload reporting processes. Generate reports from PeopleSoft, make edits to the generated flat files, ensure accuracy of the data, and submit in a timely manner an error free report that complies with the guidelines and requirements of the CSU Chancellor's Office. QUALIFICATIONS To enter this classification, a basic foundation of knowledge and skills in applications programming and systems analysis and related programming support functions is a prerequisite. This foundation would normally be obtained through a bachelor’s degree, preferably in computer science or business, or equivalent training and applied experience. Foundation knowledge and skills for the Analyst/Programmer, depending on the position assignment, may include working knowledge of a specific industry standard applications programming language and knowledge of standard systems analysis techniques. The career level is broad and includes intermediate through senior-level positions. Incumbents at this level work relatively independently and possess the experience to be fully proficient in performing most or all of the work assignments defined for their position. Typically, incumbents have acquired the requisite skills and knowledge through a combination of education, training, and progressive work experience to be able to demonstrate competence in independently applying technical judgment to standard and nonstandard applications and systems, solving a wide range of problems and developing practicable and thorough solutions, and using effective communication and listening skills. Preferred Qualifications Master's degree in computer science, data analytics, or related field. Technical Skills: Working knowledge of student data. Functional understanding of one or more Campus Solutions modules including: Admissions, Student Records, Financial Aid, Campus Community, and/or Academic Advising. Career-level proficiency in data retrieval/presentation tools including (but not limited to): SQL, Veera software, Tableau Software, Microsoft Office software, and other dashboard tools. Career-level proficiency in report programming and SQL scripts. Web design tools such as Cascade. Programming language platforms such as .NET, Python, and/or Java. Customer Service Skills: Treats all customers (students, faculty and staff colleagues) with dignity and respect, empathy, fairness and professionalism, consistent with the university mission, values and strategic vision. Self-confidence and interpersonal skills. Analytical and problem solving skills Good communication (both verbal and written) skills. Planning and organizing skills. Good administration management skills. Strong listening skills. Maintains a safe work environment. Communicates with the University community in a civil manner. Demonstrated ability to work with technical and functional peers and to share knowledge is required. Out of State Work The California State University (CSU) system is a network of twenty-three public universities providing access to a quality education through the support of California taxpayers. Part of CSU's mission is to prepare educated, responsible individuals to contribute to California's schools, economy, culture, and future. As an agency of the State of California, the CSU's business operations almost exclusively reside within California. The CSU Out-of-State Employment Policy prohibits hiring employees to perform CSU-related work outside California. See policy at https://calstate.policystat.com/v2/policy/10899725/latest/. Background Check Cal Poly Pomona will make a conditional offer of employment to final job candidates, pending the satisfactory completion of a background check (including a criminal records check). The conditional offer of employment may be rescinded if the background check reveals disqualifying information, and/or it is discovered that the candidate knowingly withheld or falsified information. In determining the suitability of the candidate for the position, Cal Poly Pomona will give an individualized assessment to any information that the applicant submits for consideration regarding the criminal conviction history such as the nature, gravity and recency of the conviction, the candidate’s conduct, performance or rehabilitation efforts since the conviction and the nature of the job applied for. For more information, go to https://calstate.policystat.com/policy/13813878/latest/ . Employment Eligibility Verification Cal Poly Pomona hires only individuals lawfully authorized to work in the United States. In compliance with federal law, all persons hired will be required to verify identity and eligibility to work in the United States and to complete the required employment eligibility verification form upon hire. See Form I-9 Acceptable Documents at https://www.uscis.gov/i-9-central/form-i-9-acceptable-documents. Child Abuse/Neglect Reporting Act (CANRA) The person holding this position is considered a "mandated reporter" under the California Child Abuse and Neglect Reporting Act and is required to comply with the requirements set forth in CSU Executive Order 1083 as a condition of employment. See policy at https://calstate.policystat.com/v2/policy/10927154/latest/. Security & Fire Safety In compliance with state and federal crime awareness and campus security legislation, including The Jeanne Clery Disclosure of Campus Security Policy and Crime Statistics Act, California Education Code section 67380, and the Higher Education Opportunity Act (HEOA), Cal Poly Pomona’s Annual Security Report and Annual Fire Safety Report are available for viewing at: https://www.cpp.edu/pdfs/annual_security_report.pdf and https://www.cpp.edu/housing/documents/fire_safety_report.pdf. Pay Transparency Nondiscrimination As a federal contractor, Cal Poly Pomona will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. For more information, see the Pay Transparency Nondiscrimination Provision poster . CSU Classification This position is part of the CSUEU bargaining unit, the CSU Classification Standards for this position are located on the following site, https://www.calstate.edu/csu-system/careers/compensation/Pages/Classification-Standards.aspx . The CSU Salary Schedule is located on the following site: https://www.calstate.edu/csu-system/careers/compensation/Pages/salary-schedule-documents.aspx . The classification salary range for this position according to the respective skill level is minimum $4,912 and maximum $12,124 per month. Please refer back to the anticipated hiring range for the appropriate salary rate for this particular position. Reasonable Accommodation We provide reasonable accommodations to applicants and employees with disabilities. Applicants with questions about access or requiring a reasonable accommodation for any part of the application or hiring process should contact the ADA Coordinator by email at ADACoordinator@cpp.edu. More information is available at: https://www.cpp.edu/eoda/employee-labor//access-accommodations/index.shtml. EEO Cal Poly Pomona is an Equal Opportunity Employer. The University subscribes to the pay transparency nondiscrimination provision and all state and federal regulations that prohibit discrimination based on race, color, religion, national origin, sex, gender identity/gender expression, sexual orientation, marital status, pregnancy, age, disability, genetic information, medical condition, and covered veteran status. More information is available at: https://www.dol.gov/sites/dolgov/files/OFCCP/pdf/pay-transp_%20English_formattedESQA508c.pdf and at https://www.cpp.edu/eoda/employee-labor/documents/aa-eeo-doc/policy-statement_2022-aap-for-california-state-polytechnic-university-pomona_confidential_20220127.pdf . Equity, Diversity, and Inclusion At Cal Poly Pomona, we are committed to the urgent and ongoing work of creating and sustaining an inclusive campus where all students, faculty, and staff are welcomed, respected and can flourish to achieve their dreams of success. We believe diversity strengthens community. Cal Poly Pomona proudly holds designations as both a Hispanic-Serving Institution (HSI) and an Asian American and Native American Pacific Islander-Serving Institution (AANAPISI). In 2022, the campus launched the Black Thriving Initiative recognizing that Cal Poly Pomona’s future as a university must be linked to the success of its Black community. More information about our campus initiatives can be found on the Office of Inclusive Excellence’s website . Other Notices For other important employment notices, we invite you to visit Cal Poly Pomona’s Employment Notices web page. Advertised: Apr 24 2024 Pacific Daylight Time Applications close: May 08 2024 Pacific Daylight Time Closing Date/Time:
Type of Appointment : Full-Time, Probationary Collective Bargaining Unit : California State University Employees Union - Unit 9 Job Classification : Analyst/ Programmer Anticipated Hiring Amount: $4,912 - $6,200 per month Work Hours : Monday - Friday 8:00am-5:00pm THE DEPARTMENT Enrollment Management & Services (EM&S) advances the educational mission of the University by providing leadership for the University's enrollment planning and management efforts. The department is responsible for providing comprehensive services and programs that promote the recruitment, matriculation, financial support and academic success of students. Specific responsibilities include: enrollment management and providing associated services to a variety of stakeholders utilizing the PeopleSoft enterprise system, supplemental software applications, and comprehensive reporting systems which support the enrollment planning process with critical data for student, academic, and financial planning. The Office of Student Systems and Operations (SSO) was formed to provide ongoing coordination and continuity between Enrollment Management & Services and the University’s central enterprise systems support teams. SSO supports EM&S administrative offices, academic departments, faculty, staff, and students in their use of PeopleSoft Campus Solutions and related student systems. SSO objectives are to maximize the benefits of PeopleSoft; interact with the university’s Division of Information Technology and other central systems support organizations; advise and alert other administrative areas on potential impacts; coordinate system usage and changes; manage system upgrades; and create, support, and maintain EM&S ancillary systems. DUTIES AND RESPONSIBILITIES Division and University Reports and Data Sets: Provide assistance and support to the Sr. Analyst Programmer. Develop proficiency in understanding student data elements and reporting tools (including PeopleSoft queries and reports). Write PeopleSoft queries as needed. Develop proficiency in data warehouse data tables. Perform data validation across a variety of key metrics. Analyze and verify reports to ensure data integrity. Create data sets for use by others. Plan, extract, generate and web-publish select university reports over a range of topics including FTES taught, FTEF by type, student/faculty ratios (SFR), major-faculty ratios (MFR), demographic profiles, and others. Develop data project specifications and seek to improve information delivery systems as well as delivery based on specified reporting schedules. Develop validated data models and reports for class schedule; faculty workload, diversity, salary, and tenure density; and instructional productivity and efficiency. Develop data models, validation methods, reporting templates, automated data delivery methods, and standard operating procedures for long-term sustainability and consistency of data and reports. Working from often vague specifications provided by users unfamiliar with the wide range of data possibilities, analyze reporting requirements, timeframe, complexity, and priority. Consult as needed to clarify requirements, supporting users with knowledge of data elements and typical reporting standards. Determine the appropriate data extraction and information delivery methodology. Meet immediate needs and leverage work to improve long-term ability to address future requests. Utilize multiple platforms in data work including (but not limited to): Oracle databases, SQL, Tableau, and Data warehouses. Dashboard development and Maintenance: Collaborate in the development of standard data models with report developers, programmers, and data architects in Institutional Research, Planning and Analytics (IRPA) and Business Intelligence. Provide knowledge transfer from other standard reporting to dashboard efforts. Make recommendations on method and source of data extraction. Coordinate with senior programmers in conversions of existing static reports to appropriate data dashboard presentations through independent and collaborative dashboard programming projects. Work with data end users to develop established and understood schedules for automated data delivery and notifications. Develop new and enhance existing dashboards utilizing the Tableau platform. Coordinate on the development of a roadmap for data dashboard development and deployment in alignment with University Strategic Plan and Academic Master Plan. Respond to dashboard maintenance requests and develop timetable and methodology for regular updates or improvements to existing dashboards. Systems Design and Support In collaboration with the Sr. Analyst Programmer analyze user system and application needs, determine and evaluate alternative solutions and approaches to meeting those needs, and select the optimal technology solution. Develop specifications and requirements for the optimal integration and implementation of systems and equipment. Design and support application programs to meet user requirements that optimize the use of available resources. Provide continual support of systems utilized by Academic Affairs including (but not limited to): Catalog and Curriculum Support (Curriculog/Acalog), Expanded Course Outlines (ECO), and other cloud/web based solutions including department websites. CSU APDB Reporting: In collaboration with Sr. Analyst Programmer, Academic Programs scheduling team and Research Analyst, support reporting of information to the CSU Academic Planning Database (APDB). For each term, collaborate in the execution of the APDB and Faculty Workload reporting processes. Generate reports from PeopleSoft, make edits to the generated flat files, ensure accuracy of the data, and submit in a timely manner an error free report that complies with the guidelines and requirements of the CSU Chancellor's Office. QUALIFICATIONS To enter this classification, a basic foundation of knowledge and skills in applications programming and systems analysis and related programming support functions is a prerequisite. This foundation would normally be obtained through a bachelor’s degree, preferably in computer science or business, or equivalent training and applied experience. Foundation knowledge and skills for the Analyst/Programmer, depending on the position assignment, may include working knowledge of a specific industry standard applications programming language and knowledge of standard systems analysis techniques. The career level is broad and includes intermediate through senior-level positions. Incumbents at this level work relatively independently and possess the experience to be fully proficient in performing most or all of the work assignments defined for their position. Typically, incumbents have acquired the requisite skills and knowledge through a combination of education, training, and progressive work experience to be able to demonstrate competence in independently applying technical judgment to standard and nonstandard applications and systems, solving a wide range of problems and developing practicable and thorough solutions, and using effective communication and listening skills. Preferred Qualifications Master's degree in computer science, data analytics, or related field. Technical Skills: Working knowledge of student data. Functional understanding of one or more Campus Solutions modules including: Admissions, Student Records, Financial Aid, Campus Community, and/or Academic Advising. Career-level proficiency in data retrieval/presentation tools including (but not limited to): SQL, Veera software, Tableau Software, Microsoft Office software, and other dashboard tools. Career-level proficiency in report programming and SQL scripts. Web design tools such as Cascade. Programming language platforms such as .NET, Python, and/or Java. Customer Service Skills: Treats all customers (students, faculty and staff colleagues) with dignity and respect, empathy, fairness and professionalism, consistent with the university mission, values and strategic vision. Self-confidence and interpersonal skills. Analytical and problem solving skills Good communication (both verbal and written) skills. Planning and organizing skills. Good administration management skills. Strong listening skills. Maintains a safe work environment. Communicates with the University community in a civil manner. Demonstrated ability to work with technical and functional peers and to share knowledge is required. Out of State Work The California State University (CSU) system is a network of twenty-three public universities providing access to a quality education through the support of California taxpayers. Part of CSU's mission is to prepare educated, responsible individuals to contribute to California's schools, economy, culture, and future. As an agency of the State of California, the CSU's business operations almost exclusively reside within California. The CSU Out-of-State Employment Policy prohibits hiring employees to perform CSU-related work outside California. See policy at https://calstate.policystat.com/v2/policy/10899725/latest/. Background Check Cal Poly Pomona will make a conditional offer of employment to final job candidates, pending the satisfactory completion of a background check (including a criminal records check). The conditional offer of employment may be rescinded if the background check reveals disqualifying information, and/or it is discovered that the candidate knowingly withheld or falsified information. In determining the suitability of the candidate for the position, Cal Poly Pomona will give an individualized assessment to any information that the applicant submits for consideration regarding the criminal conviction history such as the nature, gravity and recency of the conviction, the candidate’s conduct, performance or rehabilitation efforts since the conviction and the nature of the job applied for. For more information, go to https://calstate.policystat.com/policy/13813878/latest/ . Employment Eligibility Verification Cal Poly Pomona hires only individuals lawfully authorized to work in the United States. In compliance with federal law, all persons hired will be required to verify identity and eligibility to work in the United States and to complete the required employment eligibility verification form upon hire. See Form I-9 Acceptable Documents at https://www.uscis.gov/i-9-central/form-i-9-acceptable-documents. Child Abuse/Neglect Reporting Act (CANRA) The person holding this position is considered a "mandated reporter" under the California Child Abuse and Neglect Reporting Act and is required to comply with the requirements set forth in CSU Executive Order 1083 as a condition of employment. See policy at https://calstate.policystat.com/v2/policy/10927154/latest/. Security & Fire Safety In compliance with state and federal crime awareness and campus security legislation, including The Jeanne Clery Disclosure of Campus Security Policy and Crime Statistics Act, California Education Code section 67380, and the Higher Education Opportunity Act (HEOA), Cal Poly Pomona’s Annual Security Report and Annual Fire Safety Report are available for viewing at: https://www.cpp.edu/pdfs/annual_security_report.pdf and https://www.cpp.edu/housing/documents/fire_safety_report.pdf. Pay Transparency Nondiscrimination As a federal contractor, Cal Poly Pomona will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. For more information, see the Pay Transparency Nondiscrimination Provision poster . CSU Classification This position is part of the CSUEU bargaining unit, the CSU Classification Standards for this position are located on the following site, https://www.calstate.edu/csu-system/careers/compensation/Pages/Classification-Standards.aspx . The CSU Salary Schedule is located on the following site: https://www.calstate.edu/csu-system/careers/compensation/Pages/salary-schedule-documents.aspx . The classification salary range for this position according to the respective skill level is minimum $4,912 and maximum $12,124 per month. Please refer back to the anticipated hiring range for the appropriate salary rate for this particular position. Reasonable Accommodation We provide reasonable accommodations to applicants and employees with disabilities. Applicants with questions about access or requiring a reasonable accommodation for any part of the application or hiring process should contact the ADA Coordinator by email at ADACoordinator@cpp.edu. More information is available at: https://www.cpp.edu/eoda/employee-labor//access-accommodations/index.shtml. EEO Cal Poly Pomona is an Equal Opportunity Employer. The University subscribes to the pay transparency nondiscrimination provision and all state and federal regulations that prohibit discrimination based on race, color, religion, national origin, sex, gender identity/gender expression, sexual orientation, marital status, pregnancy, age, disability, genetic information, medical condition, and covered veteran status. More information is available at: https://www.dol.gov/sites/dolgov/files/OFCCP/pdf/pay-transp_%20English_formattedESQA508c.pdf and at https://www.cpp.edu/eoda/employee-labor/documents/aa-eeo-doc/policy-statement_2022-aap-for-california-state-polytechnic-university-pomona_confidential_20220127.pdf . Equity, Diversity, and Inclusion At Cal Poly Pomona, we are committed to the urgent and ongoing work of creating and sustaining an inclusive campus where all students, faculty, and staff are welcomed, respected and can flourish to achieve their dreams of success. We believe diversity strengthens community. Cal Poly Pomona proudly holds designations as both a Hispanic-Serving Institution (HSI) and an Asian American and Native American Pacific Islander-Serving Institution (AANAPISI). In 2022, the campus launched the Black Thriving Initiative recognizing that Cal Poly Pomona’s future as a university must be linked to the success of its Black community. More information about our campus initiatives can be found on the Office of Inclusive Excellence’s website . Other Notices For other important employment notices, we invite you to visit Cal Poly Pomona’s Employment Notices web page. Advertised: Apr 24 2024 Pacific Daylight Time Applications close: May 08 2024 Pacific Daylight Time Closing Date/Time:
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:
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:
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
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