Ecommerce Analytics Engineer
Mouser Electronics9 days ago
Bengaluru, IndiaMid Level / Senior
Responsibilities
- Translate ecommerce business needs into efficient data structures and curated datasets for BI analysts.
- Own transformation workflows between staging and analytics-ready data, including staging, intermediate, and mart layers.
- Build and maintain reusable data models using dbt or similar transformation tools.
- Optimize SQL and transformation logic for performance, scalability, and maintainability.
- Maintain documentation, lineage, testing protocols, governance standards, and data quality practices.
- Integrate data from on-premises applications, Google Analytics, and other sources to support ecommerce metrics.
- Collaborate with data engineers, product teams, BI analysts, and cross-functional stakeholders.
- Lead data modeling efforts and mentor junior engineers.
- Support analytics for site search, customer behavior, product performance, and international ecommerce websites.
Requirements
- Bachelor’s degree in a related field or equivalent related work experience.
- Master’s degree preferred.
- 2+ to 7+ years of experience with dbt or similar transformation tools, depending on level.
- 2+ to 7+ years of experience with cloud data platforms and scalable data modeling, depending on level.
- At least 6 years of digital analytics data experience; Google Analytics experience is preferred.
- Advanced SQL skills and experience with performance tuning.
- Experience with Alteryx or similar ETL platforms.
- Strong understanding of data modeling, ecommerce metrics, digital product data, data governance, and documentation practices.
- Ability to lead data modeling efforts, mentor junior engineers, optimize models, and work cross-functionally.
- Understanding of user-behavior data and basic web programming principles, tools, and technologies.
- Strong mathematics, communication, presentation, organizational, attention-to-detail, and project-management skills.
Tech Stack
dbtSQL
Categories
Data Engineering
About Mouser Electronics
Mouser Electronics is a global authorized distributor of semiconductors and electronic components for design engineers and purchasing teams. It sells a broad catalog—semiconductors, passives, interconnect and electromechanical parts—from 1,200+ manufacturers via its e-commerce platform and worldwide sales offices. Founded in 1964 and headquartered in Mansfield, Texas, Mouser operates as part of TTI, Inc., a Berkshire Hathaway company, with a focus on rapid introduction of new products.