Share Email Opening Title File Processing Coordinator  Hiring Manager(s) PATRICIA COOK   Category Administrative Assistant   Description Job Title:                        File Processing Coordinator, Grade 7                         Job Number:                 OPU-64-03-0324-V                                                           Annual Salary:              $62,770.25                                                                                                                                                                          The AFT is a union of professionals that champions fairness; democracy; economic opportunity; and high-quality public education, healthcare and public services for our students, their families and our communities. We are committed to advancing these principles through community engagement, organizing, collective bargaining and political activism, and especially through the work our members do.  The AFT believes that a culturally diverse workforce advances our mission and we strongly encourage applications from under-represented communities of workers. Position Summary:     This role will serve as the support person for the field and data processing teams of MD&A.  Their primary role will be to independently monitor all incoming affiliate files and interpret the complex data sets, manipulate the files in preparation for loading into the membership database, coordinate with local leaders and staff, and provide administrative support to the field team.                                             Position Responsibilities:             Standardize and format affiliate files into AFT database format. Work with affiliate staff and leaders on file questions and assist to improve data submissions. Analyze and interpret complex spreadsheets to identify errors and new or missing data from files prior to upload; append data to spreadsheets from other sources. Write and use SQL Select queries; execute SQL stored procedures. Monitor incoming requests and track support progress; when process is impeded, identify slow points and obstacles. Perform schedule scrapes from online catalogues and convert to Excel files. Maintain department project management system; actively monitor incoming support requests and inboxes. Record and distribute field team minutes from weekly meetings. Maintain Drupal migration and clean operations as part of the onboarding and upload process. Troubleshoot AFT Connect to identify errors and document process; create and test Connect audit users to verify affiliate user’s experience matches intended outcome. In collaboration with the convention, meetings and travel department, handle logistics for events, conferences and meetings. Participate in supportive role assignments as requested by the director of human resources. Other duties as assigned.                                                                                                                                                                          Knowledge, Skills and Abilities: Intermediate skills in Microsoft Excel, with experience utilizing functions and formulas to clean and process data preferred. Candidate must be comfortable using and writing SQL Select queries. Atlassian (JIRA, Confluence) knowledge preferred. Understanding of relational databases is preferred. Python experience is necessary for file processing. Knowledge of or ability to achieve proficiency in the use of AFT customized and standard software (or willingness to train). Candidate must be well organized and able to work independently. Excellent written and verbal communication skills are essential. Candidate must be highly trustworthy and responsible with regard to sensitive information and financial transactions. Prior work experience in a union environment is preferred. Familiarity with AFT and/or its affiliates is a plus.                                               Work Environment:   AFT is a place-based organization in Washington, D.C.  Work is performed in an office environment.  This position is part of a collective bargaining agreement.                                                                                                                                                                       How to Apply:   Successful candidates must pass a clerical skills battery test per the OPEIU collective bargaining agreement. Applicants should submit a cover letter and resume to the director of human resources   Position Requirements AFT is an Equal Opportunity Employer Vaccine Requirement: AFT requires that all staff be fully vaccinated for COVID-19. Testing Requirement: AFT requires that all staff take a self-administered AFT provided rapid-antigen test weekly. AFT is an Equal Opportunity Employer The AFT is committed to creating a diverse environment and is proud to be an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, gender, gender identity or expression, sexual orientation, national origin, genetics, disability, age, or veteran status.        American Federation of Teachers, AFL,CIO ♦ 555 New Jersey Ave. N.W. ♦ Washington, DC 20001 ♦ 202/879-4400 ♦ www.aft.org   Full-Time/Part-Time Full-Time   Work Environment AFT is a place-based organization located in Washington, D.C. Work is performed in an office environment.   Position   Close Date   Created By   Position File Processing Coordinator   Close Date   Created By PATRICIA COOK   Number of Openings 1   Exempt/Non-Exempt Non-Exempt   Open Date 3/5/2024   Location Headquarters, Washington, DC   About the Organization The AFT is a union of professionals that champions fairness; democracy; economic opportunity; and high-quality public education, healthcare and public services for our students, their families and our communities. We are committed to advancing these principles through community engagement, organizing, collective bargaining and political activism, and especially through the work our members do.   EOE Statement The AFT is a union of professionals that champions fairness; democracy; economic opportunity; and high-quality public education, healthcare and public services for our students, their families and our communities. We are committed to advancing these principles through community engagement, organizing, collective bargaining and political activism, and especially through the work our members do. The AFT believes that a culturally diverse workforce advances our mission and we strongly encourage applications from under-represented communities of workers.   This position is currently not accepting applications. To search for an open position, please go to http://AmericanFederationofTeachers.appone.com WE ALSO RECOMMEND Other Jobs Within Same Category Administrative Assistant, Human Resources in Washington, District of Columbia Posted on: 4/16/2024 [Apply Now] Administrative Assistant, Human Rights and Community Relations in Washington, District of Columbia Posted on: 4/9/2024 [Apply Now] Administrative Assistant, AFT Public Employees in Washington, District of Columbia Posted on: 3/28/2024 [Apply Now] File Processing Coordinator in Washington, District of Columbia Posted on: 3/28/2024 [Apply Now] Other Jobs Within 60 Miles Senior Associate, AFT Higher Education in Washington, District of Columbia Posted on: 3/28/2024 [Apply Now] Assistant Director, AFT Higher Education in Washington, District of Columbia Posted on: 3/28/2024 [Apply Now] National Representative I-IV in N/A, N/A Posted on: 2/28/2024 [Apply Now] Administrative Assistant, AFT Public Employees in Washington, District of Columbia Posted on: 3/28/2024 [Apply Now] File Processing Coordinator in Washington, District of Columbia Posted on: 3/28/2024 [Apply Now]

Click here for technical assistance.