Data​/Operations Research Analyst

About the Company

P17 Solutions is a distinguished Small Business Administration 8(a) certified company, delivering professional services and innovative technology solutions to Federal, State, and Local Government agencies, as well as private sector clients. Known for our commitment to excellence and proven track record, we serve as a trusted partner in navigating complex government and industry challenges. Join us in driving transformative solutions that advance technology, transportation, and public services.

Learn more at

P17 Solutions is seeking a Data Analyst / Operations Research Analyst to join our team supporting the Federal Aviation Administration (FAA) Technical Operations Resiliency, Innovation, Sustainment, and Engineering (RISE) Program. This is a full‑time position preferably on‑site in Oklahoma City, OK, with remote and alternative location arrangements considered.

The Data Analyst / Operations Research Analyst will bring mid‑to senior‑level expertise in data extraction, statistical analysis, and executive‑level data visualization to support data‑driven decision‑making across the RISE program. This role focuses on transforming complex backend operational data into clear, actionable business intelligence through the design and maintenance of intuitive dashboards, quick‑turn analytics, and narrative reporting delivered to FAA leadership and program stakeholders.

The ideal candidate brings demonstrated experience working with Technical Operations (Tech Ops) Data, National Airspace System (NAS) and FAA organizational structure, and equipment logging data with a combined proficiency in SQL, Python or R, and visualization platforms such as Tableau or Databricks strongly preferred.

• Complex Joins & Aggregations:
  Ability to extract and reshape data from databases using INNER, LEFT, RIGHT, and FULL OUTER JOINs, including proper handling of NULL values.
• Advanced Analytical Functions:
  Proficient in utilizing Common Table Expressions (CTEs) and Window Functions to calculate advanced metrics such as running totals and moving averages.
• Data Transformation:
  Experience preparing and cleaning tables through date alignment and string manipulations prior to visualization or modeling.

• Exploratory Data Analysis (EDA):
  Ability to write programmatic scripts to conduct quick EDA, hypothesis testing, and probability modeling to uncover hidden insights.
• Data Manipulation:
  Skilled in rapidly cleaning, filtering, and grouping massive datasets to bridge the gap between initial exploration and predictive science.
• Programmatic Plotting:
  Experience building custom chart layers, scales, and color hierarchies within Python visualization libraries such as Matplotlib and Seaborn.

• Interactive Design:
  Competency in structuring actions, parameters, and drill‑down filters to build automated, easily digestible executive dashboards.
• Context Control & Data Modeling:
  Ability to connect custom SQL scripts directly to Tableau, blend data sources, and utilize Level of Detail (LOD) expressions to maintain stable comparative calculations during user interaction.

• Chart Matching:
  Mastery of visual grammar to select the mathematically correct chart for specific data properties (e.g., scatter plots for correlation, time series for historical trends).
• Narrative Building:
  Ability to distill dense statistical summaries into cohesive narratives focused directly on KPIs and actionable business insights.
• Professional Communication:
  Strong oral and written communication skills to effectively convey technical findings to non‑technical leadership and varied audiences.

• Technical Operations Data (3+ years):
  Direct experience working with data pertaining to FAA systems, including but not limited to: RMLS, FSEP, NASPAS, IFS, PURE, and Delphi.
• National Airspace System (NAS) Knowledge (3+ years): A foundational understanding of the NAS, including:
  • General NAS equipment and service purposes.
  • FAA…