CompanyCam is a photo documentation and productivity app for contractors, committed to providing a game-changing experience. They are seeking a Senior Software Engineer (Ruby on Rails) to build and maintain scalable data infrastructure, focusing on backend systems integration and event pipeline architecture.
Responsibilities:
- Design and maintain event-driven pipelines from backend systems (Ruby on Rails) to Snowflake
- Own event pipelines from backend app through Snowplow ingestion
- Establish event tracking standards, documentation, and training for engineering teams
- Support feature flagging and A/B testing infrastructure requirements
- Optimize existing data workflows for efficiency and performance
- Manage Snowflake administration, performance optimization, and cost management alongside the data team
- Build reverse ETL processes and marketing automation data flows using tools like Census
- Collaborate to optimize Snowplow Analytics for event tracking and schema management
- Partner with analytics engineers on dbt deployment, testing, and production workflows
- Act as the technical bridge between engineering and analytics for pipeline questions
- Provide technical guidance to product and engineering teams on event implementation
- Lead training sessions and office hours on event tracking and troubleshooting
- Participate in architecture discussions and cross-team technical decision-making
Requirements:
- 5+ years of backend engineering experience with Ruby on Rails or similar server-side technologies
- 3+ years working with cloud data warehouses (Snowflake strongly preferred)
- Experience with event streaming platforms and event-driven architectures
- Experience with behavioral analytics platforms (e.g., Snowplow Analytics, Segment)
- Hands-on experience with ETL tools (Fivetran, Stitch, or Airbyte)
- Working knowledge of dbt for data transformation orchestration
- Strong background in backend API development, systems integration, and pipeline reliability
- You live and work permanently in the U.S. (We're not set up to hire outside the U.S.)
- Show up: Have the courage to do difficult but necessary work
- Grow up: Take ownership, learn continuously, and bring a growth mindset
- Do good: Treat your teammates and customers the way you'd want to be treated
- Experience with monitoring/observability tools for data pipelines
- Experience with Python
- Experience building reverse ETL and marketing automation data flows
- Familiarity with modern data stack concepts and architecture
- Strong technical communication skills with ability to explain complex systems to diverse audiences
- Track record of setting technical standards and mentoring other engineers