Senior Data Strategist, Health Analytics (Remote)

Archimedes; Columbus (OH); Remote; USD 95,000 - 130,000; Full time

Benefits offered by this job

Health, Dental, Vision Insurance

20 days paid time off

4 weeks parental leave

9 paid holidays

401K company match up to 5%

Adoption Assistance

Flexible Spending Account

Educational Assistance Plan

Referral Bonus Program

Job summary

Archimedes seeks a Sr. Analyst- Data to lead complex analytical initiatives and design reliable data solutions across analytics, reporting, and operations. This role partners with stakeholders to translate business problems into scalable analytical approaches, trusted datasets, and clear recommendations, leveraging SQL, data modeling, and governance practices.

The Sr. Analyst, Data mentors other analysts, enhances reporting processes, and ensures decisions are made with accurate, well-understood

Qualifications

• Bachelor's degree in a quantitative/healthcare/information systems field or equivalent work experience.
• 5 years of experience in data analysis, analytics, or data warehousing in a production environment.
• Experience leading complex analytical projects and delivering high-quality work with minimal guidance.
• Experience mentoring analysts and improving reporting or data processes.
• Experience with healthcare, PBM, or regulated data preferred.
• Advanced SQL proficiency including window functions, stored procedures, and performance-aware design.
• Experience with SSMS and SQL Server-based analytics environments for development and validation.
• Strong understanding of data warehousing concepts, ETL/ELT workflows, data modeling, and data governance.

Responsibilities

• Lead cross-functional analytical projects from definition through data analysis, validation, and delivery.
• Translate requirements into analytical plans, scalable datasets, and actionable recommendations.
• Design, optimize SQL-based solutions, data models, views, and reporting workflows.
• Write and review advanced SQL with complex joins, CTEs, and performance-focused design.
• Analyze pharmacy claims, member, client, and formulary data to identify risks and trends.
• Serve as SME for business domains, datasets, metrics, and data dependencies.
• Advise stakeholders on metric definitions, data interpretation, and methodology.
• Develop and enhance Power BI reports and semantic models used by leadership.
• Establish standards for data validation, documentation, QA, and maintainable analytics code.
• Investigate data quality issues, reconcile outputs, and recommend durable improvements.
• Lead modernization and process improvements to reduce manual work and improve reliability.
• Mentor junior analysts through code reviews and coaching.
• Support client reporting, regulatory reporting, and high-impact PBM analytics.

Skills

SQL proficiency

Power BI

Data analysis

Mentoring

Stakeholder communication

Data modeling

ETL/ELT

Education

Bachelor's degree

Tools

SSMS

SQL Server

Power BI

Job description

Archimedes seeks a Sr. Analyst- Data to lead complex analytical initiatives and design reliable data solutions across analytics, reporting, and operations. This role partners with stakeholders to translate business problems into scalable analytical approaches, trusted datasets, and clear recommendations, leveraging SQL, data modeling, and governance practices.

The Sr. Analyst, Data mentors other analysts, enhances reporting processes, and ensures decisions are made with accurate, well-understood