Senior Data Analytics Engineer: Oracle DW & Power BI Lead

AeroVironment, Inc.; Simi Valley (CA); Hybrid; USD 101,000 - 153,000; Full time

Benefits offered by this job

Medical, dental, vision

401K with company matching

9/80 work schedule

Holiday shutdown

Job summary

AeroVironment, Inc. in Simi Valley, CA is seeking a Senior Data Analytics Engineer to design and optimize Oracle data warehouse schemas and build ETL pipelines to feed enterprise Power BI analytics and reporting.

The role requires 7+ years in Oracle development, SQL, and Power BI, with aerospace/defense experience preferred; collaboration with cross-functional teams and a focus on data quality and scalable solutions.

Qualifications

• Bachelor's degree in a technical field such as Information Systems, Software Engineering, Data Analysis, or related discipline.
• 7+ years of Oracle database development and data warehousing.
• 7+ years of SQL development experience including complex queries, stored procedures, and performance optimization.
• 5+ years of Power BI development creating dashboards, semantic models (with DAX calculations and Power Query).
• 7+ years of ETL/ELT pipeline development and data integration experience.
• 7+ years working collaboratively with cross-functional teams, providing both technical insights and strategic direction.
• Demonstrated experience in aerospace, defense, or manufacturing environments with exposure to supply chain, finance, shipments, and manufacturing shop floor operations.

Responsibilities

• Design, develop, and optimize Oracle data warehouse schemas, tables, and structures to support business intelligence requirements.
• Build and maintain ETL pipelines to extract, transform, and load data from multiple source systems into the enterprise data warehouse.
• Develop complex Power BI solutions including dashboards and semantic models.
• Perform SQL development for data manipulation, QA, and analysis.
• Design and document data models that balance performance, maintainability, scalability, and business requirements.
• Troubleshoot and resolve data quality issues, performance bottlenecks, and system integration challenges.
• Stay current with emerging technologies and best practices in data warehousing and business intelligence.

Skills

Oracle database development

SQL development

Power BI development

ETL/ELT pipeline development

Cross-functional collaboration

Data warehousing

Aerospace/defense domain knowledge

Education

Bachelor's degree in Information Systems / Software Engineering / Data Analysis

Master's degree in a related field (preferred)

Tools

Power BI

Oracle

Job description

AeroVironment, Inc. in Simi Valley, CA is seeking a Senior Data Analytics Engineer to design and optimize Oracle data warehouse schemas and build ETL pipelines to feed enterprise Power BI analytics and reporting.

The role requires 7+ years in Oracle development, SQL, and Power BI, with aerospace/defense experience preferred; collaboration with cross-functional teams and a focus on data quality and scalable solutions.