Note: The job is a remote job and is open to candidates in USA. Archimedes is hiring a Senior Data Analyst to lead complex analytical initiatives and develop reliable data solutions for analytics, reporting, and operational decision-making. The role translates business problems into scalable analysis, trusted datasets, and recommendations while improving reporting processes and advising stakeholders.
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
Skills
- 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
- 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
Benefits
- Health, Dental, and Vision insurance
- 20 days paid time off
- 4 weeks paid parental leave
- 9 paid holidays
- 401K company match of up to 5% - No vesting requirement
- Adoption Assistance Program
- Flexible Spending Account
- Educational Assistance Plan
- Professional Membership assistance
- Referral Bonus Program – up to $750!
- Remote work is available only to residents of Alabama, Colorado, Florida, Georgia, Indiana, Illinois, Iowa, Kansas, Kentucky, Maryland, Minnesota, Missouri, New Hampshire, New Jersey, Ohio, Oklahoma, Pennsylvania, Tennessee, Texas, Virginia, and Wisconsin.
- Hybrid work: In Office 3 Days
Company Overview
Company H1B Sponsorship