Back to jobs
New

AMS Application and SQL Analyst

Washington, DC

The AMS Application and SQL Analyst supports the daily operation of ACOG’s Association Management System (AMS) by executing workflows, maintaining routine processes, resolving system issues and implementing solutions. This role partners with stakeholders to clarify requirements and define problems as they relate to AMS updates, processes, and issues, ensuring requests are documented and tracked through completion. The analyst performs AMS updates, imports, and SQL-driven tasks; coordinates vendor escalations; and conducts testing activities, including identifying test data, executing test cases, and validating fixes. This position supports reliable AMS performance and consistent support for membership and program operations across the organization and collaborates with technical teams to support data integration, reporting, and analytics initiatives involving AMS data.

Note: This position is considered Hybrid and will need to commute to ACOG's office located in Washington, D.C.

Duties/Responsibilities:

  • Support day-to-day AMS operations, including executing workflows, processing updates, database updates, running scripts, and maintaining AMS-driven tasks.
  • Partner with stakeholders to understand issues, define problems, clarify requirements, and ensure needs are accurately documented and resolved.
  • Troubleshoot AMS related issues; modify CMS pages, update queries, views, and stored procedures; design and develop custom AMS pages and components and manage SQL Agent jobs that support operational workflows.
  • Maintain and update AMS reports, mailing lists, and operational outputs required by internal teams.
  • Design and update AMS data structures, including creating new database tables and modifying existing schema components to support new features and business processes.
  • Perform AMS data imports; match and clean incoming information as needed.
  • Coordinate with AMS vendors when escalation is required, preparing clear problem statements and tracking resolution through completion.
  • Conduct testing activities for AMS updates, configuration changes, and new workflows, including identifying and preparing appropriate test data, executing test cases, documenting results, and validating fixes before deployment.
  • Collaborate with technical teams to support data integration, reporting, and analytics initiatives involving AMS data.
  • Document AMS data structures, business rules, and operational workflows to support enterprise data initiatives and reporting.
  • Provide subject matter expertise on AMS data structures and operational workflows to support data engineering, reporting, and analytics initiatives.
  • Assist with data validation, reconciliation, and testing activities related to new data pipelines, integrations, or reporting solutions.
  • Partner with stakeholders and technical teams to ensure AMS data is accurately represented in downstream systems, reports, and analytics environments.
  • Perform routine system maintenance tasks, including database backups and updates to test and development environments.
  • Provide second-tier AMS support and collaborate across teams to ensure reliable AMS performance and workflow continuity.
  • Partner with and receive mentorship from the Data Engineer to develop skills in data integration, pipeline processes, and advanced data management practices. 
  • Perform other duties as assigned to support the IT Solutions software development process.

Required Skills/Abilities:

  • Ability to write, troubleshoot, and update SQL queries, stored procedures, and operational scripts used in AMS workflows.
  • Ability to identify and prepare relevant test data and support thorough testing of AMS changes, system upgrades, and new processes.
  • Strong knowledge of AMS workflows, membership processes, and configurations to support troubleshooting and evaluate proposed changes.
  • Ability to interpret operational data structures and business processes and communicate them effectively to technical teams such as data engineers and analytics staff.
  • Strong analytical and problem-definition skills with the ability to gather requirements, clarify needs, and translate stakeholder issues into actionable steps.
  • Effective communication and interpersonal skills, especially when partnering with Membership and other non-technical teams.
  • Ability to coordinate vendor escalations, document issues clearly, and follow through until resolution.
  • Skill in testing system changes, validating outcomes, and ensuring operational readiness before deployment.
  • Ability to manage multiple priorities, maintain attention to detail, and work independently in a fast-paced environment.

Education and Experience:

  • Bachelor’s degree in related field required.
  • Minimum of 3 years of related experience, including experience with Association Management Systems (preferably NetForum), MS SQL, HTML, and JavaScript.
  • Experience supporting data reporting, analytics, or data integration initiatives preferred.

Salary Range

$80,000 - $85,000 USD

Our Perks

Paid Parental Leave – Breastfeeding Friendly Workplace –  Flexible work schedule –  Commuting Allowance – Generous Paid Time Off – Holiday Pay – Life Insurance – Community Volunteering Opportunities – Generous 401(k) Company Contributions – Medical, Dental, and Vision Insurance – Learning Opportunities and Tuition Reimbursement – Company-Sponsored Team Outings – and more!

ACOG is an EEO employer committed to providing equal employment opportunities to all applicants and employees. As a federal government contractor and in accordance with applicable laws, regulations, and Executive Orders, the College takes affirmative action to ensure that applicants and employees covered are not discriminated against because of their race, color, religion, national origin, sex (gender), age, disability, pregnancy, marital status, sexual orientation, personal appearance, gender identity or expression, family responsibilities, political affiliation, veteran status, genetic information, or any other characteristic that is protected by applicable law. For more information about your equal employment opportunity rights, please view this poster: EEO is the Law. The College also participates in E-Verify.

