Data Consultant

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 SalesforceNetSuite 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 field
• 4+ 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 processes
• Proficient in SQL for data profiling and transformation
• Hands on experience with at least one of the BI applications, Tableau, PowerBI and Cognos
• Experience with Datawarehouse tool like Snowflake, Amazon Redshift etc is a plus
• Exposure in data extraction, transformation, and data loading techniques
• Experience creating and using Entity Relationship and Data Flow diagrams to communicate complex migration and transformations to clients
• Must have experience working in projects with Agile Management process
• Experience working with Salesforce CRM and Netsuite ERP system data loads is highly desirable
• Passion for data accuracy and completeness
• Excellent communication and interpersonal skills
• Can work in a fast-paced, fast-growth environment and manage priorities across multiple concurrent activities