The role involves leading the architecture and solution ownership for NSAW implementations, data engineering, SQL transformations, and analytics delivery, ensuring data integrity and executive-level reporting.
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.
What you get:
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.
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
BPM LLP Bellevue, Washington, USA Office
12600 SE 38th Street Suite 245, Bellevue, United States, 98015
Similar Jobs
Fintech • Financial Services
Lead and grow a team of analytics engineers to build an AI-ready, centralized data foundation. Hands-on duties include writing/reviewing SQL and dbt, designing semantic and dimensional data models, driving data quality, observability, testing, and CI/CD, partnering cross-functionally to deliver scalable data products, and recruiting and developing engineering talent.
Top Skills:
CdcCi/CdDbtFivetranLlmLookerPythonSnowflakeSnowflake IntelligenceSQLStreamkapTableau
2 Hours Ago
Big Data • Food • Hardware • Machine Learning • Retail • Automation • Manufacturing
Perform monthly commodity analyses for grains and vegetable oils using supply/demand data and market forecasts; build and manage market intelligence databases; develop and improve constraint-optimization price models and long-range forecasts; support CPRM hedging and coverage strategy decisions; track team KPIs and deliver insights to inform pricing and risk management.
Top Skills:
Artificial IntelligenceExcelPythonR
Cloud • Security • Software • Cybersecurity • Automation
Build, ship, and maintain backend features enabling AI agents to interact with GitLab. Design GraphQL/REST APIs, extend tests (RSpec), work with PostgreSQL, troubleshoot production issues, and collaborate cross-functionally to integrate AI tooling responsibly.
Top Skills:
Background JobsGitlabGraphQLPostgresRest ApisRspecRubyRuby On RailsSQL
What you need to know about the Seattle Tech Scene
Home to tech titans like Microsoft and Amazon, Seattle punches far above its weight in innovation. But its surrounding mountains, sprinkled with world-famous hiking trails and climbing routes, make the city a destination for outdoorsy types as well. Established as a logging town before shifting to shipbuilding and logistics, the Emerald City is now known for its contributions to aerospace, software, biotech and cloud computing. And its status as a thriving tech ecosystem is attracting out-of-town companies looking to establish new tech and engineering hubs.
Key Facts About Seattle Tech
- Number of Tech Workers: 287,000; 13% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Amazon, Microsoft, Meta, Google
- Key Industries: Artificial intelligence, cloud computing, software, biotechnology, game development
- Funding Landscape: $3.1 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Madrona, Fuse, Tola, Maveron
- Research Centers and Universities: University of Washington, Seattle University, Seattle Pacific University, Allen Institute for Brain Science, Bill & Melinda Gates Foundation, Seattle Children’s Research Institute
