Senior Data Architect & Secure DB/ETL Lead

BTI; Washington (District of Columbia); On-site; USD 130,000 - 180,000; Full time

Job summary

BTI is seeking a Senior Database Administrator to design and evolve scalable data architectures supporting transfers, storage, and reporting. The role involves collaborating with analysts, SMEs, and system owners to meet mission requirements, security, and data integrity across diverse environments.

The ideal candidate has 8+ years in IT with 5+ years in data modeling, architecture, and DB administration, plus hands-on experience with ETL, data warehousing, and database security.

Qualifications

• Bachelor’s degree in computer science, information systems management, information technology, or related field, or equivalent experience.
• At least 8 years of IT experience, including 5 years in data modeling, data architecture, and database administration.
• Experience with data masking and data encryption to meet IRS Publication 1075 requirements.
• Experience designing and implementing data architecture solutions.
• Experience with database management systems such as MySQL, SQL Server, or Oracle.
• Experience with data modeling and data warehousing concepts.
• Experience developing ETL processes to load data from external sources.
• Experience with data integration tools and technologies.
• Hands-on data manipulation and query optimization.
• Experience creating system design documents and other data architecture documentation.

Responsibilities

• Design and develop robust, scalable data architecture to support transfers, storage, transformation, and reporting.
• Create and maintain data models to facilitate data transfer and storage while ensuring quality and integrity.
• Manage and optimize database systems for high availability and performance.
• Collaborate with external agencies to establish secure data transfer processes and APIs.
• Implement data security measures, access controls, and encryption for data in transfer and storage.
• Monitor and optimize data pipelines and databases for efficiency and latency reduction.
• Maintain comprehensive documentation of data architecture, integration processes, and configurations; ensure regulatory compliance where applicable.

Skills

Data modeling

Data architecture

Database administration

ETL processes

Data integration

Data encryption

Data masking

SQL Server

MySQL

Oracle DB

Documentation

Education

Bachelor’s degree

Tools

MySQL

SQL Server

Oracle DB

Job description

BTI is seeking a Senior Database Administrator to design and evolve scalable data architectures supporting transfers, storage, and reporting. The role involves collaborating with analysts, SMEs, and system owners to meet mission requirements, security, and data integrity across diverse environments.

The ideal candidate has 8+ years in IT with 5+ years in data modeling, architecture, and DB administration, plus hands-on experience with ETL, data warehousing, and database security.