NetSuite Consultant- NSAW
BPM LLPToronto, Ontario, Canada • Los Angeles, California, United States
Posted January 22, 2026
150000 - 200000 USD
Full Time
About the Company
BPM is a company that values people and provides equal employment opportunities to all employees and applicants.
Job Description
BPM is seeking a hands-on NetSuite Analytics Warehouse (NSAW) Architect who understands NSAW end-to-end. The successful candidate will be responsible for designing and implementing transformation logic in Oracle ADW, writing and optimizing complex Oracle SQL, and architecting structures that support trial balance reporting, P&L, balance sheet, and cash flow. They will also be responsible for partnering with integration teams using Boomi, Oracle Integration Cloud (OIC), or similar iPaaS tools and leading root-cause analysis when data issues occur across NetSuite, integration tools, ADW, and NSAW semantic layer.
Requirements
- 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 NetSuite data structures (e.g., Transactions vs. Transaction Lines) and core financial cycles (Order-to-Cash, Procure-to-Pay)
- 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 SuiteAnalytics Connect, REST APIs, or custom NetSuite extracts
- Experience integrating non-NetSuite systems into NSAW
- Background in financial analytics, EPM, or data warehousing projects
- Experience building reconciliation and audit frameworks
Benefits
- Total rewards package
- Well-being resources
- Balance & flexibility
- Professional development opportunities
