Systems Analyst in Washington, DC at ConsultNet

Date Posted: 9/12/2020

Job Snapshot

Job Description

  • Minimum of three (3) years working knowledge of Great Plains
  • Minimum of three (3) years working with SQL Server Data warehouse.
  • Bachelor's degree or equivalent experience in information systems / accounting / Desired nonprofit administration.
  • Provide technical support in ERP, database implementation and project deployments. Create and maintain various SQL Server procedures to validate and backup data, general reports and send/confirm trouble shooting emails.
  • Create, maintain, and distribute reports with Microsoft Great Plains and Solver.
  • Own and update product roadmap of prioritized maintenance and enhancements for ERP.
  • Ability to interact with business stakeholders and gather requirements and provide input for requested changes.
  • Ability to translate business requirements correctly into technical specifications. Should be able to write Exact, Transform, Load "ETL and report requirements.
  • Design, build, and test ETL processes (SSIS packages) to move and transform data based on defined data architectures.
  • Ability to work with developers in explaining requirements and completing testing in test environments prior to production deployments.
  • Monitor compatibility of all data delivery tools and warehouse and ensure effective resolution between the tools and the warehouse.
  • Participate in various project meetings and prepare applications for database.
  • Intermediate knowledge of nonprofit financial accounting.
  • Design and implement various reports and prepare dashboards.
  • Analyze and recommend process improvements.
  • Evaluate all training programs for end users and provide support for same.
  • Ability to learn new technologies quickly and navigate complex business environment.
  • Able to work independently and efficiently to meet deadlines.

Be a part of the ConsultNet difference. As a leading national provider of IT staffing and solutions, ConsultNet delivers exceptional services to startup, midmarket and Fortune 1000 companies across North America. Since 1996, we've partnered with clients to create rewarding opportunities for our consultants, successfully building teams that have surefire results.
In the past two years alone, we have placed more than 1,500 consultants in contract, contract-to-hire, or direct placement opportunities. We understand communication is key to finding the right job that matches your skills and career goals. For us, it's not just the work that we do; it's how we do the work. Our breadth of offerings extends to multiple IT positions in major markets throughout the country, see more at