Senior Data Analytics Engineer

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

## Senior Data Analytics EngineerApply: Simi Valley, CA: Albuquerque, NM: Germantown, MD: Sunrise, FL: Full time: Posted 9 Days Ago: 8432**Worker Type**Regular**Job Description****Summary** The Senior Data Analytics Engineer role will be critical in developing and enhancing our Oracle-based data warehouse infrastructure to support enterprise-wide Power BI analytics and reporting. The ideal candidate will bridge the gap between technical data engineering and business intelligence, working closely with cross-functional stakeholders to deliver actionable insights. **Position 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**Basic Qualifications (Required Skills & Experience)*** Bachelor's degree in a technical field such as Information Systems, Software Engineering, Data Analysis, or related discipline* 7+ years of hands-on experience with Oracle database development and data warehousing* 7+ years of advanced SQL experience including complex queries, stored procedures, and performance optimization* 5+ years of Power BI development experience 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* Strong analytical and problem-solving skills with attention to data accuracy and quality* Excellent communication and negotiation skills with the ability to translate technical concepts for non-technical stakeholders* Proven track record of delivering data solutions that drive business value**Other Qualifications & Desired Competencies*** Master's degree in a related field* Experience with modern data stack tools and technologies* Knowledge of data governance frameworks and practices* Certification in Power BI or Oracle technologies* Experience with Agile/Scrum methodologies**Physical Demands*** Ability to work in an office environment (Constant)* Required to sit and stand for long periods; talk, hear, and use hands and fingers to operate a computer and telephone keyboard (Frequent)**Clearance Level**No ClearanceThe salary range for this role is:$100,500 - $153,250AeroVironment considers several factors when extending an offer, including but not limited to, the location, the role and associated responsibilities, a candidate’s work experience, education/training, and key skills.**ITAR Requirement:***This position requires access to information that is subject to compliance with the International Traffic Arms Regulations (“ITAR”) and/or the Export Administration Regulations (“EAR”). In order to comply with the requirements of the ITAR and/or the EAR, applicants must qualify as a U.S. person under the ITAR and the EAR, or a person to be approved for an export license by the governing agency whose technology comes under its jurisdiction. Please understand that any job offer that requires approval of an export license will be conditional on AeroVironment’s determination that it will be able to obtain an export license in a time frame consistent with AeroVironment’s business requirements. A “U.S. person” according to the ITAR definition is a U.S. citizen, U.S. lawful permanent resident (green card holder), or protected individual such as a refugee or asylee. See 22 CFR § 120.15. Some positions will require current U.S. Citizenship due to contract requirements.***Benefits**: AV offers an excellent benefits package including medical, dental vision, 401K with company matching, a 9/80 work schedule and a paid holiday shutdown. For more information about our company benefit offerings please visit: http://www.avinc.com/myavbenefits.We also encourage you to review our company website at http://www.avinc.com to learn more about us.Principals only need apply. NO agencies please.**About AV:****AV isn’t for everyone. We hire the curious, the relentless, the mission-obsessed. The best of the best.**We don’t just build defense technology—we redefine what’s possible. As the premier autonomous systems company in the U.S., AV delivers breakthrough capabilities across air, land, sea, space, and cyber. From AI-powered drones and loitering munitions to integrated autonomy and space resilience, our technologies shape the future of warfare and protect those who serve.Founded by legendary innovator Dr. Paul MacCready, AV has spent over 50 years pushing the boundaries of what unmanned systems can do. Our heritage includes seven platforms in the Smithsonian—but we’re not building history, we’re building what’s next.**If you're ready to build technology that matters—with speed, scale, and purpose—there’s no better place to do it than AV.** *We are proud to be an EEO/AA Equal Opportunity Employer, including disability/veterans. AeroVironment, Inc. is an Equal Employment Opportunity (EEO) employer and welcomes all qualified applicants. Qualified applicants will receive fair and impartial consideration without regard to race, sex, color, religion, national origin, age, disability, protected veteran status, genetic data, sexual orientation, gender identity or other legally protected status.***ITAR**U.S. Citizen, U.S. Permanent Resident (Green Card holder), asylee/refugee status as defined by 8 U.S.C. 1324b(a)(3) or a person approved for an export license from the appropriate governing agency.