SEIU Local 503

SEIU Local 503
In It Together

Senior Systems Analyst

Based in Portland, OR


SEIU Local 503 is Oregon's union of 72,000 nursing home, homecare, child care and other care providers, public and non-profit workers. We are part of the 2 million member Service Employees International Union (SEIU), committed to building power for low-wage workers and engaging in social and economic justice issues facing working families, from affordable housing to immigrant rights. We wage big campaigns to win better wages, healthcare and more secure jobs to help ensure that workers--not just corporations and CEOs--benefit from today’s global economy.

Job Title: Sr. Systems Analyst (Programmer)
Reports To: Operations Services and Systems Director
Status: Exempt, Permanent, Full-Time

Purpose of the Position:

With shared vision and purpose, we will drive organizational change and effectiveness through a focus on staff and team development, accountability, and equity and inclusion.

To help coordinate the utilization of the data processing resources of the union and to provide assistance in the design and use of the Unions Information Systems. This position emphasizes the automated processing of Employer Provided data into a Membership Database (MSSQL) and to feed that processed data to other systems that directly support the mission of the Union.


  • Work with a Membership database (MSSQL) including analyzing staff and other system needs for reports and data. Creating, maintaining, and documenting automated processes, SQL queries and stored procedures to manage those data needs.
  • Participate and assist with the preparation and implementation of systems that will move and integrate data between the Membership Database (MS SQL), SalesForce and other external systems.
  • Oversee the collection and processing of Employer provided Membership and Financial Data.
  • Assist in the timely creation and reporting of legally required information to State and/or Federal Agencies.
  • Monitor System resources keeping the system as efficient as possible and maintain system integrity. Troubleshoot problem programs and systems, correct problems and recommend solutions.
  • Write and make changes to queries, stored procedures and programs using SQL and other languages as future operations require for data processing. Make coding changes to conform to new file formats and data elements as needed.
  • Design, test and implement the automation of manual tasks.
  • Design new tables in existing databases as additional data needs require.
  • Design new databases and other data infrastructure as future needs require.
  • Develop and maintain data dictionaries and support documentation which defines data elements and file structures and how they interface with application programs.
  • Develop naming conventions for data dictionary for ease of maintenance and end user interpretation when requesting new programs.
  • Process special and routine imports, reports, labels or other output. keeping within required deadlines and documenting when the task was completed and how long it took.
  • Provide relevant training and technical assistance to other staff.
  • Cooperatively participate in teams, when assigned, for development and design of database programs on the network for user access and data manipulation.
  • Participate in the establishment of the local and wide area networks by assisting in the placement and troubleshooting of equipment when required.
  • Assist in troubleshooting in any problems that might arise with the network.
  • Treat all users (Staff and Members) in a professional and respectful manner.
  • Participate in union-wide membership drives, political campaigns and other field activities as assigned. This may include worksite visits, phone banking, house visits, door-to-door canvassing and literature drops. These activities may be required after regular business hours or on weekends.
  • Other duties as assigned.

Minimum Requirements:

  • Associates Degree in Computer Science or equivalent combination of education/experience.
  • Two years’ experience in MS SQL design principles and techniques.
  • Experience with SalesForce and integrating SalesForce with Legacy databases
  • Knowledge and experience of file management, principles and techniques.
  • Experience in relational data base management systems, data communications, computer hardware and software principles.
  • Knowledge and experience with computer networks, both local and wide area.
  • Ability to provide technical support in a multi-platform environment.
  • Ability to work well under pressure and with limited timelines.
  • Good oral and written communication skills.
  • Ability to work well in a “team” environment.
  • Ability to complete assignments with minimal supervision.
  • Must be able to work outside a regular 8:00 a.m. to 5:00 p.m. work schedule.

Working Conditions/Environment:
Office and field work involving travel to areas throughout the state and in a variety of environmental situations. The workweek is Monday through Friday plus weekend work as needed. The workday may begin before and extend beyond normal office hours depending on the demands of the assignment.

Pay and Benefits: Positions provide comprehensive fully paid health, dental and vision benefits for employee and eligible dependents, domestic partner benefits, generous holiday and leave policies, a severance package, a monthly car and cell phone allowance, and a 15% employer-paid defined contribution 401K. Compensation range is based on experience $62,040-$88,224 annually.

Hiring: We are committed to hiring staff who reflect our membership and model the unity and equity that we seek to create in Oregon communities. Women, LGBTQ, people of color, and immigrants strongly encouraged to apply.

How to Apply: Submit your cover letter describing your interest and a résumé in one attachment (PDF preferred) by e-mail to: crusea@seiu503.org

WHEN APPLYING: Be sure to indicate that you saw this information at UNIONJOBS.COM.