Data Engineer

About Us

Arcady Media Inc. is a world-class email and retention marketing agency working with fast-growing DTC brands. We are an AI-first, data-driven company focused on helping eCommerce brands scale using automation, lifecycle marketing, and deep data insights. Our core values: Collaboration, Continuous Learning, and Transparency.

Role Summary

We are not looking for a backend developer who only writes SQL scripts. We are looking for a Data Engineer who can think strategically, build scalable data pipelines, and translate raw data into insights that help our clients grow.

If you have ever thought, This entire system would work better if the data actually talked to each other, this role is for you.

Because we work heavily with eCommerce and retention marketing, experience handling data from Shopify, Klaviyo, CRMs, GA4, Meta Ads, or customer lifecycle systems is a strong advantage.

Key Responsibilities

1. Build Multi-Client Data Pipelines

• Design and maintain ETL/ELT pipelines pulling data from Shopify, Klaviyo, GA4, CRMs, payment processors, and ad platforms.
• Ensure multi-tenant data isolation and security.
• Build real-time or near-real-time data syncs powering automation triggers.
• Work with Zapier, n8n, Supabase, Google Workspace APIs, Slack API, and related integration tools.

2. Enable Account Managers With Insights

• Build clear, client-facing dashboards (Looker Studio, Tableau, or similar).
• Create automated weekly/monthly reporting workflows.
• Surface insights around retention, customer segments, churn risk, LTV, and campaign performance.
• Set up alerts for metric shifts (issues in orders, open rates, revenue drops, etc.).

3. Support AI Automation Workflows

• Provide clean, structured data for AI-driven systems.
• Build event-based triggers (e.g., high-value customer, engagement drop, abandoned cart).
• Collaborate with automation engineers to ensure data freshness and reliability.

4. Data Quality and Governance

• Implement automated data validation and anomaly detection.
• Clean and standardize data from multiple platforms.
• Maintain documentation for schemas, transformations, and pipeline logic.

5. Proactively Identify Opportunities

• Explore client data to identify growth opportunities, not just fulfill requests.
• Propose new metrics, segments, and predictive models.
• Identify cross-sell, upsell, churn, and retention opportunities.
• Help guide strategy based on data patterns.

6. Leverage AI Tools for Productivity

• Use AI tools to automate analysis, transformation, and anomaly detection.
• Document reusable processes and share knowledge with the team.

Required Skills & Experience

• 2+ years in data engineering, analytics, or a similar role.
• Strong SQL and scripting skills (Python or JavaScript).
• Hands-on experience with ETL/ELT pipelines from SaaS platforms.
• Experience integrating APIs (Shopify, Klaviyo, GA4, Slack, etc.).
• Experience with workflow automation tools (Zapier, n8n, or similar).
• Understanding of normalized and dimensional data models.
• Ability to translate data into actionable insights for non-technical teams.
• Strong communication and documentation skills.
• Comfortable using AI tools for productivity and problem-solving.

Preferred / Nice-to-Have Skills

• Experience with eCommerce or marketing analytics.
• Shopify or Klaviyo API experience.
• Familiarity with dbt or event-driven architectures.
• Background in lifecycle or retention marketing.
• Exposure to streaming data, webhooks, or real-time triggers.
• Understanding of machine learning basics.

Who You Are

• You think in systems, not spreadsheets.
• You question the "why" before building the "what."
• You can explain complex technical concepts simply.
• You enjoy exploring data to find patterns that drive business results.
• You are proactive, curious, and comfortable with AI tools.
• You take ownership and act quickly when you see opportunities.
• To be considered for this role, your application must include your favorite fruit, and it must be Jackfruit. This helps us filter out automated or incomplete applications.

Benefits

• Work with fast-growing DTC brands in the eCommerce space.
• Remote-friendly work environment.
• Skill development and mentorship.
• Collaborative, fast-moving, AI-first culture.
• Competitive compensation and performance bonuses.

How to Apply

Shortlisted candidates will be invited to complete a pre-screening form, followed by:

1. Meet & Greet Call
2. Trial Assessment (call or task)
3. Final Interview with CEO
4. Offer