Senior Power BI Architect — Enterprise Analytics

AV; San Diego (CA); On-site; USD 91,000 - 139,000; Full time

Benefits offered by this job

Medical insurance

Dental insurance

Vision insurance

401K with company matching

9/80 work schedule

Paid holiday shutdown

Job summary

AV is seeking a Senior Power BI Developer to design and enhance our data warehouse infrastructure and enterprise BI analytics. You will bridge data engineering and BI, working with stakeholders to deliver actionable insights.

Responsibilities include designing dashboards, ETL pipelines, SQL development, and data modeling, with a focus on performance and data quality in aerospace/defense contexts. Applicants should reside near San Diego or be commutable.

Qualifications

• Bachelor's degree in a technical field such as Information Systems, Software Engineering, Data Analysis, or related discipline.
• 5-7 years of hands‑on experience with Power BI, Oracle, Fabric pipeline development and data warehousing.
• 5+ years experience with dashboard design, template creations, relational semantic models (with DAX calculations and Power Query).
• 5+ years of advanced SQL experience including complex queries, stored procedures, and performance optimization.
• 5+ years of ETL/ELT pipeline development and data integration experience.
• 5+ years working collaboratively with cross‑functional teams, providing both technical insights and strategic direction.

Responsibilities

• Design, develop, and optimize Power BI dashboards and data warehouse schemas.
• Build and maintain ETL pipelines to load data into the data warehouse from multiple sources.
• Perform SQL development for data manipulation, QA, and analysis.
• Design and document data models balancing performance and business requirements.
• Troubleshoot data quality issues, bottlenecks, and system integration challenges.
• Stay current with emerging technologies and best practices in data warehousing and BI.

Skills

Power BI

Data Warehousing

ETL/ELT pipelines

SQL

Data Modeling

Cross-functional Collaboration

Aerospace/Defense domain knowledge

Education

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

Master's degree (preferred)

Tools

Power BI

Oracle

Fabric

Job description

AV is seeking a Senior Power BI Developer to design and enhance our data warehouse infrastructure and enterprise BI analytics. You will bridge data engineering and BI, working with stakeholders to deliver actionable insights.

Responsibilities include designing dashboards, ETL pipelines, SQL development, and data modeling, with a focus on performance and data quality in aerospace/defense contexts. Applicants should reside near San Diego or be commutable.