Senior Data Analyst, Healthcare PBM & Analytics Lead

Archimedes

Atlanta (GA)

On-site

USD 110,000 - 140,000

Full time

5 days ago

Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Benefits offered by this job

Health, Dental, Vision

PTO 20 days

Parental leave 4 weeks

Holidays 9

401K match 5%

Adoption assistance

Flexible Spending Account

Educational assistance

Referral bonus

Job summary

Archimedes is seeking a Sr. Analyst- Client Support, Data to join our team in Atlanta. You will lead complex analytics projects, translate business questions into actionable plans, and design scalable data solutions using SQL and Power BI.

Mentoring junior analysts and partnering with stakeholders to drive data-driven decisions are core aspects of this role. The ideal candidate will have deep SQL expertise, experience with healthcare data, and a proven track record in building reliable reporting

Qualifications

Bachelor's degree in a quantitative field or equivalent experience is required.
5 years of data analysis, analytics engineering, or related analytical work in a production environment is required.
Experience leading complex analytical projects with minimal managerial guidance.
Experience mentoring analysts and improving reporting or data processes is preferred.
Experience with healthcare or pharmacy data is preferred.
Advanced SQL proficiency with window functions, stored procedures, temp tables, and data validation is required.
Experience with SSMS and SQL Server-based analytics environments is required.
Strong data warehousing, ETL/ELT, data modeling, and reporting controls knowledge is required.
Experience developing Power BI reports and dashboards is required.
Ability to establish standards for documentation, QA, maintainability, and governance is required.
Experience participating in compliance programs and cross-functional collaboration is expected.

Responsibilities

Lead complex cross-functional analytics projects from problem definition through data analysis and final delivery.
Translate ambiguous business questions into analytical plans and scalable datasets.
Design, maintain, and optimize SQL-based analytical solutions and data models.
Write and review advanced SQL using SSMS with complex joins, CTEs, and window functions.
Analyze healthcare and PBM datasets to identify risks, trends and insights.
Serve as SME for assigned domains, datasets, metrics, and reporting processes.
Advise stakeholders on metric definitions, data interpretation, and methodological trade-offs.
Develop and enhance Power BI reports, dashboards, and semantic models.
Establish standards for data validation, documentation, report design, and QA.
Investigate data quality issues, identify root causes, and recommend durable improvements.
Lead modernization and continuous improvement to reduce manual work and increase reliability.
Mentor Analysts through code reviews, coaching, and knowledge sharing.
Support client reporting, regulatory reporting, audit, formulary analytics, and other high-impact needs.
Other duties as assigned.