Data Warehouse DBA — Hybrid in Seattle, Drive Data Integrity

Plymouth Housing Group; Seattle (WA); Hybrid; USD 102,000 - 115,000; Full time

Benefits offered by this job

Medical, Dental, Vision

403(b) options

ORCA subsidy

Job summary

Plymouth Housing Group in Seattle is seeking a Database Administrator to lead the development and implementation of the PHG Data Warehouse. You will oversee database design, security, and integration with multiple data sources while collaborating with staff, vendors, and partners to ensure reliable operations.

The role emphasizes data quality, accessibility, and compliance with HIPAA and PII. The team values thoughtful analysis, project management, and clear communication to support Plymouth

Qualifications

• 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.

Responsibilities

• 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.

Skills

Database design

Analytical skills

Project management

Communication skills

Multitasking

Confidentiality

Education

Bachelor's degree in computer science or related field

Tools

Microsoft Azure Services

Microsoft SQL

SAP SQL

Job description

Plymouth Housing Group in Seattle is seeking a Database Administrator to lead the development and implementation of the PHG Data Warehouse. You will oversee database design, security, and integration with multiple data sources while collaborating with staff, vendors, and partners to ensure reliable operations.

The role emphasizes data quality, accessibility, and compliance with HIPAA and PII. The team values thoughtful analysis, project management, and clear communication to support Plymouth