This description is a summary of our understanding of the job description. Click on 'Apply' button to find out more.

Role Description

We are seeking 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. This role will focus on ETL design, data standardization, and metric governance while 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 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.

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 Analyst III will help shape our data future and directly enable the adoption of advanced analytics and AI.

Qualifications

• 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—but curiosity and respect for our community is the most important.

Compensation & Benefits

• Salary Range: $90,000 to $100,000 depending on your location as well as the experience and the skills you bring.
• Proficient-level experience falls toward the lower to mid-range.
• Strategic-level experience may be considered at the upper range.
• Bonus Plan: Eligibility for up to a 4% annual bonus based on company performance.
• 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!