Senior Data Engineer at Arena Club

<h3><strong>About Arena Club</strong></h3> <p><span data-contrast="auto">If you’re fascinated by sports cards and memorabilia, your search ends here. Arena Club is pioneering the collectibles domain by introducing the first-ever digital card show. Spearheaded by 5x World Series Champion Derek Jeter and serial entrepreneur Brian Lee, Arena Club has developed a fully digital marketplace. This innovative platform is built on trust, transparency, and fun, featuring grading &amp; authentication, vaulting, and digital pack openings for collectors to build and showcase their collections in a personalized online showroom from anywhere in the world.</span><span data-ccp-props="{}">&nbsp;</span></p> <p>&nbsp;</p> <h3><strong>About The Role</strong></h3> <p>We are seeking a Senior Data Engineer to help strengthen Arena Club’s strategic decision-making, enhance operational performance, and integrate data across the company to unlock deeper insights into customer behavior and market performance.</p> <p>As a key individual contributor, you’ll focus on building and maintaining reliable data pipelines, improving data quality, and ensuring data is well-instrumented, accessible, and structured to support meaningful analysis. You will work with existing tools and systems, including Mixpanel and AWS-based data infrastructure, partnering closely with engineering and business teams across product, operations, and the marketplace.</p> <p>This is a hands-on role for someone who enjoys owning execution, operating in evolving data environments, and incrementally improving how data is collected, processed, and used to drive better business decisions.</p> <p>&nbsp;</p> <h3><strong>What You Will Do</strong></h3> <p><strong>Current State — Production Data Warehouse<br></strong>• Maintain and optimize inbound and outbound ETL pipelines built on AWS Glue (Python Shell &amp; Spark ETL)<br>• Manage Redshift cluster performance across various schemas&nbsp;<br>• Own integrations with SaaS data sources via AppFlow&nbsp;and direct connectors&nbsp;<br>• Operate outbound distribution pipelines to external vendors<br>• Manage infrastructure, alerting, and migration state tracking</p> <div class="p-pdf_iframe__page" data-page-number="1"> <div class="textLayer" data-main-rotation="0"><br><strong>Future State — Medallion Architecture &amp; Real-Time</strong>• Lead the migration from ad-hoc SQL scripts to a Bronze/Silver/Gold medallion architecture with dbt as the transformation layer<br>• Design and implement dimensional models, i.e., fact tables and dimensions&nbsp;<br>• Build the Silver staging layer&nbsp;<br>• Architect the real-time CDC pipeline<br>• Implement data contracts and governance at the Silver layer to insulate downstream consumers from source changes</div> <div class="textLayer" data-main-rotation="0"><br><strong>Data Archival &amp; Cost Optimization</strong></div> <div class="textLayer" data-main-rotation="0">• Implement a hot/cold storage strategy&nbsp;via Redshift Spectrum<br>• Build the Unified Access Layer&nbsp;<br>• Design and automate Glue jobs<br>• Configure S3 lifecycle policies for progressive cost reduction&nbsp;</div> <h3 class="textLayer" data-main-rotation="0"><br><strong>Qualifications</strong></h3> <div class="textLayer" data-main-rotation="0">• 5+ years in data engineering with production pipeline ownership (not just analytics or BI)<br>• Deep AWS experience: Glue (both Python Shell and Spark ETL), Redshift, S3, IAM, EventBridge, Lambda, AppFlow<br>• Strong SQL: complex joins, window functions, MERGE/UPSERT patterns, Redshift-specific optimization (sort keys, dist keys, VACUUM/ANALYZE)<br>• Python fluency: boto3, data processing libraries, writing production Glue scripts (not just notebooks)<br>• Dimensional modeling: star schemas, fact/dimension design, SCD Type 1 and Type 2 implementation<br>• dbt: hands-on experience building and maintaining staging, intermediate, and mart models with tests and documentation<br>• Data warehouse operations: schema migration, incremental loads, backfill strategies, monitoring, and alerting</div> <div class="textLayer" data-main-rotation="0">• Hands-on experience using AI tools (Claude or Cursor preferred; other agentic tools welcome) to ship code, build agents, and automate workflows</div> <div class="textLayer" data-main-rotation="0">&nbsp;</div> <div class="textLayer" data-main-rotation="0">&nbsp;</div> <div class="textLayer" data-main-rotation="0"><strong>Preferred Qualifications</strong></div> <div class="textLayer" data-main-rotation="0">• Redshift Spectrum: experience with external schemas, Parquet/Hive partitioning, and unified hot/cold querying<br>• CDC / streaming: Postgres WAL, Debezium, EventBridge, or similar change data capture pipelines<br>• Data Mesh concepts: domain-oriented ownership, data-as-a-product thinking, federated governance<br>• AppFlow &amp; SaaS integrations: configuring and troubleshooting managed connectors for Stripe, Zendesk, Mixpanel, etc.<br>• Cost optimization: right-sizing Glue jobs (Python Shell vs. Spark), Redshift concurrency scaling, S3 lifecycle policies<br>• Vendor distribution: building outbound API sync jobs with rate limiting, SFTP transfers, webhook delivery</div> <div class="textLayer" data-main-rotation="0">• Familiarity with marketplace or e-commerce data (orders, payments, attribution, promo codes)</div> <div class="textLayer" data-main-rotation="0"> <div class="textLayer" data-main-rotation="0">• Experience with Mixpanel, Customer.io, or Singular data exports and event schemas</div> • Prior experience migrating from monolithic ETL to medallion or lakehouse architectures<br>• Exposure to data governance tooling: data catalogs, lineage tracking, quality frameworks (e.g., Great Expectations, dbt tests)</div> <div class="textLayer" data-main-rotation="0"> <p>&nbsp;</p> <h3><strong>The Arena Club Standard</strong></h3> <p>Life at Arena Club isn’t for the faint of heart — and that’s by design. We’re building products and experiences the collectibles world has never seen. This is a proving ground. It demands your best every single day, because anything less means you’re falling behind.</p> <p>From day one, you’re in the game. Trusted to deliver, expected to own outcomes, and driven to raise the bar higher than you thought possible. We don’t just execute — we innovate, compete, and win together. That’s how real breakthroughs happen.</p> <p>If you want routine or predictability, you won’t find it here. But if you’re ambitious, relentless, and hungry to prove yourself on a team built to dominate — step into the arena. You’ll discover growth and reward here, unlike anywhere else.</p> </div> </div><div class="content-pay-transparency"><div class="pay-input"><div class="description"><p>The base salary range listed is a guideline. Actual compensation is determined based on skills, experience, and the impact you bring. Total compensation includes base salary, bonus, and equity.</p></div><div class="title">Salary Range</div><div class="pay-range"><span>$130,000</span><span class="divider">&mdash;</span><span>$170,000 USD</span></div></div></div>