* Collaborate with Ecommerce BI Analysts to understand business needs and
translate them into productive 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.
* Strong understanding of ecommerce metrics and digital product data needs.
* Ability to lead data modeling effo