Analytics Engineer

Sweetwater Sound is seeking an Analytics Engineer to help build and maintain the organization’s analytic data architecture. This role partners with data engineering, data science, business intelligence, and key stakeholders to deliver analytics use cases, standardize warehouse data, and support a semantic layer that enables reliable reporting.

Responsibilities

• Enable analytics use cases for the merchandising & service teams by creating and maintaining data models and pipelines enriched with institutional and departmental knowledge
• Transform and standardize raw data loaded into the data warehouse by the data engineering team so end users can consume it efficiently
• Create and maintain the semantic layer leveraged by the BI platform
• Apply software engineering best practices to analytics code, including version control, testing, and continuous integration; participate in code reviews to help prevent bad data or broken pipelines
• Maintain data documentation and definitions, and train users on data availability and structure
• Monitor analytic data platform health, reduce redundancy, and identify data gaps
• Support occasional ad-hoc analysis and provide data for urgent business needs

Required Qualifications

• Technical competence paired with an empathetic understanding of business needs
• Domain expertise in one or more areas:
  • (Merchandising & Service) vendors & manufacturers, products & services, pricing, demand & planning, purchase orders, billing/credits, inspections, repairs & installs, backlogs & queues
  • (DC & Shipping) distribution center and shipping operations including receiving, picking & packing, returns, inspections
  • (Marketing) marketing tactics, principles, strategies, and how marketing plans drive revenue
  • (Sales & Music Store) multi-channel sales operations including the sales process, communications, sales and retail sales KPIs (including how to calculate them), customer knowledge, foot traffic, and CRMs
• Multiple years of experience in data design and ETL
• SQL knowledge is critical
• Proficiency with dbt and other modern data stack tools
• Understanding of cloud data warehouse architecture and best practices; BigQuery experience is a plus
• Looker/LookML knowledge is a plus
• Experience with git including CI/CD processes
• Self-motivated with strong ownership, urgency, and drive
• Strong organizational and prioritization skills to manage multiple projects and meet deadlines
• Strong communication skills and ability to work with all levels of the organization
• Ability to handle sensitive data confidentially
• Passion for Sweetwater, team success, and the data products built for internal customers

Technology Stack

• SQL
• dbt
• BigQuery
• Looker
• LookML
• git
• CI/CD
• Cloud data warehouse architecture

Team-Player Attributes

• WOWs the Customer through deep passion for customer and colleague experiences
• Get Things Done with a strong work ethic and a sense of urgency
• Obsesses over the Details with a consistent focus on accuracy
• Drives Continuous Improvement by pursuing more effective and efficient ways of working
• Develops the Future by growing personally and professionally while supporting colleagues