Liviniti ir veselības aprūpes uzņēmums un aptieku pabalstu pārvaldītājs (PBM), kas apkalpo darba devējus un veselības aprūpes sistēmas, piedāvājot pārredzamu cenu noteikšanu. Tā darbības modelis apvieno pārredzamu cenu noteikšanu, 100 % atlaižu novirzīšanu klientiem, fiksētu administrēšanas maksu un piekļuvi atlīdzību pieprasījumu un atlaižu informācijai, lai klienti varētu labāk izprast un pārvaldīt izdevumus par recepšu medikamentiem. Liviniti nodrošina arī pielāgojamus zāļu sarakstus un aptieku tīklus, klīniskās programmas, kā arī iepriekšējas atļaujas procedūru, kas izstrādāta, ņemot vērā zemākās neto izmaksas. Specializētais piedāvājums ietver LivLite, kas palīdz pārvaldīt GLP-1 svara samazināšanas medikamentus. Koncentrējoties uz uzņēmumu apkalpošanu, klīnisko vērtību un dalībnieku atbalstu, Liviniti izstrādā aptieku pabalstu risinājumus organizācijām, kuras vēlas labāk pārredzēt un kontrolēt savas veselības aprūpes izmaksas.
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.
Apraksts
- 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.
Prasības
- 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.
Priekšrocības
- 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.