Lead Full-Stack Engineer – API Integrations and Reporting Platform

Onda is a leading marketing agency specializing in e-commerce businesses. We help online brands grow through innovative marketing strategies, data-driven decision-making, and expert campaign execution. We are looking for a highly motivated and strategic individual to join our team as a Client Advocate , a hybrid role that blends e-commerce marketing strategy , project management , and client relationship management . This position is adecuado for a versatile professional who thrives in a fast-paced environment, excels at building relationships, and is passionate about driving impactful marketing initiatives for online sales growth.

Role Overview:

We are seeking a skilled Full-Stack Engineer to build and maintain a robust, scalable system that integrates marketing and analytics data from multiple APIs (e.g., Magento, Google Analytics, Meta, Klaviyo, Mailchimp, Shopify, etc.) into an Amazon-hosted backend. This system will support reporting across 50–300 unique accounts. Extensive experience in Shopify is crucial.

Key Responsibilities:

- Design and develop API connectors for major marketing platforms.

- Build scalable ETL pipelines to ingest, clean, and store data into Amazon-hosted databases.





- Architect and implement a backend system using Python (preferred) or Node.js.

- Develop a frontend UI/UX for real-time reporting using React.js or similar.

- Ensure system scalability, security, and performance.

- Manage infrastructure within AWS (RDS, S3, Lambda, etc.).

- Collaborate with stakeholders to define report formats and outputs.

Required Skills:

- Strong in Python (or Node.js) for backend services.

- Proven experience integrating multiple third-party APIs.

- Experience with AWS services (EC2, RDS, Lambda, S3).

- Expertise in SQL (preferably SQL Server or Amazon Redshift).

- Solid frontend development skills using React.js or equivalent.

- Familiarity with Docker and CI/CD pipelines.

- Understanding of data normalization and handling high-volume datasets.

Preferred Experience:

- 5+ years of full-stack development.

- Experience working on marketing data or e-commerce platforms.

- Prior work with BI tools (Tableau, Metabase, Superset).

- Working knowledge of OAuth and secure API credential management.

Tools & Technologies:

- Python, Node.js

- React.js / Next.js

- AWS (RDS, S3, EC2, Lambda)

- Docker

- GitHub Actions (or similar CI/CD)

- SQL Server / Amazon Redshift

This is a remote position!

📌 Lead Full Stack Web Developer and Shopify Expert (Colombia)
🏢 Onda
📍 Colombia