Senior Data Engineer (Secret) with Security Clearance

About Praescient Analytics

Praescient Analytics is a leader in delivering advanced analytic, data engineering, and technology integration solutions in support of the Department of Defense (DoD), Intelligence Community, and federal law enforcement. Our mission is to empower analysts and decision makers through data‑driven insights, enabling faster and more effective mission outcomes.

Position Overview

The Senior Data Engineer will be a key technical contributor to the American Battle Monuments Agency (ABMC) Data Structure and Business Intelligence Consulting project. This role is primarily responsible for the "heavy lifting" of data preparation—transforming disaggregated, "stove piped," and sometimes non‑digital information into a structured common data framework. You will work at the intersection of raw data and actionable insights, ensuring that the ABMC Cemetery Status Information System (ACSIS) is fed by accurate, reliable, and high‑performing data pipelines.

U.S. citizenship is required.

Key Responsibilities

• Assist the Agency in implementing a common data framework, an effort estimated to comprise at least 60% of the project's scope.
• Identify and catalog diverse data sources, including Microsoft SharePoint documents, Excel spreadsheets, Access databases, and transactional data.
• Work with functional stakeholders to extract critical data that currently exists only as subject matter expertise or unstructured individual transaction records.
• Develop repeatable processes to convert disaggregated data into a summarized format that portrays a complete picture of cemetery resource areas.
• Implement data validation and cleansing routines to ensure the accuracy of information used in both site and functional dashboards.
• Optimize data structures for use within the Agency's Microsoft‑based environment, specifically for Power BI consumption.
• Assist in developing the underlying data logic for performance metrics, such as the color‑coded Green/Amber/Red assessments for functional areas like horticulture and engineering.
• Prepare technical documentation covering data sources and step‑by‑step guides for managing data updates.

Required Qualifications

• At least 7 years of data engineering experience and a proven track record of helping organizations implement BI programs.
• Extensive experience with the Microsoft 365 Suite, including SharePoint, Excel, Teams, and Power BI.
• Experience and understanding of U.S. Federal government computing standards and regulations.
• Expertise in analyzing discrepancies between current data landscapes and target BI needs (gap analysis).
• Ability to implement data minimization and encryption (at rest and in transit) in alignment with NIST SP 800‑53 Revision 5.

Desired Skills

• Familiarity with Oracle Financial Services software and Archibus (Integrated Facilities Management System).
• Knowledge of Microsoft Copilot or similar large‑language‑AI tools to assist in data development.
• Familiarity with international data standards, including GDPR.

What you can expect from us

• Real opportunity for career growth in an environment where your achievements will be celebrated.
• Constant collaboration with numerous teams to ensure client success.
• A team that respects and embraces your ideas and expertise.
• Coworkers motivated by pursuing excellence, rather than the prospect of personal gain.
• A workplace dedicated to supporting and bettering public safety and government agencies.

Benefits

• Competitive salary based on qualifications and experience.
• Comprehensive, company‑paid health care.
• 401(k) with company match.
• Travel & performance incentives.
• Three weeks paid time off (plus federal holidays).
• $5,000 annual training allowance.
• $500 book allowance.
• Tuition reimbursement program.

Praescient Analytics is a Certified Woman‑Owned Small Business (WOSB) with over a decade of expertise in advanced analytics, engineering, and Dev Ops, specializing in transforming complex data into actionable intelligence for informed decision‑making. Applicants selected will be subject to a government security investigation and must meet eligibility requirements for access to classified information. U.S. citizenship required.

To apply, please visit our careers page escien