Sr. Analyst, Data - (Client Support) Archimedes

Navitus Health Solutions, LLC

Annapolis (MD)

Remote

USD 90,000 - 130,000

Full time

7 days ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Benefits offered by this job

Health, Dental, Vision benefits
PTO 20 days
Parental leave 4 weeks
9 holidays
401K match
Adoption assistance
FSAs
Education assistance
Referral bonus

Job summary

Archimedes is seeking a Sr. Analyst- Data to join our team. You will lead complex analytical initiatives, translate business problems into scalable data solutions, and deliver trusted datasets and actionable recommendations across stakeholders.

Utilize advanced SQL, data modeling, and Power BI to develop governance-friendly reports and dashboards. You will mentor junior analysts and support regulatory reporting and client analytics in a remote-capable environment.

Qualifications

  • Bachelor’s degree in a quantitative field or equivalent work experience required.
  • 5 years of experience with data analysis, business analysis, analytics engineering, reporting, or data warehousing in a production environment.
  • Advanced SQL proficiency with window functions, stored procedures, temp tables, data validation, and troubleshooting complex logic.
  • Experience with healthcare, PBM data, or regulated datasets preferred.

Responsibilities

  • Lead complex, cross-functional analytical projects from problem definition to delivery.
  • Translate business questions into analytical plans and reusable reporting logic.
  • Design, maintain, and optimize SQL-based data solutions and recurring reporting workflows.
  • Write and review advanced SQL using SSMS and SQL Server, including complex joins and performance-aware queries.
  • Analyze pharmacy claims, member, client, drug, formulary, and financial datasets to identify risks and opportunities.
  • Serve as a subject matter expert for datasets, metrics, and reporting processes.
  • Advise stakeholders on metric definitions, data interpretation, and methodological trade-offs.
  • Develop and enhance Power BI reports, dashboards, and semantic models for leadership.
  • Establish standards for data validation, documentation, and maintainable analytical code.
  • Investigate data quality issues and drive durable process improvements.
  • Lead modernization efforts to reduce manual work and increase scalability.
  • Mentor Analyst, Data and Analyst II, through code reviews and coaching.
  • Support client reporting, regulatory reporting, and PBM analytics needs.

Skills

Advanced SQL
Power BI
Data analysis
Project leadership
Mentoring
Stakeholder communication

Education

Bachelor's degree

Tools

SSMS
SQL Server

Job description

CompanyArchimedes
About Us

Archimedes - Transforming the Specialty Drug Benefit - Archimedes is the industry leader in specialty drug management solutions. Founded with the goal of transforming the PBM industry to provide the necessary ingredients for the sustainability of the prescription drug benefit – alignment, value and transparency – Archimedes achieves superior results for clients by eliminating tightly held PBM conflicts of interest including drug spread, rebate retention and pharmacy ownership and delivering the most rigorous clinical management at the lowest net cost. .____________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________. Current associates must use SSO login option at to be considered for internal opportunities.________We are committed to providing equal employment opportunity to all applicants and employees and comply with all applicable nondiscrimination regulations, including those related to protected veterans and individuals with disabilities. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, or handicap.

Pay Range

USD $0.00 - USD $0.00 /Yr.

STAR Bonus % (At Risk Maximum)

0.00 - Ineligible

Work Schedule Description

M-F 8am to 5pm

Remote Work Notification

ATTENTION: Archimedes is only able to offer remote work to residents of Alabama, Colorado, Florida, Georgia, Indiana, Illinois, Iowa, Kansas, Kentucky, Maryland, Minnesota, Missouri, New Hampshire, New Jersey, Ohio, Oklahoma, Pennsylvania, Tennessee, Texas, Virginia, Wisconsin.

Overview

Archimedes is seeking a Sr. Analyst- Client Support, Data to join our team!

The Sr. Analyst, Data leads complex analytical initiatives and designs reliable data solutions that support analytics, reporting, and operational decision-making across the organization. This role partners with stakeholders to translate ambiguous or complex business problems into scalable analytical approaches, trusted datasets, and clear recommendations.

The Sr. Analyst, Data has deep knowledge of Archimedes business offerings, healthcare and pharmacy benefit management data, analytical workflows, and data dependencies. Leveraging advanced SQL expertise, data modeling knowledge, and strong business judgment, this role promotes best practices, improves legacy and modern reporting processes, mentors other analysts, and helps ensure that the organization makes decisions using accurate, well-understood data.

Is this you? Find out more below!

Responsibilities
  • Lead complex, cross-functional, analytical projects from business problem definition through data analysis, validation, stakeholder communication, and final delivery.
  • Translate ambiguous business questions into analytical plans, reusable reporting logic, scalable datasets, and actionable recommendations.
  • Design, maintain, and optimize SQL-based analytical solutions, data models, views, stored procedures, and recurring reporting workflows supporting operational and strategic needs.
  • Write and review advanced SQL using SSMS, including complex joins, CTEs, window functions, temporary tables, stored procedures, performance-aware query design, and robust validation logic.
  • Analyze pharmacy claims, member, client, drug, formulary, rebate, network, provider, clinical, operational, and financial datasets to identify risks, opportunities, trends, and decision points.
  • Serve as a subject matter expert for assigned business domains, datasets, metrics, reporting processes, and data dependencies.
  • Advise stakeholders on metric definitions, data interpretation, analytical trade-offs, appropriate methodology, assumptions, limitations, and recommended actions.
  • Develop and enhance Power BI reports, dashboards, semantic models, and analytical deliverables used by business stakeholders and leadership.
  • Establish and promote practical standards for data validation, documentation, report design, quality assurance, peer review, and maintainable analytical code.
  • Investigate complex data quality issues, reconcile outputs across systems, identify root causes, and recommend durable process or data improvements.
  • Lead modernization and continuous improvement efforts that reduce manual work, improve reliability, increase scalability, and clarify ownership of recurring analytics processes.
  • Mentor Analyst, Data and Analyst II, Data team members through code review, analytical review, documentation, technical coaching, and business context sharing.
  • Support client reporting, regulatory reporting, network adequacy, disruption analysis, RFP responses, audit support, formulary analytics, and other high-impact PBM analytical needs.
  • Other duties as assigned.
