Data Engineer- HSV, AL (Contingent on Award)

Job Description

Job Description

Davidson is distinguished in the aerospace and missile defense industry, in part, because of its excellence in hiring exceptional experts, engineers and software developers dedicated to delivering advanced, intelligent technology solutions in defense of our nation.
Davidson is seeking a Data Engineer to support the SCALE (Supply Chain Analytics and Logistics Environment) development program in Huntsville, AL. This role is an integral part of a high-visibility, cross-functional team driving data transformation for defense supply chain analytics. The successful candidate will help design, develop, and operationalize data pipelines, visual analytics, and reporting systems that enhance decision-making across procurement, logistics, and forecasting operations.
The SCALE program integrates Power BI, SQL-based databases, and advanced data modeling to enable real-time visibility, predictive insights, and AI-ready analytics. The ideal candidate will have a strong background in data visualization, data integration, and database design within an Agile environment.

Job Responsibilities:
•Develop, maintain, and optimize Power BI dashboards and data models to deliver actionable insights for internal and external stakeholders.
•Design and manage relational databases and data pipelines to integrate data from multiple sources, ensuring integrity, consistency, and traceability.
•Collaborate with the product team, software developers, and cybersecurity personnel to define data schemas and align reporting with system architecture
•Perform ETL (Extract, Transform, Load) operations and automate data refresh processing using Power Query, SQL and related tools.
•Conduct exploratory data analysis (EDA) to identify trends, anomalies, and optimization opportunities across procurement and logistics data.
•Support the design of data governance standards, ensuring compliance with IL5/CUI and DOD data security requirements.
•Participate in Agile ceremonies (backlog refinement, sprint planning, reviews, retrospectives) to ensure data tasks are properly scoped and aligned with product goals.

Job Qualifications:
•Bachelor's degree in Data Analytics, Computer Science, Information Systems, Mathematics, or related discipline.
•Minimum of 4 years of experience as a Data Analyst/Engineer, ideally in a DOD, logistics, or supply chain environment.
•Strong proficiency in Power BI (including DAX, Power Query, and data modeling)
•Proficiency with SQL for data extraction, transformation, and relational schema design.
•Experience with database systems such as SQL Server, PostgreSQL, and Amazon RDS
•Experience with Python or similar languages
•Ability to derive meaningful insights from large, complex datasets and communicate them visually and verbally.
•Strong understanding of data lifecycle management, version control, and collaborative development practices.

Desired Competencies:
•Experience building star schemas and fact/dimension models to support BI reporting.
•Familiarity with data engineering workflows, including ETL orchestration and API-based data integration.
•Experience working with AWS, Azure, or other cloud-based analytics platforms.
•Familiarity with machine learning pipelines and preparing data for AI/ML analytics.
•Experience applying Agile and Scrum methodologies in data analytics projects.
•Familiarity with DOD data classification and cybersecurity frameworks (CUI, ILs, RMF)

Clearance:
•Must currently hold or be able to obtain a Secret security clearance (not required to start)