Sr Principal Data Insight Analyst

RELOCATION ASSISTANCE: No relocation assistance available

CLEARANCE REQUIRED FOR START: No

CLEARANCE TYPE: Secret

TRAVEL: Yes, 10% of the TimeDescription

At Northrop Grumman, our employees have incredible opportunities to work on revolutionary systems that impact people's lives around the world today, and for generations to come. Our pioneering and inventive spirit has enabled us to be at the forefront of many technological advancements in our nation's history - from the first flight across the Atlantic Ocean, to stealth bombers, to landing on the moon. We look for people who have bold new ideas, courage and a pioneering spirit to join forces to invent the future, and have fun along the way. Our culture thrives on intellectual curiosity, cognitive diversity and bringing your whole self to work — and we have an insatiable drive to do what others think is impossible. Our employees are not only part of history, they're making history.

Northrop Grumman Aeronautics Systems is seeking a Principal Data Insight Analyst or Senior Principal Data Insight Analyst to modernize and help lead a large, business-critical analytics and data solution supporting F-35 material cost estimating for a multi-year procurement proposal. The current environment includes Power BI and related Microsoft data technologies, but the selected candidate will help evaluate and implement the architecture, platforms, and engineering practices best suited to long-term business needs.

The position is 100% onsite in Redondo Beach, California. No Relocation is provided!

Key Responsibilities

• Assess the current analytics implementation, document data lineage and dependencies, identify technical debt and failure points, and contribute to or lead a phased modernization roadmap that sustains active estimating operations
• Design, build, and optimize scalable analytical data products, including semantic models, data pipelines, governed datasets, calculations, reports, and decision-support capabilities
• Diagnose and resolve capacity, memory, refresh, query-performance, reliability, and data-volume issues through architecture improvements, data reduction, efficient transformation patterns, and model redesign·        
• Evaluate the current technology stack and recommend appropriate tools and architecture based on scalability, maintainability, security, performance, governance, and business continuity·        
• Develop, refactor, and optimize complex analytical calculations and data transformations while removing brittle workarounds and unnecessary solution complexity        
• Design and maintain repeatable SQL-based data-integration and ETL processes to ingest, transform, reconcile, and publish data from enterprise and estimating sources        
• Create governed model definitions, naming conventions, calculation standards, source-to-target mappings, and technical documentation; support controlled change processes        
• Apply source control, peer review, testing, deployment, release-management, and rollback practices to analytics models, SQL, Python, and supporting automation artifacts·        
• Partner primarily with F-35 material estimators, with cross-functional support from Global Supply Chain, Pricing, Scheduling, Finance, and technical teams, to translate business requirements into durable analytical capabilities
• Provide hands-on technical leadership appropriate to the selected level, participate in code and model reviews, mentor analysts and developers, and promote sustainable analytics-engineering practices across the department

Basic Qualifications

• Must either have a bachelor’s degree in Data/Analytics, Computer Science, Information Systems, Engineering, Mathematics, Business, Finance with 8 years experience OR a master's degree in Data/Analytics, Computer Science, Information Systems, Engineering, Mathematics, Business, Finance with 6 years experience OR a PhD degree in Data/Analytics, Computer Science, Information Systems, Engineering, Mathematics, Business, Finance with 4 years experience
• Advanced experience designing, developing, and optimizing complex enterprise analytics solutions using Power BI, Microsoft Fabric, Azure data services, SQL-based platforms, data lakes, lake houses, or comparable business-intelligence and analytics technologies
• Demonstrated experience modernizing a large or technically complex analytics solution while maintaining continuity for active business operations
• Strong SQL skills, including developing and optimizing complex queries, transformations, views, stored procedures, and data-validation logic against large datasets        
• Demonstrated knowledge of dimensional modeling, star schemas, data granularity, slowly changing dimensions, aggregation strategies, data lineage, and semantic-layer design        
• Experience diagnosing and correcting model-capacity, memory-consumption, query-performance, refresh-reliability, or dataset-size problems        
• Experience integrating multiple structured data sources into repeatable analytics pipelines and reconciling results to authoritative sources        
• Experience implementing data-quality checks, testing, version control, documentation, and controlled deployment practices for production analytical products        
• Ability to lead the translation of complex business requirements into technical designs, analytical models, and actionable insights and to communicate architecture and trade-offs to stakeholders and technical teams        
• Advanced proficiency with Microsoft Excel, including analysis of large datasets and use of Power Query, pivot tables, and other advanced functions
• Must be a US Citizen and have the ability to obtain and maintain a Secret clearance within a reasonable amount of time as determined by business needs

Preferred Qualifications

• Experience with Power BI, DAX, Power Query/M, semantic models, relationships, security, refresh design, performance tuning, deployment pipelines, gateways, capacity administration, XMLA endpoints, Tabular Editor, DAX Studio, Performance Analyzer, or comparable model-development and diagnostic tools. These technologies are part of the current environment        
• Experience with Microsoft Fabric, Azure data services, SQL Server, dataflows, data lakes, lake houses, or other modern analytics platforms        
• Experience using Python, PowerShell, C#, VBA, or similar technologies to automate data processing, validation, testing, or administrative tasks        
• Experience with Git and Azure DevOps or comparable source-control, work-management, code-review, and CI/CD platforms       
• Experience developing row-level or object-level security, governed datasets, certified semantic models, and reusable self-service analytics capabilities        
• Experience applying Agile methods to analytics-product development and managing modernization work through incremental, testable releases        
• Demonstrated ability to introduce innovative data-modeling and analytics approaches while balancing schedule, usability, governance, and business continuity·        
• Experience supporting aerospace and defense programs, government contracting, Global Supply Chain, material cost estimating, pricing, procurement·        
• Knowledge of FAR Part 15, applicable DFARS requirements, and compliant proposal estimates and supporting documentation
• Experience with SAP S/4HANA data, supplier proposals and quotes, PCARs, LTAs, purchase-order actuals and history, BOMs/CBOMs, demand, and Basis of Estimate details

Primary Level Salary Range: $129,300.00 - $193,900.00

The above salary range represents a general guideline; however, Northrop Grumman considers a number of factors when determining base salary offers such as the scope and responsibilities of the position and the candidate's experience, education, skills and current market conditions.

Depending on the position, employees may be eligible for overtime, shift differential, and a discretionary bonus in addition to base pay. Annual bonuses are designed to reward individual contributions as well as allow employees to share in company results. Employees in Vice President or Director positions may be eligible for Long Term Incentives. In addition, Northrop Grumman provides a variety of benefits including health insurance coverage, life and disability insurance, savings plan, Company paid holidays and paid time off (PTO) for vacation and/or personal business.

The application period for the job is estimated to be 20 days from the job posting date. However, this timeline may be shortened or extended depending on business needs and the availability of qualified candidates.

Northrop Grumman is an Equal Opportunity Employer, making decisions without regard to race, color, religion, creed, sex, sexual orientation, gender identity, marital status, national origin, age, veteran status, disability, or any other protected class. For our complete EEO and pay transparency statement, please visit http://www.northropgrumman.com/EEO. U.S. Citizenship is required for all positions with a government clearance and certain other restricted positions.