
Closed
Posted
Background & Goal We're a medium size ecommerce retailer running on Netsuite for our ERP and Big Commerce for our front end website. We're looking for a data engineer to help build a data warehouse for Netsuite, Big Commerce, and potentially some other data platforms to help us analyse our data faster and more accurately. We wish to engage a third party data Engineer to build a central Data Warehouse in Google BigQuery (or other similar service). We want to analyse data in a data visualisation tool such as Power BI. We are also interested in other capability that we will be able to use the data warehousing for in the future (better exception reporting, better customer analytics, new sales & marketing opportunities, etc) We have a capable internal IT/Analytics team, however the teams resources and stretched so we're looking for help to implement this project. We aren't looking for a "black box" solution. We need you to build the foundation, document it well, and then train us so we can maintain it and build on top of it later. Why We Are Doing This Stop the manual work: Automate daily reports so we don't have to copy-paste data. Fix data issues: Easily spot when stock or product data in Netsuite doesn't match BigCommerce. Better insights: We want to join web traffic data (GA4) with sales data to understand customer behavior better. Scaleable and stable: We want a system that is reliable, able to handle large data sets common with e-commerce businesses Time series: current systems make analysing information by minute/hour/day cumbersome due to volume of transactions, and speed/performance of Netsuite. Granular to macro: we want the ability to roll up to macro views whilst also drilling down to the lowest level of detail eg individual SKU’s and transactions Future-proofing: We want a system we can plug other tools into later (like Facebook Ads or our Email platform) without starting over. Phase 1 We need a standard ELT pipeline set up. Warehouse: Google BigQuery or similar BI Tool: PowerBI. Transformation: All tables transformed & connected in Big Query ready for use in PBI or other platforms Connectors: We are happy to pay for connector tools providing they offer value for money and meet data security requirements. This is especially the case if buying helps us maintain the database & products in the future with greater ease. We don't want custom scripts unless absolutely necessary. The Data Sources Netsuite ERP: Sales Orders, Invoices, POs, Customers, Items, and Inventory. You'll need to help us figure out the best way to connect (ODBC/SuiteAnalytics vs REST API) for cost and speed. Handling custom fields is a must. BigCommerce: Orders, Products, Customers. The standard Big Commerce tables are already connected to Bigquery, however some transformation will be required to meet our business logic & match Netsuite Google Analytics 4: Just the standard native export to BigQuery. What the Data Needs to Do It's not enough to just dump raw data. We need you to clean it and model it for PowerBI. Clean up: Handle nulls, timezone fixes (UTC to Local), parent/child product relationships, etc Model it: Build a clean schema so our analysts can drag-and-drop fields in PowerBI without headache. Ensure Tidyiness: Handle product variant data correctly, model & tidy product-category information from Big Commerce correctly across the product catalogue, Business Logic: For metrics like Margin, data should be taken either direct from Netsuite where practical, or recalculated in the warehouse The Reports We need to prove this works. As part of the build, we want 4 prototypes in PowerBI or Big Query (as appropriate), these can be built with the help of our internal team. Daily, weekly, monthly sales dashboard: eg Daily Sales vs Target. Reconciliation: A report that shows mismatched items names, SKUs or barcodes between Big Commerce & Netsuite Inventory turns by category: Stock VS Sales by category Product performance: visits to page views to clicks to conversions to revenue, combining GA4, BigCommerce and Netsuite data Future Plans (For Context) You don't need to build this yet, but the architecture should be ready for it later: Marketing data (FB/Google Ads) - capability to start building our own attribution and analytics tools Email data (Dot Digital) - to combine email marketing and referral metrics with outcomes ie BigCommerce and Netsuite Competitor pricing scrapes - the ability to match competitor price scrapes to our own product data and eventually set up some automatic price rules. This could include other types of external data in excel, sheets, csv, etc What You'll Hand Over By the end of the project (aiming for ~8 weeks), we expect: The Infrastructure: GCP project set up with BigQuery, IAM roles, etc. The Code: A Git repo with all the SQL/dbt models. It needs to be commented well so our team understands why you did what you did. Documentation: A simple data dictionary and a "how-to" guide for troubleshooting common errors. Developing & Training: Sufficient interaction and development sessions with our internal team to ensure the data warehouse matches our business logic and we have sufficient understanding of the final product that you can handover the keys. Exception / error reporting: A dashboard or notification system so we are aware when the databases or pipelines have an issue. Timeline & Assumptions Timeline: We are thinking ~8 weeks. Weeks 1-3 for setup/ingestion, 4-6 for modeling, and the end for testing/handover. Access: We'll get you admin access to all the systems you need to set this up Data Quality: We know our data isn't perfect. Your job is to highlight the bad data, not manually fix issues in Netsuite or Big Commerce for us. The right final product will help us identify these fixes ourselves. Data update/ refresh Frequency: We are fine with Daily updates for now, but want the option to go Hourly later. Your response In order to assess the right engineering or team to help us with our project, we’ll need the following in response: Quote for the work - either fixed price, or hourly rate with expected timeline. Examples of previous work, ideally with referees. Examples ideally should be for a mature medium-size business, using some of the same systems. Your availability and expected timing What your expectations are of our involvement in the project - we are flexible & available, but we want to be clear about what you think we need to provide or be available for. Any inclusions, exclusions, or assumptions you would like to specify upfront.
Project ID: 40202453
47 proposals
Remote project
Active 2 mos ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
47 freelancers are bidding on average $43 AUD/hour for this job

