Senior Data Analyst, Client Support - Remote

Archimedes; Springfield (IL); Remote; USD 85,000 - 120,000; Full time

Benefits offered by this job

Health insurance

Paid time off

Parental leave

401K match

Education assistance

Referral bonus

Job summary

Archimedes seeks a Sr. Analyst- Client Support, Data to drive complex data initiatives and deliver trusted datasets and actionable insights. You will lead SQL-based analytics, mentor team members, and partner with stakeholders to design scalable reporting and data solutions.

The role emphasizes advanced SQL, Power BI development, data warehousing concepts, and cross-functional collaboration to support analytics and regulatory reporting across the organization.

Qualifications

• Bachelor's degree in a quantitative, business, healthcare, information systems, economics, statistics, mathematics, computer science, or related field, or equivalent work experience.
• 5 years of experience with 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.
• Experience mentoring analysts and improving reporting or data processes is preferred.

Responsibilities

• Lead complex, cross-functional analytical projects from 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 reporting workflows.
• Write and review advanced SQL using SSMS with complex joins, CTEs, window functions, temporary tables, and robust validation logic.
• Analyze pharmacy claims, member, client, drug, formulary, rebate, network, provider, clinical, operational, and financial datasets to identify risks and opportunities.
• Serve as a subject matter expert for assigned domains, datasets, metrics, reporting processes, and data dependencies.
• Advise stakeholders on metric definitions, data interpretation, methodological trade-offs, and recommended actions.
• Develop and enhance Power BI reports, dashboards, semantic models, and analytical deliverables used by leadership.
• Establish and promote standards for data validation, documentation, report design, quality assurance, and maintainable analytical code.
• Investigate data quality issues, reconcile outputs, and recommend durable improvements.
• Lead modernization efforts to reduce manual work, increase reliability, and clarify ownership of analytics processes.
• Mentor junior analysts through code review, documentation, and business-context sharing.
• Support client and regulatory reporting, audit support, formulary analytics, and other high-impact PBM needs.

Skills

Advanced SQL

Power BI

Data analysis

Data modeling

Mentoring

Stakeholder communication

SQL Server/SSMS

ETL/ELT concepts

Data quality

Problem solving

Education

Bachelor's degree in a quantitative or related field

Tools

SSMS

SQL Server environment

Job description

Archimedes seeks a Sr. Analyst- Client Support, Data to drive complex data initiatives and deliver trusted datasets and actionable insights. You will lead SQL-based analytics, mentor team members, and partner with stakeholders to design scalable reporting and data solutions.

The role emphasizes advanced SQL, Power BI development, data warehousing concepts, and cross-functional collaboration to support analytics and regulatory reporting across the organization.