Sr. Analyst, Data - (Client Support) Archimedes

Archimedes is hiring a Senior Analyst, Data, to lead complex analytical initiatives and build reliable data solutions supporting analytics, reporting, and operational decision-making. The role translates business problems into scalable analysis, trusted datasets, and recommendations while improving reporting practices and mentoring 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
• 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

Requirements:

• 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
• Experience leading complex analytical projects, translating ambiguous requirements, and delivering high-quality work with minimal managerial guidance required
• 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
• The ability to consistently interact cooperatively and respectfully with other employees
• 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