[Hiring] Data & Reporting Analyst @Southern Scripts

Role Description

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.

• 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.

Qualifications

• 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.

Requirements

• 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.
• 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.
• 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.
• 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.
• 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.

Benefits

• 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.

Company Description

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.