• Collaborate with Ecommerce BI Analysts to understand business needs and translate them into efficient data structures.
• Enable analysts to focus on delivering insights by ensuring timely access to curated, high-quality datasets.
• Partner with Data Engineers to ensure data availability in staging environments.
• Own the transformation layer between staging and analytics-ready datasets, applying business logic to create trusted sources for analysis.
• Develop and manage layered transformation workflows that promote modularity, traceability, and alignment with governance and AI-readiness standards.
• Build and maintain structured, reusable datasets using dbt or similar transformation tools, applying scalable logic to support analytics across ecommerce products.
• Maintain documentation, testing protocols, and data quality standards.
• Ensure data and models from on-prem applications, Google Analytics and other sources support key ecommerce metrics related to site search, customer behavior, product performance, and other relevant measures.
• Lead development of scalable,
modular data models (staging, intermediate, mart) that support traceability and reduce duplicative effort.
• Optimize transformation logic for performance and maintainability.
• Define and enforce documentation and lineage standards for analytics datasets.
• Work closely with cross-functional product teams to ensure data models align with customer experience goals and ecommerce KPIs.
• Experience supporting multi-domain and multi-language international ecommerce websites.
• Moderate SQL proficiency and understanding of data modeling principles.
• Experience with Alteryx or similar ETL platforms.
• Ability to optimize data models for performance and usability.
• Strong communication skills and ability to work cross-functionally.
• Advanced SQL skills and experience with performance tuning.
• Solid understanding of ecommerce metrics and digital product data needs.