Senior Data Analytics Engineer

AeroVironment; Town of Florida (NY); On-site; USD 101,000 - 153,000; Full time

Benefits offered by this job

Medical benefits

Dental benefits

Vision benefits

401(k) with company match

9/80 work schedule

Paid holiday shutdown

Job summary

AeroVironment is seeking a Senior Data Analytics Engineer to develop and enhance an Oracle-based data warehouse to support enterprise-wide Power BI analytics and reporting. The successful candidate will bridge data engineering and business intelligence, collaborating with cross-functional stakeholders to deliver actionable insights across the organization.

The role designs, builds, and optimizes Oracle schemas, ETL pipelines, and Power BI dashboards to enable timely, accurate business decisions.

Qualifications

• 7+ years of Oracle data warehousing experience.
• 7+ years of SQL experience with complex queries and performance tuning.
• 5+ years of Power BI development creating dashboards and semantic models.
• 7+ years of ETL/ELT pipeline development and data integration.
• Experience in aerospace/defense/manufacturing environments preferred.

Responsibilities

• Design and optimize Oracle data warehouse schemas, tables, and structures.
• Build and maintain ETL pipelines from multiple sources into the warehouse.
• Develop Power BI dashboards and semantic models.
• Perform SQL development for data manipulation and QA.
• Design data models balancing performance and business needs.
• Troubleshoot data quality issues and performance bottlenecks.
• Stay current with data warehousing and BI best practices.

Skills

Oracle development

SQL development

Power BI

ETL/ELT pipelines

Data warehousing

Cross-functional collaboration

Analytical skills

Data modeling

Education

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

Master's degree in related field

Tools

Power BI

Job description

Simi Valley, CA

Albuquerque, NM

Germantown, MD

Sunrise, FL

Full time

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 Clearance

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.

The salary range for this role is:

$100,500 - $153,250

AeroVironment 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.

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.

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.

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 include 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.

Careers at AeroVironment (https://www.avinc.com/careers/our-team)