IT Manager, Data & Analytics

Job Description:

IT Manager, Data & Analytics

Description

General

The IT Manager, Data & Analytics reports to the Director of IT Applications or Chief Information & Technology Officer, and is responsible for managing Data, Analytics & Business Intelligence program for the San Mateo County Transit District (SamTrans), the Peninsula Corridor Joint Powers Board (JPB), and the San Mateo County Transportation Authority (TA).

The role is to focus on strategic development and operation of the BI/data warehousing practice, including managing technical environment, staffing requirements, optimizing processes and technology, and ensuring a high availability BI/data warehouse platform. The resource will also work closely with business stakeholders in other departments to identify, recommend, develop, implement, and support analytics solutions to deliver essential information to satisfy their information needs.

This position will be highly technical in nature with hands on expertise in Visualization tools, ETL tools, Datawarehouse and Data lakes. (Knowledge of Machine learning and AI highly preferred)

Essential Functions & Duties

• Work with stakeholders to define business and systems requirements for new information technologies, particularly in the areas of BI, analytics, and data warehousing.
• Work with different business units at the director level to align the business and IT.
• Ensure the efficient utilization of data resources across different business
• Oversee all reports, dashboards, and information artifacts.
• Develop global maintenance schedules for BI and data warehousing systems.
• Promote Data & BI program.
• Facilitate system feasibility studies, proof of concepts, pilot project, and testing.
• Examine, refine, and develop BI metrics.
• Ensure best practices are established for effective problem resolution for a high availability, 24/7 environment.
• Develop, implement, and maintain all key BI and data management policies and procedures, including those for BI/EDW architecture, data centers, standards, purchasing, monitoring, and service provision.

• Collaborates and leads cross-functional teams as the subject matter expert to enhance data-driven solutions for domain and strategic business initiatives.
• Responsible for providing technical and business expertise for end-to-end reporting and analytical services to business or domain operations and enterprise analytics.
• Leads sprint teams and develops integrated solutions, and effectively applies both business knowledge and technical expertise to design, develop, and implement business intelligence solutions, predictive and artificial intelligence (AI) analytics to support strategic initiatives.
• Provides in-depth analytics and domain subject matter expertise to stakeholders with reliable analytics to answer business questions.
• Guides other analysts within the team through management of projects, providing analytics and business expertise, and training other analysts.
• Manage Middleware platforms as required
• Manage Data privacy and related policies.
• Install and manage middleware platforms
• Assist data team with their extract, transform & load (ETL) needs as necessary
• Provide Audit data as necessary.
• Supervise staff. Hire, mentor and take appropriate corrective and/or disciplinary action. Ensure EEO and affirmative action policies and procedures are followed. Coordinate staff training and professional development, establish performance objectives, monitor and evaluate employee performance.

Examples of Duties

• Guarantees the performance integrity and quality of data.
• Plan, organize, and oversee Data & BI projects that provide actionable data for operational and financial decision-making.
• Manage and enhance the BI architecture, including tools like SQL Server, Redshift Data Lake, ETL tools, Tableau / Power BI, etc.
• Oversee end-to-end data workflows, from ETL processes to advanced reporting and analytics.
• Deliver impactful dashboards, KPI scorecards, and reports using Power BI to support leadership in telling data-driven stories.
• Collaborate with the multiple departments to provide the technical support for budgeting and forecasting.
• Partner with business stakeholders to understand information needs and deliver relevant, high-quality insights.
• Promote data literacy and a culture of self-service analytics by providing user training and creating clear user guides.
• Collaborate with IT Applications team to ensure data quality and security.
• Hire, train, and develop a high-performing BI team; establish goals, monitor performance, and maintain accountability.
• Perform all job duties and responsibilities in a safe manner to protect one’s self, fellow employees, and the public from injury or harm. Promote safety awareness and follow safety procedures in an effort to reduce or eliminate accidents.
• Performs other duties and special projects as assigned.

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, Management Information System (MIS), or other related fields.
• At least five (5) years of full-time, progressive experience as a Data or BI Technical Manager
• Three (3) years of experience as a direct supervisor or manager of project teams within Data or BI fields.
• Experience training and instructing at all levels.
• Must be able to work on-call and after regular business hours as required

Preferred Qualifications:

• Master’s degree in related field preferred.
• Excellent written and oral communication skills.
• Technical documentation experience.
• Ability to conduct research into database issues, standards, and products as required.
• Ability to present ideas in user-friendly language.
• Keen attention to detail.
• Proven analytical and problem-solving abilities.
• Ability to effectively prioritize and execute tasks in a high-pressure environment.
• Strong customer service orientation.
• Experience working in a team-oriented, collaborative environment.

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: 3/2/2025 11:59 PM Pacific

Salary:

$140,129.00 - $210,192.00 Annually