Business Intelligence Analyst

Job Description:

Business Intelligence Analyst

Description

General

The BI Analyst reports to the IT Manager for Data and Analytics and is responsible for data modeling and analysis services used to mine enterprise systems and applications for knowledge and information that enhance business processes for the San Mateo County Transit District (SamTrans), the Peninsula Corridor Joint Powers Board (Caltrain), and the San Mateo County Transportation Authority (TA). This individual is also responsible for assisting in building, deploying, and maintaining data support tools, metadata inventories, and definitions for database file/table creation.

This critical role requires deep BI and data experience and advanced data skills to deliver impactful reporting and analytics. The role will analyze complex data sets, create insightful reports, and provide actionable recommendations to support effective decision-making at all levels of the organization.

Essential Functions & Duties

Examples of Essential Functions:

• Build and maintain production-level reports and dashboards using BI tools like Power BI and Tableau to support business operations.
• Develop clear and visually compelling data visualizations to communicate findings to stakeholders.
• Manage project scope, deliverables, and risks while collaborating with stakeholders to understand their data needs and translate them into technical requirements.
• Ensure BI solutions are scalable, reliable, and secure, while developing and monitoring key performance indicators (KPIs) to track business performance.
• Collaborate with cross-functional teams to optimize data workflows and drive analytics projects from inception to completion.
• Foster self-service capabilities, empowering users to independently access and report on data.

• Work with application development staff to coordinate the creation and management of data queries.
• Collaborate with unit managers, end users, development staff, and other stakeholders to integrate data management applications with existing systems.
• Develop, implement, and maintain change control and testing processes for modifications to data models.
• In conjunction with data owners and department managers, develop data models and protocols for mining production databases.
• Act as the District’s BI point of contact when the

Examples of Essential Duties:

• Analyze and validate data from various sources, utilizing advanced analytics techniques to identify trends and extract meaningful insights.
• Devise, develop, and deploy required data queries in response to business user needs.
• Provide and apply quality assurance best practices for data analysis services across the organization.
• Monitor data quality, maintain reports, investigate and fix bugs, and ensure platform stability.
• Provide ad hoc analysis and support for special projects, maintaining thorough documentation of BI processes.
• Contribute to best practices within the Analytics discipline.
• Assist in the development of data management policies and procedures.
• Identify research questions, solve problems using data analysis and communicate the results to various stakeholders.

Minimum Qualifications

Minimum Qualifications : Sufficient experience, training and/or education to demonstrate the knowledge and ability to successfully perform the essential functions of the position. In lieu of a degree, work-related experience that demonstrates the skills and experience necessary to perform this role will be accepted. Development of the required knowledge and abilities is typically obtained through but not limited to:

• Bachelor’s degree in computer science, Data Science, Statistics, or a directly related field
• Three (3) years of progressively responsible full-time experience as a Business Intelligence or data analyst.
• Three (3) years of full-time experience utilizing BI tools (Power BI, Tableau, Looker),
• Three (3) years of full-time experience with data warehousing and ETL processes.
• Experience with SQL and PL.SQL.
• Must be willing to work On Call and After hours as required

Preferred Qualifications :

• Master’s degree in computer science, Data Science, or Statistics.
• Experience with data modeling and analysis techniques.
• Knowledge of statistical analysis and machine learning algorithms.
• Experience with programming languages like Python or R.
• Experience with multiple BI systems including various BI platforms, Datawarehouse, Data Lake, ETL tools, CRM and ERP systems, as well as Financial Planning tools.
• Experience working in a high-tempo environment, adapting to day-to-day challenges.
• Experience conducting research into database issues, standards, and products as required.
• Excellent verbal and written communication skills to present findings to both technical and non-technical audiences.

Below is a summary of the comprehensive benefits provided to District full-time employees:

Health and Welfare Benefits:

• Healthcare Benefits -District employees are offered a choice of healthcare providers under the CalPERS Health Benefits Program.The District will contribute ninety (90) percent towards monthly premiums for full-time employees. Fifty (50) percent for part-time employees.
  
• Free Dental and Vision Benefits provided - Employer Covers Premiums
  
• Free Employee Assistance Benefit - Employees are entitled to 5 face-to-face sessions or telephonic or web-video consultations for problem-solving support per incident, per calendar year.
  

• Flexible Spending Accounts - Pre-tax dollars to pay for qualified Health or Dependent Care expenses.
  

Retirement Medical Benefits:

• Long Term Disability Insurance - After 90 days of total disability, Administrative full-time employees are eligible for 60% of monthly income covered by the District.
  
• Health and Wellness - Gyms located at most work locations and discounted Weight Watcher Membership Option.
  

Holidays and Paid Time Off:

• Paid Time Off - Newly hired employees accrue 6.5 hours bi-weekly when hired (if Exempt 8.25 hours).As you move up in years of service credit, the rate of the amount of PTO accrued will also increase.
  
• Paid Holidays - The District provides seven paid holidays throughout the year - New Years Day, Martin Luther King Jr. Day, Memorial Day, Independence Day (July 4th), Labor Day, Thanksgiving Day and Christmas Day
  
• Floating Holidays - District employees can earn up to five (5) floating holidays.
  

Financial Planning Benefits:

• Pension Benefits through CalPERS -You must have a minimum of 5 years of service to be eligible for this pension.
  

• CalPERS PEPRA vs. Classic - All employees hired on, or after January 1, 2013, are considered PEPRA members and will contribute 8% of their salary up to the maximum IRS cut-off. All Classic members will contribute 6%
  
• Deferred Compensation Options - Select to contribute to one or both of our Tax Deferred Compensation Options
  
• Reliance Standard Life Insurance with 100% premium paid by the District - 1 times annual salary of employee - max $200,000
  
• Optional Life Insurance - Employees may purchase additional life insurance for themselves and their eligible family members.
  

Growth and Education Benefits:

• Professional Development - Access to LinkedIn Learning and San Mateo County’s professional training. District Tuition Reimbursement Program - A maximum of $5,250 per year for courses related to your job or career goals with the District.
  
• Computer Loan Program - Interest-free two-year loan with a maximum amount of $2,000.
  

Other Amazing Benefits:

• Credit Union - Employees and family members are eligible to join the San Mateo Credit Union and Patelco Credit Union.
  
• Employee Clean Commute (ECC) - Car/Van poolers and Public Transit riders receive a monthly reimbursement.
  
• Commuter Benefits - Free Employee Parking; Free Bus Pass for employee as well as children/spouse; Clipper Card/Go Pass Program for Central employees.
  

For union employees, all of the above benefits are subject to the employee’s Collective Bargaining Agreement. Benefits listed are also subject to change with or without notice and are subject to contract/provider terms and conditions.

Closing Date/Time: 9/28/2025 11:59 PM Pacific

Salary:

$103,491.00 - $155,238.00 Annually