NetSuite Consultant- NSAW - Remote

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.
BPM encourages applications from people with disabilities. Accommodations are available upon request for all aspects of the selection process.

What you get:
Total rewards package: In the US, BPM offers personalized benefit structures and financial compensation options that provide choice and flexibility. In Canada, we offer comprehensive benefits coverage for you and your dependents. Regardless of location, colleagues have access to flexible work arrangements and health and wellness programs.
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 days, 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, firm support for professional memberships/certification, 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 DO
NSAW Architecture & Solution Ownership
Architect 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 KPIs
Define NSAW best practices for Data modeling standards, Environment setup, Security and subject area design, Performance, and scalability
Business Discovery & Rules Engineering
Lead discovery sessions to translate business questions into: KPIs, financial logic, allocation rules, hierarchies, and grain definitions
Build working SQL prototypes to validate logic before dashboards are developed.
Data Engineering, ADW & Advanced SQL
Design 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 logic
Architect structures that support trial balance reporting, P&L, balance sheet, and cash flow, operational analytics, drill-through from summary to transaction level
Integration & Pipeline Design
Partner with integration teams using: Boomi, Oracle Integration Cloud (OIC), Celigo or similar iPaaS tools
Define: source-to-target mappings, data contracts, refresh strategies, dependency flows
Understand and document how transformations in middleware impact downstream analytics.
Lead root-cause analysis when data issues occur across: NetSuite, integration tools, ADW, NSAW semantic layer
Analytics Delivery & Enablement
Design 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 material
KEY DELIVERABLES YOU WILL OWN
NSAW solution architecture documents
Source-to-target mappings
Business rules and KPI catalog
Reconciliation and validation frameworks
ADW transformation logic and views
NSAW subject area designs
Technical handover and operational guides
SUCCESS IN THIS ROLE LOOKS LIKE
NSAW 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 MATTERS
NSAW is not just another reporting product. It has become the financial and operational intelligence backbone of our customers. This role defines whether that backbone is fragile or bulletproof.


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


$150,000 - $200,000 per year


In accordance with Ontario’s pay transparency legislation, the posted compensation range, if applicable, will reflect the scope and responsibilities associated with the role. Positions supporting clients across multiple jurisdictions involve additional regulatory considerations, cross-border coordination, and broader compliance requirements compared to roles focused on a single local market. Hours of work and travel expectations may vary based on role scope and are considered in determining compensation. These factors, along with credential requirements and market benchmarks, are incorporated into compensation ranges to ensure alignment with industry standards and the specialized expertise required. Compensation includes base salary and any non-discretionary bonuses or commissions. If the top of the compensation range exceeds $200,000 annually, specific details will be provided during the recruitment process instead of being posted, in compliance with legislation.
Location Eligibility: We are only considering candidates who are currently located in Ontario
BPM provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national or ethnic origin, disability status, genetic characteristics, sexual orientation, gender identity or expression, or any other characteristic protected by federal, provincial or local laws. BPM welcomes and encourages applications from people with disabilities. Accommodations are available on request for candidates taking part in all aspects of the selection process.
We may use artificial intelligence (AI) tools to support parts of the hiring process, such as reviewing applications, analyzing resumes, or assessing responses. These tools assist our recruitment team but do not replace human judgment. Final hiring decisions are ultimately made by humans. If you would like more information about how your data is processed, please contact us.


Wondering if you should apply?
At BPM we are people who value people. We are progressive and purposeful. We are a firm with flexibility. Our shared entrepreneurial spirit drives us to see and do things differently. And our passion for people makes BPM a place where everyone feels welcome, valued, and part of something bigger.
***************
BPM provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws. BPM welcomes and encourages applications from people with disabilities. Accommodations are available on request for candidates taking part in all aspects of the selection process.
For positions based in San Francisco, consideration of qualified candidates with arrest and conviction records will be in a manner consistent with the San Francisco Fair Chance Ordinance.
Please note - this posting is for prospective candidates only. Unsolicited third-party resume submissions will be considered property of BPM and will not be acknowledged or returned.
#LI-MK1
#LI-Remote
Back to blog

Common Interview Questions And Answers

1. HOW DO YOU PLAN YOUR DAY?

This is what this question poses: When do you focus and start working seriously? What are the hours you work optimally? Are you a night owl? A morning bird? Remote teams can be made up of people working on different shifts and around the world, so you won't necessarily be stuck in the 9-5 schedule if it's not for you...

