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