Data Analyst

Data Analyst# Data Analyst Home Office - Addison, TX 75001## Description
** POSITION DESCRIPTION
***
* Job Title:

** Data Analyst
*
* Reports To:

** Information Technology Manager
** FLSA Status:
** Exempt
* * Department:
** Administration
*
* Location:

** Addison, TX (KA-DAL); travel to other King Aerospace sites as needed
** POSITION SUMMARY
** The Data Analyst is responsible for collecting, transforming, analyzing, and reporting company data to support informed decision making across King Aerospace’s operations, programs, and support functions. This position designs and maintains Power BI dashboards and key performance metrics for company leadership, develops automated data pipelines that replace manual and spreadsheet-based reporting, and leads process improvement initiatives that increase efficiency across departments and sites.

The Data Analyst supports the company’s program tracking, enterprise resource planning (ERP), and business systems initiatives, and works within a regulated defense and aerospace environment where controlled and export-controlled data must be protected in accordance with government and customer requirements. The Data Analyst is based at the Addison, Texas facility and travels to other King Aerospace locations as needed.## Qualifications
** ESSENTIAL DUTIES AND RESPONSIBILITIES
*** Design, develop, publish, and maintain Power BI dashboards and reports in the Microsoft 365 GCC High environment for company leadership, program managers, and site general managers.
* Develop, maintain, and report on core operational metrics and key performance indicators (KPIs) for operations, production, quality, finance, and support functions in coordination with department leaders.
* Gather, clean, transform, and validate data from company systems, including 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; ensure the accuracy, consistency, and performance of reports and datasets.
* Develop and maintain automated data pipelines and integrations using APIs, dataflows, and scheduled refreshes to replace manual and spreadsheet-based reporting.
* Administer, configure, and maintain  work spaces, boards, workflows, automations, dashboards, and user access used for program tracking; support  users across departments and sites.
* Develop integrations between  and Power BI using the  API to support program status, schedule, and performance reporting.
* Lead the transition of program tracking from  to company-managed solutions, including extraction, validation, and archival of historical  data into a permanent internal repository.
* Ensure continuity of program tracking during the transition from , maintaining equivalent functionality, reporting, and user access in the replacement solution.
* Design and support program tracking and reporting solutions for current and upcoming aircraft maintenance, modification, and government contract programs.
* Support the company’s ERP implementation by mapping departmental workflows, defining reporting requirements, supporting data migration and validation, and building analytics for the new system.
* Analyze business processes across departments and sites to identify inefficiencies, bottlenecks, and opportunities for improvement.
* 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 on results.
* Perform trend, variance, and root cause analysis on operational data such as labor hours, turn times, schedule performance, and cost.
* Perform ad hoc analysis and prepare reports, summaries, and presentations for leadership to support business decisions.
* Establish and maintain data quality standards, data definitions, and a data dictionary; identify and resolve data integrity issues with system owners.
* Manage Power BI work spaces, apps, dataset refresh schedules, and report access permissions in coordination with the IT department.
* Handle Controlled Unclassified Information (CUI), export-controlled (ITAR), and proprietary customer data in accordance with company policies and NIST SP 800-171, CMMC, and DFARS requirements; ensure reports and datasets are restricted to authorized users.
* Use analytics, automation, and artificial intelligence (AI) tools only within…