Hi there, I’ve reviewed your Netsuite + BigCommerce data warehouse brief and I’m confident I can build a solid, scalable ELT foundation in Google BigQuery with clean modeling for Power BI. I’ve delivered similar data warehousing projects for midsize ecommerce clients, connecting Netsuite, BigCommerce, GA4, and more, setting up automated daily loads, robust data quality checks, and clear documentation for a smooth handover. My approach starts with Phase 1: standard ELT pipelines, secure connectors, and a governed schema that’s easy to extend. I’ll connect Netsuite (REST or SuiteAnalytics depending on cost/speed), BigCommerce, and GA4, then transform and model in BigQuery so analysts can drag-and-drop in Power BI. I’ll deliver 4 prototype dashboards (Daily/Weekly/Monthly sales, Reconciliation, Inventory turns, Product performance) to prove the setup while building a data dictionary, lineage, IAM roles, and monitoring. You’ll get a Git repo with well-commented SQL/dbt models and hands-on training for your team to maintain and extend the system. Timeline is ~8 weeks with weekly milestones and a quick check-in. Ready for a quick call to confirm scope and access? What are the exact data sources and required tables (Netsuite, BigCommerce, GA4) and any custom fields?\n\nDo you prefer REST API vs ODBC/SuiteAnalytics for the Netsuite connection, and what are acceptable latency SLAs?\n\nWhat is the target BigQuery schema and preferred canonical models (facts/dimensions)?\n\nWhat data q
$35 AUD in 23 days
7.0
7.0

⭐⭐⭐⭐⭐ Valuable Client, CnELIndia, led by Raman Ladhani, can help you build a scalable, future-proof data warehouse on Google BigQuery, fully integrated with Netsuite, BigCommerce, and GA4, ready for Power BI analysis. We propose an 8-week plan: Weeks 1–3 for connector setup and ELT pipelines, 4–6 for modeling, and final weeks for validation, dashboards, and handover. We’ll ensure clean, transformed data with proper handling of nulls, timezone, parent/child relationships, and product variants. Git-based dbt models, detailed documentation, and training sessions will empower your internal team to maintain and expand the system. Exception reporting dashboards will notify your team of issues, and the architecture will allow future integrations (ads, email, competitor data). Your team’s involvement: providing admin access, clarifying business logic, and reviewing prototypes. Our rate: fixed-price or hourly, with references from similar mid-size ecommerce projects.
$38 AUD in 40 days
6.6
6.6

