Senior Data & Analytics Engineer

Position Title: Senior Data & Analytics Engineer 

Location: Pentagon, Arlington, Virginia 

Category: Funded 

Schedule (FT/PT): Full Time 

Travel Required: May require occasional domestic travel 

Shift: Day 

Remote Type: In-Office 

Clearance required: Current Top Secret. Sensitive Compartmented Information (SCI) eligibility 

Salary: $170,000 - $200,000 

Who is ACT1 Federal? ACT1 Federal LLC is a 100% employee-owned company. We’ve served the Department of War (DoW) for nearly thirty years. Our core missions include weapon systems engineering, logistics, space domain expertise, global defense and security, business and financial management for security assistance and major defense articles, as well as military training and arctic security. Join us!  

Description: ACT1 Federal is seeking an experienced Senior Data & Analytics Engineer to provide senior-level data-engineering, data-architecture, analytics-engineering, and business-intelligence support to the Director of Data Management and Performance Assessment, Office of the Deputy Assistant Secretary of the Navy for the Defense Industrial Base (DASN (DIB)). The engineer supports Department of the Navy (DON) efforts to develop governed data products and analytic capabilities supporting assessment of defense-industrial-base performance, production capacity, supply-chain risk, investment activity, and program outcomes. 

The primary mission application is wartime production planning within the defense-industrial-base portfolio. The engineer develops documented data pipelines, models, semantic layers, datasets, and analytic products that support Government assessment of industrial capacity, supplier readiness, manufacturing constraints, delivery timelines, workforce trends, material availability, and surge potential. 

This position requires a senior technical subject matter expert with demonstrated experience in enterprise data engineering, analytics engineering, data-platform architecture, and governed business-intelligence products. The engineer shall be capable of transforming complex, incomplete, inconsistent, or delayed source data into well-documented, analytic-ready datasets and products while clearly distinguishing verified data, analytical assumptions, limitations, confidence levels, and judgments. 

Responsibilities: 

• Provide data-engineering, data-architecture, analytics-engineering, data-modeling, and business-intelligence support for DASN (DIB) data-management and performance-assessment initiatives. 

• Design, develop, test, document, maintain, and support data pipelines, data transformations, data models, application programming interfaces, data services, semantic models, and analytic products. 

• Develop governed data products and documented analytical inputs supporting Government assessment of industrial capacity, supplier readiness, supply-chain risk, manufacturing constraints, delivery timelines, workforce trends, material availability, investment activity, and surge potential. 

• Integrate data pipelines and analytic products with Government-designated source systems, enterprise data platforms, and approved data environments, as authorized by the Government. 

• Develop and maintain extract, transform, load; extract, load, transform; data-integration; data-orchestration; and application programming interface workflows using SQL, Python, and other Government-approved tools and technologies. 

• Design and maintain dimensional models, semantic models, data marts, analytic datasets, and governed data-product artifacts supporting dashboards, reporting, advanced analytics, machine-learning applications, and executive decision support. 

• Develop and maintain the governed semantic layer supporting Power BI and other Government-approved business-intelligence and visualization products. 

• Prepare clean, documented, validated, and analytic-ready datasets for use in performance assessment, market analysis, supply-chain analysis, production planning, forecasting, optimization, simulation, artificial intelligence, machine learning, and related analytics. 

• Develop draft data-quality, reconciliation, validation, lineage, provenance, metadata, documentation, and data-governance standards for Government review and approval. 

• Implement data-quality checks, reconciliation processes, validation routines, exception reporting, metadata documentation, data lineage, provenance tracking, and repeatable data-engineering practices. 

• Identify data gaps, data-quality issues, source-system limitations, assumptions, dependencies, confidence considerations, and analytical limitations for Government review. 

• Develop Power BI semantic models, dashboards, reports, visualizations, and other analytic products in accordance with Government-approved governance, access, data-management, and reporting requirements. 

• Support integration with DON and Department of War enterprise data environments (e.g., Advana, Jupiter), Azure Government, Flank Speed, DON enterprise-cloud services, and other Government-approved data environments, as directed and authorized by the Government. 

• Prepare technical memoranda, architecture diagrams, data dictionaries, data-model documentation, implementation plans, executive briefings, decision packages, and status reports for senior technical and nontechnical stakeholders. 

• Coordinate technical products and supporting information with DASN (DIB) directorates, ASN (RD&A) offices, DON acquisition organizations, DON enterprise service providers, Department of War stakeholders, and other Government-approved points of contact, as directed by the Government.