Database Specialist

SEIU Local 2015 is California’s Long Term Care workers organization that will unleash the collective power of long term care workers, their families, and their communities, harness the power of technology, and build a broad movement to disrupt the unjust status quo in order to bring lasting transformational change towards a more just society for all.

Purpose

This position will provide data, membership relationship management software, and data analysis support for the Growth/External Organizing Department’s worker organizing campaigns

Primary Responsibilities

Assists in coordinating and implementing data operations, with an emphasis for the Growth/External Organizing Department’s campaigns; maintains and administers worker organizing database to ensure that information is accurate, comprehensive, and secure and that users can receive needed information from the databases

• Takes a primary role in planning, preparing, and executing the migration of current data repositories into Salesforce for the Growth Department
• Provides guidance and advice to organizers on how to use existing technology to better track and report organizing campaigns; writes training and operations materials; trains organizers on how to access, use and generate reports for campaign needs
• Imports and exports files between formats and programs such as SQL (MSSQL, MySQL, PostgreSQL), Microsoft Excel, Microsoft Access, delimited text files, and a variety of file formats including utilizing email and web based applications
• Maintains security procedures to ensure safety and integrity of data and paper lists, maintains processes, credential management, and procedures to ensure on site and off site backup of data; oversees maintenance of database office files including original materials such as lists, authorization cards, etc.
• Interacts with other departments, as well as SEIU International’s Organizing Data Team, to ensure a collaborative work environment, enabling data-centric work, and to share best practice on data flow and integrity
• Collects, analyzes and maintains publicly available data and creates, searchable internal databases that organizers can use to learn more about the long-term care industry
• Guides and advises the Department on how to best use existing technology to improve  and enhance worker list collection
• The Data Analyst/Database Specialist will also be responsible for training of staff on various software packages, including UnionWare and Microsoft Office, and should be able to present information either in a remote session or in person in a manner that is appropriate to the trainee’s level of understanding. The ideal candidate will possess strategic vision in designing both the content and delivery methods in order to produce effective learning outcomes.
• Other duties as assigned

Education and Experience

Graduation from an accredited four-year college or university with a bachelor’s degree and at least one (1) year IT experience managing large databases or 2 (2) years doing statistics and data analysis

Or, a combination of education and experience that would provide for the following knowledge, skills and abilities:

  Required Qualifications

• Experience in the Salesforce CRM ecosystem (Sales Cloud, Service Cloud, Pardot)
• Extensive experience in SQL (MSSQL or MySQL, PostgreSQL)
• Experience using SQL, Python, R or comparable programming software
• Knowledge of labor unions and how local unions operate
• Ability to work with both technical staff and external organizing staff
• Knowledge of or experience working on political, internal, and external organizing campaigns
• Expert knowledge of databases (e.g. Voter Activation