DSAID - Data Engineer (DE) - Senior

Mission Objectives ? Lead all technical and operational database engineering and business intelligence (BI) activities across DSAID and the Enterprise Reporting Capability (ERC), ensuring data reliability, quality, compliance, security, and effective reporting to support the DMDC mission. Oversee database architecture, ETL and interface operations, performance monitoring, and modernization efforts supporting secure data-driven decision-making and compliance with DoD/DMDC standards.

Position Responsibility Summary

• Serve as technical authority for all ERC (MicroStrategy) BI platform management, ensuring data schema management, report generation, dashboard creation, and BI tool enhancements are performed in accordance with agency requirements.
• Oversee the design, administration, migration, and modernization of Oracle and SQL databases, including schema management, data integrity constraints, indexing, partitioning, and performance tuning to ensure high availability and optimal performance.
• Coordinate and execute routine ETL activities, including secure SFTP data transfers, data validation, error tracking, and scheduled and ad hoc reporting to support transactional and analytical needs.
• Plan and implement database changes, data migrations, and cloud integrations (AWS, GovCloud, OCI) in concert with application, system, and cloud teams to enable modernization and scalability
• Develop, monitor, and continuously improve data quality dashboards and establish automated anomaly detection and preventive/corrective routines for data integrity and reliability.
• Support and lead BI report development, including new dashboard/report design, testing, and deployment, particularly in MicroStrategy, PowerBI, or other agency-approved tools.
• Coordinate with ISSO, Program Managers, and Authorization and Accreditation (A&A) teams, providing required verification documentation and Plan of Action & Milestones (POA&M) deliverables during security reviews and audits.
• Lead incident response, performance troubleshooting, and service restoration related to data, database, and BI environments.
• Maintain and update technical, functional, and operational documentation for data management, BI models, and database operations. Support operational documentation and deliverables in SharePoint or designated repositories.
• Ensure all deliverables, processes, and reporting adhere to Section 508 accessibility, DoD cybersecurity and data privacy mandates, and applicable federal/DoD standards.