Caravel | BPM Technology Solutions · 14 hours ago
NetSuite Consultant- NSAW
United States
Full-time
Remote
Senior Level
$150K/yr - $200K/yrCaravel | BPM Technology Solutions is a company that prioritizes caring and community. They are seeking a hands-on NetSuite Analytics Warehouse (NSAW) Architect responsible for architecting complete NSAW implementations and ensuring the integrity of data across various systems.
ConsultingEnterprise Resource Planning (ERP)Project ManagementSoftware
Responsibilities
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
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
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
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
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
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
Qualification
Required
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
Benefits
Total rewards package: from flexible work arrangements to personalized benefit structures and financial compensation options that give you choice and flexibility.
Well-being resources: interactive wellness platform and incentives, an employee assistance program and mental health resources, and Colleague Resource Groups (CRGs) that provide safe spaces for colleagues to share, be heard, feel valued and deepen connections.
Balance & flexibility: 14 Firm Holidays including 2 floating, Flex PTO, paid family leave, winter break, summer hours, and remote work options, so you can balance challenging yourself with taking care of yourself.
Professional development opportunities: A learning culture with CPA exam resources and bonuses, tuition reimbursement, a coach program, and live classes, workshops, and seminars through BPM University.
Company
Caravel | BPM Technology Solutions
What we do is simple: advise, deploy, support.
Founded in 2016
1001-5000 employees
Funding
Current Stage
Late StageLeadership Team
Caila Cohen
Partner
Scott Curry
Managing Partner
Company data provided by crunchbase