Database Administrator

What is Permanent Supportive Housing?; Seattle (WA); Híbrido; USD 102 000 - 115 000; Tempo integral

Vantagens oferecidas por esta oferta de emprego

Medical, Dental, Vision

PTO

403(b)

Employee Assistance Program

subsidized ORCA pass

Resumo da oferta

Plymouth Housing in Seattle, WA, is seeking a Database Administrator to develop and maintain the PHG Data Warehouse. You will oversee data integrity, security, and ELT processes while coordinating with staff, vendors, and external programs.

The role requires strong SQL data warehousing experience, familiarity with Azure, and the ability to design database applications for program tracking and reporting. This hybrid position supports a mission-driven nonprofit committed to ending homelessness.

Qualificações

• Bachelor’s degree in computer science or a related field, or equivalent combination of experience and training.
• At least 2 years’ experience in database programming and/or administration.
• At least 2 years’ experience with data warehousing.
• Proven experience with SQL and data analytics.
• Experience in testing and verifying data accuracy.
• Familiarity with Microsoft Azure Services, Microsoft SQL and SAP SQL is a plus.

Responsabilidades

• Develop and implement the PHG Data Warehouse, integrating data from various sources.
• Collaborate with software vendors, IT, and Data Analytics staff to configure and maintain databases (e.g., SQL Server, Oracle, MySQL).
• Design and customize applications to track programs and activities.
• Oversee data ELT processes, including migration and data entry.
• Ensure data security, including PII and HIPAA compliance.
• Maintain access control, audit records, and system security.
• Develop and manage backup and recovery plans.
• Monitor and optimize data warehouse performance.
• Diagnose and resolve data warehouse issues.
• Integrate data from various sources into the data warehouse.
• Adapt the database to meet evolving organizational needs.
• Modify the database for new programs, funding changes, and compliance requirements.
• Conduct regular audits to verify data accuracy.
• Ensure compliance with reporting requirements.
• Maintain comprehensive documentation of data warehouse configurations and policies.
• Develop user manuals, policies, procedures, and training for end-users.
• Serve as the primary contact for vendor updates and troubleshooting.
• Collaborate with IT and Data Analytics staff to ensure data stability and accessibility.
• Support data-related needs of stakeholders.

Conhecimentos

Database design

Analytical skills

Project management

Communication skills

Multitasking

Customer service

Formação académica

Bachelor’s degree in computer science or related field

Equivalent combination of experience and training

Ferramentas

Azure

MS SQL

SAP SQL

Descrição da oferta de emprego

SALARY

$102,170 - $114,566

New hires may earn a salary ranging from the minimum to the midpoint of the pay scale, with education and experience taken into consideration.

LOCATION

Seattle, WA (Hybrid)

FIND OUT ABOUT THIS ROLE AND OUR MISSION TO CREATE POSITIVE CHANGE

The Database Administrator at Plymouth Housing is responsible for development and implementation of the Plymouth Housing Group Data Warehouse. This role oversees the management, customization, and synchronization of all Plymouth Housing databases with the PHG Data Warehouse. This role involves designing database applications, performing data cleaning, generating reports, and ensuring data integrity and security. The Database Administrator also plays a critical role in collaborating with staff at all levels of the organization, vendors, and external programs to maintain seamless database operations and adapt to evolving organizational needs.

Plymouth Housing is a nonprofit organization that develops and operates permanent supportive housing for single adults who have experienced chronic homelessness. With apartment buildings throughout King County, Plymouth is helping the most vulnerable members of our community leave homelessness behind forever. At Plymouth, we’re not simply trying to get people off the streets. We provide supportive services like case management and health care so that our residents can thrive long‑term. As part of our strategic vision, we are building internal behavioral health services and transforming our systems to address rapid growth and the changing needs of residents.

WHAT YOU CAN EXPECT TO BE DOING IN THIS ROLE AT PLYMOUTH HOUSING

Database and Data Warehouse Management:

• Develop and implement the PHG Data Warehouse, integrating data from various sources.
• Collaborate with software vendors, IT, and Data Analytics staff to configure and maintain databases (e.g., SQL Server, Oracle, MySQL).
• Design and customize applications to track programs and activities.
• Oversee data ELT processes, including migration and data entry.
• Ensure data security, including PII and HIPAA compliance.
• Maintain access control, audit records, and system security.
• Develop and manage backup and recovery plans.
• Monitor and optimize data warehouse performance.
• Diagnose and resolve data warehouse issues.

Data Integration and Adaptation:

• Integrate data from various sources into the data warehouse.
• Adapt the database to meet evolving organizational needs.
• Modify the database for new programs, funding changes, and compliance requirements.

Data Integrity and Security:

• Conduct regular audits to verify data accuracy.
• Ensure compliance with reporting requirements.
• Maintain comprehensive documentation of data warehouse configurations and policies.

User Support:

• Develop user manuals, policies, procedures, and training for end-users.
• Serve as the primary contact for vendor updates and troubleshooting.
• Collaborate with IT and Data Analytics staff to ensure data stability and accessibility.
• Support data-related needs of stakeholders.

SOME KNOWLEDGE, SKILLS, AND ATTRIBUTES WE NEED FROM YOU

• Ability to communicate and work effectively with a diverse group of voices.
• Strong knowledge of database design, implementation, operation, and maintenance.
• Excellent analytical and problem‑solving skills with a keen attention to detail.
• Strong project management skills with the ability to meet deadlines.
• Effective oral and written communication skills, particularly in explaining technical concepts to non‑technical staff.
• Ability to multitask and prioritize in a dynamic environment.
• Positive customer‑service attitude and ability to maintain confidentiality.

QUALIFICATIONS

• Bachelor’s degree in computer science or a related field, or equivalent combination of experience and training.
• At least 2 years’ experience in database programming and/or administration.
• At least 2 years’ experience with data warehousing.
• Proven experience with SQL and data analytics.
• Experience in testing and verifying data accuracy.
• Familiarity with Microsoft Azure Services, Microsoft SQL and SAP SQL is a plus.

BENEFITS

We offer a comprehensive benefits package for Full‑Time employees, including Medical, Dental, Vision, PTO, and 403(b) options. Additionally, employees have access to supplementary benefits such as the Employee Assistance Program, a subsidized ORCA pass, and more. This is a full‑time position with benefits. Join us and be a catalyst for positive change!

Plymouth Housing is an equal opportunity employer. We recruit, hire, train and promote employees based on merit and business needs, and without regard for race, color, citizenship status, national origin, ancestry, gender, sexual orientation, age, weight, religion, creed, physical or mental disability, marital status, veteran status, military status, political affiliation, or any other factor protected by law.

Monday - Friday: Flexible start, able to work 5am-2pm or 6am-3pm or 7am-4pm or 8am-5pm