profile image

Amanda Knight

Data Analyst ~ Insurance/Finance Data Analyst ~ Healthcare Data Analyst

Contact Me

About Me

I’m a data analyst with a strong foundation in insurance and healthcare data. I use tools like Python, SQL, R, and Tableau to turn raw data into clear, actionable insights that support strategic decision-making. My focus is on process improvement, trend discovery, and outcome analysis—helping teams work smarter with the data they already have.

Specialties: Python, SQL, R, Tableau, data visualization, French, Microsoft Excel

Latest Projects

Medicare Analytics project thumbnail
New

What Makes a High-Performing Insurance Agent? A Python & Excel Analysis

Analyzed simulated Medicare insurance sales data to evaluate agent performance and funnel efficiency. Using Python and Excel, I uncovered high-impact quoting behaviors, identified top-performing agents, and visualized KPI trends. The project highlights how thoughtful quoting—not speed or tenure—drives conversions, offering data-backed recommendations to improve outreach, training, and quota alignment.

Github Repository LinkedIn Article
Woman Pharmacist examines an analysis of FEFO inventory

Why are Medications Expiring? A Data-Driven Analysis of Pharmacy Sales with Excel

Using Excel to analyze pharmacy sales data, I uncovered inventory inefficiencies that could impact profitability. My analysis highlights trends in medication expiration and concludes with a call to action for the pharmacy to implement FEFO (First Expiring, First Out) and leverage analytics to minimize waste and optimize inventory management.

LinkedIn Article

LEGO chart illustration

How have LEGO colors evolved since 1949?

Analyzing LEGO set color trends since 1949 using Python, Pandas, Matplotlib and Seaborn, I uncovered trends such as the introduction of new color groups, special features, the frequency of specific hues, and shifts in design preferences. This analysis showcases my ability to handle and interpret complex data, providing actionable insights into product development and consumer preferences over time.

Kaggle Notebook Data visualizations here Github Repository
Image of bike

Cyclistic Bicycles: Chicago Bike-Share Case Study

Starting with SQL queries in BigQuery, I utilized this data-base language to analyze Chicago bike-sharing trends, uncovering key usage patterns and formatting geospatial data for map visualization. I posted my code, analysis and findings on Kaggle.com

Analysis on Kaggle

BikeShare Viz

Tableau Public Viz: Chicago Bike-share

Using the insights gathered from SQL Bicycles, I integrated these findings into an interactive Tableau dashboard, increasing accessibility and aiding strategy development, highlighting key metrics to inform strategy and enhance decision-making.

Tableau Dashboard

Work Experience

Manager, Data Operations & Eligibility Systems - AmeriLife Benefits (2025 - Present)

  • Lead data operations and eligibility processes across two enterprise platforms, ensuring accurate enrollment, billing, and EDI file exchanges for employee benefits.
  • Manage and mentor a team of 3 direct reports overseeing EDI file transmissions, discrepancy resolution, and data quality audits across client accounts.
  • Collaborate cross-functionally with developers, analysts, and carriers to design, implement, and troubleshoot system integrations.
  • Drive process improvements by identifying inefficiencies, developing documentation, and proposing automation or system enhancements.

EDI & Enrollment Data Analyst - AmeriLife Benefits (2024 - 2025)

  • Conducted data validation and reconciliation audits to identify discrepancies in premium collections and enrollment records between AmeriLife and insurance carriers, ensuring compliance and billing accuracy.
  • Led user acceptance testing to develop workflows that enhanced billing accuracy and reduced manual auditing efforts by 50%, improving profitability tracking.
  • Implemented and maintained Electronic Data Interchange (EDI) maps to ensure seamless transmission of eligibility and enrollment data (834 and non-834), maintaining data integrity and minimizing downtime.
  • Utilized project management skills to coordinate cross-functional teams in launching new audit automation tools projected to save thousands of staff hours annually.
  • Managed insurance benefits enrollment data for health, life, and other insurance products to ensure coverage accuracy and prevent gaps.
  • Diagnosed and resolved enrollment and policy data issues, improving workflow efficiency, reducing processing errors, and enhancing the customer experience.
  • Oversaw and prioritized insurance benefits enrollment setups for new and existing clients, coordinating with internal teams and carriers to ensure timely implementation and system functionality.
  • Coordinated Medicare and Medicaid enrollment processes for retiree clients, ensuring accurate data integration and regulatory compliance.

French/English Elementary Teacher - Académie Lafayette (2017 - 2023)

  • Partnered with stakeholders to implement strategies that fostered improved classroom dynamics.
  • Designed and refined lesson plans to deliver clear, concise, and engaging material tailored to meet diverse learning needs.