BPM LLP
·Business Intelligence
NetSuite Consultant- NSAW
About this role
BPM/Caravel seeks a hands-on NetSuite Analytics Warehouse (NSAW) Architect to own full-stack analytics architecture from NetSuite source data through Oracle Analytics Cloud delivery. This senior consulting role requires deep expertise in Oracle SQL, ADW, semantic modeling, and iPaaS integration tools to build governed, high-performance financial analytics platforms.
Must have
Proven NSAW implementation experience
Deep Oracle SQL expertise with analytical functions and performance tuning
Strong Oracle ADW knowledge including schema design and optimization
Strong understanding of Oracle Analytics Cloud and semantic modeling
Deep understanding of NetSuite data structures and core financial cycles
Hands-on experience with iPaaS tools such as Boomi or Oracle OIC
Client-facing consulting capability to lead workshops and explain complex issues
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
Technologies
Responsibilities
Architect complete NSAW implementations from source to OAC delivery
Define NSAW best practices for data modeling security and performance
Lead discovery sessions to translate business questions into KPIs and logic
Build working SQL prototypes to validate logic before dashboard development
Design and implement transformation logic in Oracle ADW
Write optimize and review complex Oracle SQL for financial reporting
Partner with integration teams using Boomi OIC Celigo or similar tools
Define source-to-target mappings data contracts and refresh strategies
Lead root-cause analysis when data issues occur across the stack
Design executive-ready dashboards in Oracle Analytics Cloud
Develop enablement assets including documentation and training materials
Benefits
Amenities
Recruitment process
Role is with BPM LLP through their Caravel analytics practice
NSAW is the financial and operational intelligence backbone for customers
This is a full-stack analytics architecture position not a dashboard builder role
You will own the NSAW solution lifecycle end-to-end
Success means NSAW balances to NetSuite without debate
BPM values caring people entrepreneurial spirit and diverse perspectives
BPM provides equal employment opportunities and welcomes applicants with disabilities
Position based in Canada with remote work options
