Data Engineer/Analyst Job at Advanced Structural Technologies, Oxnard, CA

dDVMc2hBYzRSVXpwTUVTSk5wYzNJYlFvS1E9PQ==
  • Advanced Structural Technologies
  • Oxnard, CA

Job Description

Job Description

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

  • Operations Performance Dashboards: Real-time metrics for yield, scrap, and efficiency by department
  • Labor Utilization Model: Track labor cost allocation and employee efficiency across departments
  • Executive Dashboards: Weekly summaries of company-wide output, backlog, cost, and revenue
  • Job Costing Tools: Compare estimated vs. actual costs by job, part, and customer
  • HR & Recruiting Reports: Track hiring pipelines, turnover, tenure, and training effectiveness
  • APS Readiness Audits: Prepare ERP system data for scheduling integration and optimization
  • Scheduling & Capacity Models: Visualize schedule adherence and forecast workload by work center

Qualifications

  • Bachelor’s degree in Computer Science, Data Analytics, Information Systems, Engineering, or related field
  • 3–5 years of experience in a data engineer, data analyst, or business intelligence role
  • Strong proficiency in SQL, data wrangling, and building automated data pipelines (ETL)
  • Familiarity with ERP systems, relational databases, APIs, and scheduling tools
  • Experience with Power BI, Tableau, or similar dashboarding tools
  • Understanding of manufacturing operations, job costing, inventory systems, and production metrics preferred
  • Strong analytical thinking and the ability to translate complex datasets into actionable insights
  • Effective communicator able to work across multiple departments to align data strategy with business goals
  • Passion for accuracy, automation, and continuous improvement

Why Join AST?

  • Competitive pay
  • Medical, Dental, and Vision Insurance
  • 401(k) Savings Plan
  • Company-Sponsored Life Insurance
  • Short-term and Long-term Disability Coverage
  • Paid Holidays
  • Paid Vacation and Sick Leave

Job Type & Pay

  • Job Type : Full-Time, In-Person
  • Pay Range: $85,000 — $115,000 per year (commensurate with experience)

Hours & Schedule

  • Schedule: Monday – Friday
  • Expected Hours: Flexibility required for deadlines or executive presentations

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.

Job Tags

Full time, Temporary work, Work at office, Monday to Friday, Shift work,

Similar Jobs

Mutual of Omaha Mortgage

Experienced Loan Officer - Consumer Direct Job at Mutual of Omaha Mortgage

 ...service lending division offering a complete line of residential mortgage, refinancing, and specialty loans. We employ a knowledgeable staff of experienced Loan Officers with an operations team that is second to none. By constantly updating our loan programs and pricing... 

Smugglers Notch Resort

HVAC/Gas Technician Job at Smugglers Notch Resort

 ...HVAC/Gas Technician As a HVAC/Gas Tech at Smugglers' Notch Resort, you will be responsible for assembling, installing, and repairing heating, ventilation, and air conditioning systems. This role also includes maintaining and repairing machinery, equipment, plumbing... 

Third Party CS

Customer Service Representative Job at Third Party CS

 ...) Excellent retirement plan Tremendous upward mobility into other positions and management Flexible hours Remote Position(s) available (work from home) Benefits Health Insurance (dental and vision included) Excellent retirement plan Tremendous upward... 

TridentCare

General/File Clerk- Cash Dept Job at TridentCare

 ...Includes cleaning company, real estate management company etc. Assist with the organization of on-site meetings Performs other...  ...a competitive wage and robust benefit package to full time employees . Part time employees are eligible for many of the same below, pro-... 

Provider Solutions & Development

Sleep Medicine Physician (Spokane) Job at Provider Solutions & Development

 ...Providence is currently seeking a highly skilled and dedicated Sleep Medicine Physician to join its team in Spokane Valley, Washington. Seeking a board-certified/board-eligible Sleep Medicine physician with a preference for Sleep fellowship-trained individuals. This position...