Data Warehousing Administrator

Data Warehousing Administrator

The Data Warehousing Administrator manages the AAA Dashboard's SQL Server infrastructure, ensuring high availability and compliance.

Responsibilities:

• Design and optimize SQL Server databases for 10TB+ logistics and acquisition datasets.
• Develop ETL processes to ingest data from DLA's Enterprise Business System (EBS).
• Implement Role-Based Access Control (RBAC) and encryption for sensitive data.
• Perform quarterly disaster recovery drills and maintain 99.9% uptime.
• Collaborate with data analysts to build OLAP cubes for business intelligence reporting.
• Patch servers in accordance with DLA's Cybersecurity Service Provider (CSSP) directives.

Requirements:

• Bachelor's degree in Data Science or related field.
• Microsoft Certified: Azure Data Engineer or SQL Server DBA certification.
• 5+ years of data warehousing experience, including 2+ years with DoD systems.
• Proficiency in SSIS, SSAS, and Power BI.
• Active IT-II Non-Critical Sensitive (Tier 3) clearance.
• U.S. citizenship required.