Senior Data Analyst – Remote, Power BI & SQL Lead

Navitus Health Solutions, LLC

New Hampshire

Remote

USD 90,000 - 130,000

Full time

9 days ago

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 insurance
20 days paid time off
4 weeks paid parental leave
9 paid holidays
401K company match up to 5%
Adoption Assistance
Flexible Spending Account
Educational Assistance Plan

Job summary

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

The Sr. Analyst, Data has deep knowledge of Archimedes offerings, healthcare data, and analytics workflows. You will mentor other analysts and help ensure decisions are based on accurate data.

Qualifications

  • Bachelor’s degree 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.
  • Advanced SQL proficiency, including window functions, stored procedures, temp tables, performance-aware query design, data validation, and troubleshooting complex business logic, required.

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.

Skills

Advanced SQL
SSMS experience
Power BI
Data modeling
Mentoring
Stakeholder communication
Data validation
ETL/ELT
Analytical thinking
Team collaboration

Education

Bachelor's degree

Tools

SSMS
SQL Server

Job description

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

The Sr. Analyst, Data has deep knowledge of Archimedes offerings, healthcare data, and analytics workflows. You will mentor other analysts and help ensure decisions are based on accurate data.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Senior Data Analyst - Remote, Power BI & SQL Expert
Senior Data Analyst - Remote, Power BI & SQL Expert

Archimedes • Trenton (NJ)

Remote
USD 110,000 - 170,000
Health insurance
PTO 20 days
Parental leave 4 weeks
+6
Senior Data Analyst, Remote — SQL & Power BI Expert
Senior Data Analyst, Remote — SQL & Power BI Expert

Archimedes • Montgomery (AL)

Remote
USD 95,000 - 125,000
Health insurance
Dental insurance
Vision insurance
+1
Senior Data Analyst, Remote | SQL, Power BI, Healthcare PBM
Senior Data Analyst, Remote | SQL, Power BI, Healthcare PBM

Archimedes • Tallahassee (FL)

Remote
USD 90,000 - 120,000
Health, Dental, Vision insurance
Paid time off 20 days
4 weeks parental leave
+6
Senior Data Analyst - Remote, Power BI & Data Modeling
Senior Data Analyst - Remote, Power BI & Data Modeling

Navitus Health Solutions, LLC • Iowa City (IA)

Remote
USD 90,000 - 130,000
Health insurance
Dental insurance
Vision insurance
+9
Senior Data Analyst, Healthcare Analytics Lead (Remote)
Senior Data Analyst, Healthcare Analytics Lead (Remote)

Archimedes • Trenton (NJ)

Remote
USD 110,000 - 140,000
Health, dental, and vision insurance
Paid time off
Parental leave
Senior Data Analyst, Healthcare Analytics — Remote
Senior Data Analyst, Healthcare Analytics — Remote

Navitus Health Solutions, LLC • Nashville (TN)

Remote
USD 90,000 - 120,000
Health insurance
20 days PTO
4 weeks parental leave
+2
Remote Senior Data Analyst - SQL + Power BI
Remote Senior Data Analyst - SQL + Power BI

Navitus Health Solutions, LLC • Springfield (IL)

Remote
USD 90,000 - 130,000
Health insurance
Dental insurance
Vision insurance
+5
Senior Data Analyst, Analytics & BI (Remote)
Senior Data Analyst, Analytics & BI (Remote)

Navitus Health Solutions, LLC • United States

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

Archimedes • Harrisburg

Remote
USD 90,000 - 130,000
Health insurance
Dental insurance
Vision insurance
+7
Senior Data Analyst – Healthcare Analytics (Remote)
Senior Data Analyst – Healthcare Analytics (Remote)

Navitus Health Solutions, LLC • Kansas City (MO)

On-site
USD 90,000 - 120,000
Health, Dental, Vision insurance
20 days paid time off
Parental leave (4 weeks)
+5