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, 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 implementation, and business systems in a regulated defense and aerospace environment where controlled, export-controlled, and proprietary data must be protected in accordance with 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 works with department leaders, program managers, site general managers, and IT to develop reporting and analytics solutions. The role also supports end users, maintains documentation and data quality standards, and provides metrics and evidence for customer, government, and internal reviews and audits. Employment is contingent upon completion of required pre-employment screenings. The employee must be able to travel on short notice as business needs dictate.

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 with Microsoft 365, including SharePoint, Lists, Teams, and Power Automate.
• Proficiency in data integration using REST APIs.
• Proficiency with work management platforms such as Monday.com.
• Proficiency with process-mapping and diagramming software such as Visio, as well as 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; and present information and respond to questions from executives, managers, customers, and employees.
• Ability to apply descriptive and inferential statistics, probability, forecasting, and trend analysis, and to use fractions, percentages, ratios, and proportions in practical situations.
• 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.
• 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.
• Ability to travel on short notice as business needs dictate.
• Successful completion of required pre-employment screenings, which may include a background check and drug screening, in accordance with applicable laws and company policies.

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 in Microsoft 365 GCC High for leadership, program managers, and site general managers.
• Develop, maintain, and report core operational metrics and KPIs for operations, production, quality, finance, and support functions in coordination with department leaders.
• Gather, clean, transform, and validate data from maintenance and production systems, ERP, Microsoft 365 and SharePoint, helpdesk, and other 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 to replace manual and spreadsheet-based reporting.
• Administer and maintain Monday.com workspaces, boards, workflows, automations, dashboards, and user access; support users across departments and sites.
• Integrate Monday.com with Power BI using the Monday.com API to support program status, schedule, and performance reporting.
• Lead the transition of program tracking from Monday.com to company-managed solutions, including extracting, validating, and archiving historical data in a permanent internal repository.
• Maintain equivalent program-tracking functionality, reporting, and user access during the transition from Monday.com.
• 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 for the new system.
• Analyze processes across departments and sites 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; track and report results.
• Perform trend, variance, and root cause analysis on operational data, including labor hours, turn times, schedule performance, and cost.
• Conduct 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.
• Protect CUI, ITAR export-controlled information, and proprietary customer data in accordance with company policies and NIST SP 800-171, CMMC, and DFARS requirements; restrict 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.

What This Job Offers

• Job Type: Full-time