NSAW Architect

Job Summary:

BPM/Caravel is looking for a hands-on NSAW Architect to design and deliver end-to-end analytics solutions across NetSuite, NSAW, Oracle ADW, and Oracle Analytics Cloud (OAC). The role requires strong technical architecture, data modeling, integration, and client-facing consulting skills.

The NSAW Architect will own the solution lifecycle from business discovery and data architecture through integration, transformation, reconciliation, semantic modelling, and executive-level analytics delivery.

 Key Responsibilities

• Architect and lead end-to-end NSAW implementations.
• Design data models, transformation layers, and integrations across NetSuite and third-party systems.
• Develop complex Oracle SQL for financial transformations, analytics, and performance optimization.
• Design and optimize Oracle ADW schemas and data pipelines.
• Build NSAW semantic models, subject areas, KPIs, and OAC dashboards.
• Work with NetSuite data structures and financial processes such as O2C and P2P.
• Develop integrations using Boomi, Oracle OIC, SuiteAnalytics Connect, REST APIs, or custom extracts.
• Build data reconciliation, audit, and data quality frameworks.
• Lead client workshops and translate business requirements into scalable analytics solutions.

Required Skills

• Proven hands-on NSAW implementation experience.
• Strong Oracle SQL and ADW expertise.
• Experience with OAC and semantic modeling.
• Strong understanding of NetSuite ERP data and financial processes.
• Experience with Boomi or Oracle OIC.
• Experience integrating non-NetSuite systems into NSAW.
• Experience with SuiteAnalytics Connect / REST APIs.
• Background in financial analytics, EPM, or data warehousing.
• Strong client-facing communication and consulting skills.