Business Intelligence Analyst

Type of Appointment: Full-Time, Probationary

Collective Bargaining Unit: California State University Employees Union – Unit 9

Job Classification: Analyst/Programmer – Expert

Anticipated Hiring Amount: $7,000 - 8,333 per month

Work Hours: Monday – Friday 8:00am-5:00pm

 

 

THE DEPARTMENT

This position is in the Enterprise Applications - Data Architecture & Analytics (DAA) area, within the Information Technology & Institutional Planning (IT&IP) Division. Under the direction of the Executive Director, DAA serves the university by providing leadership and support for data architecture, visualization, and analytics. The office provides action-oriented data that helps decision-makers throughout the university to foster student success and institutional effectiveness.

 

DUTIES AND RESPONSIBILITIES

• Contribute to the design and enhancement of Business Intelligence (BI) Architecture
• Develop and maintain existing and new data models that form the foundation for accurate and timely reporting across the university.
• Create ETL (Extract, Transform, and Load) scripts to move data from source systems into the Business Intelligence reporting environment. Develop and maintain appropriate processing schedules. Troubleshoot in the event of load errors or system failures.
• Perform data validation and sanitation to ensure quality, accuracy, and relevance of the BI Architecture.
• Participate in the planning and implementing of migration from outdated to new data systems and tools.
• Proactively engage in ongoing professional development in order to stay abreast of emerging tools and approaches in this fast-changing field. Recommend new strategies based upon best practices.
• Work closely with the Department Leads and Director to research and develop solutions to integrate existing data sources into the campus-wide comprehensive reporting solution.
• Inform emerging campus data governance policies and practices and take these into consideration in the ongoing development of data and reporting sources.
• Utilize data integration tools to design, develop, and maintain data integration solutions to enable the efficient and effective exchange of data between disparate sources.
• Develop BI Reports and Dashboards
• Gather user requirements and develop solutions for campus-wide dashboards and reports based on campus reporting standards.
• Develop campus-wide dashboards by applying Tableau development skills and knowledge about best practices for effective data visualization.
• Develop standards and processes behind the migration of reports/dashboards from development to production environments.
• Processes include, but are not limited to: code review for adherence to standards; impact on performance; and the administration of security related to dashboards/reports and data.
• Apply accessible technology (ATI) guidelines to data visualizations.
• Work with end-users to troubleshoot and solve issues.
• Collaborate with department (DAA) colleagues in advocating for effective utilization of campus data by facilitating access, training, and use by faculty and staff throughout the campus community.
• Provide training for users in one-on-one and group settings.
• Develop documentation and data dictionaries for users.
• Seek and review exemplary models of dashboards used at other universities and suggest ways to adapt them for local use as appropriate.
• Lead in new development, enhancement, release, upgrade, or implementation projects, including developing and maintaining project plans in coordination with other team participants; managing project issues; collaborating with other project participants in accomplishing tasks, communicating issues to management and other project participants to ensure resolution
• Lead project management on sub-projects within an overall campus or department project.
• Coordinate task assignment and completion with staff members this position leads.
• Collaborate with multiple constituents (consultants, faculty, staff, and management) to address technical and functional issues, as well as implement new products and services or enhance existing services to meet campus and/or department needs.
• Communication and coordinate maintenance, support, and changes to the enterprise applications across a diverse audience, including technical staff (DBAs, developers, server administrators), functional departments (including Student Administration, Academic Affairs and Administrative Affairs), IT management, and CSU/CMS to plan changes, identify issues, and to mitigate unintended impacts.
• Coordinate technical testing to ensure end-to-end testing across interdependent groups. Provide technical expertise to developers, system administration, and end-users to ensure comprehensive testing. Document and communicate results of testing. Track issues to resolution.
• Demonstrate strong analytical, problem-solving, and interpersonal skills to effectively lead the DAA team.
• Lead the DAA team in the successful development and implementation of dashboard/visualization solutions and data integration solutions that enhance the user experience and empower informed decision-making across the organization.
  

QUALIFICATIONS

• To enter this classification, a basic foundation of knowledge and skills in applications programming and systems analysis and related programming support functions is a prerequisite. This foundation would normally be obtained through a bachelor’s degree, preferably in computer science or business, or equivalent training and applied experience. Foundation knowledge and skills for the Analyst/Programmer, depending on the position assignment, may include working knowledge of a specific industry standard applications programming language and knowledge of standard systems
• Incumbents at the expert level work almost completely independently on the most complex problems and work assignments. They possess an advanced and comprehensive knowledge of the technical specialty and a working knowledge of related specialties and are able to apply this extensive expertise as a generalist or specialist. Experts are proactive and understand problems from broad, interactive perspective and are able to develop solutions that combine information and ideas in new, unprecedented ways. Incumbents at this level are capable of leading teams and implementation efforts for assigned projects using advanced communication and listening skills.
• Depth/Level of Knowledge - Functional/working knowledge of the specialty area demonstrated by an understanding and use of the general principles, practices and theories pertinent to the specialty.
• Integration/Scope of Knowledge - Able to integrate knowledge and skill from other specialties to address problems. Technical Capabilities & Judgment - Demonstrated competency in applying standard and non-standard technology applications and exploring and adapting changing technology. Demonstrated ability to independently apply technical judgment to achieve desired results. Able to work from specifications, with multiple systems and platforms.
• Problem Solving & Reasoning - Recognizes problems, uses reasoning and logic to establish possible causes, interprets and applies theories and principles, generates, and evaluates alternative solutions, devises, and implements a plan of action for the best resolution within organizational constraints. Able to develop solutions where precedents do not always exist.
• Future Thinking - Able to be proactive demonstrated by recognizing needs, anticipating outcomes and consequences of different approaches, and making necessary modifications to action plans to achieve desired results.
• Ability to Acquire Knowledge - Able to independently recognize and use various learning techniques to apply and adapt new knowledge and skills in related, different, and changing situations.
• Communication Skills - Demonstrated competence at interpreting and communicating information, ideas, and instructions. Able to select appropriate information and best method or format for presenting it.
• Listening Skills - Demonstrated reflective listening skills in working with others to interpret and identify needs and requirements and develop successful solutions.
• Leading/Teaching Skills - Demonstrated ability to assist others in completing assignments and to provide basic work direction. Able to train others on new skills and procedures.
• Team Skills - Able to plan and work on shared projects to achieve established objectives.

 

