Senior Data Analyst (Remote) - PBM Analytics Leader

Archimedes; Frankfort (KY); On-site; USD 90,000 - 130,000; Full time

Benefits offered by this job

Health insurance

PTO 20 days

Parental leave

Holidays 9

401K match

Adoption assistance

FSA

Education assistance

Referral bonus

Job summary

Archimedes is seeking a Sr. Analyst, Data to join our team in Kentucky. You will lead complex analytical initiatives and design reliable data solutions to support analytics, reporting, and decision-making across the organization.

The role partners with stakeholders to translate business problems into scalable analytical approaches, trusted datasets, and clear recommendations. Mentoring other analysts and improving reporting processes are key aspects.

Qualifications

• Bachelor’s degree or equivalent work experience required.
• 5 years of data analysis or analytics experience in a production environment.
• Experience leading complex analytical projects with minimal managerial guidance.
• Advanced SQL proficiency, including window functions, stored procedures, temp tables.
• Healthcare/PBM data experience preferred.

Responsibilities

• Lead cross-functional analytical projects from problem definition to delivery.
• Translate questions into analytical plans, reusable reporting logic, scalable datasets, and recommendations.
• Design, maintain, and optimize SQL-based solutions, data models, views, and reporting workflows.
• Write and review advanced SQL using SSMS with complex joins, CTEs, and performance-aware queries.
• Analyze pharmacy claims, member, client, drug, formulary, and financial data to identify risks and trends.
• Serve as SME for datasets, metrics, and reporting processes.

Skills

SQL proficiency

Power BI

Data modeling

SSMS

Healthcare data

Mentoring

Education

Bachelor’s degree

Tools

SSMS

SQL Server

Job description

Archimedes is seeking a Sr. Analyst, Data to join our team in Kentucky. You will lead complex analytical initiatives and design reliable data solutions to support analytics, reporting, and decision-making across the organization.

The role partners with stakeholders to translate business problems into scalable analytical approaches, trusted datasets, and clear recommendations. Mentoring other analysts and improving reporting processes are key aspects.