> Markdown version of [/jobs/ext/2788127-netsuite-analytics-warehouse-nsaw-architect](https://www.wearedevelopers.com/jobs/ext/2788127-netsuite-analytics-warehouse-nsaw-architect). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md).

---

# NetSuite Analytics Warehouse (NSAW) Architect

- **Company:** BPM
- **Location:** San Francisco, CA, United States (Remote available)
- **Salary:** $150,000.0 - $200,000.0
- **Contract:** Permanent contract
- **Skills:** Data Analysis, Business Logic, Cloud Computing, System Configuration, Data Architecture, Information Engineering, Data Structures, Data Warehousing, Middleware, Systems Analysis, Netsuite, Oracle (Applications), Oracle SQL Developer, Performance Tuning, SQL Databases, Systems Integration, Cloud Platform System, Sql Optimization, Boomi, Analytic Functions, Oracle Service Cloud, Integration Frameworks, Data Management, Restful APIs, Oracle Integration, Data Pipelines
- **Published:** September 8, 2026
- **Apply:** https://jobs.lever.co/bpmcpa/3b4c09bf-258e-4da5-a7b6-ee7421e1e70f/apply

## About the Role

· Caring people who put others first
· Self-starters who embody the BPM entrepreneurial spirit
· Authentic individuals with a diverse point of view
· Lifelong learners with a drive to excel
· Resilient people who rise to the occasion, * Proven NSAW implementation experience.

 * Deep Oracle SQL expertise, including analytical functions, performance tuning, financial transformation logic
 * Strong Oracle ADW knowledge including schema design, transformation layering, optimization
 * Strong understanding of Oracle Analytics Cloud (OAC) and semantic modeling.
 * ERP Fluency: Deep understanding of NetSuite data structures (e.g., Transactions vs. Transaction Lines) and core financial cycles (Order-to-Cash, Procure-to-Pay).
 * Hands-on experience with iPaaS tools such as Boomi or Oracle OIC.
 * Client-facing consulting capability to lead workshops, challenge requirements, explain complex data issues simply
 * Experience with SuiteAnalytics Connect, REST APIs, or custom NetSuite extracts
 * Experience integrating non-NetSuite systems into NSAW
 * Background in financial analytics, EPM, or data warehousing projects
 * Experience building reconciliation and audit frameworks

## Description

BPM/Caravel is seeking a hands-on NetSuite Analytics Warehouse (NSAW) Architect who understands NSAW end-to-end: NetSuite source data, integration pipelines, Autonomous Data Warehouse, semantic modeling, and Oracle Analytics Cloud delivery.
This is not a "dashboard builder" role. This is a full-stack analytics architecture position responsible for turning raw ERP and third-party data into a reconciled, governed, high-performance analytics platform.
You will own the NSAW solution lifecycle: discovery, data architecture, integration design, SQL transformations, reconciliation frameworks, and executive-level analytics delivery.
If someone asks, "Why doesn't this number match NetSuite?" you are the person who traces it across NetSuite * iPaaS * ADW * NSAW semantic model * OAC visualization and fixes it.
WHAT YOU'LL DO
NSAW Architecture & Solution Ownership
Architect complete NSAW implementations including Source system analysis (NetSuite + external systems), ADW data structures and transformation layers, NSAW semantic models and subject areas, OAC dashboards and KPIs
Define NSAW best practices for Data modeling standards, Environment setup, Security and subject area design, Performance, and scalability
Business Discovery & Rules Engineering
Lead discovery sessions to translate business questions into: KPIs, financial logic, allocation rules, hierarchies, and grain definitions
Build working SQL prototypes to validate logic before dashboards are developed.
Data Engineering, ADW & Advanced SQL
Design and implement transformation logic in Oracle ADW.
Write, optimize, and review complex Oracle SQL involving multi-table financial joins, time-series logic, hierarchical modeling, reconciliation datasets, snapshotting and historical logic
Architect structures that support trial balance reporting, P&L, balance sheet, and cash flow, operational analytics, drill-through from summary to transaction level
Integration & Pipeline Design
Partner with integration teams using: Boomi, Oracle Integration Cloud (OIC), Celigo or similar iPaaS tools
Define: source-to-target mappings, data contracts, refresh strategies, dependency flows
Understand and document how transformations in middleware impact downstream analytics.
Lead root-cause analysis when data issues occur across: NetSuite, integration tools, ADW, NSAW semantic layer
Analytics Delivery & Enablement
Design executive-ready dashboards in Oracle Analytics Cloud aligned to NSAW models.
Enforce visualization and modeling best practices.
Develop enablement assets like technical documentation, solution walkthroughs, admin handover guides, internal training and client training material
KEY DELIVERABLES YOU WILL OWN
NSAW solution architecture documents
Source-to-target mappings
Business rules and KPI catalog
Reconciliation and validation frameworks
ADW transformation logic and views
NSAW subject area designs
Technical handover and operational guides
SUCCESS IN THIS ROLE LOOKS LIKE
NSAW balances to NetSuite without debate.
Business logic is documented, versioned, and scalable.
Integrations are predictable, traceable, and debuggable.
Clients trust the platform.
Internal teams can extend your work without breaking it.
WHY THIS ROLE MATTERS
NSAW is not just another reporting product. It has become the financial and operational intelligence backbone of our customers. This role defines whether that backbone is fragile or bulletproof.


## Related Videos

- [Developer’s Perspective: Overview of the Tezos Blockchain Ecosystem](https://www.wearedevelopers.com/videos/237-developer-s-perspective-overview-of-the-tezos-blockchain-ecosystem)
- [From Global Capability Centers to AI-Powered Command Centers](https://www.wearedevelopers.com/videos/100096-from-global-capability-centers-to-ai-powered-command-centers)
- [Exploring BOS: The Blockchain Operating System by NEAR Protocol](https://www.wearedevelopers.com/videos/781-exploring-bos-the-blockchain-operating-system-by-near-protocol)
- [Making Data Warehouses fast. A developer's story.](https://www.wearedevelopers.com/videos/302-making-data-warehouses-fast-a-developer-s-story)
- [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works)
- [Full-stack role-based authorization in 45 minutes](https://www.wearedevelopers.com/videos/312-full-stack-role-based-authorization-in-45-minutes)

## Related Articles

- [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story)
- [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers)
- [How We Built a Worry-Free System That Runs for 10+ Years – And What We’d Do Again](https://www.wearedevelopers.com/magazine/751-how-we-built-a-worry-free-system-that-runs-for-10-years-and-what-we-d-do-again)
- [What Are The Top Skills Required For Azure Developers?](https://www.wearedevelopers.com/magazine/77-what-are-the-top-skills-required-for-azure-developers)
- [What Makes WeAreDevelopers World Congress Different From Every Other Tech Event?](https://www.wearedevelopers.com/magazine/701-what-makes-wearedevelopers-world-congress-different-from-every-other-tech-event)
- [Coffee with Developers - Maria Apazoglou - Making AI understandable for all in production](https://www.wearedevelopers.com/magazine/475-coffee-with-developers-maria-apazoglou-making-ai-understandable-for-all-in-production)