Data Analyst

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.

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 Monday.com workspaces, boards, workflows, automations, dashboards, and user access used for program tracking; support Monday.com users across departments and sites.
• Develop integrations between Monday.com and 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 extraction, validation, and archival of historical Monday.com data into a permanent internal repository.
• Ensure continuity of program tracking during the transition from Monday.com, 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 workspaces, 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 approved, compliant environments, in accordance with the company's Information Security, Acceptable Use, and AI Use Policies.
• Support the 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 new 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 with stakeholders, observe operations, and support process improvement initiatives.
• Perform other related duties as assigned.

QUALIFICATIONS

The requirements below are representative of the knowledge, skills, and abilities needed to successfully perform the essential functions of this position. Reasonable accommodations may be made to enable individuals with disabilities to perform these functions.

EDUCATION / EXPERIENCE

• Bachelor's degree in Data Analytics, Business Analytics, Information Systems, Computer Science, Industrial Engineering, Statistics, or a related field preferred, or three (3) years of data analysis or business intelligence experience, or an equivalent combination of education and experience.
• Experience administering, building, or reporting from Monday.com strongly preferred.
• Microsoft Certified: Power BI Data Analyst Associate (PL-300) or a similar business intelligence certification preferred.
• Lean Six Sigma Green Belt or other process improvement training or certification preferred.
• Experience in an aviation maintenance, repair and overhaul (MRO), manufacturing, or defense contractor environment preferred.
• Experience with ERP system data, reporting, or implementation preferred.

COMMUNICATION SKILLS

Ability to read, analyze, and interpret business reports, technical documentation, and governmental regulations; write reports, business correspondence, and procedure manuals; translate complex data and analysis into clear findings and recommendations for non-technical audiences; and effectively present information and respond to questions from executives, managers, customers, and employees.

MATHEMATICAL SKILLS

Ability to apply concepts of descriptive and inferential statistics, probability, forecasting, and trend analysis, and to apply fractions, percentages, ratios, and proportions to practical situations.

REASONING AND PROBLEM-SOLVING SKILLS

Ability to define problems, collect data, establish facts, draw valid conclusions, and interpret a wide variety of technical instructions in mathematical or diagram form while dealing with several abstract and concrete variables.

COMPUTER SKILLS

Advanced proficiency in Microsoft Power BI, including Power Query, DAX, data modeling, and the Power BI Service; Microsoft Excel, including PivotTables, advanced formulas, and Power Pivot; SQL and relational database concepts; Microsoft 365, including SharePoint, Lists, Teams, and Power Automate; data integration using REST APIs; work management platforms such as Monday.com; process mapping and diagramming software such as Visio; and spreadsheet, presentation, and word processing software. Familiarity with Python or R, Power Apps, Microsoft Fabric, and Microsoft 365 GCC High preferred.

OTHER QUALIFICATIONS

• 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.

COMPLIANCE, WORK ENVIRONMENT AND PHYSICAL DEMANDS

The following information describes the general work environment and physical demands associated with this position. The statements below are representative of those an employee may encounter while performing the essential functions of the role. Reasonable accommodations may be made to enable individuals with disabilities to perform these essential functions.

WORK ENVIRONMENT

• The noise level in the work environment is usually moderate.
• Work is primarily performed in an office environment and may also be performed in aircraft hangar and shop environments, where noise levels may be loud at times and personal protective equipment may be required.

PHYSICAL DEMANDS

• The employee is frequently required to sit and use a computer for extended periods, and occasionally required to stand and walk, including on hangar and shop floors.
• The employee must occasionally lift and or move up to 25 pounds.
• Vision requirements may include close vision, distance vision, color vision, peripheral vision, depth perception, and the ability to adjust focus.

EMPLOYMENT REQUIREMENTS

Employment is contingent upon successful completion of required pre-employment screenings, which may include a background check and drug screening, in accordance with applicable laws and company policies. This position requires the ability to travel on short notice, as business needs dictate.

EQUAL EMPLOYMENT OPPORTUNITY

King Aerospace is an Equal Opportunity Employer. Employment decisions are made without regard to race, color, religion (including religious dress and grooming practices), creed, sex (including pregnancy, childbirth, breastfeeding, or related medical conditions), gender, gender identity, gender expression, sexual orientation, marital status, domestic partner status, age, national origin, ancestry, citizenship, physical or mental disability, medical condition, genetic information, military or veteran status, or any other characteristic protected by applicable federal, state, or local law.

King Aerospace complies with all applicable federal, state, and local laws governing nondiscrimination in employment.