Quick overview
Job description
- 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.
- Strong understanding of ecommerce metrics and digital product data needs.
- Ability to lead data modeling efforts and mentor junior engineers.
- Strong understanding of data governance and documentation best practices.
- Strong skills in mathematics.
- Strong attention to detail.
- Solid organizational skills, ability to handle multiple projects and meet deadlines.
- Good presentation, oral, and written communication skills.
- Communicate clearly and concisely with technical and non-technical stakeholders.
- Highly effective in working within teams with wide target audiences.
- Understanding of basic web programming principles, tools, and technologies.
- Experience with data that explains user behavior.
- Bachelor’s degree in a related field or equivalent related work experience. Master’s degree preferred.
- 2+ to 7+ years of combined experience with dbt or similar transformation tools based on level.
- 2+ to 7+ years of experience with cloud data platforms and scalable data modeling based on level.
- 6+ years digital analytics data (Google Analytics Preferred) experience required.
This is a summary of the primary accountabilities and requirements for this position. The company reserves the right to modify or amend accountabilities and requirements at any time at its sole discretion based on business needs. Any part of this job description is subject to possible modification to reasonably accommodate individuals with disabilities
Haystack's AI agent can fill in and submit this application for you. How AI auto apply works
Similar jobs
- EX
Analytics ConsultantRecently posted Auto Apply
Experian · Mumbai · On-site · Posted 12 Nov 2026 🇮🇳
PythonMachine LearningTechnologySalary not listed - TE
Digital Analytics Engineer Auto Apply
The Economist Group · Gurugram · Hybrid · Posted 10 Nov 2026 🇮🇳
HTMLSnowflakeCSS+6TechnologySalary not listed - CA
FBS Analytics Engineer Auto Apply
Capgemini · Hyderabad, Telangana · Hybrid · Posted 3 Nov 2026 🇮🇳
Workers CompensationTechnologySalary not listed - CA
FBS Analytics Engineer Auto Apply
Capgemini · Pune, Maharashtra · Hybrid · Posted 3 Nov 2026 🇮🇳
Workers CompensationTechnologySalary not listed - B2
Lead Analytics Engineer - R01572950 Auto Apply
Brillio 2 · Bengaluru · Hybrid · Posted 30 Oct 2026 🇮🇳
SQLETLData Pipeline+8TechnologySalary not listed - DI
Senior Analytics Engineer Auto Apply
DoorDash India · Hyderabad · Hybrid · Posted 5 Nov 2026 🇮🇳
SQLScalaMicrosoft Excel+10TechnologySalary not listed - ME

Senior Analytics EngineerRecently posted Auto Apply
Metropolis · Bengaluru · Hybrid · Posted 11 Nov 2026 🇮🇳
SQLSnowflakeComputer Vision+2TechnologySalary not listed - PA

Analytics Lead- User Growth I Exp- 8- 10 Years Auto Apply
Paytm · Noida · On-site 🇮🇳
FirebaseSQLMicrosoft Excel+13Salary not listed - CO

Principal Data Analytics Engineer Auto Apply
Commvault · Bengaluru · Hybrid · Posted 3 Nov 2026 🇮🇳
SQLGitMLOps+12TechnologySalary not listed - JU

Senior Business Analytics Engineer - India Auto Apply
Junipersquare · India · Hybrid 🇮🇳
SQLLookerSOC 2+7TechnologySalary not listed - PE
Senior AI & Analytics Engineer Auto Apply
Pearl · India · Hybrid · Posted 6 Nov 2026 🇮🇳
DockerSQLSnowflake+12TechnologySalary not listed - 6S

Sr. Manager, Enterprise Analytics - G&A Auto Apply
6sense · Bengaluru · Hybrid · Posted 30 Oct 2026 🇮🇳
OnboardingSQLSnowflake+4Salary not listed