Hello, As a team dedicated to turning your visions into reality, we at Live Experts® LLC are confident in our ability to construct a cohesive and efficient data warehouse solution for your Netsuite and Big Commerce systems. In our vast experience as Data Engineers, we have successfully implemented similar ELT pipelines utilizing Google BigQuery and Power BI for numerous other e-commerce clients. This experience will prove invaluable in the task of connecting, transforming, modeling, and maintaining your extensive sales order, inventory, customer and product data across multiple platforms. Notably, our proficiency in SQL ensures that we can handle complex data logic requirements such as handling parent-child product relationships correctly. We also understand the criticality of clean and accurate data for effective decision making thus rest assure that we'd identify issues such as mismatched items or nulls and correct them during ETL ensuring the final result is trustworthy. Additionally, our mastery of cloud technologies means we can build scalable Data Warehouses tailor-made for large e-commerce data sets - a perfect fit to your thorough project description. Our ability to connect external sources like Google Analytics 4 will provide you richer insights by combining web traffic analysis with sales transactions volume that may cumbersome on any other platform Thanks!
$71 AUD in 29 days
5.2
5.2

As an experienced data engineer and e-commerce expert, I'm confident that I'm the ideal match for your project. My extensive knowledge in handling data from multiple sources and platforms such as Netsuite, BigCommerce, and Google BigQuery coupled with a strong understanding of PowerBI will ensure a seamless integration between your ERP and front-end website, while granting your analysts easy access to crucial business insights. I not only focus on providing a "black-box" solution but also prioritizes collaboration and knowledge transfer. I understand the constraints of resource-strapped teams and appreciate the need for long-term maintenance. Therefore, partnering with me would mean receiving a well-documented, efficient solution that guarantees easy maintenance post-handover, leaving you confidently equipped to extend and adapt it to other tools as needed.
$38 AUD in 40 days
5.3
5.3

Hi I can build your scalable data warehouse in Google BigQuery, integrating Netsuite, BigCommerce, and GA4 with clean ELT pipelines and well-structured models ready for Power BI. The main technical challenge is unifying Netsuite and BigCommerce data—handling custom fields, product variants, mismatched attributes, and time-series volume—and I solve this through robust transformation layers, schema standardization, and tidy business logic modeling. I’ve built similar analytics foundations for ecommerce companies, ensuring automation, clear documentation, and internal team training so nothing becomes a “black box.” You’ll receive a properly architected warehouse, dbt/SQL models, reconciliation logic, and prototypes proving the system works end-to-end. I also design pipelines with future integrations in mind (ads, email, competitor data) for long-term scalability. I work collaboratively and provide full transparency so your team can maintain and extend everything confidently after handover. Thanks, Hercules
$50 AUD in 40 days
3.9
3.9

Hi, We’re a specialist team of data engineers, BI developers and ERP consultants (NetSuite, MS Business Central) with deep ecommerce experience, and this mix is a perfect fit for your Netsuite–BigCommerce data warehouse initiative. For Phase 1, we propose an 8‑week engagement aligned to your plan: Weeks 1–3 for GCP/BigQuery setup, ELT connectors selection (no “black box”), and ingestion from NetSuite, BigCommerce and GA4; Weeks 4–6 for dbt/SQL modelling, business logic (margin, inventory turns, reconciliation rules), and building the four prototype Power BI dashboards; Weeks 7–8 for optimisation, documentation, exception monitoring and handover/training of your internal analytics team. Could you share rough volumes (daily orders/SKUs, GA4 events), preferred/allowed ELT tools, and any compliance or PII constraints that might affect BigQuery region and access design? We’d be happy to walk you through similar retail/ERP–commerce warehouse builds, clarify assumptions, and then lock in a detailed plan, timelines and responsibilities for a smooth handover. Regards Sahanaj
$50 AUD in 40 days
2.8
2.8

