Data Analytics Engineer

Job Description:

Data Analytics Engineer

Description

General

The Information System Analyst III (Data Engineer) reports to the IT Manager, Data Analytics., 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).

This pivotal role demands extensive expertise in Python, SQL, Snowflake, SQL Server, Redshift, ETL tools, and data visualization platforms. The ideal candidate will be responsible for designing, developing and maintaining robust data pipelines and architecture that support our business intelligent initiatives. This role requires a strong understanding of database design, data warehousing, and cloud technologies to ensure efficient processing and storage of large datasets.

Essential Functions & Duties

• Design, build, and optimize ETL/ELT processes using tools like Fivetran, Matillion, Informatica and StreamSets for efficient data ingestion, transformation into data warehouses like Amazon Redshift and SQL Server.
• Manage and optimize databases like SQL Server, Amazon Redshift, Snowflake including schema design, query optimization, performance tuning, and data modeling.
• Develop and maintain data processing scripts and automation workflows using Python for data manipulation, integration, and system automation.
• Implement and monitor data quality checks, ensuring data integrity, accuracy, and adherence to data governance policies.
• Identify, troubleshoot, and resolve issues related to data pipelines, databases, and data-related systems.
• Create and maintain comprehensive documentation for data pipelines, data models, and system configurations.

Essential Duties

• Design, build, and maintain production-level reports and dashboards using BI tools like Power BI and Tableau to support business operations.
• Design, develop, and integrate RESTful and SOAP-based web services to enable seamless data exchange between enterprise applications and third-party systems, ensuring scalability, security, and performance.
• 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.
• Contribute to best practices and mentor other analysts within the Analytics discipline.

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, Business Administration, or a related field; Master’s degree is a plus.
• 4+ years as a Data Engineer or in a similar role with Strong proficiency in Python, SQL for data manipulation, scripting, and automation.

• Available to work On Call and After hours as required

Preferred Qualifications

• Extensive experience with SQL Server, Redshift, ETL tools like Informatica, Streamsets.
• Solid understanding of data warehousing concepts, dimensional modeling, and ETL methodologies.

• Familiarity with data preparation and integration for reporting tools like Power BI and Tableau.
• Strong problem-solving skills and the ability to interpret complex data and provide actionable insights.
• Excellent verbal and written communication skills to present findings to both technical and non-technical audiences.
• Ability to manage multiple tasks and projects simultaneously with strong organizational skills.
• Good understanding of various cloud systems eg, AWS, Azure

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

Salary:

$114,493.00 - $171,739.00 Annually