Senior Data Analytics Engineer: Oracle DW & Power BI

AV; Germantown (MD); On-site; USD 101,000 - 153,000; Full time

Benefits offered by this job

Medical

Dental

Vision

401K with company matching

9/80 work schedule

Paid holiday shutdown

Job summary

AV is seeking a Senior Data Analytics Engineer to design and optimize an Oracle-based data warehouse and enable 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 expertise, strong Power BI skills, and experience building robust ETL pipelines while ensuring data quality and performance.

Qualifications

• Bachelor's degree in a technical field (Information Systems, Software Engineering, Data Analysis, or related).
• 7+ years Oracle database development and data warehousing experience.
• 7+ years advanced SQL experience with complex queries, stored procedures, and optimization.
• 5+ years Power BI development: dashboards and semantic models (DAX, Power Query).
• 7+ years ETL/ELT pipeline development and data integration experience.
• 7+ years cross-functional collaboration delivering technical insights and direction.

Responsibilities

• Design, develop, and optimize Oracle data warehouse schemas 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, QA, and analysis.
• Design data models balancing performance and business requirements.
• Troubleshoot data quality issues and performance bottlenecks.
• Stay current with data warehousing and BI best practices.

Skills

Oracle data warehousing

Advanced SQL

Power BI development

ETL/ELT pipelines

Cross-functional collaboration

Data quality

Business insights

Analytical problem-solving

Education

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

Master's degree (desired)

Tools

Power BI

Oracle

SQL

Job description

AV is seeking a Senior Data Analytics Engineer to design and optimize an Oracle-based data warehouse and enable 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 expertise, strong Power BI skills, and experience building robust ETL pipelines while ensuring data quality and performance.