Hi there, I’m excited about the opportunity to develop a data warehouse for your ecommerce environment! With extensive experience in SQL, ETL processes, and integrations specifically tailored for systems like Netsuite and BigCommerce, I can help streamline your data handling to eliminate manual reporting and enhance your insights. I'll ensure a robust ELT pipeline in Google BigQuery, transforming your data for seamless analysis in Power BI. Documentation and training sessions are guaranteed, so your team can confidently maintain this system moving forward. Best regards,
$25 AUD in 131 days
2.5
2.5

Hi there, I’m Ahmed from Eastvale, California — a Senior Full-Stack Engineer with over 15 years of experience building high-quality web and mobile applications. After reviewing your job posting, I’m confident that my background and skill set make me an excellent fit for your project — Netsuite & Big Commerce Data Warehouse Project . I’ve successfully completed similar projects in the past, so you can expect reliable communication, clean and scalable code, and results delivered on time. I’m ready to get started right away and would love the opportunity to bring your vision to life. Looking forward to working with you. Best regards, Ahmed Hassan
$56 AUD in 40 days
0.0
0.0

Hello, How are you? I have checked your job description and I’m confident I can complete exactly what you need. I have extensive experience with data warehousing, ETL processes, Google BigQuery, and Power BI. Specifically, I've developed robust data pipelines and models for e-commerce platforms similar to Netsuite and BigCommerce, ensuring clean and actionable insights for analysis. My approach will focus on establishing a scalable architecture for your data warehouse, enabling better visibility and reporting while providing full documentation and training for your internal team. This job is an ideal match with my skills and experience. Please send me a message so that we can discuss more. Thanks,
$35 AUD in 31 days
0.0
0.0

Hey Mate , Good morning! I can complete this project quickly and professionally. I’m a Senior Software Developer with 13+ years of experience delivering production-grade systems for global clients. I focus on results: clean architecture, fast execution, and long-term stability. I’ve handled similar work before and can jump in immediately without onboarding delays. I have strong experience with Data Warehousing, ETL, BigCommerce, Power BI, Data Integration, SQL, Business Intelligence and Data Visualization and related technologies. For more information, please review my portfolio. Ready to start right away. Thanks Eduard Shypovych
$35 AUD in 35 days
0.0
0.0

Hello, I understand the complexities of integrating Netsuite and Big Commerce to create an efficient data warehouse for your eCommerce needs. With extensive experience building data pipelines and optimizing data architecture, I am confident in establishing a robust Google BigQuery warehouse that meets your requirements. My background includes working with data visualization in Power BI, leveraging strong ETL skills to ensure clean, actionable data models. I will emphasize documentation and training as part of the project, ensuring your team can autonomously manage and develop the data infrastructure in the future. I propose a timeline of approximately 8 weeks, focusing first on the ELT setup, then modeling for insightful reporting. I look forward to discussing your expectations and how we can collaborate effectively . Best regards, Thaveesha
$42 AUD in 29 days
0.0
0.0

Hi Employer, I am highly interested in your Netsuite & Big Commerce Data Warehouse Project. With a strong background in data engineering and a deep understanding of e-commerce platforms, I am confident that I can help you achieve your goal of building a scalable and efficient data warehouse. Your project aligns perfectly with my expertise in SQL, BigCommerce, data warehousing, and business intelligence. I have extensive experience in setting up ELT pipelines, particularly using Google BigQuery and Power BI, and I am well-versed with integration from platforms like Netsuite and BigCommerce. My approach will ensure that your data is not only clean and structured but also ready for insightful analysis. I propose to begin with a comprehensive assessment of your existing data sources and requirements, followed by setting up a robust infrastructure on Google BigQuery. I will ensure seamless integration with Power BI, enabling you to derive meaningful insights and automate reporting. The solution will be designed with scalability in mind, allowing future integration of additional data sources like marketing and email platforms. Your involvement will be crucial for the success of this project. I will work closely with your internal IT/Analytics team, providing thorough documentation and training to ensure a smooth handover. This collaboration will empower your team to maintain and expand the system in the future. I am ready to start immediately and am excited about the opportunity to contribute to your project's success. Best Regards, George M.
$25 AUD in 14 days
0.0
0.0

