← Back to jobsJob ID col-cmwp76kt2076hd8hac1p41noh

Navitus Health SolutionsPosted 1 day ago

Senior Data Analyst - ArchimedesNew

Full-time
Hybrid
5+ years
Competitive
Posted 1 day ago

Archimedes is hiring a Senior Data Analyst to lead complex analytical initiatives and develop reliable data solutions for analytics, reporting, and operational decision-making. The role translates business problems into scalable analysis, trusted datasets, and recommendations while improving reporting processes and advising stakeholders.

Healthcare

Posted
1 day ago
Source
careers-navitus.icims.com
Sector
Information Technology & AI

Opens the employer's application page in a new tab

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

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
  • Advanced SQL proficiency, including window functions, stored procedures, temp tables, performance-aware query design, data validation, and troubleshooting complex business logic, required
  • Experience leading complex analytical projects, translating ambiguous requirements, and delivering high-quality work with minimal managerial guidance 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

Required skills

Analytical Project LeadershipData AnalysisData ModelingData WarehousingETL/ELTPower BISQLSQL ServerSSMS

Full job description

Archimedes is hiring a Senior Data Analyst to lead complex analytical initiatives and develop reliable data solutions for analytics, reporting, and operational decision-making. The role translates business problems into scalable analysis, trusted datasets, and recommendations while improving reporting processes and advising stakeholders.

Healthcare

  • Information Technology
  • Health Care

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

Benefits

  • 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
  • Professional Membership assistance
  • Referral Bonus Program – up to $750!
  • Remote work is available only 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, and Wisconsin.
  • Hybrid work: In Office 3 Days

Company

  • Transparent, cost-effective pharmacy benefit management services.
  • Madison, Wisconsin, USA
  • https://www.navitus.com/

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
  • Advanced SQL proficiency, including window functions, stored procedures, temp tables, performance-aware query design, data validation, and troubleshooting complex business logic, required
  • Experience leading complex analytical projects, translating ambiguous requirements, and delivering high-quality work with minimal managerial guidance 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
  • 5 years of experience with data analysis, business analysis, analytics engineering, reporting, data warehousing, or related analytical work in a production environment required.

Required skills

  • Analytical Project Leadership, Data Analysis, Data Modeling, Data Warehousing, ETL/ELT, Power BI, SQL, SQL Server, SSMS

Experience

  • 5+ years

Job details

Employment type

Full-time

Seniority level

5+ years

Date posted

Nov 20, 2026

Work mode

Hybrid

Job source

careers-navitus.icims.com

Company

Navitus Health Solutions

Information Technology & AI

Transparent, cost-effective pharmacy benefit management services.

See all 5 jobs from Navitus Health Solutions →
  • Madison, Wisconsin, USA
  • Information Technology & AI
  • navitus.com

Similar jobs

Matched on role, skills and location · live jobs only

See more Data Analyst jobs in Madison

Tetra Tech

1d ago

New

Data Analyst

Full-timeHybridMadison, WI$65K – $95K/yr

Tetra Tech is hiring a Data Analyst to support research and analytics services for client decision-making. The role prepares and analyzes data, supports survey and qualitative research, manages survey projects and databases, and communicates results.

Why similarSame roleData AnalysisMadison

Soho Square Solutions

1d ago

New

Senior Data Analyst – Data Discovery, Modernization & Migration

TemporaryOn-siteMcLean, VACompetitive

Soho Square Solutions is recruiting for an unnamed direct client seeking a Senior Data Analyst. The role focuses on discovering and profiling legacy data, supporting application modernization, and leading data analysis across migration, transformation,…

Why similarSame roleData AnalysisData Modeling

Optum

1d ago

New

Senior Data Analyst-Little Rock,Arkansas

Full-timeOn-siteLittle Rock, AR$92K – $164K/yr

Optum is hiring a Senior Data Analyst for the Arkansas AME DSS Project. The role analyzes data from multiple sources, maintains business intelligence dashboards, assures data quality, and provides analytical and project management support to enterprise…

Why similarSame roleData AnalysisPower BI

Get new Data Analyst jobs in Madison by email

Create job alert

Senior Data Analyst - Archimedes

Navitus Health Solutions · Competitive

Apply on company site