Senior Database Architect & Data Engineer

BTI; Washington; On-site; USD 120,000 - 160,000; Full time

Job summary

BTI is seeking a Senior Database Administrator to design scalable data architectures, model data, and manage secure, high-performance database systems. The role collaborates across analysts, SMEs, and customers to meet mission requirements and ensure data integrity.

Responsibilities include implementing ETL processes, data transfer APIs, encryption, and ongoing optimization of data pipelines while maintaining comprehensive documentation and regulatory compliance.

Qualifications

• Undergraduate degree in computer science, information systems management, IT, or related discipline.
• At least 8 years of IT experience including 5 years in data modeling, architecture, and DBA duties.
• Experience with data masking and encryption compliant with IRS Publication 1075.
• Experience designing and implementing data architecture solutions.
• Experience with MySQL, SQL Server, or Oracle DBMS.
• Strong knowledge of data modeling and data warehousing concepts.
• Experience implementing ETL processes and data integration tools.
• Hands-on data manipulation and query optimization.
• Ability to create system design documents for data architecture and warehousing.

Responsibilities

• Design and develop scalable data architecture to support transfers, storage, transformation, and reporting.
• Create and maintain data models to ensure quality and integrity.
• Manage and optimize database systems for high availability and performance.
• Collaborate with external agencies to establish secure data transfer processes and API integration.
• Implement access controls and encryption to protect data in transit and at rest.
• Monitor data pipelines and databases to improve efficiency and reduce latency.
• Maintain documentation of data architecture, integration processes, and configurations.
• Ensure compliance with relevant standards and regulations (e.g., NIST, FIPS, HIPAA).

Skills

Data modeling

Data warehousing

Database administration

Data encryption

Data masking

ETL development

SQL optimization

Documentation

Education

Bachelor's degree in Computer Science or related field

Tools

MySQL

SQL Server

Oracle

Job description

BTI is seeking a Senior Database Administrator to design scalable data architectures, model data, and manage secure, high-performance database systems. The role collaborates across analysts, SMEs, and customers to meet mission requirements and ensure data integrity.

Responsibilities include implementing ETL processes, data transfer APIs, encryption, and ongoing optimization of data pipelines while maintaining comprehensive documentation and regulatory compliance.