Linked In

  • Opportunity

    our quality team can
    enhance your career

  • 1


Excel/VBA Specialist Part Time

Location: Roselle Park, NJ
Our direct client is currently transitioning from multiple CRM systems to an enterprise wide CRM system and is looking for a contract Data Validation Specialist/Analyst to review data from each point to verify accuracy, consistency and completion.  In this role you will be reviewing and modifying underlying rows of linked data (meta-data), which are contributing details of a prescriber record, in order to resolve incorrectly linked source information.  You must have excellent excel skills including v-lookups, h-lookups, write complex macro's, create pivot tables and analyze the data for accuracy or anomalies  Working with the senior Data Anlyst, you may also be asked to execute SQL scripts, looking for errors.  You should have basic SQL (read SQL). This is a part time role - 20 hours a week or so, client prefers someone who can come on site but may be flexible for a the right remote candidate.

  • Excellent knowledge of MS excel and Macros 
  • Knowledge of file control version (be able to track and record file versions)
  • Web-based look-ups – utilizing various search engines and professional Web sites
  • Visual data inspection – keen attention to detail
  • Research and troubleshoot issues and questions related to deployed data
  • Basic understanding of SQL as candidate might be required to work on pre-written scripts for testing
  • Ability to deliver key findings to members of the business though presentations and/or direct engagement that result in action and improved decision making
  • Strong organizational skills
  • Resourceful and not afraid to ask questions
  • Qualitative skills
  • Ability to switch from task to task
  • Ability to work independently and as part of a dynamic team
  • Flexibility to work under tight deadlines
  • Excellent verbal/written communication and time management skills
  • Familiarity with commercial ERP systems.
  • Prior knowledge of vendor and customer data a huge plus
  • Familiarity with MAS 500, Dynamics GP and or SL, or Dynamics AX is a huge plus.
Keywords:- Excel; Macros data Validation; CRM; version control; Sql;   

For immediate consideration please submit your resume in Word format, along with daytime contact information.  LOCAL CANDIDATES ONLY PLEASE unless you are willing to relocate yourself at your own expense.  Client is unable to provide H-1B Visa sponsorship at this time. All submittals will be treated confidentially.  Selected candidate may be asked to pass a comprehensive background, credit and/or drug screening.  Principals only, no third parties please.

Established in 2000, Atrilogy Solutions Group, Inc. provides organizations of all sizes with high-quality, cost effective information technology (IT) and business process consulting & staffing services.  Our industry-leading service model combines experienced project managers with seasoned technical and functional consultants to eliminate client uncertainty and deliver superior value and results.
Clients turn to Atrilogy for expertise in:
  • IT staffing and placement (Project Managers, Agile/Scrum Masters, Business Analysts, DBA’s, Software Engineers, Mobile Developers (iOS, Android), DevOps, Automation, QA, Systems & Network Engineers, Cyber Security / Information Security Specialists)
  • All major ERP & CRM packages (including Oracle, Workday, PeopleSoft, JD Edwards, Lawson, SAP, Dynamics AX, Salesforce, Microsoft CRM, NetSuite)
  • Business Intelligence, Data Warehousing, and Big Data Integration
  • Creative (Interactive Project Manager/Art Director, Information Architect, UI/UX Designer, Web/Graphic Design)
Atrilogy has been recognized by Inc. magazine as one of the nation’s fastest-growing, privately-held companies. Headquartered in Irvine, California, Atrilogy also has offices in Denver, Phoenix, Atlanta, and Dallas with satellite offices in Boston, Jersey City, Las Vegas, Seattle, and Delhi, India.
Atrilogy Solutions Group is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, gender expression, national origin, protected veteran status, or any other basis protected by applicable law, and will not be discriminated against on the basis of disability.

this job portal is powered by CATS