Hi, I’ve worked on projects like this before, so what you’re describing makes sense to me. And I'm really interested in this project - Netsuite & Big Commerce Data Warehouse Project. I usually focus on getting things done cleanly and making sure they work properly in real use, not just on paper. I’m comfortable either improving an existing setup or helping build something new, depending on what stage you’re at. I keep communication straightforward, share progress along the way, and flag issues early so there are no surprises later. If you want, you can share a bit more about the current setup or the goal you’re trying to reach, and I can let you know how I’d approach it. Thanks, Jesse
$85 AUD in 27 days
0.0
0.0

⭐⭐⭐⭐⭐ ✅Hi there, hope you are doing well! I have extensive experience building data warehouses for e-commerce platforms integrating Netsuite, BigCommerce, and analytics data into Google BigQuery enabling seamless fast reporting and accurate insights. The key to success in your project is establishing clean, scalable data pipelines and well-modeled schemas that align with your business logic for Power BI reporting. Approach: ⭕ Setup secure, cost-effective connectors for Netsuite (evaluating ODBC/SuiteAnalytics or REST API) and BigCommerce data ingestion ⭕ Build ELT pipelines with dbt in Google BigQuery for clean, transformed, and joined data ready for visualization ⭕ Develop documented dbt models handling timezone, nulls, product hierarchies, and business metrics like margin ⭕ Create prototype Power BI reports alongside your team for sales, reconciliation, inventory, and product performance ⭕ Deliver full documentation, error alert dashboards, and conduct training sessions for your internal team ❓Could you clarify the volume of daily transactions expected? This will influence optimization and update frequency decisions. I am confident I can deliver a future-proof, maintainable data warehouse foundation that empowers your analysts and scales with your business. Best regards, Nam
$35 AUD in 35 days
0.0
0.0

Hi there, I have carefully reviewed your project requirements for building a data warehouse for Netsuite, Big Commerce, and other data platforms. I am confident in my ability to deliver a high-quality solution that meets your goals and expectations. With over 3 years of experience in Power BI and SQL, I have the expertise to set up a standard ELT pipeline in Google BigQuery, connect all necessary data sources, and create clean schemas for easy analysis in Power BI. I am well-versed in handling complex data transformations and ensuring data accuracy. I am excited about the opportunity to work on this project and help your team automate manual processes, gain better insights, and future-proof your data analytics capabilities. I am ready to collaborate closely with your internal team, provide detailed documentation, and offer training to ensure a smooth handover. I look forward to discussing your project further and addressing any questions you may have. Best Regards, Ghulman
$38 AUD in 40 days
0.0
0.0

Hello , I checked your project, and it looks interesting. This is something we already work on, so the requirements are clear from the start. We mainly work on SQL, BigCommerce, Data Warehousing, Business Intelligence, Data Visualization, Data Integration, Power BI, ETL We focus on making things simple, reliable, and actually useful in real life not overcomplicated stuff. Let’s connect in chat and see if we’re a good fit for this. Best Regards, Ali nawaz
$25 AUD in 40 days
0.0
0.0

