SystemsAccountants

Data and Analytics Consultant (NSAW Track)

⭐ - Featured Role | Apply direct with Data Freelance Hub
This role is a contract Data and Analytics Consultant (NSAW Track) paying up to $70/hour, remote in the U.S. Requires strong SQL skills, experience in data migrations, and familiarity with NetSuite. Training in NSAW provided.
🌎 - Country
United States
πŸ’± - Currency
$ USD
-
πŸ’° - Day rate
560
-
πŸ—“οΈ - Date
October 16, 2025
πŸ•’ - Duration
Unknown
-
🏝️ - Location
Remote
-
πŸ“„ - Contract
Unknown
-
πŸ”’ - Security
Unknown
-
πŸ“ - Location detailed
United States
-
🧠 - Skills detailed
#Complex Queries #Fivetran #Migration #Data Warehouse #Data Migration #Data Modeling #Datasets #Cloud #Data Pipeline #Snowflake #BI (Business Intelligence) #CRM (Customer Relationship Management) #Boomi #Slowly Changing Dimensions #Data Extraction #"ETL (Extract #Transform #Load)" #SQL (Structured Query Language) #Documentation #Consulting #dbt (data build tool)
Role description
Contract Data and Analytics Consultant (NSAW Track) Overview A boutique NetSuite Analytics Warehouse consulting client is seeking a Data and Analytics expert with deep SQL experience. You will own data extraction, transformation, loading, and reconciliation across multiple sources. Prior NetSuite exposure is preferred. You will also receive on the job training in NetSuite Analytics Warehouse (NSAW) , which is a strong career accelerator. Type: Contract Rate: Up to $70 per hour Location: Remote in the U.S. Start: ASAP What You Will Do Design and execute end to end data migrations, including profiling, mapping, transformation, load, and reconciliation Write advanced SQL to assemble and validate data models, join complex datasets, and produce audit ready results Build repeatable staging and transformation layers to support analytics and reporting use cases Create reconciliation scripts and checks to tie subledgers and operational data back to the general ledger and source systems Partner with consultants and client stakeholders to define data requirements and success criteria Document data dictionaries, lineage, and job runbooks so solutions are maintainable Learn and apply NSAW capabilities with mentorship from senior consultants What You Bring Strong SQL expertise with a track record building complex queries, views, and stored procedures Experience delivering data migrations or integrations across ERP, CRM, billing, or operational systems Solid understanding of data modeling concepts such as star and snowflake schemas, slowly changing dimensions, and surrogate keys Fluency in Excel or Google Sheets for profiling and quick checks Clear communication, structured documentation, and a bias for accuracy and repeatability Nice To Have Experience with NetSuite data structures or prior work alongside NetSuite teams Familiarity with ETL or ELT tools such as Celigo, Boomi, Fivetran, Stitch, dbt, or similar Exposure to cloud data warehouses or BI stacks What You Will Learn Formal training and guided project work in NetSuite Analytics Warehouse (NSAW) Best practices for NSAW data pipelines, semantic modeling, and performance tuning Patterns for reconciling NSAW outputs back to source systems How To Apply Email your resume and a brief note on recent SQL projects and data migrations to Kyle@systemsaccountants.com . Please include your availability and confirm your comfort level with the $70 per hour rate ceiling.