Business Intelligence Analyst

Position Title :

Business Intelligence Analyst

Position Type : Regular

Hiring Range :

$91,800 - $114,785 annually; Compensation will be based on education, experience, skills relevant to the role, and internal equity.

Pay Frequency : Annual

A. POSITION PURPOSE

With minimal supervision, provide technical and functional support, training and documentation for all administrative offices using ERP reporting tools.

B. ESSENTIAL DUTIES AND RESPONSIBILITIES

Provide technical support for ERP and Lakehouse reporting tools Provide functional support for ERP and Lakehouse reporting tools Provide training and documentation for ERP and Lakehouse reporting tools

C. SPECIFIC RESPONSIBILITIES

Provide Technical Support for ERP and Lakehouse reporting tools

Manage security Conduct periodic review of existing setups Create and test new security roles and permission lists to meet needs Resolve end user access and security issues as reported through the IT Service Center Work with Information Security Office and Enterprise Applications staff on establishing security policies such as timeouts, access levels, password configuration and training

Support reporting needs Teach power users how to write their own reports Troubleshoot complex private queries and reports Streamline and promote common menu-driven reports Design, build, and maintain custom reports, dashboards and analytics for end-users in various offices. Design, build, and maintain Prism data sources and custom Prism reports. Access legacy data via SQL Create views in Lakehouse.

Conduct change management and new function integration and testing Monitor new updates and releases and determine impact Conduct initial testing prior to user testing

Manage primary troubleshooting of application and data issues and / or errors Triage incoming user error reports Identify and help resolve issues related to data and setups Replicate and document reported problem Report problems to vendor as necessary Document and report problems to IT Developers with any possible causes and solutions Use system tools to identify source of problem

Provide support for upgrades and projects

Perform Fit / Gap analysis

Assist with the development of test plans and scripts

Coordinate and manage end user upgrade testing

2. Provide Functional Support for ERP and Lakehouse reporting tools

Evaluate functional procedures and work with end users to identify and implement enhancements Review current business practices Manage requests and translate business requirements to functional specifications working in close collaboration with the Technical Team and business users. Investigate and prototype new reporting functionality

Assist user community with functional responsibilities Coordinate batch processes among end user offices Provide support to power users with functional questions and issues

3. Provide Training and Documentation for ERP and Lakehouse Reporting

Provide one-on-one training with power users, enabling them to train others in their functional areas Work with internal and external teams on best practices and determine standards. Ensure and enforce adherence to reporting standards, and assist with moving reports to production Maintain internal documentation for business and technical processes

5. Other Duties as Assigned

Learn new skills through vendor learning platforms. Attend Workday Rising and other professional conferences Special projects, as assigned

D. QUALIFICATIONS

To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The items below are representative of the knowledge, skills, abilities, education, and experience required or preferred.

This position requires the ability to effectively establish and maintain cooperative working relationships within a diverse multicultural environment.

1. Knowledge, Skills and Abilities

Working knowledge of BI platforms such as Tableau or PowerBI Understanding of ETL scripting and data modeling concepts. Must have excellent oral and written communication skills Advanced Windows and MS Office skills Working knowledge of open source database tools such as MySQL or PostgreSQL Working knowledge of SQL Working knowledge of reporting fundamentals Working knowledge of Python, Java, Javascript Comprehensive knowledge of systems analysis tools and techniques

Education BA / BS in Computer Science or related field; Master's degree in Computer Science or related field preferred.

Experience 2-4 years of experience with data, reporting, statistical analysis or related fields. Preferred : experience with HR and / or Finance data and business processes Preferred : exposure to BI and data warehousing applications, environments, tools and concepts.

E. PHYSICAL DEMANDS

The physical demands described below are representative of those that must be met by an employee to successfully perform the essential functions of this job. In accordance with the Americans with Disabilities Act, as amended, the California Fair Employment & Housing Act, and all other applicable laws, SCU provides reasonable accommodations for qualified persons with disabilities. A qualified individual is a person who meets skill, experience, education, or other requirements of the position, and who can perform the essential functions of the position with or without reasonable accommodation.

• Considerable time is spent at a desk using a computer terminal.
• Required to travel to other buildings on the campus.
• Required to attend conference and training sessions within Bay Area or in- or out-of-state locations.
• Required to travel to outside customers, vendors or suppliers.

F. WORK ENVIRONMENT

The work environment characteristics described below are representative of those an employee encounters while performing the essential functions of this job.

Telecommute

Santa Clara University is registered to do business in the following states : California, Nevada, Oregon, Washington, Arizona, and Illinois. Employees approved to telecommute are required to perform their work within one of these states.

EEO Statement

Equal Opportunity / Notice of Nondiscrimination

Santa Clara University is an equal opportunity employer. All qualified applicants are encouraged to apply and will receive consideration for employment without regard to race, color, ethnicity, national origin, citizenship, ancestry, religion, age, sex, sexual orientation, gender, gender expression, gender identity, marital status, parental status, veteran or military status, physical or mental disability, medical conditions, pregnancy or related conditions, reproductive health decision making, or any other characteristic protected by federal, state, or local laws. For a complete copy of Santa Clara University's equal opportunity and nondiscrimination policies, please visit the Office of Equal Opportunity and Title IX website at

Clery Notice of Availability

Santa Clara University annually collects information about campus crimes and other reportable incidents in accordance with the federal Jeanne Clery Disclosure of Campus Security Policy and Campus Crime Statistics Act. To view the Santa Clara University report, please visit the Campus Safety Services website. To request a paper copy please call Campus Safety at (408) 554-4441. The report includes the type of crime, venue, and number of occurrences.

Americans with Disabilities Act

Consistent with its obligations under the law, Santa Clara University will provide reasonable accommodations to applicants and employees with disabilities. Applicants who wish to request a reasonable accommodation for any part of the application or hiring process should contact the Department of Human Resources ADA Team at hraccommodations@scu.edu or by phone at (408)554-5750.