Qualifications
  • Bachelor’s degree, preferably in a quantitative, business, healthcare, information systems, economics, statistics, mathematics, computer science, or related field, or equivalent work experience, required.
  • 5 years of experience with data analysis, business analysis, analytics engineering, reporting, data warehousing, or related analytical work in a production environment required.
  • Experience leading complex analytical projects, translating ambiguous requirements, and delivering high-quality work with minimal managerial guidance required.
  • Experience mentoring analysts, reviewing analytical code or report logic, and improving reporting or data processes preferred.
  • Experience with healthcare, pharmacy benefit management, managed care, or other highly regulated data preferred.
  • Advanced SQL proficiency, including window functions, stored procedures, temp tables, performance-aware query design, data validation, and troubleshooting complex business logic, required.
  • Advanced experience using SSMS and SQL Server-based analytics environments to develop, validate, document, and optimize analytical solutions required.
  • Strong understanding of data warehousing concepts, ETL/ELT workflows, data modeling, upstream and downstream dependencies, and production reporting controls required.
  • Experience developing or improving Power BI reports, dashboards, semantic models, and governed analytical datasets required.
  • Ability to establish practical standards for documentation, quality assurance, peer review, maintainability, and business-rule transparency required.
  • Participate in, adhere to, and support compliance program objectives.
  • The ability to consistently interact cooperatively and respectfully with other employees.
What can you expect from Navitus?
  • Top of the industry benefits for Health, Dental, and Vision insurance
  • 20 days paid time off
  • 4 weeks paid parental leave
  • 9 paid holidays
  • 401K company match of up to 5% - No vesting requirement
  • Adoption Assistance Program
  • Flexible Spending Account
  • Educational Assistance Plan and Professional Membership assistance
  • Referral Bonus Program – up to $750!
Location : Address

Remote

Location : Country

"US"

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Sr. Analyst, Data - (Client Support) Archimedes
Sr. Analyst, Data - (Client Support) Archimedes

Navitus Health Solutions, LLC • Springfield (IL)

Remote
USD 90,000 - 130,000
Health insurance
Dental insurance
Vision insurance
+5
Sr. Analyst, Data - (Client Support) Archimedes
Sr. Analyst, Data - (Client Support) Archimedes

Navitus Health Solutions, LLC • Philadelphia

Remote
USD 90,000 - 120,000
Health insurance
Paid time off
Parental leave
+3
Sr. Analyst, Data - (Client Support) Archimedes
Sr. Analyst, Data - (Client Support) Archimedes

Navitus Health Solutions, LLC • Montgomery (AL)

Remote
USD 120,000 - 150,000
Health insurance
Paid time off
Parental leave
+4
Sr. Analyst, Data - (Client Support) Archimedes
Sr. Analyst, Data - (Client Support) Archimedes

Navitus Health Solutions, LLC • Iowa City (IA)

Remote
USD 90,000 - 130,000
Health insurance
Dental insurance
Vision insurance
+9
Sr. Analyst, Data - (Client Support) Archimedes
Sr. Analyst, Data - (Client Support) Archimedes

Navitus Health Solutions, LLC • Nashville (TN)

Remote
USD 90,000 - 120,000
Health insurance
20 days PTO
4 weeks parental leave
+2
Sr. Analyst, Data - (Client Support) Archimedes
Sr. Analyst, Data - (Client Support) Archimedes

Navitus Health Solutions, LLC • Saint Paul (MN)

Remote
USD 90,000 - 140,000
Health benefits
PTO 20 days
Parental leave 4 weeks
+2
Sr. Analyst, Data - (Client Support) Archimedes
Sr. Analyst, Data - (Client Support) Archimedes

Navitus Health Solutions, LLC • Colorado Springs (CO)

Remote
USD 90,000 - 135,000
Health insurance
20 days PTO
4 weeks parental leave
+2
Sr. Analyst, Data - (Client Support) Archimedes
Sr. Analyst, Data - (Client Support) Archimedes

Navitus Health Solutions, LLC • Virginia Beach (VA)

Remote
USD 90,000 - 130,000
Health, dental, and vision insurance
20 days paid time off
4 weeks parental leave
+2
Sr. Analyst, Data - (Client Support) Archimedes
Sr. Analyst, Data - (Client Support) Archimedes

Navitus Health Solutions, LLC • Tallahassee (FL)

Remote
USD 90,000 - 130,000
Health insurance
Paid time off
Parental leave
+6
Sr. Analyst, Data - (Client Support) Archimedes
Sr. Analyst, Data - (Client Support) Archimedes

Navitus Health Solutions, LLC • United States

Remote
USD 95,000 - 130,000
Health benefits
Dental and Vision insurance
Paid time off (20 days)
+4