Senior Data Analytics Engineer: Oracle DW & Power BI Lead

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

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.