Job Title: Data Analyst III
Location: Fully Remote from Any US-Based Location
Reports To: Vice President of Analytics & AI
About Us:
At Local Crafts,we’rehere to helpyou love what you make.
We’rea team of passionate makers who value the hands-on process and the beauty of handmade things. Crafting connects us—to ourselves, to others, and to the world. It’sour way to unwind, create, give, and sometimes, get a little wild. It’s a mindful practice that pulls us away from screens and into creativity, conversation, and yes, even a bit of math.
With a team ofemployeesacross the U.S., we design and make most of what we sell—from knitting needles and yarns to printed fabric and thread—always with care andcraftatthe center. Every item is tested and loved by our team, andit is thiscollaboration that drives us to do better every day.
We’rehome to a passionate community of knitters, crocheters, quilters and sewists who come to usfor the highest-quality yarns, thoughtfully designed tools, andtheinspiration to bringvisionto life. With a product linefound nowhere else,we’rebuilding more than a store—we’rebuilding a movement. Nowwe’reseekinga Vice President of Revenue to help us grow that movement and lead the charge on turning creativity into business growth.
Role Overview:
We are seeking aSenior Data Analystto play a pivotal role in building a modern, standardized data foundation that powers insight and decision-making across the organization. This role will focus onETL design, data standardization, and metric governancewhile supporting dashboard development and mentoring a Jr. Analyst. Working closely with the VP of Analytics & AI, this individual will help transition the company’s current SQL data lake into a scalable, governed, and analytics-ready platform that supports AI and machine learning initiatives.
Key Responsibilities:
- Own and maintain core reporting tables and ETL processes to ensure data accuracy, reliability, and consistency across all business functions.
- Collaborate with department headsand 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 and coach the 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.
Success in the First Year
6 months:
- Stabilize and improve all critical reporting tables and ETL accuracy.
- Establish reporting standardization across departments.
- Help onboard Jr. Analyst and Data Engineer; prepare datasets for AI readiness.
12 months:
- Deliver validated ML / AI-integrated datasets and leadership data self-service capabilities.
- Establish governance framework and clear roadmap for 2027 reporting and analytics improvements.
Why This Role Matters
This position is key to transforming our analytics landscape, moving from siloed data and ad-hoc reporting to a unified, governed data platform that empowers leadership with trusted, actionable insights. The Data AnalystIII will help shape our data future and directly enable the adoption of advanced analytics and AI.
Building Our Community
We believe crafting is foreveryone, andso 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.
Ifyou’reexcited about this role but don’t meet every single requirement, we encourage you to apply anyway. We know the best teams are built by people who bring curiosity, a willingness to learn, and a love for what they do.
What You Bring:
- 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; familiarity with R, DAX, or Power Query a plus.
- Experience with ETL development and data pipeline automation.
- Background in DTC (direct-to-consumer) analytics preferred, with demonstrated understanding of metrics such as acquisition, retention, and LTV.
- 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.
- Experience in mentoring or leading junior analysts is preferred.
- Bonus points if you love yarn, crafts, or the maker movement—curiosity and respect for our community is the most important
Salary Range: The starting pay range for this exempt/salary position $90,000 - $110,000 per year plus bonus plan.
Benefits
We offer a generous benefits package , including:
- 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 Planwith Employer Match
- Generous paid time off and holiday pay policies
- Employee discounts at all Local Crafts companies!