Sr Principal Data Insight Analyst

RELOCATION ASSISTANCE: No relocation assistance available CLEARANCE REQUIRED FOR START: No CLEARANCE TYPE: Secret TRAVEL: Yes, 10% of the Time Description 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 Responsibilitie s • 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 compar