Apply for this job

*

indicates a required field

Resume/CV*

Accepted file types: pdf, doc, docx, txt, rtf

Cover Letter

Accepted file types: pdf, doc, docx, txt, rtf

Select...

 

 

Select...
Select...
Select...
Select...
Select...

Voluntary Self-Identification

For government reporting purposes, we ask candidates to respond to the below self-identification survey. Completion of the form is entirely voluntary. Whatever your decision, it will not be considered in the hiring process or thereafter. Any information that you do provide will be recorded and maintained in a confidential file.

As set forth in American College of Obstetricians and Gynecologists’s Equal Employment Opportunity policy, we do not discriminate on the basis of any protected group status under any applicable law.

Select...
Select...
Race & Ethnicity Definitions

If you believe you belong to any of the categories of protected veterans listed below, please indicate by making the appropriate selection. As a government contractor subject to the Vietnam Era Veterans Readjustment Assistance Act (VEVRAA), we request this information in order to measure the effectiveness of the outreach and positive recruitment efforts we undertake pursuant to VEVRAA. Classification of protected categories is as follows:

A "disabled veteran" is one of the following: a veteran of the U.S. military, ground, naval or air service who is entitled to compensation (or who but for the receipt of military retired pay would be entitled to compensation) under laws administered by the Secretary of Veterans Affairs; or a person who was discharged or released from active duty because of a service-connected disability.

A "recently separated veteran" means any veteran during the three-year period beginning on the date of such veteran's discharge or release from active duty in the U.S. military, ground, naval, or air service.

An "active duty wartime or campaign badge veteran" means a veteran who served on active duty in the U.S. military, ground, naval or air service during a war, or in a campaign or expedition for which a campaign badge has been authorized under the laws administered by the Department of Defense.

An "Armed forces service medal veteran" means a veteran who, while serving on active duty in the U.S. military, ground, naval or air service, participated in a United States military operation for which an Armed Forces service medal was awarded pursuant to Executive Order 12985.

Select...

Voluntary Self-Identification of Disability

Form CC-305
Page 1 of 1
OMB Control Number 1250-0005
Expires 04/30/2026

Why are you being asked to complete this form?

We are a federal contractor or subcontractor. The law requires us to provide equal employment opportunity to qualified people with disabilities. We have a goal of having at least 7% of our workers as people with disabilities. The law says we must measure our progress towards this goal. To do this, we must ask applicants and employees if they have a disability or have ever had one. People can become disabled, so we need to ask this question at least every five years.

Completing this form is voluntary, and we hope that you will choose to do so. Your answer is confidential. No one who makes hiring decisions will see it. Your decision to complete the form and your answer will not harm you in any way. If you want to learn more about the law or this form, visit the U.S. Department of Labor’s Office of Federal Contract Compliance Programs (OFCCP) website at www.dol.gov/ofccp.

How do you know if you have a disability?

A disability is a condition that substantially limits one or more of your “major life activities.” If you have or have ever had such a condition, you are a person with a disability. Disabilities include, but are not limited to:

  • Alcohol or other substance use disorder (not currently using drugs illegally)
  • Autoimmune disorder, for example, lupus, fibromyalgia, rheumatoid arthritis, HIV/AIDS
  • Blind or low vision
  • Cancer (past or present)
  • Cardiovascular or heart disease
  • Celiac disease
  • Cerebral palsy
  • Deaf or serious difficulty hearing
  • Diabetes
  • Disfigurement, for example, disfigurement caused by burns, wounds, accidents, or congenital disorders
  • Epilepsy or other seizure disorder
  • Gastrointestinal disorders, for example, Crohn's Disease, irritable bowel syndrome
  • Intellectual or developmental disability
  • Mental health conditions, for example, depression, bipolar disorder, anxiety disorder, schizophrenia, PTSD
  • Missing limbs or partially missing limbs
  • Mobility impairment, benefiting from the use of a wheelchair, scooter, walker, leg brace(s) and/or other supports
  • Nervous system condition, for example, migraine headaches, Parkinson’s disease, multiple sclerosis (MS)
  • Neurodivergence, for example, attention-deficit/hyperactivity disorder (ADHD), autism spectrum disorder, dyslexia, dyspraxia, other learning disabilities
  • Partial or complete paralysis (any cause)
  • Pulmonary or respiratory conditions, for example, tuberculosis, asthma, emphysema
  • Short stature (dwarfism)
  • Traumatic brain injury
Select...

PUBLIC BURDEN STATEMENT: According to the Paperwork Reduction Act of 1995 no persons are required to respond to a collection of information unless such collection displays a valid OMB control number. This survey should take about 5 minutes to complete.