• Build and maintain curated datasets using Databricks (Delta tables, jobs, SQL Warehouses) and SQL-based governed reporting tables. • Ingest and manage full pursuit lifecycle artifacts including RFPs, specifications, drawings, and addenda with proper metadata and version control. • Develop applied analytics solutions including: - Forecasting - Scenario modeling - Optimization (LP/MILP or practical heuristics) - Similarity modeling and benchmarking • Publish reliable datasets and insights for Tableau Cloud consumption with consistent business definitions. • Establish a closed-loop learning cycle by comparing design assumptions against operational outcomes to continuously improve benchmarks and estimate accuracy. • Partner cross-functionally with engineering, analytics, and solution design teams to improve automation decision-making at scale.

• Partner with Prior Authorization leadership to develop operational reporting and KPI frameworks • Build dashboards, reports, and performance tracking tools • Write and optimize SQL queries to support operational analytics initiatives • Create and maintain views and datasets within Snowflake • Conduct ad hoc analyses to support business decisions and operational improvement initiatives • Identify trends, workflow gaps, and performance opportunities through data analysis • Translate operational needs into scalable reporting solutions • Support process improvement and operational optimization initiatives • Ensure data accuracy and usability across reporting workflows.

• You will develop, maintain, and enhance reporting, dashboards, and analytical solutions that provide clear, actionable insights across TLC’s operational, client, and product environments. • You will analyse business, campaign, loyalty, and customer engagement data to identify trends, opportunities, risks, and areas for optimisation, supporting KPI tracking, commercial analysis, forecasting, and data-driven decision-making across the organisation. • You will work with data from Snowflake and connected operational systems to transform, analyse, and model data into trusted, business-ready datasets and semantic layers that support scalable reporting and self-service analytics. • You will help ensure data is accurate, structured, documented, and optimised for insight generation across the business. • You will contribute to improving reporting processes, dashboard usability, automation, and analytical workflows across TLC’s modern data environment. • You will support the adoption of AI-enabled analytics, intelligent workflows, and AI-assisted tooling to improve efficiency, accessibility of insights, and decision-making, while helping evolve future predictive and advanced analytical capabilities. • You will work closely with Product, Technology, Client Services, Commercial, and Leadership teams to understand business requirements, translate them into analytical solutions, and communicate insights clearly to both technical and non-technical stakeholders. • You will help maintain high standards of data accuracy, consistency, governance, and reporting best practices across TLC’s analytics environment. • You will support analysis across TLC’s operational ecosystem, including COSMOS, Mixpanel, campaign platforms, and third-party systems, helping deliver trusted insights into operational performance, programme effectiveness, and customer engagement.

• Consolidate and link data across partner APIs, internal databases, and partner-facing portals to build a coherent picture of program performance • Build and maintain dashboards (in Redash or similar) covering registration numbers, enrollment funnel analyses, and other key program metrics • Manually collect interval usage data from after demand response events, and help develop processes to make this collection faster and more reliable over time • Identify gaps, inconsistencies, and opportunities for automation in our residential data pipelines, and flag them so we can fix them