Data Engineer

Protecht; San Francisco (CA); Remote; USD 173,000 - 242,000; Full time

Job summary

An innovative company is seeking a Data Engineer to optimize and scale its data infrastructure. You will design robust data architectures and implement efficient data pipelines, ensuring high performance and reliability. Collaborating with both engineering and business teams, your work will empower data-driven insights and support critical applications. This role offers a fully remote working environment, competitive salary, and excellent benefits, including unlimited paid time off and company-sponsored events. Join a forward-thinking team where your contributions will significantly impact the company's growth and success.

Benefits

Unlimited Paid Time-off

Medical, Dental, and Vision Benefits

Annual Bonus Program

401k Matching

$100/month for Event Ticket Purchase

Company-Sponsored Events

Qualifications

• 3-5+ years of experience in data engineering with hands-on experience designing 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.

Responsibilities

• Design scalable data models and pipelines to support engineering and business needs.
• Develop ETL/ELT pipelines to migrate critical applications to separate data warehouses.
• Collaborate with engineers to design effective data schemas and storage strategies.

Skills

Data Engineering

SQL

Python

Java

ETL/ELT

Data Quality

Data Governance

Problem-Solving

Education

Bachelor's Degree in Computer Science or related field

Tools

AWS Redshift

Airflow

DynamoDB

Tableau

Job description

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

Seniority level

• Seniority level

  Mid-Senior level

Employment type

• Employment type

  Full-time

Job function

• Job function

  Information Technology

• Industries

  Internet Publishing

Referrals increase your chances of interviewing at Protecht by 2x

Get notified about new Data Engineer jobs in San Francisco, CA.

United States $173,000.00-$242,000.00 2 weeks ago

San Francisco, CA $45.00-$60.00 2 months ago

Software Engineer, SQL - AI Training (Freelance, Remote)

San Francisco, CA $170,000.00-$210,000.00 1 month ago

Software Engineer, Python - AI Training (Freelance, Remote)

Software Engineer - AI Training (Freelance, Remote)

Staff Software Engineer, Data Systems (Python)

Senior Software Engineer, Data Systems (Python)

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.