Job Details

Sr. Lead Business Intelligence Analyst

Position Number: 6519808
Location: Santa Clara, CA
Position Type: Computing - Database Administration

Sr. Lead Business Intelligence Analyst

Position Title:
Sr. Lead Business Intelligence Analyst

Position Type:
Regular

Hiring Range:

$102,800 - $128,560 annually; Compensation will be based on education, experience, skills relevant to the role, and internal equity.

Pay Frequency:
AnnualA. 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 infrastructure support for ERP and Lakehouse reporting
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 the CISO to security policies such as timeouts, 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 Infrastructure Support for ERP and Lakehouse Reporting

A. Design, develop, and implement high-performance, scalable, and secure APIs for real-time and batch data ingestion into the lakehouse.

Work with various data sources, including relational databases, NoSQL databases, streaming platforms (e.g., Kafka, Kinesis), SaaS applications, and third-party APIs.
Ensure APIs adhere to RESTful principles and organizational standards for security, reliability, and maintainability.
Develop and optimize data ingestion processes, including data validation, transformation, and loading into lakehouse formats
Implement robust error handling, retry mechanisms, monitoring, and logging for all ingestion APIs.
Collaborate with data engineers to define data schemas, partitioning strategies, and storage optimizations within the lakehouse.
Partner with source system owners to understand data structures, access methods, and ingestion requirements.
Work closely with data architects to ensure API designs align with the overall data strategy and lakehouse architecture.
Collaborate with data consumers (e.g., data scientists, analysts) to understand their data needs and ensure data availability.
Optimize API performance for high throughput and low latency, particularly for streaming data ingestion.
Implement scalable solutions that can handle growing data volumes and diverse data types.
Conduct performance testing and tuning to identify and resolve bottlenecks.

B. Install and maintain infrastructure to support Open MetaData framework

Integrate Open Metadata with existing data sources, data processing tools, and enterprise systems
Configure metadata ingestion pipelines from various sources (databases, files, streaming data, APIs).
Monitor the health, performance, and stability of the Open Metadata platform.
Perform regular maintenance tasks, including upgrades, patching, and backups.
Troubleshoot and resolve issues related to metadata ingestion, search, and platform functionality.
Optimize platform performance and scalability to accommodate growing data volumes and user needs.

C. Collaborate with data architects, data stewards, and data owners to define and implement metadata standards, policies, and governance rules.

Ensure data quality and consistency within the metadata catalog.
Develop and implement processes for metadata lifecycle management.
Support the creation and maintenance of business glossaries, data dictionaries, and data lineage.

4. 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

Advanced knowledge of BI platforms such as Tableau or PowerBI
Advanced knowledge of ETL scripting and data modeling concepts.
Must have excellent oral and written communication skills
Advanced Windows and MS Office skills
Advanced knowledge of open source database tools such as MySQL or PostgreSQL
Advanced knowledge of SQL
Advanced knowledge of reporting fundamentals
Working knowledge of other technical tools such as Application Designer, FTP, SQR, Application Engine, Data Mover, and COBOL
Extensive knowledge of Python, Java, Javascript
Comprehensive knowledge of systems analysis tools and techniques

2. Education

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

3. Experience

7-8 years experience systems support or other technology related experience
5+ years of BI and data warehousing experience

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.

Typical office environment.
Mostly indoor office environment with windows.
Offices with equipment noise.
Offices with frequent interruptions.

EEO Statement

Santa Clara University is an equal opportunity employer. For a complete copy of Santa Clara University's equal opportunity and nondiscrimination policies, see https://www.scu.edu/title-ix/policies-reports/

Title IX of the Education Amendments of 1972

Santa Clara University does not discriminate in its employment practices or in its educational programs or activities on the basis of sex/gender, and prohibits retaliation against any person opposing discrimination or participating in any discrimination investigation or complaint process internally or externally. Information about Title IX can be found at www.scu.edu/title-ix. Inquiries can also be made to the Assistant Secretary of Education within the Office for Civil Rights (OCR).

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 go to 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

Santa Clara University affirms its commitment to employ qualified individuals with disabilities within the workplace and to comply with the Americans with Disability Act. All applicants desiring an accommodation should contact the Department of Human Resources, and 408-554-5750 and request to speak to Indu Ahluwalia by phone at 408-554-5750 or by email at iahluwalia@scu.edu.

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.

To view the full job posting and apply for this position, go to https://wd1.myworkdaysite.com/en-US/recruiting/scu/scu/job/Santa-Clara-CA/Sr-Lead-Business-Intelligence-Analyst_R6488