NetSuite Consultant

🕒 January 27

🏄 California – Remote

🏄 California – Remote

💵 $150k - $200k / year

⏰ Full Time

🟡 Mid-level

🟠 Senior

💼 Consultant

🦅 H1B Visa Sponsor

This company has sponsored H1B visas in the past.

Apply Now

Find Similar Remote Jobs

Set Up Email Alert For New Jobs

📊 Check your resume score for this job

Improve your chances of getting an interview by checking your resume score before you apply.

Upload Resume

BPM LLP

WebsiteLinkedInAll Job Openings

501 - 1000 employees

💸 Finance

☁️ SaaS

Finance • Consulting • SaaS

BPM LLP is a large California-based accounting and consulting firm providing a wide range of services. These include assurance, advisory, tax, and IT consulting, with specialized expertise in areas like cybersecurity and risk advisory. The firm serves a diverse client base across multiple industries, including financial services, real estate, and technology. BPM is committed to delivering personalized service tailored to meet the specific needs of each client, facilitating business growth and compliance with industry regulations.

📋 Description

• 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. • 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. • 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. • 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. • 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.

🎯 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: from flexible work arrangements to personalized benefit structures and financial compensation options that give you choice and flexibility. • 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, 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, tuition reimbursement, a coach program, and live classes, workshops, and seminars through BPM University.