Data Engineer

Intrepid, an SPA Company, supports the Department of Defense and U.S. Government by delivering technology and mission-focused solutions across air, space, land, and sea domains. The Data Engineer will support Army Material Command by developing and managing data pipelines, data models, analytics, visualizations, and automation solutions while helping modernize legacy environments and strengthen financial management processes.

Responsibilities:

• Create ad hoc python script/SQL code or 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 for PowerBI dashboards
• Provide documentation or work with another team member to create documentation for products created
• Analyze existing technical processes and systems to identify gaps, 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, PowerAutomate 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 to maintain stable and reliable data pipelines

Requirements:

• 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, and PowerBI
• 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 high-impact solutions in fast-paced environments
• An active Secret DoD security clearance and the ability to maintain it throughout employment
• Experience with Army financial systems, such as ADVANA, GFEBS, and LMP
• Prior experience supporting federal audit readiness or CFO functions within DoW or 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)