Preferred Qualifications

• Minimum of five (5) years’ experience in data reporting and report developing, preferably in a higher education environment.
• Working knowledge of ETL (Extract/Translate/Load) tool.
• Experience in dimensional data modeling.
• Five years of experience in business intelligence, preferably in a higher education environment.
• Knowledge of data warehouse and business intelligence tools and best practices. Demonstrated competence in relational databases and structured programming design, ability to write and edit SQL queries.
• Experience in dimensional data modeling. Experience with PeopleSoft tables and data.
• Experience with data visualization tools (eg. Tableau). Working knowledge of Oracle RDBMS. ODI (Oracle Data Integrator) - ETL tool Software release and system change management experience.
• Data analysis and programming languages (e.g. R, Python) Comprehensive knowledge, skills and abilities to perform requirements analysis.
• Expertise and skills with technical and functional problems identification, resolving and tracking.
• Advanced experience with using PC tools (Word processing, diagramming and spreadsheets).
• Effective communication of technical issues and solutions to faculty, staff, and management.
• Ability to work with shifting and demanding deadlines and workload.
• Ability to research multiple sources and recommended solutions to problems.
• Experience working in higher education

 

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 . 

 

Out of State Work

The California State University (CSU) system is a network of twenty-three public universities providing access to a quality education through the support of California taxpayers. Part of CSU’s mission is to prepare educated, responsible individuals to contribute to California’s schools, economy, culture, and future. As an agency of the State of California, the CSU’s business operations almost exclusively reside within California.   The CSU Out-of-State Employment Policy prohibits hiring employees to perform CSU-related work outside California. For more information, go to https://calstate.policystat.com/policy/10899725/latest/ .

 

Background Check

Cal Poly Pomona will make a conditional offer of employment to final job candidates, pending the satisfactory completion of a background check (including a criminal records check). The conditional offer of employment may be rescinded if the background check reveals disqualifying information, and/or it is discovered that the candidate knowingly withheld or falsified information. In determining the suitability of the candidate for the position, Cal Poly Pomona will give an individualized assessment to any information that the applicant submits for consideration regarding the criminal conviction history such as the nature, gravity and recency of the conviction, the candidate’s conduct, performance or rehabilitation efforts since the conviction and the nature of the job applied for. For more information, go to https://calstate.policystat.com/policy/13813878/latest/ .

 

CSU Classification Salary Range

This position is part of the CSUEU bargaining unit. The CSU Classification Standards for this position are located on the following site: https://www.calstate.edu/csu-system/careers/compensation/Pages/Classification-Standards.aspx . The CSU Salary Schedule is located on the following site: https://www.calstate.edu/csu-system/careers/compensation/Pages/salary-schedule-documents.aspx . The classification salary range for this position according to the respective skill level is: minimum $7,020 and maximum $13,594 per month. Please refer to the anticipated hiring range for the appropriate salary rate for this particular position.

 

Employment Eligibility Verification

Cal Poly Pomona hires only individuals lawfully authorized to work in the United States. In compliance with federal law, all persons hired will be required to verify identity and eligibility to work in the United States and to complete the required employment eligibility verification form upon hire.  For more information, go to https://www.uscis.gov/i-9-central/form-i-9-acceptable-documents .

   

Security & Fire Safety 

In compliance with state and federal crime awareness and campus security legislation, including The Jeanne Clery Disclosure of Campus Security Policy and Crime Statistics Act, California Education Code section 67380, and the Higher Education Opportunity Act (HEOA), Cal Poly Pomona’s Annual Security Report and Annual Fire Safety Report are available for viewing at: https://www.cpp.edu/pdfs/annual_security_report.pdf and https://www.cpp.edu/housing/documents/fire_safety_report.pdf.

 

Pay Transparency Nondiscrimination

As a federal contractor, Cal Poly Pomona will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant.  For more information, see the Pay Transparency Nondiscrimination Provision poster .

 

Reasonable Accommodation

We provide reasonable accommodations to applicants and employees with disabilities. Applicants with questions about access or requiring a reasonable accommodation for any part of the application or hiring process should contact the ADA Coordinator by email at [email protected] . For more information, go to Employment Notices .

 

Equal Employment Opportunity

Cal Poly Pomona is an Equal Opportunity Employer, committed to promoting an inclusive and diverse workforce. The university subscribes to all state and federal regulations that prohibit discrimination based on race, color, religion, national origin, sex, gender identity/gender expression, sexual orientation, marital status, pregnancy, age, disability, genetic information, medical condition, and veteran or military status.  We engage the talents of all qualified workers, regardless of their background. More information is available at Equal Employment Opportunity statement .

 

Other Notices

For other important employment notices, we invite you to visit Cal Poly Pomona’s Employment Notices web page.