Position OverviewHerdt Consulting is seeking an experienced Navy ERP DDEF / UMT Error Research SME to support research and analyze Defense Departmental Reporting Error File (DDEF) and UMT errors. This role will use Jupiter/Databricks to investigate error conditions, identify root causes, and support accurate, auditable financial data processing.
Quick Facts- Location: Remote; proximity to Norfolk, VA, Washington, DC, or San Diego, CA is helpful but not required
- Security Clearance: Secret
- Citizenship: US Citizenship Required
- Education: Bachelor's degree in Business Administration, Accounting, Finance, or another relevant discipline
- Experience: 6+ years of relevant professional experience
- Work Schedule/Arrangement: Full-time / Remote
Key Responsibilities- Use Jupiter/Databricks to research DDEF and UMT errors and trace error conditions through source records, data transformations, interfaces, and Navy ERP processing to identify root causes.
- Analyze incomplete, inaccurate, rejected, or unmatched transactions and isolate patterns affecting UMT error processing.
- Use queries, notebooks, and data comparisons to reconcile source information with Navy ERP records and validate findings.
- Coordinate with functional, technical, and data teams to recommend corrective actions and verify remediation outcomes.
- Document research methods, supporting evidence, recurring error trends, and resolution status for auditability and knowledge sharing.
Required Qualifications- Hands-on Navy ERP experience researching transaction errors, financial data issues, or reconciliation discrepancies.
- Experience investigating DDEF and/or UMT errors, including transaction-level root-cause analysis.
- Practical experience using Jupiter/Databricks to explore, query, and analyze datasets.
- Ability to interpret financial transaction data, identify data-quality issues, and trace processing or interface failures.
- Experience comparing data across source systems, analytical outputs, and ERP records to substantiate findings.
- Strong analytical problem-solving, technical documentation, and cross-functional communication skills.
- Experience with SQL, Python, notebook-based analysis, or dashboards supporting financial data investigation is a plus!
What we can offer you- Excellence: The chance to be part of a company with a reputation for excellence in task execution.
- Time Off: 3 weeks of paid vacation each year plus 11 federal holidays.
- Health Benefits: Competitive Medical (Blue Cross Blue Shield), Dental, and Vision insurance.
- Financial Security: 401K program with Fidelity (including company match) and Flexible Spending Account
- Insurance: Short-term and Long-term Disability provided at no cost, plus voluntary Life and AD&D options.