Senior Oracle Data Warehouse Engineer - Power BI & ETL

AV; Albuquerque (NM); On-site; USD 97,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 optimize an Oracle-based data warehouse that powers enterprise-wide Power BI analytics. You will bridge data engineering and business intelligence, collaborating with cross-functional stakeholders to deliver actionable insights.

The role requires extensive Oracle, SQL, and ETL experience, plus Power BI development and data modeling. You'll join a team focused on data quality, performance, and scalable analytics in a defense/aerospace

Qualifications

• 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

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

SQL

Power BI

ETL/ELT

cross-functional

data warehousing

data quality

communication

problem solving

aerospace

Education

Bachelor's degree (technical)

Master's degree

Tools

Oracle Database

ETL tools

Power Query

Job description

AV is seeking a Senior Data Analytics Engineer to design and optimize an Oracle-based data warehouse that powers enterprise-wide Power BI analytics. You will bridge data engineering and business intelligence, collaborating with cross-functional stakeholders to deliver actionable insights.

The role requires extensive Oracle, SQL, and ETL experience, plus Power BI development and data modeling. You'll join a team focused on data quality, performance, and scalable analytics in a defense/aerospace