A project-based contracting company is seeking a contractor with expertise in NetSuite SuiteAnalytics and SuiteScript development. The role focuses on building datasets for forecasting and performance tracking, with responsibilities that include adding custom fields, automating scripts, and optimizing user workflows. Strong experience with analytical tools is desired. This position offers a pay rate of $90-$125 per hour, based in Santa Monica, California.
Qualifications
Strong experience with NetSuite SuiteAnalytics Workbooks and Datasets.
Proven background in SuiteScript (1.0 or 2.x) development.
Solid understanding of Opportunity, Project (Core), Item, and Sales Order flows.
Experience designing custom fields, validation scripts, and user workflows.
Ability to translate business requirements into technical implementation.
Responsibilities
Build SuiteAnalytics datasets for forecasting revenue and performance.
Add custom fields and configure field-level rules.
Develop SuiteScripts for automated data exports and validations.
Optimize user workflows for PMs and Reps.
Skills
NetSuite SuiteAnalytics Workbooks
SuiteScript (1.0 or 2.x)
Business Requirement Translation
Data Validation
Tools
Power BI
Tableau
Looker Studio
Monday.com
Job description
Job Description
Scope of Work
Data Model & Analytics
Build SuiteAnalytics datasets and workbooks to support:
Forecast vs. Actual revenue and margin tracking
Weekly Rep-level performance dashboards
Opportunity → Project → Sales Order → Invoice data flow visibility
Design reusable data structures for analytics — enabling easy pivoting and trend comparisons.
Work with stakeholders to define key metrics and layout for standardized reports.
Custom Fields & Configuration
Add custom fields (e.g., Forecast) at Project and Opportunity level.
Configure field-level rules and validations to enforce consistency (e.g., placeholder FG logic).
Establish clean item subtype usage across opportunities, sales orders, and projects.
Automation & Scripting
Develop SuiteScripts (1.0/2.x) for:
Scheduled exports of analytical datasets (CSV/XLS/API)
Automated flagging of duplicates, missing FG placeholders, or invalid entries
Data validation (e.g., checking that every open opportunity has forecast and FG item)
User Workflow Optimization
Improve experience for PMs and Reps entering forecast or placeholder items.
Ensure field visibility and role access is clean and intuitive.
Qualifications
Strong experience with NetSuite SuiteAnalytics Workbooks and Datasets
Proven background in SuiteScript (1.0 or 2.x) development
Solid understanding of Opportunity, Project (Core), Item, and Sales Order flows
Experience designing custom fields, validation scripts, and user workflows
Ability to translate business requirements into technical implementation
Nice to Have (for future projects):
Experience with BI tools (e.g., Power BI, Looker Studio, Tableau)
Experience integrating NetSuite with Monday.com
Deliverables
SuiteAnalytics datasets/workbooks for project and rep-level reporting
Custom Forecast field + validation logic
Scripts for data cleanup or scheduled exports
Streamlined user workflows with minimal friction for PMs and Reps
Light documentation or handoff notes
Rate: $90-$125 per hour. This is a project based contractor role.