Remote Senior Data Analyst, Healthcare & PBM

Archimedes; Saint Paul (MN); Remote; USD 95,000 - 135,000; Full time

Benefits offered by this job

Health insurance

Dental insurance

Vision insurance

20 days paid time off

4 weeks parental leave

9 holidays

401K company match 5%

Adoption Assistance

Flexible Spending Account

Educational Assistance Plan

Professional Membership assistance

Referral Bonus Program

Job summary

Archimedes is seeking a Sr. Analyst, Data to join our team in a data-driven role focused on analytics, reporting, and decision support. You will design reliable data solutions, mentor analysts, and partner with stakeholders to translate complex problems into scalable analytical approaches.

The role emphasizes advanced SQL, data modeling, and Power BI, with responsibilities spanning data validation, governance, and continuous improvement of analytics processes.

Qualifications

• Bachelor’s degree in a quantitative or related field, or equivalent work experience.
• 5 years of data analysis, analytics engineering, or related experience in a production environment.
• Experience leading complex analytics projects with minimal supervision.
• Experience mentoring analysts and improving reporting or data processes.
• Experience with healthcare, PBM, or regulated data preferred.

Responsibilities

• Lead complex, cross-functional analytics projects from problem definition to delivery.
• Translate business questions into analytical plans and reusable reporting logic.
• Design, maintain, and optimize SQL-based solutions and data models.
• Write advanced SQL in SSMS with complex joins, CTEs, and window functions.
• Analyze pharmacy claims and related data to identify risks, trends, and opportunities.
• Serve as SME for datasets, metrics, and reporting processes.
• Advise stakeholders on data interpretation, methodology, and actions.
• Develop and enhance Power BI reports and semantic models.
• Establish standards for data validation, documentation, and maintainable code.
• Investigate data quality issues and suggest durable improvements.
• Lead modernization efforts to reduce manual work and increase reliability.
• Mentor Analysts through code reviews and coaching.
• Support client and regulatory reporting and other high-impact PBM analytics.

Skills

Advanced SQL

Power BI

Data modeling

Data warehousing

Mentoring

Stakeholder communication

ETL/ELT

Stored procedures

Performance tuning

Education

Bachelor’s degree

Tools

SSMS

SQL Server

Job description

Archimedes is seeking a Sr. Analyst, Data to join our team in a data-driven role focused on analytics, reporting, and decision support. You will design reliable data solutions, mentor analysts, and partner with stakeholders to translate complex problems into scalable analytical approaches.

The role emphasizes advanced SQL, data modeling, and Power BI, with responsibilities spanning data validation, governance, and continuous improvement of analytics processes.