• Develop and maintain data replication and ELT pipelines feeding the analytics platform • Design and implement dimensional data models using star and snowflake schemas • Build and maintain data transformations that convert operational data into analytics-ready datasets • Implement data quality checks, testing, and validation to ensure accuracy of KPIs and metrics • Create and maintain documentation for data models, business logic, and data lineage • Establish data governance standards for analytics, including naming conventions, access controls, and metric definitions • Partner with BI tool users (Tableau, Looker, Power BI) to design efficient, performant data structures • Mentor junior engineers and analysts on data modeling, SQL optimization, and analytics best practices