Business Systems Analyst with Strong SQL

{
  "content_hash": "259128a70f863d49debac8d17940960c2bcc1206029b0bb4106b51480a78fd22",
  "source_hash": "946dcfb7d65dbc840fb5e17f3e8e7bac3cd02380edf0f02e29b8eb4faf5d39bf",
  "last_changed_at": "2026-05-31T17:46:27.880Z",
  "active_status": "active"
}

{
  "language": "en",
  "location": {
    "raw": "Washington, DC, United States",
    "city": "Washington",
    "region": "DC",
    "country": "United States",
    "is_remote": false,
    "confidence": 0.8
  },
  "salary_max": null,
  "salary_min": 45,
  "inferred_at": "2026-06-19T10:48:55.799Z",
  "launch_scope": {
    "reason": "english_us_canada",
    "included": true,
    "language": "en",
    "location": {
      "raw": "Washington, DC, United States",
      "city": "Washington",
      "region": "DC",
      "country": "United States",
      "is_remote": false,
      "confidence": 0.8
    },
    "countries": [
      "United States"
    ]
  },
  "remote_policy": null,
  "salary_period": "hour",
  "workplace_type": null,
  "salary_currency": "USD"
}

{}

{
  "id": "743999658189283",
  "ref": "https://api.smartrecruiters.com/v1/companies/usm2/postings/743999658189283",
  "name": "Business Systems Analyst with Strong SQL",
  "uuid": "87a3ff15-a51a-4437-ab18-51bab83ebb11",
  "detail": {
    "id": "743999658189283",
    "name": "Business Systems Analyst with Strong SQL",
    "uuid": "87a3ff15-a51a-4437-ab18-51bab83ebb11",
    "jobAd": {
      "sections": {
        "jobDescription": {
          "text": "<p><b>Job Title: Business Systems Analyst <span>with Strong SQL</span><span> </span></b></p><p><b>Location: Washington, DC</b></p><p><b>Duration: 6 months +</b></p><p><b><span></span></b></p><p><b><span>Locals to DC/VA/MD only – Face to face must</span><span></span></b></p><p><b><span></span></b></p><p><b><span>Hourly Rate: $<span>45-48</span>/hour MAX</span></b></p><p><b></b></p><p><b><span>Minimum 8+ years profiles.</span></b></p><p><b></b></p><p><b>Must have Top Skills: SQL, Agile, Jira, As-Is and To-Be statements, UML, JAD</b></p><p><strong><span>Overview:</span></strong><span></span></p><p><span>Working in close co-operation with the business customers and IT teams, the senior systems analyst applies advanced analytical and business skills to evaluate existing and identify new or enhanced systems, products and processes which advance business objectives. The senior systems analyst also leads, manages, and executes all phases of quality assurance testing, including analysis of product requirements to produce test requirements, and development and execution of functional/system test plans in a multi-tiered environment.</span></p><p><span> </span></p><p><strong><span>Responsibilities:</span></strong><span></span></p><p><span>The position’s essential duties include the following:</span></p><ul><li>Develops and maintains a thorough knowledge of business processes supported by software systems/products;</li><li>Documents business requirements and business processes; develops training programs, documents, and materials;</li><li>Analyzes and documents “as-is” and “to-be” scenarios (processes, models, use cases, plans and solutions);</li><li>Leads requirements reviews, design reviews, and change control activities;</li><li>Creates test plans, test requirements, test scenarios, and test data for use during all testing phases of the software development lifecycle, for new and existing software systems/products; </li><li>Ensures that test plans and scenarios fully exercise every aspect of the product;</li><li>Produces and presents formal test plans; leads the testing effort for assigned projects;</li><li>Documents and reports issues discovered during testing, and follows up for resolution;</li><li>Defines and implements standards, methods and procedures for requirements and testing activities;</li><li>Works as part of Scrum Development Team and/or as Scrum Master, conducts and effectively participates in sprint planning, task estimates, task sequencing, task assignments, sprint reviews and retrospectives. </li><li>Other duties, as assigned.</li></ul><p><span> </span></p><p><strong><span>TECHNICAL EXPERIENCE:</span></strong><span></span></p><p><b><span>Type of Experience                                                                                                               Years of Experience</span></b></p><p><span><span>·<span>         </span></span></span><span>Demonstrated experience with increasingly complex system analysis projects                   7-10 years</span></p><ul><li><span>Experience developing user stories based on business and system requirements                 2-3 years</span></li><li><span>Experience defining and elaborating user stories with validation and acceptance criteria   2-3 years</span></li><li><span>Experience with various requirements gathering techniques and methodologies                 7-10 years</span></li></ul><p><span>(UML/ Use cases, Activity diagrams, JAD sessions).</span></p><ul><li><span>Hands-on QA testing experience in client server and/or web-based environment                5-7 years</span></li><li><span>Experience developing manual and automated test scripts                                                    5-7 years</span></li><li><span>Experience with 3rd party testing and change management tools                                         5-7 years</span></li><li><span>Experience with Scrum and/or other Agile Development frameworks                                 2-3 years</span></li></ul><p><span> </span></p><p><span>NOTE:  In addition, please list any desired experience.</span></p><ul><li>Experience with automated requirements engineering and testing tools</li><li>RDBMS experience (MS SQL Server and/or Oracle) and ability to write SQL queries.</li><li>Experience with Project Management Software</li><li>Experience with Software Development</li></ul><p><span> </span></p><p><strong><span>SPECIAL SKILLS</span></strong><span>:</span></p><ul><li><span>Analytical and problem solving skills</span></li><li><span>Developing and/or creating new or more effective ideas, approaches, etc.</span></li><li><span>Developing and executing short-range plans/decisions</span></li><li><span>Excellent interpersonal and communication skills</span></li><li><span>Ability to exercise sound judgment across a broad range of circumstances</span></li></ul>",
          "title": "Job Description"
        },
        "qualifications": {
          "text": "",
          "title": "Qualifications"
        },
        "companyDescription": {
          "text": "<p>USM Business Systems Inc. is a quickly developing worldwide System Integrator, Software and Product Development, IT Outsourcing and Technology assistance supplier headquartered in Chantilly, VA with off-shore delivery centers in India. We offer world-class ability in giving most astounding quality and administrations through industry best practices planned to convey remarkable worth to our customers.</p><p>Utilizing our industry knowledge, administration service offering expertise and innovation abilities, we distinguish new business and innovation slants and create answers for help customers around the globe, giving top of the line solid and practical IT benefits which are cost effective services.</p><p>Established in 1999, the organization has corner qualities in building and dealing with a Business Oriented IT environment with rich involvement in technology innovation, ERP and CRM counselling, Product Engineering, Business Intelligence, Data Management, SOA, BPM, Data Warehousing, SharePoint Consulting and IT Infrastructure. Our other offerings include modified solutions and administrations in ERP, CRM, Enterprise architecture, offshore advisory services ,e-commerce, Social , Mobile, Cloud, Analytics (SMAC) and DevOps.</p><p>USM, a US ensured Minority Business Enterprise (MBE) is perceived as one of the fastest developing IT Systems Integrator in the Washington, DC zone. Most as of late, USM was positioned #9 on the rundown of the Top administrations organizations in the DC Metro Area – Washington Business Journal (2011). We are a project-driven firm that reliably meets the IT needs of our State and Government customers through development and business keenness.</p>",
          "title": "Company Description"
        },
        "additionalInformation": {
          "text": "<p>If you are interested in above position, please share your updated resume to<b> gmahesh(at)usmsystems(dot)com</b> or can directly call me on <b>703-880-4184.</b><br /></p>",
          "title": "Additional Information"
        }
      }
    },
    "jobId": "10809559-583c-40bc-99c8-df59dd259262",
    "active": true,
    "company": {
      "name": "USM",
      "identifier": "USM2"
    },
    "creator": {
      "name": "",
      "avatarUrl": ""
    },
    "jobAdId": "7b47b105-d463-4774-b051-571a06714325",
    "applyUrl": "https://jobs.smartrecruiters.com/USM2/743999658189283-business-systems-analyst-with-strong-sql?oga=true",
    "function": {
      "id": "information_technology",
      "label": "Information Technology"
    },
    "industry": {
      "id": "marketing_and_advertising",
      "label": "Marketing And Advertising"
    },
    "language": {
      "code": "en",
      "label": "English",
      "labelNative": "English (US)"
    },
    "location": {
      "city": "Washington",
      "hybrid": false,
      "region": "DC",
      "remote": false,
      "country": "us",
      "latitude": "38.9071923",
      "longitude": "-77.03687070000001",
      "fullLocation": "Washington, DC, United States"
    },
    "refNumber": "REF3430D",
    "postingUrl": "https://jobs.smartrecruiters.com/USM2/743999658189283-business-systems-analyst-with-strong-sql",
    "visibility": "PUBLIC",
    "customField": [
      {
        "fieldId": "58b7e4dae4b0885c92cd9920",
        "valueId": "default",
        "fieldLabel": "Brands",
        "valueLabel": "USM"
      },
      {
        "fieldId": "COUNTRY",
        "valueId": "us",
        "fieldLabel": "Country/Region",
        "valueLabel": "United States"
      }
    ],
    "referralUrl": "https://jobs.smartrecruiters.com/external-referrals/company/USM2/publication/87a3ff15-a51a-4437-ab18-51bab83ebb11?dcr_ci=USM2",
    "defaultJobAd": true,
    "releasedDate": "2017-08-18T21:58:18.000Z",
    "experienceLevel": {
      "id": "mid_senior_level",
      "label": "Mid-Senior Level"
    },
    "typeOfEmployment": {
      "id": "permanent",
      "label": "Full-time"
    }
  },
  "company": {
    "name": "USM",
    "identifier": "USM2"
  },
  "jobAdId": "7b47b105-d463-4774-b051-571a06714325",
  "function": {
    "id": "information_technology",
    "label": "Information Technology"
  },
  "industry": {
    "id": "marketing_and_advertising",
    "label": "Marketing And Advertising"
  },
  "language": {
    "code": "en",
    "label": "English",
    "labelNative": "English (US)"
  },
  "location": {
    "city": "Washington",
    "hybrid": false,
    "region": "DC",
    "remote": false,
    "country": "us",
    "latitude": "38.9071923",
    "longitude": "-77.03687070000001",
    "fullLocation": "Washington, DC, United States"
  },
  "refNumber": "REF3430D",
  "department": {},
  "visibility": "PUBLIC",
  "customField": [
    {
      "fieldId": "58b7e4dae4b0885c92cd9920",
      "valueId": "default",
      "fieldLabel": "Brands",
      "valueLabel": "USM"
    },
    {
      "fieldId": "COUNTRY",
      "valueId": "us",
      "fieldLabel": "Country/Region",
      "valueLabel": "United States"
    }
  ],
  "defaultJobAd": true,
  "releasedDate": "2017-08-18T21:58:18.000Z",
  "detail_errors": [],
  "experienceLevel": {
    "id": "mid_senior_level",
    "label": "Mid-Senior Level"
  },
  "typeOfEmployment": {
    "id": "permanent",
    "label": "Full-time"
  }
}