Select a State * NATIONAL MAP * Alabama Alaska Arizona Arkansas California Colorado Connecticut Delaware District of Columbia Florida Georgia Hawaii Idaho Illinois Indiana Iowa Kansas Kentucky Louisiana Maine Maryland Massachusetts Michigan Minnesota Mississippi Missouri Montana Nebraska Nevada New Hampshire New Jersey New Mexico New York North Carolina North Dakota Ohio Oklahoma Oregon Pennsylvania Puerto Rico Rhode Island South Carolina South Dakota Tennessee Texas Utah Vermont Virginia Washington West Virginia Wisconsin Wyoming

• ISSUES
  • Budget & Taxes
  • Health & Safety
  • Health Care
  • Pension Security
  • Privatization
  • Women
• JOBS WE DO
  • Corrections
  • Early Childhood Education
  • Emergency Services
  • Environmental Stewardship
  • Health Care Workers
  • Higher Education
  • Home Care
  • Housing
  • Human Services
  • K-12 Schools
  • Law Enforcement
  • Library Workers
  • Nurses
  • Probation and Parole
  • Public Administration
  • Public Works
  • Transportation
• LEGISLATION & POLITICS
• MEMBERS ONLY
  Savings, Resources & Trainings
• PUBLICATIONS
• PRESS ROOM
• ABOUT AFSCME
  • AFSCME Leadership
  • AFSCME History
  • Employment Opportunities
  • AFSCME Store

Database Analyst I - Organizing & Field Services, Indiana

Responsible for the overall operation and performance of organizing databases on multiple campaigns (including future internet hosting/browser services). Provides technical support to organizers and other staff on use of organizing software, devises and implements training plan for departmental staff.  Collects and maintains distributed or collected campaign databases for departmental analysis.  Designs improvements and corrections to database software.  In coordination with Information Systems (IS) and outside vendors, establishes and supports field office network and hardware needs.   Serves as Information Systems liaison and works with Information Systems to coordinate Department's data needs with the membership and enterprise data needs.

DUTIES: Administers, maintains and coordinates AFSCME organizing database software, applying knowledge of database design standards and database management systems. Designs supplemental procedures and reports. Ensures database compatibility with AFSCME organizing practices. Travels extensively to train, provide technical support and devises data management strategies for organizing campaigns. Devises and implements comprehensive training strategies for departmental staff on use of database and other software for organizing purposes.  Reviews organizing project requests describing data base user’s needs.  Estimates time and cost required to accomplish project.  Determines project requirements.  Consults and coordinates with staff to ensure that data needs will be met with proposed changes.  Develops and executes a test plan for all new or modified databases prior to production status. Analyzes organizing campaign data needs and devises strategies for data management. Test proposed changes to the database for data integrity, performance issues and reporting to comply with end-user requests.  Develops procedures for data reporting, data viewing on-line and data auditing.  Develops data sources to enhance information on addresses, phone numbers, and voter files and other organizing needs.  Performs complex data matching to compare external and internal data to insure data integrity.   Imports and restructures data from external sources.  Answers user database questions by producing queries, reports, charts and graphs from available data.  Sets up queries, reports, and other mechanisms to be user friendly so users can produce reports.  Identifies and corrects system and data handling errors; solves user problems. Administers security for the system. Performs new installations, conversions and upgrades to the database system.  Converts existing databases to new version.  Defines requirements and assists in ensuring the compatibility of database with various data communications technology.  Prepares regularly scheduled and ad hoc management reports, analyzing and determining data fields and source data from disparate files.  Conducts short- and long-term systems planning, researches alternatives and recommends procurement of new software applications to upgrade current systems.  Assist in the development of the hardware and software budget for the department.  Must maintain current technical skills consistent with industry standards.  Performs other related duties as assigned. 

REQUIREMENTS: College graduate with a degree in information systems, business, mathematics, music or computer science, an MCP (MicroSoft Certified Professional) is desirable and 3-5 years experience with relational database technology or any combination of education and experience to provide the following knowledge, skills and abilities:  knowledge of relational database technology, theory and development in MSAccess, MSSQL, etc; knowledge of end-user training methods, curriculum development, and help desk support techniques; knowledge of front-end development tools such as Visual Basic; knowledge of report development software; knowledge of Web-enabled applications; knowledge of data administration and data normalization techniques; knowledge of systems analysis, systems specifications, and systems development; knowledge of organizing support services; knowledge of automation and networking principles; ability to do data analysis with databases, spreadsheets and develop appropriate reporting techniques; strong verbal and written communication skills; ability to develop documentation, standard operating procedures, audit and test data; skill in trouble shooting software problems and solving end user problems.  Extensive travel and work outside the normal work hours is required.

Print Version Email This Page

What's This?