Data Engineer

Duties and ResponsibilitiesData Infrastructure & Pipeline Engineering* Design, build, and operate scalable data pipelines across Salesforce, Snowflake, and external systems (ticketing, lottery, partners)* Leverage Fivetran and API-based ingestion frameworks to standardize and automate data ingestion from third-party platforms* Own API, webhook and file-based ingestion systems (SFTP, third-party feeds), ensuring reliability and observability* Manage AWS infrastructure supporting data ingestion, processing, and orchestration Data Warehouse & Modeling* Own Snowflake data architecture, including schema design, transformations, and data modeling* Develop and maintain transformation layers using dbt, including modular, testable, and well-documented models* Build canonical datasets and dimensional models supporting analytics, CRM, ticketing, and pricing* Optimize warehouse performance, cost, and scalability through clustering, partitioning, and query optimization* Manage schema evolution and deprecation of legacy data structuresData Quality, Governance & Reliability* Establish data quality frameworks using dbt tests, monitoring tools, and pipeline validation checks to detect and resolve inconsistencies, duplication, and missing data* Implement automated validation, monitoring, and alerting across pipelines* Own data hygiene standards across customer, order, and transaction datasetsAutomation & Systems Optimization* Develop Python-based workflows to automate ingestion, transformation, and operational processes* Reduce manual workflows through system design, tooling, and pipeline reliability improvements* Leverage HighTouch to operationalize data by syncing curated datasets back into Salesforce and other business systems* Partner with third-party developers to maintain ticket lottery systems* Continuously improve pipeline performance, latency, and failure recoveryReporting & Data Enablement* Build and maintain data pipelines supporting core reporting (sales, marketing performance, partner reporting)* Enable downstream analytics and BI through clean, accessible, and well-modeled datasetsDynamic Pricing Data Infrastructure & Modeling Support* Own the data infrastructure supporting dynamic pricing models* Design and maintain model-ready datasets across pricing, inventory, and demand signals using Snowflake and dbt* Partner with internal teams and external consultants to operationalize pricing models within Snowflake* Enable rapid iteration, backtesting, and deployment of pricing strategies

QUALIFICATIONSExpertise* Strong proficiency in SQL and advanced data modeling (dimensional + canonical)* Experience building and operating data pipelines using Python and modern data stack tools (Fivetran, dbt, HighTouch or similar)* Deep experience with Snowflake or similar cloud data warehouses* Experience working with CRM systems (Salesforce preferred)* Experience managing data infrastructure in AWS or similar cloud environments* Strong understanding of ETL/ELT design patterns, APIs, and distributed data systems What Success Looks Like* Reliable, scalable data pipelines with minimal manual intervention* Improved data quality and reduced duplication/errors* Faster reporting and improved data accessibility across teams* Successful deployment and iteration of pricing models supported by robust data systemsGrowth & Development Opportunities* Opportunity to lead data architecture strategy, build scalable infrastructure, and directly impact revenue through pricing optimization systems.