Analytics Engineer: Open-source Transit Data Infrastructure

We're seeking an Analytics Engineer to join our growing practice building modern open-source data infrastructure for public transit agencies. In this role, you'll help transform complex transit operational data into clear, actionable insights through well-engineered data models and analytical solutions. You'll work at the intersection of software engineering and data analytics, creating reliable, maintainable, and scalable data transformations that power critical transit operations decisions.

We are seeking a freelancer for this role with flexible availability of between 15–30 hours per week based on sprint planning for a term of at least 6-8 months.

This role was previously also open to full-time W2 employment, but evolving needs have removed that option

• Enable analysts to efficiently report key operational metrics like on-time vehicle performance
• Design and implement modular, reusable data models and transformations for transit agencies, modeled after our successful open-source work at Cal-ITP
• Write and optimize complex SQL queries to analyze transit operational data
• Collaborate with transit agencies to understand their analytical needs and data challenges
• Build and maintain data documentation and testing frameworks
• Partner with data analysts to enable self-service analytics
• Contribute to open-source data infrastructure projects
• Report to Jarvus’ lead data engineer and collaborate with Jarvus data and analytics engineers assigned to other projects to evolve a cohesive set of practices across transit and other data projects
• Help establish best practices for version control and code quality in analytics

• Comfort being client-facing in multi-stakeholder environments and representing both your team and technical considerations to mixed audiences
• Strong aptitude for writing and refactoring complex SQL queries and analytical views
• Experience working as a data analyst or as a partner with data analysts
• Well-versed in using Git and source control workflows to collaborate with team members
• Applied understanding of software engineering concepts like modularization, reusability, and code quality
• Strong communication skills and ability to work with cross-functional teams

• Experience with dbt or DAG-based data orchestration
• Experience using Python to analyze data
• Experience using frontend development tools to build custom data visualizations
• Experience working with geographic or transportation data
• Familiarity with transit operations or public transportation systems
• Background in open source development

• 4 weeks PTO per year + federal holidays
• Comprehensive health, dental, and vision coverage
• Pre-tax Flexible Spending Account (FSA) for healthcare expenses
• 401k with 5% non-elective employer contributions
• See additional benefits

Jarvus is a civic technology consultancy that builds institutional capacity—not vendor dependence—by combining deep engineering, data science, design, and strategy expertise to help state and local agencies deliver better services through open-source solutions that achieve meaningful outcomes for their communities.

Send us your resume and tell us about either:

• A data project where you improved code quality or maintainability
• Why you're interested in building open source data infrastructure for public transit

This is primarily a remote role. Some travel may be required for client meetings and team collaboration.