Hello Employer, I’m Dragan M., and I’m excited about the opportunity to work with your team on the Netsuite & Big Commerce Data Warehouse Project. Your goal of creating a robust, scalable data warehouse aligns perfectly with my expertise in SQL, data warehousing, and business intelligence. I understand that your primary objectives are to automate daily reports, resolve data discrepancies, and gain better insights into customer behavior. With my extensive experience in setting up ELT pipelines and integrating data from ERP systems like Netsuite and platforms such as BigCommerce and Google Analytics, I am confident in delivering a solution that meets your needs. My approach will involve setting up a central data warehouse on Google BigQuery, ensuring seamless data integration and transformation ready for visualization in Power BI. I will focus on creating a clean, intuitive data model that supports both granular and macro-level analysis. Additionally, I will ensure that the solution is future-proof, allowing for the integration of additional data sources like marketing and email platforms. I have previously worked with medium-sized retail businesses, helping them achieve similar goals, and can provide examples upon request. My aim is not only to build the foundation but also to empower your internal team through comprehensive documentation and training, ensuring you have full control over the system post-handover. I look forward to collaborating closely with your team to ensure the project's success. Please let me know how I can assist further. Best regards, Dragan M.
$38 AUD in 14 days
0.0
0.0

Hello, After reviewing your project description, it's clear that building a data warehouse for Netsuite and Big Commerce is crucial for automating reports, fixing data discrepancies, and gaining better insights. I propose setting up a standard ELT pipeline in Google BigQuery, transforming all tables, and connecting them for analysis in PowerBI. With experience in similar projects integrating Netsuite and Big Commerce data for e-commerce businesses, I can ensure a scalable, stable solution that meets your specific needs. Best regards, Justin
$40 AUD in 40 days
0.0
0.0

Hello Employer, Thank you for the detailed project brief—your goals are very clear, and I believe my experience aligns perfectly. I have designed and delivered similar data warehouse and BI solutions for mid-sized ecommerce businesses, integrating Netsuite, BigCommerce, and Google Analytics data into BigQuery and modeling it for seamless Power BI usage. My approach will be to set up robust, well-documented ELT pipelines using industry-standard connector tools where possible, ensuring data cleanliness, business logic accuracy, and future scalability. I’ll work closely with your internal team throughout the process, providing transparent documentation, training, and handover so you have full ownership and understanding of every component. To ensure success, I’ll need timely access to your systems and periodic feedback sessions to align data models with your business needs. I’m confident I can deliver a flexible, reliable foundation that will empower your analytics now and in the future.
$38 AUD in 14 days
0.0
0.0

Hi, This project is a great fit for my background in data engineering and analytics platforms. I can help you build a scalable, well-documented data warehouse in Google BigQuery, designed specifically for e-commerce volumes and Power BI analysis. I recommend BigQuery + Power BI with SQL/dbt-style transformations inside the warehouse. This approach enables fast time-series analysis, clean joins across NetSuite, BigCommerce, and GA4, and a schema your analysts can easily work with. I’ll help select the most maintainable ingestion method for NetSuite (SuiteAnalytics or REST, including custom fields), build on your existing BigCommerce → BigQuery connection, and use GA4’s native export. I prefer managed connectors where they add long-term value and avoid unnecessary custom scripts. Deliverables include a production-ready ELT pipeline, cleaned and modeled data (variants, categories, inventory, margins), four working prototype reports (sales, reconciliation, inventory turns, product funnel), full documentation, and a commented Git repo so your team can own and extend the system. Happy to discuss architecture and timeline. Thanks
$50 AUD in 40 days
0.0
0.0

Brisbane, Australia
Member since Jan 28, 2026
$10-30 USD
₹600-1500 INR
₹600-1500 INR
$30-250 USD
₹600-1500 INR
$250-750 USD
₹750-1250 INR / hour
$250-750 CAD
₹600-1500 INR
₹12500-37500 INR
min €36 EUR / hour
₹12500-37500 INR
₹1500-12500 INR
₹1500-12500 INR
₹12500-37500 INR
$30-250 USD
£3000-5000 GBP
₹750-1250 INR / hour
₹12500-37500 INR
₹1500-12500 INR