The Data Consultant plays a key role in designing, implementing, and supporting data integration and analytics solutions across Salesforce, NetSuite, and other enterprise systems. This position focuses primarily (~80%) on Salesforce–NetSuite integration and data migration projects, ensuring seamless data flow across front-office and back-office platforms. The remaining (~20%) effort is dedicated to BI and reporting implementations, enabling clients to gain actionable insights from their integrated data landscape.
Responsibilities Include :
- Analyze, cleanse, and validate data from legacy systems before migration to Salesforce / Netsuite
- Partner with the client for data extraction and cleansing
- Design and build ETL workflows using tools like SSIS and / or Informatica using CDATA / Kingswaysoft utilities to assist with data migration
- Conduct data mapping exercises, data migration plans on client projects
- Collaborate with Salesforce / Netsuite admins, and business analysts to ensure alignment on data requirements and field mappings
- Develop complex queries, stored procedures, functions, triggers, views required for data migration in SQL
- Support post-migration audits and ensure data integrity within Salesforce / Netsuite
- Design and build dashboards and reports using tools like Tableau, Power BI or NetSuite Analytics Warehouse
- Demonstrate ability to learn and research advanced data technologies and concepts, learning new skills and software as necessary
- This position requires no travel
Basic Qualifications :
Requires Bachelor's degree in Computer Science, Software Engineering, Management Information Systems, or a related field4+ years’ experience in data migration space, working on ETL tools like SSIS, Informatica, Talend, Azure Data Factory etc.Strong experience with data cleansing, deduplication, and validation processesProficient in SQL for data profiling and transformationHands on experience with at least one of the BI applications, Tableau, PowerBI and CognosExperience with Datawarehouse tool like Snowflake, Amazon Redshift etc is a plusExposure in data extraction, transformation, and data loading techniquesExperience creating and using Entity Relationship and Data Flow diagrams to communicate complex migration and transformations to clientsMust have experience working in projects with Agile Management processExperience working with Salesforce CRM and Netsuite ERP system data loads is highly desirablePassion for data accuracy and completenessExcellent communication and interpersonal skillsCan work in a fast-paced, fast-growth environment and manage priorities across multiple concurrent activities