Analytics Engineer

Sweetwater; Fort Wayne (IN); On-site; USD 110,000 - 160,000; Full time

Job summary

Sweetwater, the nation’s leading online retailer of pro audio equipment and music instruments, is seeking an Analytics Engineer to partner with data engineers, scientists, BI developers, and stakeholders to build and maintain our analytic data architecture.

This role focuses on serving internal customers with top-tier data and analytics, informing business decisions across merchandising, service, and operations.

Qualifications

• SQL knowledge is essential for designing data models and transforming data.
• Experience with ETL design and data integration across systems.
• Strong communication skills and ability to partner with multiple teams.
• Familiarity with dbt and analytics engineering best practices.
• Knowledge of cloud data warehouses and BI semantic layers is a plus.

Responsibilities

• Enable analytics use cases for merchandising and service teams by building data models and pipelines.
• Transform and standardize raw data for the data warehouse to ease end-user consumption.
• Create and maintain the semantic layer used by the BI platform.
• Apply software engineering best practices to analytics code, including version control and testing; participate in code reviews.
• Maintain data documentation and definitions; train users on data availability and structure.
• Monitor health of the analytic data platform and identify data gaps or redundancies.
• Assist in ad-hoc analysis or supplying data for urgent business needs.

Skills

SQL

Data modeling

ETL processes

Ownership & urgency

Communication skills

Tools

dbt

BigQuery

Looker LookML

Git CI/CD

Job description

Job Requirements

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.

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.

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
• 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

Sweetwater "Ideal" Team-Player:

• WOWs The Customer - Deep passion and desire for creating amazing customer & colleague experiences
• Get Things Done - Great work ethic and moves with a sense of urgency
• Obsesses over the Details - committed to paying attention to the details
• Drives Continuous Improvement - Always focusing on effective and efficient work and way to get better
• Develops the Future - committed to pursuit of growing personally & professionally and has a focus on bringing your colleagues along with you on that journey

We function best as a unified team, so relocation to our state-of-the-art campus in Fort Wayne, IN is required. Interested and qualified candidates, we look forward to exploring your #FullTimeDream with Sweetwater!

Sweetwater's culture is built upon celebrating the creative creation of music, which unifies people from all walks of life. Our individual differences make Sweetwater stronger as a company and a better place to work as we respect, learn, and grow from each team member's unique perspective and experience. We have welcomed thousands of employees and their families from all over the world, and we invite you to discover why we consider a career at Sweetwater the full-time dream.