Senior Data Analytics Engineer

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

Benefits offered by this job

Medical

Dental

Vision

401K with company matching

9/80 schedule

Paid holiday shutdown

Job summary

AV is seeking a Senior Data Analytics Engineer to design and enhance our Oracle-based data warehouse to support enterprise-wide Power BI analytics and reporting. You will bridge technical data engineering and business intelligence while collaborating with cross-functional stakeholders to deliver actionable insights.

The role involves building scalable ETL pipelines, optimizing data models, and delivering dashboards and semantic models.

Qualifications

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

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 DB

SQL

Power BI

ETL/ELT

Data warehousing

Cross-functional

Data quality

Communication

Aerospace/defense domain

Problem solving

Education

Bachelor's degree in a technical field

Master's degree in a related field

Job description

Job Description

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.

Worker Type

Regular

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

The Salary Range For This Role Is

$100,500 - $153,250

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

• medical
• dental
• vision
• 401K with company matching
• a 9/80 work schedule
• 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.