Senior Power BI Data Architect

AV; Huntsville (AL); On-site; USD 91,000 - 139,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 Power BI Developer to lead the design and optimization of our data warehouse and enterprise BI analytics. You’ll bridge data engineering and business intelligence, collaborating with cross-functional teams to deliver actionable insights.

The role requires deep Power BI, SQL, and ETL proficiency, with exposure to aerospace/defense environments. A focus on data quality, performance, and scalable data models will be essential for supporting enterprise reporting needs.

Qualifications

• Bachelor's degree in a technical field (Info Systems, Software Eng, Data Analysis)
• 5-7 years hands-on Power BI, Oracle, Fabric pipeline development & data warehousing
• 5+ years dashboard design, templates, relational semantic models with DAX/Power Query
• 5+ years advanced SQL in complex queries, stored procedures, performance optimization
• 5+ years ETL/ELT pipeline development & data integration
• 5+ years cross-functional collaboration, with technical insights & strategic direction
• Experience in aerospace/defense/manufacturing with supply chain/finance/shipment/shop floor
• Strong analytical and problem-solving skills with attention to data accuracy
• Excellent communication and negotiation to translate tech concepts for non-tech
• Proven track record delivering data solutions driving business value

Responsibilities

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

Skills

Power BI

ETL/ELT pipelines

SQL development

Data modeling

Cross-functional teams

A&D domain

Data warehousing

Data quality

Communication

Problem solving

Education

Bachelor's degree

Master's degree

Tools

Power BI

Oracle

Fabric

SQL

Job description

AV is seeking a Senior Power BI Developer to lead the design and optimization of our data warehouse and enterprise BI analytics. You’ll bridge data engineering and business intelligence, collaborating with cross-functional teams to deliver actionable insights.

The role requires deep Power BI, SQL, and ETL proficiency, with exposure to aerospace/defense environments. A focus on data quality, performance, and scalable data models will be essential for supporting enterprise reporting needs.