Data & Reporting Analyst

Data & Reporting Analyst - REMOTE

Role And Responsibilities The Data and Reporting Analyst is responsible for developing, maintaining, validating, and enhancing reporting solutions that support operational, client, and leadership decision-making across RxCompass and Variable Copay programs. Reporting to the Supervisor of Data and Analytics, this role serves as a technical reporting resource within a growing analytics environment, translating business requirements into accurate, efficient, and scalable reporting solutions. The position requires strong hands-on SQL expertise, a high level of analytical rigor, and an unwavering commitment to data integrity. The Data and Reporting Analyst partners closely with operations, business integration, quality, client services, leadership, and subject matter experts to deliver trusted reporting, investigate data discrepancies, and improve reporting processes. This individual must be comfortable working independently, navigating existing data structures, and driving requests from intake through delivery while maintaining proactive communication with stakeholders. The following objectives further define the key job functions with a special focus on the following: • Develop, maintain, and optimize reporting solutions using SQL/T-SQL within SQL Server and Snowflake environments. • Build new reports and enhance existing reporting assets by translating business requirements into efficient and accurate query logic. • Gather and validate reporting requirements, including business definitions, granularity, assumptions, and edge cases prior to development. • Perform multiple levels of validation and reconciliation before releasing reporting deliverables to ensure data accuracy and integrity. • Review and reverse-engineer inherited SQL code, reporting logic, and existing reporting structures to understand business rules and validate correctness. • Conduct root cause analysis (RCA) of reporting discrepancies, data quality concerns, and operational reporting issues. • Identify, document, and communicate findings and recommendations resulting from data investigations. • Scope, draft, and submit reporting and stored procedure requests to Information Technology teams and manage requests through implementation. • Automate recurring reports, workflows, and business processes using Power Automate or other approved tools. • Maintain reporting documentation, business logic documentation, report inventories, process documentation, and data dictionaries. • Collaborate with subject matter experts to validate business logic and ensure reporting aligns with stakeholder intent. • Present data trends, findings, and recommendations in a clear and understandable format for both technical and non-technical audiences. • Support operational, client, and leadership reporting needs through recurring and ad hoc reporting requests. • Prioritize and manage multiple concurrent reporting initiatives while meeting established deadlines. • Take ownership of reporting requests from intake through delivery, proactively managing stakeholder communication, timelines, and issue resolution • Drive continuous improvement initiatives that enhance reporting quality, automation, efficiency, and scalability. • Abide by all obligations under HIPAA related to Protected Health Information (PHI). • If a HIPAA violation is discovered, whether individually or by another, you must report the violation to the Compliance Officer and/or Human Resources. • Attend, complete, and demonstrate competency in all required HIPAA Training offered by the company. • Flexibility to understand, appreciate, and embrace that this job description is not designed to cover or contain a comprehensive listing of activities, duties, or responsibilities that are required of the employee. Duties, responsibilities, and activities may change, or new ones may be assigned at any time with or without notice Required Skills And Competencies Technical Skills: • Advanced SQL/T-SQL development skills with the ability to write complex, efficient queries from scratch. • Experience working within relational database environments, preferably SQL Server (SSMS) and Snowflake. • Strong understanding of query optimization and performance tuning techniques. • Ability to work effectively within established data environments using existing tables, views, and reporting objects. • Ability to independently interpret schemas, understand data structures, and map table relationships. • Experience reading, troubleshooting, and reverse-engineering existing SQL code and reporting logic. • Strong proficiency in Microsoft Excel and other Microsoft Office applications Analytical Foundations and Process: • Strong understanding of the end-to-end reporting and analytics lifecycle. • Familiarity with ETL concepts, reporting workflows, and data movement processes. • Experience conducting root cause analysis and resolving data quality issues. • Understanding data modeling fundamentals, including keys, relationships, data grain, and reporting layers. • Ability to evaluate reporting outputs critically and identify inconsistencies or anomalies Analytical Rigoe and Standards: • Strong requirements gathering and business analysis skills. • Demonstrated commitment to data accuracy, validation, and quality assurance. • Ability to verify business logic and ensure alignment between stakeholder expectations and reporting outputs. • Experience maintaining detailed documentation, reporting standards, and data definitions. • Strong critical-thinking skills and intellectual curiosity when evaluating data and reporting results. • Self-motivated and capable of working independently with limited direction while maintaining accountability Communication and Collaboration: • Strong verbal and written communication skills. • Ability to communicate effectively with technical teams, operational partners, and leadership. • Consistent and proactive stakeholder communication throughout the lifecycle of a reporting request. • Strong organizational and project management skills. • Ability to work effectively in a rapidly evolving environment where processes and infrastructure continue to mature. • Excellent attention to detail and digital organization Automation and Process Improvement: • Experience automating recurring reports and workflows using Power Automate or similar automation platforms. • Ability to define requirements and coordinate development efforts with centralized IT teams. • Commitment to identifying opportunities to improve reporting efficiency, scalability, and reliability Supervisory Responsibility - This position has no supervisory responsibilities Position Type And Expected Hours of Work • Full-time, salary/exempt position. • Some flexibility in hours is allowed, but the employee must be available during the “core” work hours of 8:00 AM to 5:00 PM CT. We cover clients from the West to the East Coast; work times must be adjusted to cover meetings in all time zones. Ability to work extended hours, weekends, and holidays in accordance with industry demands What We Have to Offer Our benefits package is designed to keep our employees happy and healthy - physically, mentally and financially. • Medical, Dental and Vision insurance • Disability and Life insurance • Employee Assistance Program • Remote work options • Generous Paid-Time Off • Annual Reviews and Development Plans • Retirement Plan with company match immediately 100% vested Travel - No travel expected Qualifications And Education Requirements • Bachelor’s degree in information systems, Data Analytics, Computer Science, Business Analytics, Statistics, or a related field; or equivalent combination of education and practical experience. • 3 to 5+ years of hands-on reporting, analytics, business intelligence, or related experience. • Demonstrated experience writing advanced SQL/T-SQL queries in a business or operational environment. • Experience delivering recurring and ad hoc reporting solutions for business stakeholders. • Experience validating and reconciling reporting outputs to ensure data accuracy. • Experience working with sensitive and confidential healthcare-related information. • Experience managing multiple priorities and stakeholder requests simultaneously. • Strong understanding of reporting documentation and governance practices Preferred Qualifications • PBM, healthcare, specialty pharmacy, or health plan experience. • Experience with Snowflake data environments. • Experience with Azure DevOps, source repositories, or change management processes. • Experience utilizing ticketing systems for work intake and project tracking. • Tableau experience, including report development, maintenance, or support. • Experience supporting operational, client-facing, or healthcare analytics functions Variable Copay, LLC (VCP), and all entities provide equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, sex, national origin, age, disability, or genetics. In addition to federal law requirements, VCP complies with applicable state and local laws governing nondiscrimination in employment in every location in which the company has facilities. This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation, and training. VCP expressly prohibits any form of workplace harassment based on race, color, religion, gender, sexual orientation, gender identity or expression, national origin, age, genetic information, disability, or veteran status. Improper interference with the ability of VCP employees to perform their job duties may result in discipline up to and including discharge. EOE M/F/D/V