Data Engineer

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.

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 for writing new python scripts,running existing code/jobs,editing complex inter-related python scripts,running

Glue jobs(and other pipelines), implementing star-schema data models forPowerBI, designing Power Automate 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 scripts for data ingestion 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 include AWS environment size and scoping,opportunities for ML models, NLP models, connections to source data rather than uploaded data,Power Automate workflows, in-built QA flags, etc.
• Support integration of advanced analytics and automation tools,leveraging platforms 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.

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 communication and ability to synthesize complex information and deliver…