NetSuite Consultant- NSAW

BPM – where caring and community is in our company DNA; we are always striving to be our best selves; and we’re compelled to ask the questions that lead to innovation. Working with BPM means using your experiences, broadening your skills, and reaching your full potential in work and life—while also making a positive difference for your clients, colleagues, and communities. Our shared entrepreneurial spirit drives us to see and do things differently. Our passion for people makes BPM a place where everyone feels welcome, valued, and part of something bigger. Because People Matter. What you get: 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.Who is successful at BPM:· 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 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 DONSAW Architecture & Solution OwnershipArchitect 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 KPIsDefine NSAW best practices for Data modeling standards, Environment setup, Security and subject area design, Performance, and scalabilityBusiness Discovery & Rules EngineeringLead discovery sessions to translate business questions into: KPIs, financial logic, allocation rules, hierarchies, and grain definitionsBuild working SQL prototypes to validate logic before dashboards are developed.Data Engineering, ADW & Advanced SQLDesign 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 logicArchitect structures that support trial balance reporting, P&L, balance sheet, and cash flow, operational analytics, drill-through from summary to transaction levelIntegration & Pipeline DesignPartner with integration teams using: Boomi, Oracle Integration Cloud (OIC), Celigo or similar iPaaS toolsDefine: source-to-target mappings, data contracts, refresh strategies, dependency flowsUnderstand and document how transformations in middleware impact downstream analytics.Lead root-cause analysis when data issues occur across: NetSuite, integration tools, ADW, NSAW semantic layerAnalytics Delivery & EnablementDesign 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 materialKEY DELIVERABLES YOU WILL OWNNSAW solution architecture documentsSource-to-target mappingsBusiness rules and KPI catalogReconciliation and validation frameworksADW transformation logic and viewsNSAW subject area designsTechnical handover and operational guidesSUCCESS IN THIS ROLE LOOKS LIKENSAW 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 MATTERSNSAW is not just another reporting product. It has become the financial and