Senior Data Engineer, Finance (R3972)

Shield AI; San Diego (CA); On-site; USD 120,000 - 180,000; Full time

Job summary

A leading defense technology company in San Diego seeks an experienced Data Engineer to join the Finance team. You will develop ETL pipelines, automate data processes, and support compliance for financial reporting. The ideal candidate has over 3 years of data engineering experience and proficiency in SQL, Python, and PySpark. This full-time position offers competitive compensation ranging from $120,000 to $180,000 per year along with bonuses and benefits.

Benefits

Bonus

Benefits

Equity

Qualifications

• 3+ years of experience in data engineering or analytics with hands-on ETL pipeline development.
• Proficiency in SQL, Python, and PySpark.
• Exposure to compliance-driven data handling including audit readiness.

Responsibilities

• Develop ETL pipelines (Python, SQL, PySpark) to integrate data from various systems.
• Automate ingestion and transformation workflows for data accuracy.
• Support development and deployment of machine learning workflows.

Skills

ETL pipeline development

SQL

Python

PySpark

Microsoft Fabric

Azure/AWS services

Data warehousing

Machine learning workflows

Tools

Databricks

Snowflake

Job description

Overview

Founded in 2015, Shield AI is a venture-backed deep-tech company with the mission of protecting service members and civilians with intelligent systems. Its products include the V-BAT aircraft, Hivemind Enterprise, and the Hivemind Vision product lines. With nine offices and facilities across the U.S., Europe, the Middle East, and the Asia-Pacific, Shield AI’s technology actively supports operations worldwide. For more information, visit www.shield.ai. Follow Shield AI on LinkedIn, X, Instagram, and YouTube.

Job Description

Shield AI is seeking a Data Engineer to join our Finance team in support of our financial enterprise reporting platform. This role will help establish secure, automated, and scalable data pipelines that connect finance, compliance, and operations to actionable insights. You will enable Finance to improve forecasting, budgeting, and reporting accuracy while supporting compliance with government and cyber requirements.

What you\'ll do

• Develop ETL pipelines (Python, SQL, PySpark) to integrate data from ERP, FP&A, and other enterprise systems into Microsoft Fabric.
• Automate ingestion, transformation, and validation workflows to ensure accuracy, timeliness, and compliance of finance and accounting data.
• Build and maintain Lakehouse structures (raw, processed, curated) to support efficient data modeling and reporting.
• Curate datasets for end users and analysts to consume in their own reporting and dashboarding tools.
• Design and maintain orchestration frameworks and dataflows to support higher-frequency refresh schedules while optimizing Fabric compute unit (CU) usage.
• Support development and deployment of machine learning workflows (e.g., GL/expense classification models) as part of the financial reporting platform.
• Collaborate with Finance, FP&A, and Product stakeholders to evolve data models and reporting capabilities.

Required qualifications

• 3+ years of experience in data engineering or analytics with hands-on ETL pipeline development.
• Proficiency in SQL, Python, and PySpark, with experience in Microsoft Fabric, Databricks, or Snowflake.
• Understanding of data warehousing and Lakehouse architectures, medallion models, and orchestration workflows.
• Experience with Azure or AWS cloud services (S3, EC2, IAM, Databricks, or Azure equivalents).
• Familiarity with compliance-driven data handling, including audit readiness and government reporting requirements.

Preferred qualifications

• Experience in a defense or government technology environment.
• Exposure to finance systems (Costpoint, Vena, ERP/FP&A platforms) and accounting data structures.
• Knowledge of compliance frameworks and data governance/security policies (DCAA, FAR/DFARS, CUI).
• Background in automation or machine learning techniques to support data validation and compliance.
• Experience delivering scalable data solutions in Agile environments.

$120,000 - $180,000 a year

#LI-HM1

#LC

Full-time regular employee offer package:

Pay within range listed + Bonus + Benefits + Equity

Temporary employee offer package:

Pay within range listed above + temporary benefits package (applicable after 60 days of employment)

Salary compensation is influenced by a wide array of factors including but not limited to skill set, level of experience, licenses and certifications, and specific work location. All offers are contingent on a cleared background and possible reference check. Military fellows and part-time employees are not eligible for benefits. Please speak to your talent acquisition representative for more information.

Shield AI is proud to be an equal opportunity workplace and is an affirmative action employer. We are committed to equal employment opportunity regardless of race, color, ancestry, religion, sex, national origin, sexual orientation, age, marital status, disability, gender identity or Veteran status. If you have a disability or special need that requires accommodation, please let us know.