Senior Financial Data Engineer - DoD Data & Reconciliation

Silverthorne Advisory Group LLC; Virginia (MN); On-site; USD 140,000 - 170,000; Full time

Job summary

Silverthorne Advisory Group LLC seeks a Senior Financial Data Engineer to design and maintain data pipelines that support DoW financial management and reconciliation. You will structure and interpret data from multiple DoW sources, ensuring accuracy and security in mission-critical environments.

You will collaborate with clients to define requirements, build datasets, and automate processes using Python, SQL, and enterprise platforms like Advana, Foundry, and Databricks.

Qualifications

• 3–10 years of directly related professional experience.
• Bachelor’s or Master’s degree in Finance, Accounting, Business, Economics, Data Analytics, Information Systems, Computer Science, Data Engineering, or a related field.
• 3+ years of experience evaluating, transforming, and validating diverse datasets for financial reconciliation, reporting, or analytics.
• Demonstrated ability to interpret, align, and synthesize complex data from multiple DoW systems and sources.
• Hands‑on experience working with DoW financial data, financial management systems, or related DoW business processes.
• Experience with WDP/Advana, Foundry, and/or Databricks in a data engineering or analytics capacity.
• Experience managing the data acquisition lifecycle and source systems for datasets.
• Demonstrated experience working directly with clients to define and implement requirements.
• Advanced proficiency in Python and SQL.
• Experience with public accounting, financial data, federal financial management, or related environments.
• Experience applying data governance principles and maintaining security controls.
• Active Secret security clearance required.

Responsibilities

• Design, develop, and maintain data pipelines and backend data solutions supporting DoW financial management and reconciliation activities.
• Evaluate, analyze, and structure diverse financial datasets to support accurate and complete financial reconciliation.
• Interpret, align, and synthesize complex data from multiple DoW systems and sources.
• Work with WDP/Advana, Foundry, Databricks and other platforms to support financial data solutions.
• Support integration of financial systems, datasets, and processes to improve data accuracy and usability.
• Manage the data acquisition lifecycle, identifying data populations, sources, and requirements for datasets.
• Collaborate with clients and stakeholders to define, refine, document, and implement requirements.
• Engineer backend data solutions and manipulate large datasets using Python, SQL, and related tech.
• Develop programmatic business rules for data enrichment, cleansing, transformation, validation, reconciliation.
• Automate recurring data and financial processes to improve efficiency and scalability.
• Perform data quality assessments and address discrepancies and gaps.
• Apply data governance and security controls throughout the lifecycle.
• Support financial analysis, reporting, reconciliation, and audit readiness.
• Communicate findings clearly to technical and non-technical stakeholders.
• Support senior leaders with accurate, reliable financial data.

Skills

Python

SQL

Data governance

Security/compliance

Education

Bachelor's degree

Master's degree

Tools

WDP/Advana

Foundry

Databricks

Job description

Silverthorne Advisory Group LLC seeks a Senior Financial Data Engineer to design and maintain data pipelines that support DoW financial management and reconciliation. You will structure and interpret data from multiple DoW sources, ensuring accuracy and security in mission-critical environments.

You will collaborate with clients to define requirements, build datasets, and automate processes using Python, SQL, and enterprise platforms like Advana, Foundry, and Databricks.