Data Analyst

KING AEROSPACE•Addison, TX

11d•Onsite

About The Position

The Data Analyst collects, transforms, analyzes, and reports company data to support decision-making across King Aerospace’s operations, programs, and support functions. The role designs and maintains Power BI dashboards and key performance metrics for company leadership, develops automated data pipelines to replace manual and spreadsheet-based reporting, and leads process improvement initiatives across departments and sites. It supports program tracking, ERP, and business systems initiatives in a regulated defense and aerospace environment, protecting controlled, export-controlled, and proprietary data according to government and customer requirements. The position is based at the Addison, Texas facility and requires travel to other company locations as needed. The Data Analyst builds and maintains dashboards, datasets, data models, transformations, metrics, integrations, and reporting solutions; administers Monday.com program-tracking tools; and supports the transition from Monday.com to company-managed solutions. The role also contributes to ERP implementation, analyzes and documents business processes, recommends and facilitates process improvements, and prepares analysis and reporting for leadership, customers, government reviews, and audits. It partners with department managers and site leadership, trains end users, maintains technical documentation, and evaluates analytics and automation tools subject to company approval. The role requires advanced proficiency in Power BI, Excel, SQL and relational database concepts, Microsoft 365, REST API integrations, Monday.com, and process-mapping software. A bachelor’s degree in a relevant field is preferred, or three years of data analysis or business intelligence experience, or an equivalent combination of education and experience. The candidate must have a valid driver’s license and be a U.S. Person as defined by ITAR. The candidate must be able to obtain and maintain a U.S. Department of Defense security clearance if required by customer programs. Employment is contingent upon required pre-employment screenings. The work is primarily office-based, with possible work in aircraft hangar and shop environments.

Requirements

Bachelor’s degree in Data Analytics, Business Analytics, Information Systems, Computer Science, Industrial Engineering, Statistics, or a related field; alternatively, three years of data analysis or business intelligence experience, or an equivalent combination of education and experience.
Advanced proficiency in Microsoft Power BI, including Power Query, DAX, data modeling, and Power BI Service.
Advanced proficiency in Microsoft Excel, including PivotTables, advanced formulas, and Power Pivot.
Proficiency in SQL and relational database concepts.
Proficiency in Microsoft 365, including SharePoint, Lists, Teams, and Power Automate.
Proficiency with data integration using REST APIs.
Proficiency with work management platforms such as Monday.com.
Proficiency with process mapping and diagramming software such as Visio, and spreadsheet, presentation, and word-processing software.
Ability to read, analyze, and interpret business reports, technical documentation, and governmental regulations; write reports, business correspondence, and procedure manuals; communicate complex analysis clearly to non-technical audiences; present information and respond to questions from executives, managers, customers, and employees.
Ability to apply descriptive and inferential statistics, probability, forecasting, trend analysis, and practical mathematical concepts such as fractions, percentages, ratios, and proportions.
Ability to define problems, collect data, establish facts, draw valid conclusions, and interpret technical instructions in mathematical or diagram form while handling abstract and concrete variables.
Valid driver’s license required.
Must be a U.S. Person as defined by ITAR (22 CFR 120.62) due to access to export-controlled information.
Must be able to obtain and maintain a U.S. Department of Defense security clearance if required by customer programs.
Must complete required pre-employment screenings, which may include a background check and drug screening.
Must be able to travel on short notice as business needs dictate.

Nice To Haves

Experience administering, building, or reporting from Monday.com.
Microsoft Certified: Power BI Data Analyst Associate (PL-300) or a similar business intelligence certification.
Lean Six Sigma Green Belt or other process improvement training or certification.
Experience in an aviation maintenance, repair and overhaul (MRO), manufacturing, or defense contractor environment.
Experience with ERP system data, reporting, or implementation.
Familiarity with Python or R, Power Apps, Microsoft Fabric, and Microsoft 365 GCC High.

Responsibilities

Design, develop, publish, and maintain Power BI dashboards and reports for company leadership, program managers, and site general managers.
Develop, maintain, and report operational metrics and KPIs for operations, production, quality, finance, and support functions in coordination with department leaders.
Gather, clean, transform, and validate data from company systems and operational sources.
Build and maintain data models, Power Query transformations, and DAX measures, ensuring report and dataset accuracy, consistency, and performance.
Develop and maintain automated data pipelines and integrations using APIs, dataflows, and scheduled refreshes.
Administer and support Monday.com workspaces, boards, workflows, automations, dashboards, and user access.
Develop Monday.com API integrations with Power BI for program status, schedule, and performance reporting.
Lead the transition of program tracking from Monday.com to company-managed solutions, including extraction, validation, and archival of historical data.
Maintain program-tracking continuity during the transition, including equivalent functionality, reporting, and user access.
Design and support program-tracking and reporting solutions for aircraft maintenance, modification, and government contract programs.
Support ERP implementation by mapping departmental workflows, defining reporting requirements, supporting data migration and validation, and building analytics.
Analyze business processes to identify inefficiencies, bottlenecks, and improvement opportunities.
Document current-state and future-state processes, including process maps, workflow diagrams, and standard operating procedures.
Recommend, plan, and facilitate process improvement initiatives using Lean, Six Sigma, or similar methodologies, and track and report results.
Perform trend, variance, and root-cause analysis on operational data, including labor hours, turn times, schedule performance, and cost.
Perform ad hoc analysis and prepare reports, summaries, and presentations for leadership.
Establish and maintain data quality standards, data definitions, and a data dictionary; identify and resolve data integrity issues with system owners.
Manage Power BI workspaces, apps, dataset refresh schedules, and report access permissions in coordination with IT.
Handle CUI, export-controlled (ITAR), and proprietary customer data in accordance with company policies and applicable requirements, restricting reports and datasets to authorized users.
Use analytics, automation, and AI tools only in approved, compliant environments and in accordance with company policies.
Support preparation of data, metrics, and evidence for customer, government, and internal reviews and audits.
Partner with department managers and site leadership to translate business questions into reporting and analysis requirements.
Train and support end users on dashboards, reports, and self-service analytics tools; develop user guides and training materials.
Evaluate and recommend analytics, reporting, and automation tools, subject to company review and approval.
Maintain documentation for data sources, data models, reports, and pipelines.
Travel to other company locations as needed to meet stakeholders, observe operations, and support process improvement initiatives.
Perform other related duties as assigned.