Liviniti yra sveikatos priežiūros įmonė ir darbdaviams bei sveikatos sistemoms paslaugas teikiantis skaidraus atsiskaitymo vaistinių išmokų valdytojas (PBM). Jos modelis apima skaidrią kainodarą, 100 proc. nuolaidų perleidimą klientams, fiksuotą administravimo mokestį ir prieigą prie žalų bei nuolaidų informacijos, kad klientai galėtų geriau suprasti ir valdyti išlaidas receptiniams vaistams. Liviniti taip pat siūlo pritaikomus vaistų sąrašus ir vaistinių tinklus, klinikines programas bei išankstinio leidimo procedūrą, sukurtą atsižvelgiant į mažiausias grynąsias išlaidas. Specializuoti pasiūlymai apima „LivLite“, padedantį valdyti GLP-1 svorio mažinimo vaistus. Daugiausia dėmesio skirdama verslui verslui teikiamoms paslaugoms, klinikinei vertei ir narių palaikymui, Liviniti kuria vaistinių išmokų sprendimus organizacijoms, siekiančioms geriau matyti ir kontroliuoti savo sveikatos priežiūros išlaidas.
Data Reporting Analyst
Develop SQL reporting solutions for Variable Copay’s healthcare programs, safeguarding data quality and automating workflows. Deliver operational and client reports that support informed decisions.
Aprašymas
- Develop and improve reporting solutions with SQL/T-SQL in SQL Server and Snowflake.
- Create and update reports by translating business needs into accurate, efficient query logic.
- Collect and confirm reporting requirements, including definitions, data granularity, assumptions, and edge cases.
- Validate and reconcile deliverables before release to protect data accuracy and integrity.
- Examine and reverse-engineer existing SQL, reporting logic, and inherited report structures.
- Investigate reporting discrepancies, data quality problems, and operational issues to identify root causes.
- Document and share findings and recommendations from data investigations.
- Prepare reporting and stored procedure requests for IT teams, then track them through implementation.
- Automate recurring reports, workflows, and business processes with Power Automate or other approved tools.
- Maintain report and business logic documentation, inventories, process guides, and data dictionaries.
- Work with subject matter experts to confirm business logic and align reporting with stakeholder needs.
- Explain data trends, findings, and recommendations to technical and non-technical audiences.
- Provide recurring and ad hoc reports for operations, clients, and leadership.
- Coordinate concurrent reporting initiatives and deliver them within established timelines.
- Manage reporting requests from intake to delivery, including stakeholder updates, timelines, and issue resolution.
- Improve reporting quality, automation, efficiency, and scalability through ongoing process improvements.
- Follow HIPAA requirements for Protected Health Information and report violations.
- Complete required HIPAA training.
- This role has no supervisory responsibilities.
- No travel is expected.
Reikalavimai
- Advanced SQL/T-SQL skills, including writing complex, efficient queries from scratch.
- Experience with relational databases, preferably SQL Server (SSMS) and Snowflake.
- Strong grasp of query optimization and performance tuning.
- Ability to work in established data environments with existing tables, views, and reporting objects.
- Able to interpret schemas independently, understand data structures, and map table relationships.
- Experience reading, troubleshooting, and reverse-engineering existing SQL code and reporting logic.
- Strong skills in Microsoft Excel and other Microsoft Office applications.
- Strong understanding of the full reporting and analytics lifecycle.
- Familiarity with ETL concepts, reporting workflows, and data movement.
- Experience finding root causes and resolving data quality issues.
- Understanding of data modeling fundamentals, including keys, relationships, data grain, and reporting layers.
- Ability to assess report outputs critically and spot inconsistencies or anomalies.
- Strong requirements gathering and business analysis skills.
- Commitment to data accuracy, validation, and quality assurance.
- Ability to verify business logic and align report outputs with stakeholder expectations.
- Experience maintaining detailed documentation, reporting standards, and data definitions.
- Strong critical thinking and curiosity when assessing data and reporting results.
- Self-directed and able to work independently with limited guidance while remaining accountable.
- Strong written and verbal communication skills.
- Able to communicate effectively with technical teams, operations partners, and leaders.
- Proactive, consistent stakeholder communication throughout each reporting request.
- Strong organizational and project management skills.
- Able to work in a fast-changing environment with evolving processes and infrastructure.
- Excellent attention to detail and digital organization.
- Experience automating recurring reports and workflows with Power Automate or similar tools.
- Able to define requirements and coordinate development with centralized IT teams.
- Bachelor’s degree in information systems, data analytics, computer science, business analytics, statistics, or a related field, or an equivalent combination of education and practical experience.
- At least 3 to 5 years of hands-on experience in reporting, analytics, business intelligence, or a related area.
- Demonstrated experience writing advanced SQL/T-SQL queries in a business or operational setting.
- Experience delivering recurring and ad hoc reports for business stakeholders.
- Experience validating and reconciling reports to ensure data accuracy.
- Experience handling sensitive and confidential healthcare information.
- Experience managing multiple priorities and stakeholder requests at once.
- Strong understanding of reporting documentation and governance practices.
- Preferred: Experience in PBM, healthcare, specialty pharmacy, or health plans.
- Preferred: Experience with Snowflake data environments.
- Preferred: Experience with Azure DevOps, source repositories, or change management processes.
- Preferred: Experience using ticketing systems for work intake and project tracking.
- Preferred: Tableau experience in report development, maintenance, or support.
- Preferred: Experience supporting operations, client-facing work, or healthcare analytics.
Privalumai
- Medical, dental, and vision insurance.
- Disability and life insurance.
- Employee Assistance Program.
- Remote work options.
- Generous paid time off.
- Annual performance reviews and development plans.
- Retirement plan with an immediate company match and 100% vesting.