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:

www.candlescience.com/about

Igniting Growth with CandleScience | https://partners.wsj.com/ups/igniting-growth-candl...

First Candles, Now Soap. Durham's CandleScience Expands in DIY Market | https://wraltechwire.com/2016/06/02/durham-candles...

CandleScience and the Science of Candle Making | https://www.avery.com/blog/customer-spotlight-candlescience/

Facebook | https://www.facebook.com/candlescience

TikTok | https://www.tiktok.com/@candlescience

Instagram | https://www.instagram.com/candlescience

Expert Jobs at CandleScience

Latest Jobs

Data Analyst

Quick Links

Resources

Legal