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. As a NSAW Consultant, you will be responsible for understanding NSAW's End to End source data, integration pipelines, ADW Semantic modeling, & OAC delivery. Your role will be more than building dashboards, you'll operate in a full-stack analytics architect function turning raw ERP & third-party data into high performing analytics platforms by owning the NSAW solution lifecycle. 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: F rom flexible work arrangements to personalized benefit structures and financial compensation options that give you choice and flexibility   Well-being resources: I nteractive wellness platform and incentives, an employee assistance program and mental health resources, and Colleague Resource Groups (CRGs) 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, a coach program, and live classes, workshops, and seminars through BPM University   Be part of a purpose-driven organization : V alues people, community, and sustainability, where BPM's B Corp commitment is reflected in the way we work and support one another.   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 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. Recruitment Fraud Warning: BPM LLP will never ask candidates to pay money, purchase equipment or gift cards, or provide financial information as part of the hiring process. All official communications regarding interviews and job offers will come exclusively from an email address ending in @bpmcpa.com or @bpm.com. If you receive a suspicious communication, please verify it through BPM’s official recruiting channels. 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

Requirements

Must-haves

Total rewards package: F rom flexible work arrangements to personalized benefit structures and financial compensation options that give you choice and flexibility
Professional development opportunities: A learning culture with CPA exam resources and bonuses, a coach program, and live classes, workshops, and seminars through BPM University
Be part of a purpose-driven organization : V alues people, community, and sustainability, where BPM's B Corp commitment is reflected in the way we work and support one another.
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
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?
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.

Nice-to-haves

None flagged.

Application prep

Use the role’s language and application details while tailoring your materials.

Keywords to mirror

sqlrest

Platform: lever
Effort: quick

Benefits

Benefits detected in the listing.

Pto

Wellness

Professional Development