BPM LLP - NetSuite Consultant- NSAW

• 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 • 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 • 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.