Senior Data Analyst - Healthcare Analytics, Remote

Archimedes; Annapolis (MD); Remote; USD 110,000 - 160,000; Full time

Job summary

Archimedes is seeking a Sr. Analyst- Client Support, Data to join our team. The role leads complex analytical initiatives and designs reliable data solutions that support analytics, reporting, and operational decision-making across the organization.

You will translate ambiguous business problems into scalable analyses, trusted datasets, and clear recommendations. Deep knowledge of Archimedes data, healthcare PBM data, and advanced SQL is required.

Qualifications

• Bachelor's degree in a quantitative, business, healthcare, information systems, economics, statistics, mathematics, computer science, or related field, or equivalent work experience.
• 5+ years of data analysis, business analysis, analytics engineering, reporting, data warehousing, or related analytical work in a production environment.
• Experience leading complex analytical projects and translating requirements into deliverables.
• Experience mentoring analysts and improving reporting or data processes.
• Experience with healthcare, pharmacy benefit management, or regulated data preferred.
• Advanced SQL proficiency and complex query troubleshooting are required.
• Strong SSMS/SQL Server-based analytics experience is required.
• Knowledge of data warehousing concepts and ETL/ELT workflows is needed.
• Experience developing Power BI reports and governance datasets is required.

Responsibilities

• Lead complex, cross-functional analytical projects from problem definition to delivery.
• Translate ambiguous questions into analytical plans, reusable logic, scalable datasets, and actionable recommendations.
• Design and optimize SQL-based solutions, data models, views, and recurring reporting workflows.
• Write and review advanced SQL with complex joins, CTEs, window functions, and validation logic.
• Analyze pharmacy claims and related datasets to identify risks, trends, and decision points.
• Serve as SME for datasets, metrics, reporting processes, and data dependencies.
• Advise stakeholders on metric definitions, interpretation, and methodological trade-offs.
• Develop and enhance Power BI reports, dashboards, and semantic models.
• Establish standards for data validation, documentation, and maintainable code.
• Investigate data quality issues and propose durable improvements.
• Lead modernization efforts to reduce manual work and improve reliability.
• Mentor junior analysts and collaborate on code reviews and best practices.
• Support client reporting, regulatory reporting, and PBM analytics needs.
• Other duties as assigned.

Skills

Advanced SQL

Power BI

Data warehousing

Mentoring

Stakeholder communication

Data analysis

Analytical thinking

Education

Bachelor's degree in related field

Tools

SSMS

SQL Server

Power BI

Job description

Archimedes is seeking a Sr. Analyst- Client Support, Data to join our team. The role leads complex analytical initiatives and designs reliable data solutions that support analytics, reporting, and operational decision-making across the organization.

You will translate ambiguous business problems into scalable analyses, trusted datasets, and clear recommendations. Deep knowledge of Archimedes data, healthcare PBM data, and advanced SQL is required.