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.
Skills Required
- Hands-on NSAW implementation experience
- Strong Oracle SQL expertise
- Oracle ADW expertise
- Experience with Oracle Analytics Cloud 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 and REST APIs
- Background in financial analytics, EPM, or data warehousing
- Strong client-facing communication and consulting skills
BPM LLP Compensation & Benefits Highlights
The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about BPM LLP and has not been reviewed or approved by BPM LLP.
-
Leave & Time Off Breadth — Policies include generous PTO, multiple firm holidays, and seasonal breaks, with unlimited PTO available for certain roles. Feedback suggests these options enhance overall value even in a demanding industry.
-
Healthcare Strength — Multiple medical, dental, and vision plan choices are offered with a strong employer-paid share, alongside HSA options and mental-health resources. Feedback suggests the breadth and depth of coverage are a core strength of the package.
-
Flexible Benefits — Flexible and remote/hybrid work options are emphasized, along with alternative schedules. Feedback suggests this flexibility is a meaningful component of total rewards.
BPM LLP Insights
What We Do
BPM LLP is one of the 50 largest public accounting and advisory firms in the country. With more than 800 professionals along the West Coast – as well as offices abroad – we help clients succeed around the world. We offer a cross-functional team approach that gives clients direct access to the best and most qualified resources. With full-service capabilities in audit, tax and advisory services, we possess in-depth knowledge of the transactional industry—its key processes, challenges surrounding growth and performance, regulatory compliance and governance—and the many other complex accounting and reporting issues you face. Our collective knowledge representing a diverse client base allows us to serve as experts in over a dozen industries. In 2021, we are proud to be named by Forbes “Best Tax and Accounting Firms” and #22 on Vault’s “Accounting 50” ranking! We invite you to learn more about us, visit bpmcpa.com
