Senior Data Analyst & Insights Lead (Remote)

Navitus Health Solutions, LLC

Saint Paul (MN)

Remote

USD 90,000 - 140,000

Full time

6 days ago
Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Benefits offered by this job

Health benefits
PTO 20 days
Parental leave 4 weeks
Holidays 9
401K match

Job summary

Archimedes is seeking a Sr. Analyst- Data to lead complex analytical initiatives supporting analytics, reporting, and operational decision-making. You will translate business problems into scalable data solutions, mentor peers, and promote best practices using SQL and Power BI.

You will collaborate with stakeholders, design robust data models, and drive data quality improvements while supporting client reporting and regulatory needs. This role offers a strong remote-friendly schedule.

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.
  • 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.

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.

Skills

Analytical thinking
Advanced SQL
Mentoring analysts
Cross-functional collaboration

Education

Bachelor’s degree in quantitative/healthcare/IS field

Tools

SSMS
SQL Server
Power BI

Job description

Archimedes is seeking a Sr. Analyst- Data to lead complex analytical initiatives supporting analytics, reporting, and operational decision-making. You will translate business problems into scalable data solutions, mentor peers, and promote best practices using SQL and Power BI.

You will collaborate with stakeholders, design robust data models, and drive data quality improvements while supporting client reporting and regulatory needs. This role offers a strong remote-friendly schedule.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Senior Data Analyst & Analytics Lead (Remote)
Senior Data Analyst & Analytics Lead (Remote)

Navitus Health Solutions, LLC • Colorado Springs (CO)

Remote
USD 90,000 - 135,000
Health insurance
20 days PTO
4 weeks parental leave
+2
Senior Data Analyst - Remote & Strategic Insights
Senior Data Analyst - Remote & Strategic Insights

Navitus Health Solutions, LLC • Annapolis (MD)

Remote
USD 90,000 - 130,000
Health, Dental, Vision benefits
PTO 20 days
Parental leave 4 weeks
+6
Senior Data Analyst - Remote and Strategic Insights
Senior Data Analyst - Remote and Strategic Insights

Archimedes • Jefferson City (MO)

On-site
USD 105,000 - 140,000
Health benefits
Paid time off (PTO)
Parental leave
+6
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 - Remote, Impactful Analytics
Senior Data Analyst - Remote, Impactful Analytics

Navitus Health Solutions, LLC • Columbus (OH)

Remote
USD 90,000 - 130,000
Health insurance
Paid time off
Parental leave
+2
Senior Data Analyst - Remote, Impactful Analytics Leader
Senior Data Analyst - Remote, Impactful Analytics Leader

Navitus Health Solutions, LLC • Colorado

Remote
USD 110,000 - 140,000
Health, Dental, Vision insurance
Paid time off
Parental leave
Senior Data Analyst - Strategic Analytics (Remote)
Senior Data Analyst - Strategic Analytics (Remote)

Archimedes • Concord (NH)

On-site
USD 90,000 - 120,000
Top-tier health benefits
Paid time off
Parental leave
+2
Senior Data Analyst - Remote, High-Impact Analytics
Senior Data Analyst - Remote, High-Impact Analytics

Navitus Health Solutions, LLC • New Jersey

Remote
USD 110,000 - 140,000
Health insurance
Paid time off
Parental leave
+1
Senior Data Analyst, Client Support - Remote
Senior Data Analyst, Client Support - Remote

Archimedes • Springfield (IL)

Remote
USD 85,000 - 120,000
Health insurance
Paid time off
Parental leave
+3
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