Data Analyst

Job Summary

The Data Analyst at CandleScience plays a key role in supporting day-to-day data operations and enabling reliable, actionable reporting across the organization. This position supports Operations, Product Development, Marketing, Finance, and Leadership by maintaining data pipelines, improving reporting accuracy, and delivering timely insights that inform business decisions.

Reporting directly to the Vice President of Data Analytics, this role is responsible for executing and maintaining core analytics workflows, ensuring data integrity, and fulfilling cross-functional reporting needs. The position requires a strong balance of technical execution, analytical problem-solving, and cross-team collaboration, contributing to CandleScience’s overall goals by strengthening operational visibility, improving efficiency, and supporting data-informed growth.

Key Responsibilities

• Generates recurring business reporting, KPI dashboards, and operational analytics workflows
• Maintains and improves SQL-based data models and transformations to ensure reliable reporting
• Manages analytics requests, reporting tools, and dashboard deliverables across departments
• Maintains data pipelines and integrations from multiple business systems into centralized data warehouses
• Facilitates meetings with stakeholders to gather, document and translate business needs into functional / technical requirements
• Audits queries and models to improve performance, reduce cost, and enhance efficiency
• Designs and implements data validation checks and tests to ensure accuracy of critical datasets
• Creates and maintains dashboards, views, and reporting tools for business stakeholders
• Prioritizes projects, communicates updates to stakeholders, and ensures timelines are met
• Conducts operational analysis, performance evaluations, and forecasting support to inform decision-making
• Advises stakeholders on data capture standards, reporting requirements, and structural improvements
• Collaborates cross-functionally with Operations, Marketing, Finance, Product Development and Technology teams
• Assists with data preparation for forecasting models and advanced analytics initiatives
• Monitors industry trends and integrates feedback to maintain reporting relevance and effectiveness
• Performs other related duties as assigned by supervisor

Required Skills / Abilities

• Bachelor’s degree in Business, Analytics, Statistics, Mathematics, Information Systems, or related field and/or 2–5 years of relevant experience
• Strong SQL proficiency (2–4+ years writing SQL as a primary responsibility)
• Experience working with relational databases such as Google BigQuery or PostgreSQL
• Familiarity with data transformation tools (e.g., dbt) and data integration tools (e.g., Fivetran or similar platforms)
• Experience building dashboards and reporting in BI tools such as Looker, Tableau, or Power BI
• Proven ability to manage multiple reporting priorities and stakeholder requests in a fast-paced environment
• Strong analytical, problem-solving, and organizational skills
• Excellent written and verbal communication skills with both technical and non-technical audiences
• Ability to prioritize tasks effectively and meet deadlines
• Familiarity with forecasting, statistical modeling, or operational performance analysis preferred
• Experience in e-commerce, retail, manufacturing, or supply chain environments preferred

Work Environment

This role is based in Durham, NC and may be offered in a hybrid format, depending on business needs and budget considerations. Team members may be required to work onsite (number of days, if applicable).

The position requires significant time spent (desk work, computer use, meetings, etc.), along with regular collaboration through meetings, video calls, and occasional in-person sessions. The role may require the ability to lift up to 20 pounds and perform physical tasks such as climbing or using a ladder as needed.

The Hiring Salary Range is $90,000 - $99,000.

To Apply: Please submit your resume along with a short Cover Letter telling us why you would be a good fit for this position.

Benefits:

Big company benefits with small company culture! We provide comprehensive medical, dental, and vision coverage with low deductibles. All employees receive employer match for retirement contributions of up to 3% of annual earnings. We have liberal vacation policies and offer additional benefits including technology stipends, gym memberships, and company-paid life insurance.

• Employee assistance program
• Paid time off (Vacation & Sick)
• Referral program
• 401(k)
• 401(k) matching
• Dental insurance
• Medical insurance
• Vision insurance
• Life insurance
• Tuition reimbursement

About Us:

CandleScience develops and sells candle and soap making supplies. Our customers vary in size from candle and soap entrepreneurs to seasonal hobbyists. We began in 2003 as a two-person startup, and have become the market leader in the industry.

We work hard to develop natural and safe products that push the boundaries of candle and soap making. Our success is a result of our focus on web development, product development, and operations.

For More About Us:

Igniting Growth with CandleScience | ...

First Candles, Now Soap. Durham’s CandleScience Expands in DIY Market | ...

CandleScience and the Science of Candle Making |

Facebook |

TikTok |

Instagram |