Senior Software Engineer - Data Platform

Cavnue, a Consor company, is redefining what’s possible for modern transportation infrastructure. As the digital infrastructure platform within Consor Engineers, a leading North American engineering and advisory firm, Cavnue combines advanced roadway technology with deep transportation design and delivery expertise to modernize how roads are operated and managed.

We believe the future of roadways is connected, intelligent, and designed to actively improve safety, efficiency, and accessibility for all users. While vehicle technologies such as advanced driver assistance systems and automated driving continue to evolve rapidly, roadway infrastructure must evolve alongside them. Cavnue is closing that gap by developing and deploying smart road technologies that deliver a real-time digital twin of the roadway environment, leveraging AI-enabled, analytics, sensors, cameras, and integrated digital infrastructure to provide actionable operational insights.

Together with Consor, we are accelerating the deployment of these solutions at scale, helping public and private clients modernize infrastructure and prepare for the next generation of mobility. With active projects across the United States, our work is setting a new standard for roadway performance today while laying the foundation for a safer, more efficient, and more connected transportation future.

Join us as we shape the future of infrastructure where digital innovation meets engineering excellence to deliver measurable real-world impact.

Role Overview

We are looking for a Senior Software Engineer with deep expertise in database systems, data pipelines, and real-time data infrastructure. As a core member of our engineering team, you will own the design and evolution of our data layer, from schema design and query optimization to building scalable pipelines and APIs that power our platform. This is a fully remote, hands-on individual contributor role where you'll wear many hats, move fast, and have significant ownership over foundational systems. If you enjoy collaborating closely with a tight-knit team and having real ownership over the systems you build, we'd love to meet you.

Core Responsibilities:

• Design, build, and maintain robust database schemas optimized for both transactional and time-series workloads, primarily using PostgreSQL and TimescaleDB/TigerDB.


• Architect and manage scalable data pipelines, from raw ingestion through transformation and storage with a focus on reliability, performance, and maintainability.


• Build and operate data warehouse infrastructure on GCP, ensuring data is well-organized, queryable, and cost-effective at scale.


• Develop and maintain APIs that expose clean, performant interfaces for internal services and external consumers.


• Implement real-time and streaming data solutions that handle high-throughput, low-latency workloads.


• Own data quality, monitoring, and alerting across the data layer.


• Design and maintain data warehouse architecture that supports system playback and integration testing, enabling engineers to replay real-world data scenarios against the full stack.


• Collaborate closely with engineers, researchers, and hardware teams to understand data requirements and translate them into reliable infrastructure.


• Write clear documentation for schemas, pipeline designs, data contracts, and operational runbooks.


• Contribute to a healthy, high-trust engineering culture where good ideas can come from anywhere.

Nice to Have Experience:  

• Experience with Redis for caching, real-time data access patterns, and streams.


• Familiarity with Infrastructure as Code tools (Terraform) and CI/CD pipelines.


• Experience with GitLab workflows and CI/CD pipelines.


• Proficiency with GCP data products beyond the core stack, including BigQuery for analytics and large-scale querying.


• Experience with agentic coding tools (e.g., Claude code, Cursor, or similar AI-assisted development environments).


• Prior experience in an early-stage startup environment.


• Exposure to ML/AI data workflows, feature stores, training data pipelines, or model serving infrastructure.

Requirements:

• 5+ years of professional software engineering experience, with a meaningful focus on database systems and data infrastructure.


• Deep expertise in PostgreSQL, including schema design, query optimization, indexing strategies, and performance tuning.


• Hands-on experience with time-series databases (TimescaleDB/TigerDB, or similar).


• Strong proficiency in Python and/or C++ for pipeline and backend development.


• Experience building and operating data pipelines and data warehouses in a production environment.


• Familiarity with GCP data products (e.g., BigQuery, Cloud Storage, Pub/Sub).


• Experience with containerization (Docker) and orchestration (Kubernetes).


• Comfortable working in a Linux development environment.


• Strong communication skills — you can explain data models and architecture decisions clearly to both technical and non-technical stakeholders.


• Demonstrated ability to work independently and make meaningful progress with minimal guidance.


• BS in Computer Science, Engineering, or equivalent practical experience.

Salary Range: The compensation range for this position is specific to the location(s) listed below and is the range Cavnue reasonably and in good faith expects to pay for the position taking into account the wide variety of factors that are considered in making compensation decisions, including job-related knowledge; skillset; experience, education and training; certifications; and other relevant business and organizational factors. Actual pay may vary based on these factors and geography.

Remote - $150,000 – $195,000

Additional Compensation: The successful candidate may be eligible to participate in Cavnue's equity program and/or a discretionary annual incentive program, subject to the rules governing such programs. (Cash or equity incentive awards, if any, will depend on various factors, including, without limitation, individual and company performance.) Note: Cavnue's benefit, compensation and incentive programs are subject to eligibility requirements and other terms of the applicable plan or program.

Benefits:

Eligible employees may participate in a benefits program that may include:

• Medical, dental, and vision benefits


• Life insurance and disability insurance


• 401(k) with company contribution


• Paid Parental leave


• Fertility and infertility benefits


• Industry-competitive PTO


• Learning and development opportunities

Benefits are subject to eligibility requirements and the terms of the applicable benefit plans and programs.

We are building an incredible team of employees with diverse backgrounds and experiences. We believe that great work can occur anywhere and are open to considering candidates who meet our needs who reside outside our geographic footprint. We also value the impact that can result from co-located teams and some roles may require regular presence in one of our offices.

Cavnue is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, pregnancy, sexual orientation, gender identity or expression, national origin, age, disability, genetic information, marital status, protected veteran status, or any other characteristic protected by applicable federal, state, or local law.

If you need more information or require a reasonable accommodation to participate in the application or hiring process due to a disability or limited English proficiency, please contact Human Resources at View phone number on jobs.jobcopilot.com. Individuals with hearing or speech impairments may dial 711 to access Telecommunications Relay Services (TRS).

Notice: The above job description is intended to convey a general sense of the position’s responsibilities and expectations and does not describe all duties that may be assigned. As business needs evolve, the duties and responsibilities of this position may change. Employment in this position is contingent upon the successful completion of applicable pre-employment background checks and substance screening, conducted in accordance with applicable law.