Senior Data Analyst - Archimedes

Navitus Health Solutions is hiring a Senior Data Analyst for its Archimedes team. The role leads complex analytical initiatives, develops reliable SQL-based data solutions and Power BI deliverables, and partners with stakeholders to support reporting and operational decision-making. The position also serves as a subject matter expert, promotes data-quality and documentation standards, and mentors analysts.

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

Requirements:

• Bachelor's degree, 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
• preferably in a quantitative, business, healthcare, information systems, economics, statistics, mathematics, computer science, or related field