• Collaborate with data engineering, analytics, product, and marketing teams to design and implement reliable, scalable data models and transformation pipelines. • Develop and maintain dbt models, macros, and documentation that ensure data accuracy, reusability, and clarity across the organization. • Partner with business stakeholders to translate analytical needs into well-structured datasets that support reporting and self-service analytics. • Support and uphold best practices for data modeling, testing, version control, and documentation across analytics workflows. • Proactively identify and address issues in data quality, model performance, and pipeline efficiency. • Contribute to the standardization of metrics, definitions, and semantic layers to ensure consistent reporting across business units. • Participate in code reviews and knowledge-sharing to continuously improve team processes and data craftsmanship. • Stay current with modern data tools, frameworks, and best practices to help evolve our analytics engineering stack.

• Establish the foundation of LiveKit's analytics practice • Translate business concepts into robust data models • Create actionable KPIs • Enable data-driven decision making across the organization • Use AI coding assistants extensively and evolve AI development workflows • Resist the urge to over-engineer • Spend significant time with stakeholders to memorialize business logic and create trusted metrics • Ensure everything built needs clear documentation for users and AI systems • Follow engineering best practices with PR reviews and automated testing • Comfort with ambiguity and rapid iteration

• Apply hands-on analytics engineering expertise to solve complex, fast-paced business and clinical problems using data. • Design, develop and maintain scalable, analytics ready data models and pipelines (primarily in dbt) that power clinical program reporting, metrics and insights in our Unified Data Warehouse (UDW). • Partner closely with clinical program leaders, analysts, product teams, and operations stakeholders to understand program workflows (e.g., enrollment, adherence, outcomes, follow ups) and translate them into intuitive, well-documented data models. • Build curated data marts and semantic layers that make analytics for clinical programs (such as diabetes and weight management) easy to self-serve for dashboards, ad-hoc analysis and operational reporting. • Own KPI and metric definitions end-to-end, from raw source data through production-grade models, ensuring consistency, transparency and trust in reporting. • Implement automated data validation, testing and quality checks to ensure high data reliability across clinical and operational datasets. • Continuously optimize data models and warehouse performance for both cost and speed as usage scales. • Contribute to analytics governance by establishing guardrails, documentation and best practices that improve accountability, ownership, and data literacy across teams. • Communicate insights effectively by developing clear data memos, documentation and presentations tailored to clinical and business stakeholders. • Explore and integrate AI-enabled analytics and predictive modeling use cases (e.g., adherence risk, program outcomes, operational forecasting) into the analytics stack. Experience operationalizing ML models is a plus.

• Apply hands on analytics and data expertise to solve complex, fast moving financial and operational problems using PBM data. • Design, develop and maintain scalable, analytics ready data models (primarily in dbt) that power a PBM financial risk engine, leveraging claims, eligibility, pricing, rebates, guarantees and contract data in our Unified Data Warehouse (UDW). • Translate complex PBM contract and pricing structures (e.g plan paid vs. member paid, rebates, guarantees, caps, fees, exclusions) into transparent, auditable data models that enable financial analysis and risk assessment. • Partner closely with underwriting, finance, client success and PBM operations teams to understand financial assumptions, risk drivers and reporting requirements and convert them into reliable metrics and models. • Build curated financial and risk data marts and semantic layers that enable self service analysis for forecasting, scenario modeling and executive reporting among other things. • Own core financial KPIs and risk metrics E2E from raw claims and contract inputs through production grade models, ensuring consistency and traceability. • Implement automated data quality checks, reconciliations and controls to validate financial outputs and ensure alignment with source systems and contractual logic. • Continuously optimize data models and warehouse performance to support large scale claims volumes and time-sensitive financial analysis. • Contribute to data governance by establishing modeling standards, documentation and guardrails that support auditability, explainability and long term maintainability. • Communicate complex financial insights clearly through data memos, documentation and presentations for both technical and non technical stakeholders. • Explore advanced analytics and predictive modeling use cases (e.g utilization forecasting, trend analysis, risk stratification, margin sensitivity) to enhance financial planning and decision making. Experience operationalizing ML models is a plus.