Senior Data Engineer (Secret)

Location: Fairfax, VA (may be remote with occasional travel)
Clearance: Secret
Employment Type: Full-Time

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, "stovepiped," 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:

• Data Transformation & Implementation: Assist the Agency in implementing a common data framework, an effort estimated to comprise at least 60% of the project's scope.
• Source Integration: Identify and catalog diverse data sources, including Microsoft SharePoint documents, Excel spreadsheets, Access databases, and transactional data.
• Data "Mining" & Extraction: Work with functional stakeholders to extract critical data that currently exists only as subject matter expertise or unstructured individual transaction records.
• Pipeline Development: Develop repeatable processes to convert disaggregated data into a summarized format that portrays a complete picture of cemetery resource areas.
• Quality Assurance: Implement data validation and cleansing routines to ensure the accuracy of information used in both Site and Functional Dashboards.
• Technical Optimization: Optimize data structures for use within the Agency's Microsoft-based environment, specifically for Power BI consumption.
• Metric Support: 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.
• Documentation: Prepare technical documentation covering data sources and the step-by-step guides for managing data updates.

Required Qualifications:

• Experience: At least 7 years of data engineering experience and a proven track record of helping organizations implement BI programs.
• Technical Proficiency: Extensive experience with the Microsoft 365 Suite, including SharePoint, Excel, Teams, and Power BI.
• Federal Standards: Experience and understanding of U.S. Federal government computing standards and regulations.
• Data Profiling: Expertise in analyzing discrepancies between current data landscapes and target BI needs (Gap Analysis).
• Security Compliance: 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 that are 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 healthcare for you (We pay your premiums and deductibles)
• 401(k) with company match
• Travel & performance incentives
• 3 weeks paid time off (plus Federal Holidays)
• $5K 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 DevOps, specializing in transforming complex data into actionable intelligence for informed decision-making. Since 2011, we have supported over 40 organizations across diverse domains, including military intelligence operations, financial and fraud investigations, and insider threat detection.

Our team of experts-skilled in cloud computing, artificial intelligence, machine learning, data science, DevOps, and engineering-brings deep experience in solving complex challenges. With a proven track record in federal contracting, we deliver tailored, high-impact solutions designed to enhance operational efficiency, ensure mission success, and address the evolving needs of our clients. Praescient's innovative and adaptive approach makes us a trusted partner in delivering data-driven insights and technological excellence for critical missions.

Applicants selected will be subject to a government security investigation and must meet eligibility requirements for access to classified information.
US Citizenship Required
Interested Candidates: Please forward your resume to recruiting@praescientanalytics.com and please visit our website to apply online at www.praescientanalytics.applicantstack.com/x/openings.