We are a fast-paced, growing organization currently relying heavily on spreadsheets due to limitations in our NetSuite setup. Our goal is to build scalable reporting and automation within NetSuite, aligning Sales, Finance, and Operations through standardized, system-native processes.
We're seeking a NetSuite Developer with strong experience in SuiteAnalytics and SuiteScript, who can help us establish a clean, reportable data layer and improve data accuracy across key objects like Opportunities, Projects, and Sales Orders. Note: We are using the standard Projects functionality available in core NetSuite (not the Advanced Projects module or SuiteProjects).
Scope of Work
1. 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.
2. 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.
3. 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)
4. User Workflow Optimization
- Improve experience for PMs and Reps entering forecast or placeholder items. - Ensure field visibility and role access is clean and intuitive.
- 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.
All your information will be kept confidential according to EEO guidelines.
...Job Description VP of Marketing Overview Spherix is seeking a VP of Marketing to... ...strategic planning, brand positioning, digital and traditional marketing execution, conference... ...in Exton, PA, with consideration for a remote arrangement. Key Responsibilities...
...Full Time, Swing) What Youll Make $20.60 - $21.86 per hour DOE/Credentials. An additional $3.00 per hour night shift differential will apply during... .... Per OAR 309-035-0135, Direct Care staff must be 18 or older at the time of hire. About Us ColumbiaCare...
...clinched a spot in the 2023 MLS Playoffs for the second straight year. With a diverse ownership group with strong ties to Cincinnati, the club strives to unite the community both on and off the pitch through FCC Foundation, and its dedication to improving the lives of...
...POSITION POSTING: Deputy -- Road Patrol The Ottawa County Sheriff's Office has openings for a full time Deputy -- Road Patrol. This... ...the County for observation and maintenance of the safety and security of persons and property; Maintains and cares for Sheriff's cruiser...