--- title: 'NetSuite Consultant- NSAW at BPM LLP' canonical: 'https://feeny.ai/job/netsuite-consultant-nsaw-bpm-llp-united-states-zem7wak3z7mc' type: 'job' last_seen: '2026-09-14' --- # NetSuite Consultant- NSAW at BPM LLP - **Company:** BPM LLP - **Location:** United States - **Compensation:** $150k–$200k - **Employment:** full-time - **Work type:** remote - **Posted:** 2026-01-22 - **Last confirmed live:** 2026-09-14 - **Apply:** https://jobs.lever.co/bpmcpa/3b4c09bf-258e-4da5-a7b6-ee7421e1e70f ## Job description 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 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 ## About BPM LLP ## Company Overview - **One-liner**: BPM LLP is a top-40 public accounting and advisory firm that delivers tax, audit, and consulting services with a people-first approach. - **Entity Type**: Private (LLP) - **Headquarters**: San Francisco, California, United States - **Founded**: 1986 - **Founders**: Not publicly available ## Core Business - **Primary industry/industries**: Public Accounting, Tax, Audit, Advisory, Business Consulting - **Target customers**: B2B — mid-market to large enterprises, high-net-worth individuals, and private equity firms across a wide range of industries (technology, life sciences, financial services, real estate, non-profit, etc.) - **Mission or purpose statement**: “To help people be successful in work and life by fostering an inclusive and empowering environment — one where diverse perspectives, expansive expertise and progressive solutions come together to create exceptional experiences for our clients.” [bpm.com](https://www.bpm.com/who-we-are/) ## Products & Services - **Tax Services**: Compliance, planning, international tax, state and local tax, and private client services for individuals and businesses. - **Assurance Services**: Financial statement audits, reviews, compilations, and SOC reporting. - **Advisory Services**: Accounting advisory (CAAS), IT risk advisory, forensic and restructuring, business valuation, and transaction advisory. - **BPM1™ Service Model**: A proprietary model that provides clients with direct access to the firm’s brightest minds and world-class solutions, emphasizing a people-first approach. [bpm.com](https://www.bpm.com/who-we-are/) ## Market Standing - **Valuation/Market Cap**: Not disclosed (Private firm) - **Key Metric**: Annual Revenue of **$170M** [linkedin.com](https://linkedin.com/company/bpmllp) - **Notable Investors/Partners**: Not applicable (private, partner-owned firm). Parent company is Elliott CPA Group Inc. [linkedin.com](https://linkedin.com/company/bpmllp) - **Growth Signals**: - Headcount of ~928 employees (+6.1% YoY, +107 people) [linkedin.com](https://linkedin.com/company/bpmllp) - Recognized as one of IPA’s 100 Fastest-Growing Firms [linkedin.com](https://linkedin.com/company/bpmllp) - Acquired Elliott CPA Group (2022), Gumbiner Savett (2021), and Infinitech (2019) [linkedin.com](https://linkedin.com/company/bpmllp) - Active job postings up +61.8% year-over-year [linkedin.com](https://linkedin.com/company/bpmllp) - Certified B Corporation, reflecting a commitment to social and environmental performance [bpm.com](https://www.bpm.com/who-we-are/) ## Competitive Advantages - **Certified B Corporation**: Differentiates them as a purpose-driven firm using business as a force for good, appealing to values-driven talent and clients. [bpm.com](https://www.bpm.com/who-we-are/) - **BPM1™ Service Model**: A unique, client-centric model that prioritizes direct access to senior talent, setting them apart from larger, more bureaucratic firms. [bpm.com](https://www.bpm.com/who-we-are/) - **Strong Culture & People Focus**: Consistently recognized as a top firm for supporting women professionals and for its inclusive, empowering environment. [linkedin.com](https://linkedin.com/company/bpmllp) - **Global Reach with Local Touch**: Offices across the U.S. and internationally, plus a Virtual Region, providing flexibility and local support. [bpm.com](https://www.bpm.com/who-we-are/) ## Strategic Focus - **Current priorities and direction for growth**: Continued organic and acquisition-based growth (as seen with recent acquisitions), expanding advisory services, and deepening its commitment to being a Certified B Corporation. The firm is investing in technology and talent to support its BPM1 service model and enhance client experiences. ## Why Work Here - **Culture highlights**: “Because People Matter” is a core motto. The firm emphasizes an inclusive, empowering environment where diverse perspectives are valued. Employees are described as hockey-playing accountants, avid gardeners, and global explorers who bring their authentic selves to work. [bpm.com](https://www.bpm.com/careers/) - **Remote/hybrid/office policy**: **Hybrid and remote options available.** The firm offers flexible work arrangements (“Work Your Way”) and has a Virtual Region for fully remote roles. Many roles are hybrid, with offices in San Francisco, Long Beach, San Jose, Santa Rosa, Irvine, Sacramento (CA), Las Vegas (NV), and Sioux Falls (SD). [bpm.com](https://www.bpm.com/careers/benefits/) [jobs.lever.co](https://jobs.lever.co/bpmcpa/) - **Notable perks**: - **Compensation**: Competitive base salary, 401K employer match, employee/client referral bonuses. - **Health**: Up to 90% employer-paid premiums for medical, dental, and vision; HSA contributions; FSA options. - **Time Off**: 14 firm holidays (including 2 floating days), generous PTO (unlimited for eligible colleagues), paid family leave, winter break, summer hours. - **Development**: Coaching program, BPM University, defined career paths, CPA exam resources, tuition reimbursement. - **Wellness**: Interactive wellness platform, Employee Assistance Program (EAP), mental health resources. - **Extra**: Pet insurance, student loan consolidation, travel assistance, colleague discount program, and a travel platform with company contributions. [bpm.com](https://www.bpm.com/careers/benefits/) - **Engineering/technical culture**: The firm has a dedicated IT, Security, and Administrative team. They are hiring for roles like Senior Information Security Administrator, indicating a growing investment in technology and security infrastructure. [linkedin.com](https://linkedin.com/company/bpmllp) ## Sources 1. [bpm.com - About BPM](https://www.bpm.com/who-we-are/) 2. [bpm.com - Careers](https://www.bpm.com/careers/) 3. [bpm.com - Benefits](https://www.bpm.com/careers/benefits/) 4. [linkedin.com - BPM LLP Company Page](https://linkedin.com/company/bpmllp) 5. [jobs.lever.co - BPM Careers](https://jobs.lever.co/bpmcpa/) ## Other roles at BPM LLP - [Fiduciary Accounting Manager](https://feeny.ai/job/fiduciary-accounting-manager-bpm-llp-california-mzv7r7pb9d0a) — California - [Accounting Advisory Associate II](https://feeny.ai/job/accounting-advisory-associate-ii-bpm-llp-sioux-falls-3rssfn7t4xxj) — Sioux Falls, SD - [Tax Manager - U.S. International Tax](https://feeny.ai/job/tax-manager-u-s-international-tax-bpm-llp-united-states-yf1y7pq4dzb7) — United States - [Fiduciary Accounting Supervisor](https://feeny.ai/job/fiduciary-accounting-supervisor-bpm-llp-california-xyrbhby675vr) — California - [Advisory Manager - Forensic & Restructuring](https://feeny.ai/job/advisory-manager-forensic-restructuring-bpm-llp-san-francisco-9vskdf7p45gp) — San Francisco, CA - [Tax Director - Private Client Service (PCS) HNW](https://feeny.ai/job/tax-director-private-client-service-pcs-hnw-bpm-llp-santa-rosa-drm14fbs2fjp) — Santa Rosa, CA - [Assurance Intern (Summer 2027)](https://feeny.ai/job/assurance-intern-summer-2027-bpm-llp-california-2xwk0vzx6q1b) — California - [Tax Manager - Private Client Services (PCS- HNW) Relocation Assistance Available](https://feeny.ai/job/tax-manager-private-client-services-pcs-hnw-relocation-assistance-available-bpm-yxy5mcf0gwpy) — Santa Rosa, CA - [Tax Supervisor - Flowthrough](https://feeny.ai/job/tax-supervisor-flowthrough-bpm-llp-san-francisco-wemy3h4mp9z7) — San Francisco, CA - [Tax Director - Cryptocurrency & Digital Assets Experience Required](https://feeny.ai/job/tax-director-cryptocurrency-digital-assets-experience-required-bpm-llp-united-x3pgpjjff1a3) — United States