Data Engineer / Analyst

About Us

Advanced Structural Technologies (AST) is a leading manufacturer specializing in forged, flow-formed, and machined products for the aerospace, defense, and automotive industries. With over 25 years of experience, AST has built a strong reputation for precision engineering, innovation, and high-quality manufacturing.

Located in Oxnard, California, AST operates out of cutting-edge facilities spanning over 250,000 sq. ft., including a dedicated 70,000+ sq. ft. building focused on aerospace and space product manufacturing. AST employs approximately 185 skilled professionals across multi-shift operations, ensuring efficiency, precision, and timely delivery for mission-critical industries.

Position Overview

We are seeking a self-driven and technically skilled Data Engineer / Analyst to lead AST's data infrastructure and reporting initiatives. This hybrid role will be responsible for designing and building scalable pipelines to extract data from operational systems, while also analyzing and visualizing key metrics that support business decisions. This person will serve as the cornerstone of AST's growing data and business intelligence efforts—building the foundation for digital transformation across operations, production, finance, quality, and HR.

The ideal candidate is comfortable getting into the technical details of data engineering (ETL, databases, APIs) while also understanding the business context behind the data to deliver impactful reports, dashboards, and insights.

Key Responsibilities

• Design, build, and maintain automated pipelines to extract data from ERP, scheduling, quality, maintenance, and HR systems
• Partner with internal stakeholders to understand data needs and translate them into clean, structured datasets and visual dashboards
• Develop SQL queries and scripts to transform and normalize raw data from multiple sources
• Build and manage databases or data warehouses to support long-term storage and reporting
• Create executive dashboards and department-level reporting tools using Power BI, Tableau, or similar platform
• Perform ad-hoc and recurring data analyses to support production, labor planning, job costing, inventory tracking, and performance KPIs
• Identify gaps in existing data systems and propose architectural improvements to enhance visibility and automation
• Work closely with IT, Operations, Finance, and Engineering to ensure accurate and consistent data definitions across the organization
• Help prepare AST for future business intelligence tools, APS system integration, and predictive analytics initiatives
• Document processes, maintain data dictionaries, and implement data validation procedures to ensure accuracy and reliability
• Support forecasting, budget modeling, and long-term planning with clean historical datasets

Key Projects & Deliverables

Qualifications

Why Join AST?

Job Type & Pay

Full-Time, In-Person

Hours & Schedule

If you are a data-driven problem solver with a passion for manufacturing and business impact, we encourage you to apply and be part of AST's journey toward smarter, faster, and more connected operations.