City of Austin, TX
Austin, TX, United States
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
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
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: