• Develop and maintain robust data pipelines using Fivetran to ingest data from multiple sources. • Implement and manage data transformation processes using dbt, ensuring consistency and quality. • Design, build, and optimize data models in Snowflake to support analytics and reporting. • Collaborate with senior data engineers to troubleshoot data issues and deliver high‑quality solutions. • Contribute to best practices in data engineering and pipeline development. • Support dashboard and report development in Power BI to surface insights for internal teams. • Focus entirely on technical execution without direct stakeholder engagement.

• Build and maintain robust data infrastructure for ingesting, transforming, and modeling music content, metadata, and rights data. • Design, build, and support data products and internal tools that serve analytics, operations, and self-service reporting use cases: e.g. data observability dashboards, ingestion monitors, rights reporting and audit trails, content QA interfaces. • Design and optimize cloud-based architectures using AWS services, including DynamoDB, MySQL, Redshift, S3, Lambdas, and CloudWatch, to ensure high availability and performance. • Contribute to DevOps efforts, including monitoring, logging, and alerting, to ensure the reliability and resilience of our services. • Support rights compliance workflows through reproducible, transparent data practices. • Drive performance, cost efficiency, and observability across the entire stack. • Own work end-to-end, from ideation to production, in a small, highly collaborative team environment.

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 888-451-6822 ext. 55214. 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.

• Own the end-to-end technical integration lifecycle for strategic clients, from initial discovery and solution design to a successful go-live. • Act as the primary technical point of contact for a portfolio of clients, building trust and ensuring a seamless integration experience with the Loyal Guru platform. • Design and architect robust and scalable integration solutions tailored to complex client needs, leveraging your deep knowledge of our platform and Google Cloud Platform. • Proactively identify and troubleshoot complex technical challenges that arise during and after the integration process, collaborating with internal teams to ensure swift resolution. • Work in close partnership with the Head of Integrations & Delivery to align client solutions with the team's architectural standards and best practices. • Collaborate with Customer Success Managers to ensure a smooth handover post-integration and provide ongoing technical account management to drive product adoption and long-term success. • Translate complex client requirements into clear technical specifications for the Product Development team. • Serve as a subject matter expert on our platform's integration capabilities, representing the team in discussions with Product and other departments.