NetSuite Consultant- NSAW

Net Suite Analytics Warehouse (NSAW) Architect

BPM/Caravel is seeking a hands‑on Net Suite Analytics Warehouse (NSAW) Architect who understands NSAW end‑to‑end:
Net Suite source data, integration pipelines, Autonomous Data Warehouse, semantic modeling, and Oracle Analytics Cloud delivery.

• NSAW Architecture & Solution Ownership
  :
  Architect complete NSAW implementations including source system analysis, ADW data structures, transformation layers, semantic models, dashboards, and KPIs. Define best practices for data modeling standards, environment setup, security, 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 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, cash flow, operational analytics, drill‑through from summary to transaction level.
• Integration & Pipeline Design
  :
  Partner with integration teams using Boomi, Oracle Integration Cloud, Celigo or similar iPaaS tools. Define source‑to‑target mappings, data contracts, refresh strategies, dependency flows. Understand and document how transformations in middleware affect downstream analytics. Lead root‑cause analysis when data issues occur across Net Suite, 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 such as 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

• 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 Net Suite data structures and core financial cycles.
• 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 Suite Analytics Connect, REST APIs, or custom Net Suite extracts.
• Experience integrating non‑Net Suite systems into NSAW
  .
• Background in financial analytics, EPM, or data warehousing projects.
• Experience building reconciliation and audit frameworks.

$150,000 - $200,000 a year (salary range reflects scope and responsibilities associated with the role). Specific details for compensation above $200,000 will be provided during the recruitment process.

BPM provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national or ethnic origin, disability status, genetics, sexual orientation, gender identity or expression, or any other characteristic protected by federal, provincial or local laws. BPM encourages applications from people with disabilities. Accommodations are available on request.