NetSuite Consultant- NSAW

RemoteSeniorPosted Aug 17, 2026

NetSuiteOracleSQLOracle Analytics CloudBoomiOracle Integration CloudCeligoETL+9 more

About this role

BPM LLP seeks a hands-on NetSuite Analytics Warehouse (NSAW) Architect to own full-stack analytics architecture, turning raw ERP and third-party data into a governed, high-performance analytics platform. This senior role spans data architecture, integration design, SQL transformations, and executive-level analytics delivery.

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

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

SQLRESTBusiness analysisETLCloudOracleData engineeringData analyticsERPData modelingDWHCI/CDNetSuiteOracle Analytics CloudBoomiOracle Integration CloudCeligo

Responsibilities

Architect complete NSAW implementations from source to OAC dashboards

Define NSAW best practices for modeling security and performance

Lead discovery sessions to translate business questions into KPIs and logic

Build 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 or Celigo

Define source-to-target mappings and refresh strategies

Lead root-cause analysis for data issues across the full stack

Design executive-ready dashboards in Oracle Analytics Cloud

Develop technical documentation and client training materials

Benefits

Flexible time offTraining and career developmentEmployee Assistance ProgramPaid parental leaveWellness platform with incentivesFlexible hoursCompetitive salaryTuition reimbursementRemote work

Amenities

14 firm holidays including 2 floatingFlex PTO and paid family leaveWinter break and summer hoursRemote work optionsInteractive wellness platform with incentivesMental health resources and Colleague Resource GroupsCPA exam resources and bonusesCoach program and live classes through BPM University