Senior Data Analyst - Client Insights (Remote)

Archimedes; Harrisburg (Dauphin County); Remote; USD 90,000 - 130,000; Full time

Benefits offered by this job

Health insurance

Dental insurance

Vision insurance

20 days paid time off

Parental leave (4 weeks)

9 holidays

401K company match (up to 5%)

Adoption assistance

Flexible Spending Account

Educational assistance

Job summary

Archimedes is seeking a Sr. Analyst- Client Support, Data to join our team. The role leads complex analytical initiatives, designs reliable data solutions, and partners with stakeholders to translate complex problems into scalable analytical approaches and trusted datasets.

The position requires deep SQL expertise, data modeling know‑how, and experience mentoring analysts. You will develop Power BI reports and dashboards to support leadership and business decisions.

Qualifications

• Bachelor's degree in a quantitative or related field or equivalent work experience.
• 5+ years of data analysis, analytics engineering, or related work in a production environment.
• Advanced SQL with window functions, stored procedures, and performance-aware design.
• Experience with healthcare/pharmacy benefit management data preferred.
• Experience developing Power BI reports and semantic models.

Responsibilities

• Lead cross-functional analytical projects from problem definition to final delivery.
• Translate business questions into analytical plans and scalable datasets.
• Design and optimize SQL-based solutions, data models, and reporting workflows.
• Develop and review advanced SQL in SSMS with complex joins and window functions.
• Analyze healthcare and PBM datasets to identify risks, trends, and opportunities.
• Mentor Analysts on code reviews and best practices.
• Develop and enhance Power BI dashboards for stakeholders and leadership.
• Establish documentation, quality assurance, and maintainable analytical code standards.
• Support client reporting, regulatory reporting, and formulary analytics.

Skills

SQL proficiency

Power BI

Data modeling

Data validation

ETL/ELT

Data warehousing

Mentoring

Education

Bachelor's degree

Tools

SSMS

SQL Server

Job description

Archimedes is seeking a Sr. Analyst- Client Support, Data to join our team. The role leads complex analytical initiatives, designs reliable data solutions, and partners with stakeholders to translate complex problems into scalable analytical approaches and trusted datasets.

The position requires deep SQL expertise, data modeling know‑how, and experience mentoring analysts. You will develop Power BI reports and dashboards to support leadership and business decisions.