Data Engineer

Systems Planning & Analysis; Huntsville (AL); Hybrid; USD 76,000 - 152,000; Full time

Benefits offered by this job

Health insurance

Retirement plans

Paid time off

Job summary

Intrepid is seeking a Data Engineer to support Army Material Command, focusing on data management, analytics, and continuous audit readiness across finance processes. You will develop Python scripts, manage Databricks pipelines, and build Power BI dashboards to provide actionable insights for asset visibility and accountability.

The role requires experience with AWS Databricks and Microsoft Power Platform, plus a DoD security clearance.

Qualifications

• Bachelor’s Degree or 5+ years of relevant experience in IT, finance, or logistics.
• Strong Python, SQL, Dataverse, Power Platform, and Databricks skills.
• Active Secret DoD security clearance is required.

Responsibilities

• Create ad hoc Python scripts and SQL for data ingestion and transformation.
• Manage Databricks AWS Data Lake pipelines and data structures.
• Design Power BI dashboards and data models to support reporting.
• Collaborate with teams to modernize legacy environments and automate analytics.

Skills

Python

SQL

Dataverse

Power Apps

Power Automate

Databricks

Power BI

Education

Bachelor’s Degree or 5+ years experience

Job description

Overview

Intrepid, an SPA Company, brings more than 20 years of experience supporting the Department of Defense and U.S. Government, consistently setting the standard for excellence in the federal marketplace. Committed to advancing the mission of the U.S. Warfighter, Intrepid leverages technological superiority to deliver innovative solutions across air, space, land, and sea domains. We are proud to foster a collaborative, dynamic work environment, offering competitive compensation and an industry-leading 401k contribution. Our team is built through merit and achievement, and we’re always looking for the best and brightest to join us in our growth. We treat our people like family, we are mission-focused, and we give back! Join us today.

We are looking for a Data Engineer to join our team to support the Army Material Command. This position will be responsible for working with clients to strengthen their financial management processes, operations and systems, with a focus on maximizing the impact of the organization’s resources. Additionally, this position will provide data management, analysis, and visualization capabilities with the accounting and financial processes, creating continuous audit readiness as well as provide advisory and support on asset visibility and accountability, asset resolution, and disposition.

Responsibilities

Seeking an experienced Data Engineer to join our practice with a dedicated focus on military clients in the Defense & Security segment. This individual will have abig data architecturebackground,responsible forwriting new python scripts,running existing code/jobs,editingcomplex inter-related python scripts,runningGlue jobs(and other pipelines), implementing star-schema datamodels forPowerBI, designing PowerAutomate workflows, and other responsibilities with managing a Data Lake. The Data Engineer will collaborate with cross-functional teams to modernize legacy environments, and support advanced automations and analytics initiatives for our federal client.

Responsibilities include:

• Createad hocpython script/SQL codeor edit existing scriptsfor dataingestion or transformation.
• Manage pipelines in a large Databricks AWS Data Lake (via Databricks:S3 > Glue >S3 via SQL and Python).
• Restructure source data(implement a data model)and connection forPowerBIdashboards.
• Provide documentation or work with another team member to create documentation for products created.
• Analyze existing technical processes and systems toidentifygaps, recommend improvements, and support modernization initiatives.Gaps includeAWS environment size and scoping,opportunities for ML models, NLP models, connections to source data rather than uploaded data,PowerAutomateworkflows, in-built QA flags, etc.
• Support integration of advanced analytics and automation tools,leveragingplatforms such as Power BI, Qlik, Power Apps, and Databricks to improve reporting and decision-making.
• Design, configure, and develop custom solutions in Microsoft Power Platform using Power Apps, Power Automations, and Microsoft Dynamics 365.
• Troubleshoot and resolve issues in development and production environments tomaintainstable and reliable data pipelines.

Qualifications

Required Qualifications:

• Bachelor’s Degree or minimum 5 years or more of experience in Accounting, Finance, Information Technology, Logistics or Business Management.
• Strong Core Technological Skills in: Python, SQL, Microsoft Dataverse (CDS), Power Apps, Power Automate, Databricks,andPowerBI.
• Experience with data analytics, automation, and AI tools.
• Experience with ETL pipelines, integration of data sources, and big data processing.
• Experience refactoring and optimizing legacy code.
• Strong communicationand ability to synthesize complex information and deliver high-impact solutions in fast-paced environments.
• An active Secret DoD security clearance and the ability to maintain it throughout employment.

Desired Qualifications:

• Experience with Army financial systems, such as ADVANA, GFEBS, and LMP.
• Prior experience supporting federal audit readiness or CFO functions withinDoWor similar agencies.
• Experience in data visualization tools (e.g., Power BI, Qlik), familiarity with data platforms (e.g., Databricks), and cloud platforms (e.g., AWS, Azure).

Pay Range Information

At SPA, we strive to deliver a robust total compensation package that will attract and retain top talent. Elements of the compensation package include competitive base pay and variable compensation opportunities. SPA provides eligible employees with an opportunity to enroll in a variety of benefit programs, generally including health insurance, flexible spending accounts, health savings accounts, retirement savings plans, life and disability insurance programs, and a number of programs that provide for both paid and unpaid time away from work. The specific programs and options available to any given employee may vary depending on eligibility factors such as geographic location, date of hire, etc. Please note that the salary information shown below is a general guideline only. Salaries are commensurate with experience and qualifications, as well as market and business considerations. , Pay Transparency Salary range: USD $76,225.43/Yr. - USD $151,649.84/Yr.