Senior Oracle Data Warehouse & Power BI 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

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.