Analytics Engineer

Sweetwater, the nation’s #1 online retailer of pro audio equipment and music instruments is seeking to hire an Analytics Engineer to work closely with various teams within the organization. This role will partner with data engineers, data scientists, business intelligence developers, and business stakeholders to build and maintain our analytic data architecture, which is informed by business strategies and technical data knowledge.

We currently have four openings and have need for an Analytics Engineer in the following specialty areas:

Merchandising & Services
Sales & Music Store
Distribution Center
Marketing

The individuals in each of these areas will serve as the Analytics Engineer focusing on projects and data for these specific areas in order to serve our need to provide top-of-the-line data and analytics, serving our internal stakeholders in an unprecedented manner.

We are seeking candidates who are hungry for the next challenge, exhibit strong interpersonal communication skills, and take personal ownership of their projects. Here, you’ll have a voice while being an active participant in the way we solve complex business challenges. We care deeply about the work we do, and we are committed to serving our customers. If this sounds like a challenge you are excited to take on, we would love to speak with you!

Job Responsibilities:

Enable and unlock various analytics use cases for the merchandising & service teams by creating and maintaining data models & pipelines enriched with institutional and departmental knowledge
Transform and standardize raw data loaded into the data warehouse by the data engineering team; making it easy and efficient for end users to consume
Create and maintain the semantic layer leveraged by our BI platform
Apply software engineering best practices to analytics code, including version control, testing, and continuous integration; engage in code reviews to ensure code changes don’t result in bad data or broken pipelines
Maintain data documentation & definitions and train users on data availability and structure
Monitor overall health of the analytic data platform, avoid redundancy, identify data gaps, etc.
Assist in occasional ad-hoc analysis or supplying data to support urgent business needs

Qualifications

An ideal candidate will have technical competence balanced by an empathetic understanding of business needs
(Merchandising & Service) Merchandising and/or service domain expertise: vendors & manufacturers, products & services, pricing, demand & planning, purchase orders & billing/credits, inspections, repairs & installs, backlogs & queues are part of everyday vernacular
(DC & Shipping) Distribution Center & shipping domain expertise: experience supporting a large logistics operation with knowledge of various concepts and processes such as receiving, picking, & packing, returns, inspections
(Marketing) Understanding of marketing tactics and principles, strategies, and how marketing plans drive revenue
(Sales & Music Store) Retail Sales domain expertise: experience supporting a multi-channel sales organization with knowledge of the overall sales process, communications, common sales & retail sales KPIs and how to calculate them, customer knowledge, foot traffic, CRMs etc.
Multiple years of experience in data design and ETL
SQL knowledge is critical; Python/R knowledge is desired
Proficiency with dbt and other modern data stack tools
Understanding of cloud data warehouse architecture and best practices, BigQuery experience a plus
Looker/LookML knowledge is a plus
Experience with git including CI/CD processes
Self-motivated with a strong sense of ownership, urgency, and drive
Solid organizational and prioritization skills to manage multiple projects easily while meeting deadlines
Strong communication skills with an ability to interface effectively with all levels of the organization
Ability to handle sensitive data in a confidential manner
Passion for Sweetwater, your team’s success, and the data products we are building for our internal customers

‌