San Mateo County Transit District
Business Intelligence Analyst
San Mateo County Transit District, San Carlos, California, United States, 94071
Overview
Join to apply for the
Business Intelligence Analyst
role at
San Mateo County Transit District . Base pay range
$103,491.00/yr - $155,238.00/yr Responsibilities
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 San Mateo County Transit District (SamTrans), the Peninsula Corridor Joint Powers Board (Caltrain), and the San Mateo County Transportation Authority (TA). This role also assists in building, deploying, and maintaining data support tools, metadata inventories, and definitions for database file/table creation. The position requires deep BI and data experience to deliver impactful reporting and analytics, analyze complex data sets, create insightful reports, and provide actionable recommendations to support decision-making at all levels of the organization. Essential Functions & Duties
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 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 appropriate. Qualifications
Minimum Qualifications
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 BI platforms, Data Warehouse, Data Lake, ETL tools, CRM and ERP systems, and Financial Planning tools Experience working in a high-tempo environment and adapting to day-to-day challenges Experience conducting research into database issues, standards, and products Excellent verbal and written communication skills to present findings to technical and non-technical audiences How to Apply
Complete an online employment application by 11:59 p.m. of the listed closing date. Resumes and cover letters will not be accepted in lieu of fully completed applications. It is the applicant’s responsibility to ensure that applications are completed with all relevant information (experience, education, certifications, licenses, references and/or other information). The Human Resources Department will make reasonable efforts in the recruitment/examination process to accommodate applicants with disabilities upon request. If you have a need for an accommodation, please contact the Human Resources Department. We celebrate diversity and are committed to creating an inclusive and welcoming workplace environment. We are an Affirmative Action/Equal Opportunity Employer. Minorities, Women, Persons with Disabilities and Veterans are encouraged to apply. Employment details
Seniority level: Associate Employment type: Full-time Job function: Information Technology For reference, this job description includes information about benefits such as medical insurance, pension plan, vision insurance, 401(k), and tuition assistance; related postings may be shown for other locations.
#J-18808-Ljbffr
Join to apply for the
Business Intelligence Analyst
role at
San Mateo County Transit District . Base pay range
$103,491.00/yr - $155,238.00/yr Responsibilities
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 San Mateo County Transit District (SamTrans), the Peninsula Corridor Joint Powers Board (Caltrain), and the San Mateo County Transportation Authority (TA). This role also assists in building, deploying, and maintaining data support tools, metadata inventories, and definitions for database file/table creation. The position requires deep BI and data experience to deliver impactful reporting and analytics, analyze complex data sets, create insightful reports, and provide actionable recommendations to support decision-making at all levels of the organization. Essential Functions & Duties
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 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 appropriate. Qualifications
Minimum Qualifications
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 BI platforms, Data Warehouse, Data Lake, ETL tools, CRM and ERP systems, and Financial Planning tools Experience working in a high-tempo environment and adapting to day-to-day challenges Experience conducting research into database issues, standards, and products Excellent verbal and written communication skills to present findings to technical and non-technical audiences How to Apply
Complete an online employment application by 11:59 p.m. of the listed closing date. Resumes and cover letters will not be accepted in lieu of fully completed applications. It is the applicant’s responsibility to ensure that applications are completed with all relevant information (experience, education, certifications, licenses, references and/or other information). The Human Resources Department will make reasonable efforts in the recruitment/examination process to accommodate applicants with disabilities upon request. If you have a need for an accommodation, please contact the Human Resources Department. We celebrate diversity and are committed to creating an inclusive and welcoming workplace environment. We are an Affirmative Action/Equal Opportunity Employer. Minorities, Women, Persons with Disabilities and Veterans are encouraged to apply. Employment details
Seniority level: Associate Employment type: Full-time Job function: Information Technology For reference, this job description includes information about benefits such as medical insurance, pension plan, vision insurance, 401(k), and tuition assistance; related postings may be shown for other locations.
#J-18808-Ljbffr