Sr. Analyst, Data - Archimedes

Navitus Health Solutions, LLC•,

1d•Remote

About The Position

Archimedes is seeking a Sr. Analyst, Data to lead complex analytical initiatives and design reliable data solutions supporting analytics, reporting, and operational decision-making across the organization. The role partners with stakeholders to translate ambiguous or complex business problems into scalable analytical approaches, trusted datasets, and clear recommendations. The Sr. Analyst, Data applies deep knowledge of Archimedes business offerings, healthcare and pharmacy benefit management data, analytical workflows, and data dependencies. Using advanced SQL expertise, data modeling knowledge, and business judgment, this role promotes best practices, improves legacy and modern reporting processes, mentors other analysts, and helps ensure organizational decisions use accurate, well-understood data. The position is remote, with remote work limited to residents of the states listed in the job posting.

Requirements

Bachelor’s degree, preferably in a quantitative, business, healthcare, information systems, economics, statistics, mathematics, computer science, or related field, or equivalent work experience.
At least 5 years of experience in data analysis, business analysis, analytics engineering, reporting, data warehousing, or related analytical work in a production environment.
Experience leading complex analytical projects, translating ambiguous requirements, and delivering high-quality work with minimal managerial guidance.
Advanced SQL proficiency, including window functions, stored procedures, temporary tables, performance-aware query design, data validation, and troubleshooting complex business logic.
Advanced experience using SSMS and SQL Server-based analytics environments to develop, validate, document, and optimize analytical solutions.
Strong understanding of data warehousing concepts, ETL/ELT workflows, data modeling, upstream and downstream dependencies, and production reporting controls.
Experience developing or improving Power BI reports, dashboards, semantic models, and governed analytical datasets.
Ability to establish practical standards for documentation, quality assurance, peer review, maintainability, and business-rule transparency.
Ability to interact cooperatively and respectfully with other employees.

Nice To Haves

Experience mentoring analysts, reviewing analytical code or report logic, and improving reporting or data processes.
Experience with healthcare, pharmacy benefit management, managed care, or other highly regulated data.

Responsibilities

Lead complex, cross-functional analytical projects from business problem definition through 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.
Write and review advanced SQL using SSMS, including complex joins, CTEs, window functions, temporary tables, stored procedures, performance-aware query design, and 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, methodology, assumptions, limitations, and recommended actions.
Develop and enhance Power BI reports, dashboards, semantic models, and analytical deliverables for business stakeholders and leadership.
Establish and promote 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 to reduce manual work, improve reliability and scalability, and clarify ownership of recurring analytics processes.
Mentor Analyst, Data and Analyst II, Data team members through code and 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.
Participate in, adhere to, and support compliance program objectives.
Interact cooperatively and respectfully with other employees.
Perform other duties as assigned.