Local Crafts is hiring a Data Analyst III to play a pivotal role in building a modern, standardized data foundation that powers insight and decision-making across the organization. You will focus on ETL design, data standardization, and metric governance while supporting dashboard development and mentoring a Jr. Analyst. Your work will help transition our current SQL data lake into a scalable, governed, and analytics-ready platform that supports AI and machine learning initiatives.

What You'll Do

Own and maintain core reporting tables and ETL processes to ensure data accuracy, reliability, and consistency across all business functions.
Collaborate with department heads and the VP of Analytics & AI to identify business needs, define metrics, and standardize reporting practices.
Oversee dashboards and reporting outlines, delegating updates and visualization tasks to the Jr. Analyst while ensuring quality and consistency.
Design and optimize data pipelines within the existing SQL data lake, preparing for migration to Microsoft Fabric.
Support the development of ML/AI data readiness, ensuring ETL pipelines and datasets are structured for advanced analytics.
Lead data governance initiatives by defining table naming conventions, key business metrics, and data documentation for organization-wide use.
Mentor Jr. Analyst on reporting techniques, data literacy, and technical best practices.
Partner cross-functionally with business leaders to deliver actionable insights and data-driven recommendations.

What We're Looking For

5+ years of experience in data analytics, data science, or business intelligence.
Strong SQL and Python skills for data manipulation, transformation, and analysis.
Proficiency in Power BI and Excel.
Experience with ETL development and data pipeline automation.
Proven ability to work independently with high autonomy and minimal supervision.
Strong communication and stakeholder management skills; able to translate data into meaningful business insights.

Nice to Have

Familiarity with R, DAX, or Power Query.
Background in DTC (direct-to-consumer) analytics preferred, with demonstrated understanding of metrics such as acquisition, retention, and LTV.
Experience in mentoring or leading junior analysts.
Bonus points if you love yarn, crafts, or the maker movement.

Technical Stack

SQL
Python
Power BI
Excel
Microsoft Fabric

Team & Environment

You will report directly to the Vice President of Data Analytics & AI.

Benefits & Compensation

Compensation: $90,000 to $100,000
Multiple medical, dental and vision plan options after 30 days (with company contributions to the premium costs)
Healthcare Savings and Flexible Spending Accounts
Company-paid Life, Short and Long-Term Disability, and worldwide travel assistance benefits
Voluntary life and income replacement plans
401(k) Retirement Savings Plan with Employer Match
Generous paid time off and holiday pay policies
Employee discounts at all Local Crafts companies!

Work Mode

This is a remote position open to candidates in any US-based location.

We believe crafting is for everyone, and so is working here. Creativity thrives when different voices, perspectives, and experiences come together. We welcome team members of all races, ethnicities, ages, religions, identities, orientations, abilities, and backgrounds.