2. HOW DO YOU USE THE DIFFERENT COMMUNICATION TOOLS IN DIFFERENT SITUATIONS?

When you're working on a remote team, there's no way to chat in the hallway between meetings or catch up on the latest project during an office carpool. Therefore, virtual communication will be absolutely essential to get your work done...

3. WHAT IS "WORKING REMOTE" REALLY FOR YOU?

Many people want to work remotely because of the flexibility it allows. You can work anywhere and at any time of the day...

4. WHAT DO YOU NEED IN YOUR PHYSICAL WORKSPACE TO SUCCEED IN YOUR WORK?

With this question, companies are looking to see what equipment they may need to provide you with and to verify how aware you are of what remote working could mean for you physically and logistically...

5. HOW DO YOU PROCESS INFORMATION?

Several years ago, I was working in a team to plan a big event. My supervisor made us all work as a team before the big day. One of our activities has been to find out how each of us processes information...

6. HOW DO YOU MANAGE THE CALENDAR AND THE PROGRAM? WHICH APPLICATIONS / SYSTEM DO YOU USE?

Or you may receive even more specific questions, such as: What's on your calendar? Do you plan blocks of time to do certain types of work? Do you have an open calendar that everyone can see?...

7. HOW DO YOU ORGANIZE FILES, LINKS, AND TABS ON YOUR COMPUTER?

Just like your schedule, how you track files and other information is very important. After all, everything is digital!...

8. HOW TO PRIORITIZE WORK?

The day I watched Marie Forleo's film separating the important from the urgent, my life changed. Not all remote jobs start fast, but most of them are...

9. HOW DO YOU PREPARE FOR A MEETING AND PREPARE A MEETING? WHAT DO YOU SEE HAPPENING DURING THE MEETING?

Just as communication is essential when working remotely, so is organization. Because you won't have those opportunities in the elevator or a casual conversation in the lunchroom, you should take advantage of the little time you have in a video or phone conference...

10. HOW DO YOU USE TECHNOLOGY ON A DAILY BASIS, IN YOUR WORK AND FOR YOUR PLEASURE?

This is a great question because it shows your comfort level with technology, which is very important for a remote worker because you will be working with technology over time...

Other Jobs To Apply

Appointment Setter – Remote

Remote - Bilingual Spanish Customer Service Representative (Automotive)

Customer Success Specialist

Booking Agent – Remote

Remote Help Desk Specialist

Video Content Moderator - Remote

Remote Payroll specialist, Onboarding specialist amd recruitment specialist job

Client Success Coordinator – Remote

Customer Service Representative – Travel Agency (USA Remote)

Growth Marketing Specialist – Display

Growth Product Manager – Stores Apparel

Field Marketing Coordinator - Remote Role with Travel

Amazon Catalog Optimization Specialist

Senior Consultant, AI Development and Go to Market Strategy

REMOTE: Marketing Operations Manager-Marketo

Lead Ads Product Marketing Manager, Programmatic Supply & Inventory

Content Strategist (Remote US) - Future Opening

eCommerce Marketing Specialist (Hybrid/Remote)

PR & Communications Manager (Remote US)

Email Retention Marketing Manager (Remote)

Hubspot Marketing Consultant (Remote)- CONTRACT

Marketing Director (Remote)

Product Marketing Manager (Remote)

Cold Email Marketing Specialist - Remote Job

SEO and Content Marketing Manager (Remote)

Director II, IT Service Owner - ERP & Finance Services

Remote Engineering Manager

Cloud Security Engineer/Architect (Remote)

Backend Security Engineer - Remote

Ruby on Rails Architect - Remote

.NET Developer - Remote

Senior Product Analyst - 100% Remote

Generative AI Architect - Remote

Automation Engineer (Remote, San Miguel de Tucuman)

Snowflake Engineer for Migration- REMOTE

Site Reliability Engineering(SRE) - Remote

Principal OpenShift Kubernetes Engineer- Remote

Flutter & Laravel Developer (Full-Time, Remote)

Remote Typescript Engineer

QA Test Engineer - Remote

Remote Cloud Support Engineer — AWS/Azure (Digital Marketing)

Fulltime | Senior Java Developer | 100% Remote

Remote Senior JavaScript Engineer

Principal Architect, Software Engineering

Digital Insurance Project Manager (Fully Remote)

Statistics Expert

Cleaning Specialist (Up to \$24/hr + Tips)

Digital Nomad Program Through The Intern Group

Senior Manager & Team Lead, GTM Training

Credentialing Assistant