Ecommerce Analytics Engineer

Mouser Electronics, Inc.; Bengaluru, Bidar District; On-site; INR 1,200,000 - 2,400,000; Full time

Job summary

Mouser Electronics, Inc. is seeking a data analytics engineer to build scalable data models and transformation workflows for ecommerce insights. You will work across staging to analytics-ready datasets, mentor juniors, and drive governance, quality, and performance in a fast-paced environment.

The role emphasizes modular data engineering, collaboration with BI and analytics teams, and delivering trusted data for site-wide metrics and customer behavior analyses.

Qualifications

• This role requires strong SQL and data modeling skills with attention to data quality.
• Experience translating business needs into scalable analytics structures.
• Excellent communication and ability to work with cross-functional teams.

Responsibilities

• Collaborate with Ecommerce BI Analysts to understand business needs and translate them into efficient data structures.
• Enable analysts to access curated, high-quality datasets for insights.
• Partner with Data Engineers to ensure data availability in staging environments.
• Own the transformation layer between staging and analytics-ready datasets.
• Develop modular, scalable data models (staging, intermediate, mart) for traceability.

Skills

SQL proficiency

Data modeling

Communication

Mathematics

Attention to detail

Cross-functional collaboration

Leadership

Mentoring

Documentation

Education

Bachelor's degree

Master's degree preferred

Tools

dbt

Alteryx

ETL tools

Google Analytics

Cloud data platforms

Data governance tools

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