About the Position

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 preferred 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 is strongly preferred.

Job Requirements

Data Extraction & Preparation (SQL)

• 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 (e.g., running totals, moving averages).
• Data Transformation: Experience preparing and cleaning tables through date alignment and string manipulations prior to visualization or modeling.

Statistical Analysis & Quick-Turn Analytics (Python, R, etc.)

• 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 (e.g., Matplotlib, Seaborn).

Easily Consumable Data Visualizations (Tableau, Databricks, etc.)

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

Data Storytelling & Communication

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

Knowledge, Skills, and Abilities (KSAs)

• 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 organizational structure.
• Equipment logging fields and their operational meanings.

Education and Years of Experience

• Degree: A Bachelor's degree (or higher) in Mathematics, Statistics, Computer Science, Data Science, or a field directly related to the position. The major field of study must be directly appropriate for the role.
  • 5+ years of relevant experience
• Combination of Education & Experience: Courses equivalent to a major field of study (at least 30 semester hours) in the disciplines listed above, plus professional experience.
  • 10+ years of relevant experience

Citizenship and Security Clearance: Candidates must be either a US citizen or a current green card holder with the last 3 consecutive years as a resident of the US. Proof of eligibility and verification is a must. P17 Solutions does not provide sponsorship at this time.

Upon receiving a conditional offer of employment, candidates will undergo a Government investigation and must meet eligibility requirements to obtain and maintain Government clearance.

Relocation and Salary Disclaimer: Relocation expenses are not considered for this position. Candidate must reside or be willing to relocate within a commutable distance to onsite location.

Total Rewards: At P17 Solutions, we are dedicated to investing in the success and well-being of our employees. We offer a competitive compensation and benefits package designed to support you both personally and professionally. The salary range for this position is between $72,000 to $145,000. This range is provided as a general guideline and should not be interpreted as a guarantee of compensation. Actual salary offers will be determined based on a variety of factors, including but not limited to the specific responsibilities of the position, the candidate's education and experience.

Full-time employees are eligible for comprehensive medical, dental, and vision coverage, paid supplemental insurance, paid life & AD&D insurance, paid disability, 401(k)-retirement plan w/company match, educational assistance, generous leave policies, 11 paid federal holidays and 2 supplemental holidays, and any additional paid leave required by law.

Work Environment

This is a full-time on-site position. The role primarily involves computer-based work, requiring extended periods of sitting and focused attention on system and technical documentation. Occasional collaboration with team members or stakeholders may require standing or moving between workstations as needed.

* Travel is estimated at 25% per year.

* Lifting
Interview Requirements

AI DISCLOSURE / CONSENT: The Company values authenticity and fairness in the hiring process. To maintain the integrity of interviews and assessments, applicants are not permitted to:

1.Use any AI tool to generate or suggest responses in real time during interviews (e.g., ChatGPT, Copilot, Gemini, or similar "answer-assistant" tools).

2.Use AI-based live coaching, hidden communication tools, or remote-assistance technologies to obtain real-time help from other individuals or systems.

3.Use AI tools that alter or mask their identity, including deepfake video, AI avatars, or AI voice changers.

4.Use AI code generators or AI writing tools to complete coding challenges, case studies, or written assessments, unless the assessment instructions explicitly permit such tools.

5.Record or transcribe interviews using AI tools (e.g., Otter.ai, Noty.ai, Fireflies, or similar) without prior explicit consent from the interviewer or recruiter.

1. Applicants may not use AI tools that inflate, or fabricate application materials, online profiles, or credentials such as professional experience, in ways that misrepresent their true qualifications.

Applicants may use AI tools before interviews for preparation (e.g., researching the Company, practicing questions, or reviewing resumes), provided the content submitted is truthful and accurately reflects the applicant's own experience and capabilities.

The company does not authorize or consent to applicants using AI tools during live interviews or assessments, unless explicitly stated. Applicants agree to follow the Company's AI-use rules and affirm that all responses and materials submitted reflect their own authentic experience.

The applicant has the right to withdraw consent at any time. Should consent be withdrawn, the Company will either continue the evaluation or will discontinue the application process if no reasonable alternative exists.

By participating in a P17 Solutions interview, you consent to the AI Disclosure. Failure to comply with the Company's AI-use requirements may result in disqualification from employment consideration.