Business Intelligence Analyst

Company: CAL Poly Pomona
Location: Pomona
Posted on: March 17, 2023

Job Description:

Business Intelligence AnalystJob No: 521941Work Type: StaffLocation: PomonaCategories: Unit 9 - CSUEU - Technical Support Services, Probationary, Full Time, Information Systems & Technology, Telecommute eligible (work onsite as scheduled and/or as requested and telecommute as scheduled)Type of Appointment: Full-time, probationaryCollective Bargaining Unit: California State University Employees Union (CSUEU - Unit 9)Job Classification: Analyst/Programmer I - Foundation Classification Salary Range: $3,713 - $7,149 per monthAnticipated Hiring Range: $6,250 per monthWork Hours: Monday - Friday, 8 am - 5 pm, unless otherwise notifiedRecruitment Closing Date: 1/19/2023THE DEPARTMENT:The Division of Information Technology & Institutional Planning (IT&IP) provides innovative, strategic, and cost-appropriate technology services in collaboration with the campus community to advance the mission of the university. Technology services are recognized as an essential resource in furthering the university's mission. IT will provide technology solutions, expert consultation, and leadership, resulting in numerous enhancements to the advancement of learning and knowledge and to the effectiveness of campus support services and business processes for the entire university.The Enterprise Applications department has a responsibility to provide systems analysis, programming, reporting, technical support, consultation, and testing of the enterprise-wide systems for the campus, which include PeopleSoft Systems (Campus Solutions, Human Resources, and Financials), data warehouse reporting system, data integration tools, and other applications. The unit assists in and tracks testing protocols related to patches and upgrades in PeopleSoft modules; supports the development of dashboards and data integrations; works with departments, users, and subject matter experts to improve functionality and troubleshoot issues as they arise; administers user security, tracks technology projects and tasks, coordinates resources to assure the timely delivery of services and project completion. DUTIES AND RESPONSIBILITIES: Contribute to the design and enhancement of Business Intelligence (BI) Architecture: Develop and maintain existing and new data models that form the foundation for accurate and timely reporting across the university. Create ETL (Extract, Transform, and Load) or data integration scripts to move data from source systems into the Business Intelligence reporting environment. Develop and maintain appropriate processing schedules. Troubleshoot in the event of load errors or system failures. Perform data validation and sanitation to ensure the BI Architecture's quality, accuracy, and relevance. Participate in the planning and implementation of migration from outdated to new data systems and tools. Proactively engage in ongoing professional development in order to stay abreast of emerging tools and approaches in this fast-changing field. Recommend new strategies based on best practices. Work closely with the Department Lead and Executive Director to research and develop solutions to integrate existing data sources into the campus-wide comprehensive reporting solution. Inform emerging campus data governance policies and practices, and take these into consideration in the ongoing development of data and reporting sources. Develop Dashboards: Gather user requirements and develop solutions for campus-wide dashboards and reports based on campus reporting standards. Develop campus-wide dashboards by applying Tableau development skills and knowledge about best practices for effective data visualization. Develop standards and processes behind the migration of reports/dashboards from development to production environments. Processes include, but are not limited to: code review for adherence to standards, impact on performance, and the administration of security related to dashboards/reports and data. Apply accessible technology (ATI) guidelines to data visualizations. Business Intelligence Support and Advocacy: Work with end users to troubleshoot and solve issues. Collaborate with department (DAA) colleagues in advocating for the effective utilization of campus data by facilitating access, training, and use by faculty and staff throughout the campus community. Provide training for users in one-on-one and group settings. Develop documentation and data dictionaries for users. Seek and review exemplary models of dashboards used at other universities and suggest ways to adapt them for local use as appropriate. Others: Consistent with job classification, assumes and carries out other duties and responsibilities at the discretion of the Executive Director of Enterprise Applications or his/her designee. Serve on committees, attend, and participate in departmental and campus meetings/events/activities. Utilizes advanced communication and listening skills through effective interpersonal interactions and written correspondence with Department, Division, University staff, and external contacts in person, by online communication tools, and via email. Consistent with job, operational, or project duties, communicate with Enterprise Application management staff and other appropriate functional managers regarding imminent systems, data, or security problems, and as directed, may facilitate alternatives. Uses sound judgment and decision-making in order to find solutions and implement appropriate and timely resolutions. QUALIFICATIONS: Equivalent to a bachelor's level degree in Computer Science, Computer Information Systems, Information Systems, Engineering Depth/Level of Knowledge - Functional/working knowledge of the specialty area demonstrated by an understanding and use of the general principles, practices, and theories pertinent to the specialty. Integration/Scope of Knowledge - Able to integrate knowledge and skill from other specialties to address problems. Technical Capabilities & Judgment - Demonstrated competency in applying standard and nonstandard technology applications and exploring and adapting to changing technology. Demonstrated ability to independently apply technical judgment to achieve desired results. Able to work from specifications with multiple systems and platforms. Problem Solving & Reasoning - Recognizes problems, uses reasoning and logic to establish possible causes, interprets and applies theories and principles, generates and evaluates alternative solutions, devises and implements a plan of action for the best resolution within organizational constraints. Able to develop solutions where precedents do not always exist. Future Thinking - Able to be proactive demonstrated by recognizing needs, anticipating outcomes and consequences of different approaches, and making necessary modifications to action plans to achieve desired results. Ability to Acquire Knowledge - Able to independently recognize and use various learning techniques to apply and adapt new knowledge and skills in related, different and changing situations. Communication Skills - Demonstrated competence in interpreting and communicating information, ideas, and instructions. Able to select appropriate information and the best method or format for presenting it. Listening Skills - Demonstrated reflective listening skills in working with others to interpret and identify needs and requirements and develop successful solutions. Leading/Teaching Skills - Demonstrated ability to assist others in completing assignments and to provide basic work direction. Able to train others on new skills and procedures. Team Skills - Able to plan and work on shared projects to achieve established objectives PREFERRED EXPERIENCE: Knowledge of data warehouse and business intelligence tools and best practices. Demonstrated competence in relational databases and structured programming design, ability to write and edit SQL queries. ? Experience in dimensional data modeling. Experience with PeopleSoft tables and data. Experience with data visualization tools (e.g. Tableau). Working knowledge of Oracle RDBMS. ODI (Oracle Data Integrator) - ETL tool Software release and system change management experience. Data analysis and programming languages (e.g., R, Python) Comprehensive knowledge, skills, and abilities to perform requirements analysis. Expertise and skills in technical and functional problem identification, resolving, and tracking. Advanced experience with using PC tools (Word processing, diagramming and spreadsheets). Effective communication of technical issues and solutions to faculty, staff, and management. Ability to work with shifting and demanding deadlines and workload. Ability to research multiple sources and recommend solutions to problems. Experience working in higher education. COVID-19 VaccinationCSU requires faculty, staff, and students who physically access campus facilities or programs to be fully vaccinated against COVID-19, which includes obtaining a COVID-19 booster dose, or declare a medical or religious exemption from doing so. Any candidates advanced in a currently open search process should be prepared to comply with this requirement. See policy at https://calstate.policystat.com/policy/11030468/latest.Out of State WorkThe 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 CheckCal Poly Pomona will make a conditional offer of employment, 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 criminal conviction history, considering such factors 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. See policy at https://www.cpp.edu/eoda/employee-labor//documents/employment-policies/hr2017-17.pdf. I-9Cal 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/.SmokingCal Poly Pomona is a smoke and tobacco-free campus. See policy at https://calstate.policystat.com/policy/6591951/latest/. Clery ActIn 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), the Cal Poly Pomona Annual Security and Fire Safety Report is available at: https://www.cpp.edu/campus-safety-plan.shtml.Reasonable AccommodationWe 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.EEOCal Poly Pomona is an Equal Opportunity, Affirmative Action 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.Advertised: January 05, 2023 (9:00 AM) Pacific Daylight TimeApplications close: January 19, 2023 (11:55 PM) To apply, visit https://careers.pageuppeople.com/873/po/en-us/job/521941/business-intelligence-analystCopyright -2022 Jobelephant.com Inc. All rights reserved.Posted by the FREE value-added recruitment advertising agency jeid-94f607d8cdb9d84091d0984ec62e7cb3

Keywords: CAL Poly Pomona, Pomona , Business Intelligence Analyst, Professions , Pomona, California