• Define event schemas, required fields, and compatibility rules in collaboration with the CDP team • Implement automated validation and contract enforcement to prevent breaking schema changes • Maintain versioning and compatibility guarantees for event producers and downstream consumers • Build and maintain pipelines that ingest, validate, and process high-volume product events • Ensure event streams are deduplicated, ordered correctly, and safe for downstream consumption • Partner with platform teams to ensure ingestion pipelines scale with product growth • Define and maintain identity stitching logic across anonymous and authenticated users • Handle identity merges, splits, and corrections while preserving tenant boundaries • Ensure identity resolution remains explainable, deterministic, and safe for downstream datasets • Design workflows that allow event datasets and identity graphs to be replayed or rebuilt safely • Build tooling for historical corrections, schema evolution, and dataset reprocessing • Ensure downstream models can be rebuilt without manual intervention when definitions evolve • Provide guidance and tooling that help product teams emit events consistently • Maintain validation checks and schema enforcement that catch instrumentation issues early • Collaborate with engineering teams to evolve instrumentation safely over time • Ensure deletion and suppression requests propagate correctly through event and identity pipelines • Partner with governance and security teams to support policy requirements • Define requirements and interfaces for event infrastructure and downstream analytical systems • Work with platform teams to ensure pipelines remain reliable, scalable, and observable.

• Develop reusable, metadata-driven data pipelines with strong focus on database design and SQL optimization • Work extensively with AWS-based datasets and data infrastructure including Redshift, RDS, S3, Glue, Athena, and DMS • Support comprehensive ETL development and optimization using advanced SQL techniques and query performance tuning • Automate and optimize data platform processes leveraging AWS data services ecosystem • Build robust integrations with data sources and consumers using AWS native solutions • Proactively resolve performance and data quality issues through SQL optimization and database tuning • Leverage DBT for data transformation modeling and Jenkins/GitHub Actions for CI/CD automation • Contribute to platform documentation and runbooks with focus on database best practices • Propose and implement improvements to data platform architecture using AWS data services

• Develop and maintain data pipelines in a cloud environment. • Model data for consumption by reports, APIs, and data products. • Implement best practices for data quality, versioning, and data testing. • Optimize query performance and data loading processes. • Collaborate with product, BI, and engineering teams to understand requirements. • Monitor systems, handle incidents, and ensure solution reliability. • Document processes, data flows, and data standards.

Senior Software Engineer, Data @ Scotch About Us Scotch’s mission is to modernize one of the oldest industries on earth: the $1.6T beverage alcohol market. We’re starting by building the next-generation operating system for BevAlc retailers (POS, payments, Back Office, E-commerce). We are seeking a detail-oriented Senior Backend Engineer to join our data onboarding team. You will be a critical component of our team that builds out the tools and automations needed to onboard new retailers at scale. You’ll deliver key components and functionality needed to ensure data quality, accuracy and reliability while working with a variety of data structures and challenges. Key Responsibilities We’re a lean and efficient team but growing quickly, and this role is critical to the next phase of our business. Your core responsibilities include: - Data Pipeline: You will help extract data from legacy POS systems, serving as the bridge between old technology and our modern platform. - Automation: You will build tools to transform and validate data to ensure all fields meet requirements and accuracy standards before importing into Scotch - Process Optimization: You will find ways through automation, AI, and other tools to streamline and optimize the onboarding process - Collaboration: You will use your strong communication skills to work with our onboarding team to most efficiently bring on new customers What We Value For this engineering role, we specifically value: - Technical Execution: A core strength in getting things done technically and effectively. - Organizational Rigor: A high level of attention to detail and the ability to manage a pipeline of tasks simultaneously without dropping the ball. - Independence: The ability to work autonomously to solve problems and move tasks forward. - Customer Empathy: Our customers trust us to help manage their business, so we must do what we can to help them. Who You Are - 5+ years of relevant professional experience in software development or data engineering (We use Ruby on Rails and Postgres as our backend tech stack) - Hands-on experience with production application systems and data pipelines - Expert knowledge of performance optimization techniques including query optimization, data transformation, and async job processing - Demonstrated organizational rigor and attention to detail. - Strong cross-functional collaborator across engineering, product, and operations teams. - Clear communicator who drives alignment and moves projects forward quickly. Bonus Points - Experience specifically in the POS or fintech industry. - Experience in the alcohol industry - Experience working with AI tools and incorporating them into workflows - Proficiency as a full stack engineer or front end frameworks is a nice to have - Familiarity with legacy data extraction and cleaning processes. Compensation & Benefits - Competitive salary and equity - Health, dental, and vision - Company sponsored 401k - Unlimited, flexible PTO - Bi-Annual Company Offsites — company-paid trips to places like Jackson Hole, Park City, Lake Tahoe, and more to work alongside & bond with your colleagues. Equal Opportunity Employer We are an equal-opportunity employer. We don’t discriminate based on race, religion, color, national origin, gender, sexual orientation, age, marital status, veteran status, or disability status. We also consider for employment qualified applicants with arrest and conviction records, consistent with applicable federal, state and local law, including but not limited to the San Francisco Fair Chance Ordinance. Questions When Applying - What has you interested in this opportunity? - Where are you currently located or will you be based if offered this position? - What is your stance on AI productivity tools and AI workflows?