Protecht

Data Engineer

San Francisco, CA, US

5 days ago
Save Job

Summary

Protecht is reinventing refunds, striving to make every experience refundable. Our strength lies in our proprietary Software-as-a-Service (SaaS) embedded refund protection platform, which allows us to aggregate significant distribution while providing a top-tier digital purchasing experience for event organizers, booking platforms, ticketing systems, and end consumers. Our e-commerce solution is embedded in millions of carts each month and backed by A.M.-Best-Rated insurers.

Job Summary

Our data-driven solutions power mission-critical applications, and we need a Data Engineer to help us optimize and scale our data infrastructure. If you thrive on building robust data architectures, designing effective schemas, ensuring high-performance data pipelines, and empowering business teams with the right data solutions, we want you on our team.

As a Data Engineer at Protecht, you’ll work closely with both engineering and business teams.

Your work will help:

  • Developers optimize data storage and retrieval
  • Migrate key applications to separate data warehouses to prevent revenue-impacting disruptions
  • Implement efficient data pipelines to transform and transfer data in near real-time
  • Support reporting and analytics capabilities to promote data-driven insights across the business

As we scale, you’ll play a crucial role in ensuring our data systems remain performant, reliable, and accessible, both for our internal teams and external partners.

Responsibilities

  • Design & Implement Data Solutions – Architect scalable, efficient, and well-structured data models and pipelines to support both engineering and business needs
  • Optimize & Migrate Data Workflows – Develop ETL/ELT pipelines to migrate critical applications to separate data warehouses, ensuring seamless integration and minimal impact on live revenue-generating applications
  • Collaborate with Developers – Work closely with engineers to design and implement the most effective data schemas, storage strategies, and indexing techniques for performance optimization
  • Develop & Maintain Pipelines – Build batch and near real-time data pipelines to support various applications, ensuring efficient data transformation and storage
  • Support Core Business Processes - Collaborate with analytics and product teams to support key reporting across multiple business functions
  • Ensure Data Quality & Governance – Design frameworks for data validation, integrity, and compliance including SOC II & PCI to ensure high-quality, accurate, and secure data
  • Performance Optimization & Troubleshooting – Analyze and improve query performance, database efficiency, and system scalability while troubleshooting complex data issues
  • Support & Scale Data Infrastructure – Help establish best practices, automation, and monitoring strategies to ensure our data architecture scales with the company’s growth

Requirements

  • 3-5+ years of experience in data engineering, with hands-on experience designing and managing data pipelines
  • Strong SQL skills and experience optimizing queries for performance across large datasets
  • Proficiency in Python or Java for building data workflows and transformations
  • Experience with databases such as AWS Redshift, Athena, Postgres, MySQL, DynamoDB, or other modern data storage solutions
  • Knowledge of ETL/ELT systems like Airflow, Glue, Spark, DBT, or similar tools
  • Familiarity with AWS services (Lambda, Step Functions, Fargate, S3, etc.) for scalable data infrastructure
  • Experience working with message queues and event-driven architectures (Kafka, Kinesis, SQS, etc.)
  • Understanding of data modeling, indexing strategies, and schema design to optimize for various application use cases
  • Experience with BI tools such as Domo, Tableau, Looker, or similar is a plus
  • Strong problem-solving skills and a proactive mindset for improving data workflows
  • Excellent communication skills to collaborate with engineers, product teams, and business stakeholders
  • This is a remote position. Travel to Protecht Hubs in Phoenix, San Francisco, Denver, Los Angeles, Austin, or Chicago may be required as necessary

Why Join Protecht?

  • Fully Remote Working Environment
  • Competitive Salary and Equity Opportunities
  • Unlimited Paid Time-off
  • Medical, Dental, and Vision Benefits
  • Annual Bonus Program
  • 401k Matching
  • $100/month for Event Ticket Purchase
  • Company-Sponsored Events

Powered by JazzHR

K8bn2AvuHV

How strong is your resume?

Upload your resume and get feedback from our expert to help land this job

People also searched: