• Manage and scale ClickHouse clusters (replication, sharding, distributed tables) to 100s of TBs. • Maintain data consistency across replicas and shards. • Profile and optimize heavy ETL/ELT queries and table engines. • Tune key configs (max_threads, max_memory_usage, merge settings, I/O schedulers). • Benchmark cluster performance (ingest throughput, query latency, merge rate). • Proactively work with engineers to optimize schema and query patterns. • Improve observability stack on DataDog. • Set up alerting on query performance, merges, replicas, and disk usage. • Own backup and restore processes (to secondary cluster and S3). • Plan and execute upgrades with zero or minimal downtime. • Test and document disaster recovery scenarios. • Own security within ClickHouse, including access control, encryption where applicable, and adherence to internal and regulatory data protection requirements. • Resolve production issues and figure ways to prevent them. • Participate in the Architecture Review process to ensure major changes to the product portfolio have data flow and ClickHouse considerations represented at the very start.

• Keep the current headless site stable and improving (next ~3–4 months) - Own day-to-day stability: triage issues, fix bugs, ship improvements, and keep releases moving - Improve performance and reliability across funnel pages (Collection → PDP → Cart → Checkout) - Support business-critical updates (launches, promos, pricing changes) without breaking conversion - Execute a mix of quick wins and targeted refactors to reduce fragility and regressions - Maintain analytics and tracking integrity so marketing, attribution, and testing don’t get corrupted - Operate with a clear constraint: we’re not looking for a big rewrite right now—we’re migrating, so we need pragmatic improvements that keep the business running • Provide technical input during the agency rebuild (collaborative, not meeting-heavy) - Instead, you’ll provide focused technical partnership to keep the rebuild accurate, maintainable, and launch-ready: - Provide technical guidance early (constraints, feasibility, integration requirements, edge cases) - Review key deliverables that benefit from engineering eyes (technical specs, implementation approach, critical PRs) - Join the working sessions where engineering input is genuinely needed (not every status meeting) - Answer agency questions quickly and clearly so they don’t guess—or build the wrong thing • Post-migration: Shopify theme execution + experimentation - Work within Shopify theme constraints intelligently (speed, maintainability, extensibility) - Build and iterate on features that support an ever-evolving ecommerce business - Enable experimentation: implement tests, iterate quickly, and ship improvements that move conversion and AOV - Maintain and extend apps/integrations cleanly (no duct-taping the stack) - Build lightweight documentation and internal runbooks so we can own what we ship • Frontend Development - Build and maintain React/Next.js experiences across the ecommerce funnel - Improve UX in ways that directly impact conversion, AOV, and subscription attach - Ensure performance and accessibility standards are met (Core Web Vitals matter) • Backend / Platform Development - Build and maintain APIs, serverless functions, and integration logic (TypeScript-heavy) - Debug issues across services: Shopify, internal tools, and third-party partners - Improve observability: logging, monitoring, error reporting, and alerting where needed • API Integration & Ecommerce Tooling - Integrate Shinesty systems with third-party tools (subscription, search, analytics, marketing partners) - Ensure reliable data flow and maintainable implementation patterns • Performance + Conversion Rate Optimization - Identify and resolve bottlenecks across frontend and backend systems - Implement smart, well-scoped A/B tests and iterate based on results - Partner with the Digital Product Manager to translate hypotheses into shippable changes**

• responsible for providing technical leadership and defining, developing, and evolving software in a fast paced and agile development environment • Capture system level requirements by brainstorming with Architects, Data Scientists, Businesses & Product Managers • Identify the scope of the work, provide initial estimate and justify the estimate with facts • Demonstrate the understanding of Agile software development lifecycle • Engage in technical discussions; participate in technical designs and present technical ideas • Execute in a fast pace delivery mode and focus in delivering tasks to meet the product release goal • Maintain code quality through best practices, unit testing and code quality automation • Seek and provide feedback on design and development • Understand whole APM product, its modules and the interrelationship between them • Help in designing interfaces and information exchange between modules • Articulate the need for scalability and improve quality through testing • Drive design reviews, define interfaces between code modules • Provide guidance to a team of 5 to 7 developers with either planning and execution and/or design architecture using agile methodologies such as SCRUM • Work with Product Line Leaders (PLLs) to understand product requirements & vision

• Code, test, debug, document, and ship and maintain software applications using established coding standards and methodologies • Designing and building out API’s that will be consumed by the UI to surface application data. • Partner with product management to drive agile delivery of both existing and new products based on project requirements, UX design, and industry best practices • Ensure new software meets quality standards by writing unit and end-to-end automated tests • Work with product, data, and other stakeholders to analyze usage and product metrics to inform key strategic decisions • Troubleshoot, debug, resolve product issues as they arise • Work cross functionally to resolve complex partner problems • Ensure platform and services meet SLA requirements; on call rotation for production issues, along with the rest of engineering