AI-Assisted Developer for Amazon EU Sales & Advertising Dashboard

AI-Assisted Developer for Amazon EU Sales & Advertising Dashboard Amazon SP-API, Ads API, Claude Code / ChatGPT Project Overview We sell consumer products through Amazon across seven European marketplaces. We want to build one internal dashboard that allows our management and marketing teams to: Monitor sales across all countries Compare country-level and consolidated performance Review advertising spend and efficiency Understand where the advertising budget is being used Drill down to ASIN-level performance Identify advertising improvement opportunities We are specifically looking for a developer who uses tools such as Claude Code, ChatGPT, GitHub Copilot or similar AI development tools to build the solution faster and more cost-effectively. We actively encourage responsible AI-assisted development. However, the selected freelancer must personally understand and validate the system architecture, APIs, calculations, security and generated code. This is not a project for someone who can only create visual dashboards or generate code through prompts without understanding it. Core Dashboard Requirements Sales overview Total sales and units sold Country-level and consolidated views Week-over-week and year-over-year comparison MTD and YTD performance Product and ASIN-level sales Local-currency and consolidated EUR views Filters by country, period, product and ASIN Advertising overview The dashboard should show advertising spend and performance by: Sponsored Products Sponsored Brands Sponsored Brands Video Sponsored Display Amazon DSP, if accessible Required metrics include: Advertising spend Advertising-attributed sales Impressions Clicks Orders CPC CTR Conversion rate ROAS ACOS TACOS ASIN-level analysis Users should be able to select an ASIN and see: Total sales Advertising spend Advertising-attributed sales ROAS, ACOS and TACOS Performance by country Performance by campaign and advertising type WoW and YoY changes Management insights The dashboard should make it easy to identify: Countries or products with declining sales Campaigns with increasing spend but declining efficiency ASINs receiving excessive or insufficient advertising investment Significant WoW or YoY changes Areas requiring advertising review AI-generated summaries, anomaly alerts or optimisation recommendations may be added after the core dashboard and data accuracy have been validated. Preferred Lean Technology Approach We want a simple, maintainable and cost-efficient solution rather than an unnecessarily complex enterprise system. The solution may use: Amazon Selling Partner API Amazon Ads API Python SQL or PostgreSQL Power BI, Metabase, Streamlit, Looker Studio or another suitable dashboard AWS, Azure, Google Cloud or another low-cost hosting solution Claude Code, ChatGPT, GitHub Copilot or similar AI development tools We are open to the freelancer’s recommendation. The proposed technology must have: Low ongoing software and hosting costs Automated or scheduled data updates Secure handling of Amazon credentials and API tokens Clear source-code ownership Simple maintenance after handover No dependency on the freelancer’s personal AI accounts or private tools Project Phases Phase 1 – Paid Technical Design and Prototype Review our Amazon account and available data sources Confirm API access requirements Define sales and advertising metrics Recommend the technology stack Create the data architecture Produce a dashboard wireframe or prototype using sample data Confirm development cost, timeline and ongoing costs Phase 2 – Core Dashboard Development Connect Amazon sales and advertising data Build the database and automated data pipeline Build the seven-country dashboard Add country, product, period and ASIN filters Validate results against Amazon source reports Deploy the dashboard to a secure environment Phase 3 – Optional Enhancements Amazon DSP integration Automated weekly summaries Performance anomaly detection AI-assisted advertising insights Email or Slack alerts Additional management reporting Required Experience Applicants must have: Experience building Amazon Seller Central or advertising dashboards Practical experience with Amazon Selling Partner API Practical experience with Amazon Ads API Experience working with multiple Amazon marketplaces Strong understanding of Amazon advertising metrics Python, SQL and data-modelling experience Experience using AI coding tools to accelerate development Ability to review, test and debug AI-generated code Experience delivering maintainable source code and documentation Applicants with only general Power BI or dashboard design experience, but no Amazon data integration experience, will not be considered. Expected Deliverables Technical architecture and data-flow documentation Complete dashboard Automated data pipeline Source code in a company-controlled Git repository Database structure and queries API setup documentation Definition of all dashboard metrics Data-validation report Deployment instructions Maintenance instructions User training and handover Post-launch bug-fixing period AI Development Requirements We expect the freelancer to use AI tools efficiently, but the following conditions apply: All AI-generated code must be reviewed and tested by the freelancer Amazon credentials and confidential data must not be entered into public AI tools The freelancer must be able to explain the architecture and code The final solution must not depend on the freelancer’s personal AI subscription All code, prompts, configurations and documentation required to maintain the system must be transferred to us The freelancer remains responsible for data accuracy, security and system reliability Application Questions Please answer every question: Which Amazon SP-API and Amazon Ads API projects have you completed? Please provide screenshots or links to the most relevant Amazon dashboard you personally built. Anonymised examples are acceptable. How do you use Claude Code, ChatGPT or other AI coding tools in your development process? Please describe an example where AI significantly reduced your development time or project cost. How do you test and validate AI-generated code? What technology stack would you recommend for this project, and why? How would you keep monthly software, database and hosting costs low? How would you validate sales and advertising results against Amazon reports? How would you calculate TACOS without confusing total sales with advertising-attributed sales? How would you manage seven marketplaces, multiple currencies and ASIN/SKU mapping? What access would you need from our Amazon account? What is your proposed timeline and fixed-price quotation for each phase? Please separate one-time development costs from ongoing monthly costs. Start your proposal with “AI Amazon EU7” so we know that you have read the complete job description. Budget and Contract Structure This is a fixed-price, milestone-based project. Please quote separately for: Phase 1: Technical design and prototype Phase 2: Core automated dashboard Phase 3: Optional DSP and AI enhancements Optional monthly maintenance We value developers who can use AI to reduce development time and cost while still delivering an accurate, secure and maintainable solution.