Data Engineer / Reporting Automation Specialist / BI Developer

Automated Marketplace Reporting System – Data Engineering, API Integrations & BI We are looking for an experienced Data Engineer / Analytics Engineer / Reporting Automation Specialist to design and implement a centralized automated reporting system covering our ecommerce operations in the USA, European Union and Poland. We sell through multiple marketplaces and ecommerce channels and currently use: Veeqo as the main order/sales management system for the USA BaseLinker as the main order/sales management system for the EU and Poland Our goal is to automatically consolidate sales, orders, advertising expenses and all major selling costs into one centralized data environment and reporting dashboard, with as little manual work as possible. Main data sources USA – primarily through Veeqo: Amazon US eBay US Walmart US Etsy US Shopify US EU & Poland – primarily through BaseLinker: Amazon EU eBay EU Shopify EU markets eMAG Allegro Erli Hebe Empik Temu TikTok Shop Advertising data Advertising spend should also be collected automatically where technically possible, including: Amazon Ads Walmart Ads Google Ads Meta Ads TikTok Ads Allegro Ads Empik Ads Erli Ads Some advertising platforms may currently be inactive, but the system should be designed so they can be added or enabled later. Other costs / financial data The reporting system should also include: Marketplace fees and settlements Refunds and chargebacks Shipping costs Product costs / COGS Other relevant selling costs where available Scope of work We expect the selected specialist to: Review our current systems and available APIs/data sources. Recommend the best architecture, tools and integrations for this reporting system. Connect to Veeqo and BaseLinker and automatically collect relevant order, sales, product, refund and settlement data. Integrate advertising platforms and automatically collect advertising spend. Build automated ETL / ELT pipelines for collecting, cleaning, validating, mapping and standardizing data. Create a centralized database / data warehouse serving as a single source of truth. Correctly match costs and transactions with marketplaces, countries, orders and products/SKUs where possible. Build a clear reporting dashboard using an appropriate BI solution. Implement automated data refreshes. Create an automated weekly report delivered every Monday. Implement basic data quality checks, consistency validation and error notifications. Provide documentation of the final architecture, integrations and maintenance requirements. Main reporting requirements The dashboard and weekly reports should include at least: Sales / Net Sales Number of Orders Advertising Spend Total Cost of Selling Profit Profit Margin Advertising Performance / ROAS where applicable We need to analyze performance by: Marketplace Country Product / SKU Time period Historical data should be retained so we can compare performance week over week and month over month. Technology We are not committed to a specific technology stack. We want the specialist to recommend the best solution based on: reliability scalability API availability automation possibilities ease of maintenance operating cost minimal manual work Possible technologies could include SQL databases, PostgreSQL, BigQuery, Snowflake, Microsoft Fabric, Power BI, Looker Studio, Tableau, Python, Make, n8n, cloud functions or similar solutions. These are only examples. We expect you to recommend the optimal architecture. Required experience Strong experience with: Data Engineering ETL / ELT pipelines API integrations SQL Data modeling Database / data warehouse architecture Reporting automation Business Intelligence / dashboards Data validation and monitoring Experience with ecommerce, marketplaces, Veeqo, BaseLinker, Amazon or advertising APIs will be a strong advantage. Important We are not looking only for someone who can create a dashboard. The main challenge is to build the underlying automated data infrastructure and integrations correctly, with the dashboard being the reporting layer on top of it. We are looking for someone who can independently evaluate our requirements and recommend the best technical approach. When applying, please include: Examples of similar automated reporting / data engineering projects you have completed Your experience with ecommerce or marketplace integrations Technologies you would recommend for this project and why Your proposed general approach Estimated number of hours / implementation timeline Approximate total project cost Information about availability for future maintenance and development We require estimated total project cost / estimated number of hours before implementation There may be an opportunity for ongoing cooperation and maintenance after the initial implementation.