Senior Analyst, Data

This is a fully remote position, open to applicants in Alabama, +19 more locations.

📋 Description

• Oversee intricate, cross-departmental analytical projects from the initial business problem definition through data analysis, validation, stakeholder communication, and final delivery.

• Convert ambiguous business inquiries into analytical strategies, reusable reporting frameworks, scalable datasets, and actionable insights.

• Design, sustain, and enhance SQL-driven analytical solutions, data models, views, stored procedures, and recurring reporting processes.

• Compose and review advanced SQL using SSMS, encompassing complex joins, CTEs, window functions, temporary tables, stored procedures, performance-oriented query design, and thorough validation logic.

• Examine pharmacy claims, member, client, drug, formulary, rebate, network, provider, clinical, operational, and financial datasets.

• Act as a subject matter expert for designated business domains, datasets, metrics, reporting processes, and data dependencies.

• Guide stakeholders on metric definitions, data interpretation, analytical trade-offs, methodologies, assumptions, limitations, and suggested actions.

• Create and enhance Power BI reports, dashboards, semantic models, and analytical outputs.

• Set standards for data validation, documentation, report design, quality assurance, peer reviews, and maintainable analytical coding.

• Investigate data quality issues, reconcile outputs across systems, identify root causes, and propose process or data enhancements.

• Spearhead modernization and continuous improvement initiatives to minimize manual efforts, enhance reliability, boost scalability, and clarify ownership.

• Mentor Analyst, Data and Analyst II, Data team members through code reviews, analytical evaluations, documentation, technical coaching, and sharing business context.

• Assist with client reporting, regulatory reporting, network adequacy, disruption analysis, RFP responses, audit support, formulary analytics, and other PBM analytical needs.

• Execute additional responsibilities as assigned.

⛳️ Requirements

• A bachelor's degree, ideally in a quantitative field such as business, healthcare, information systems, economics, statistics, mathematics, computer science, or a related area, or equivalent work experience, is required.

• Five years of experience in data analysis, business analysis, analytics engineering, reporting, data warehousing, or comparable analytical work in a production setting is required.

• Proven experience in leading complex analytical projects, translating unclear requirements, and producing high-quality outputs with minimal managerial oversight is required.

• Experience in mentoring analysts, reviewing analytical code or reporting logic, and enhancing reporting or data processes is preferred.

• Familiarity with healthcare, pharmacy benefit management, managed care, or other highly regulated data is preferred.

• Advanced SQL skills, including window functions, stored procedures, temporary tables, performance-oriented query design, data validation, and troubleshooting complex business logic, are required.

• Extensive experience using SSMS and SQL Server-based analytics environments to develop, validate, document, and optimize analytical solutions is required.

• Strong knowledge of data warehousing concepts, ETL/ELT workflows, data modeling, upstream and downstream dependencies, and production reporting controls is required.

• Experience in developing or enhancing Power BI reports, dashboards, semantic models, and governed analytical datasets is required.

• Ability to establish effective standards for documentation, quality assurance, peer reviews, maintainability, and business-rule transparency is required.

• Engage in, adhere to, and support compliance program objectives.

• The ability to consistently interact cooperatively and respectfully with colleagues is essential.

🏝️ Benefits

• Comprehensive industry-leading benefits for Health, Dental, and Vision insurance

• 20 days of paid time off

• 4 weeks of 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 and Professional Membership support

• Referral Bonus Program – up to $750!