BI Analytics Engineer

About the role

Lifetime Brands is looking for a BI Analytics Engineer to build the data products our business runs on — and to make sure people actually use them. You own reporting end to end: the pipelines that move the data, the models that shape it, and the dashboards that put it in front of decision-makers.

Our data team supports 500+ users and 150+ production reports on a modern stack — Airbyte for ingestion, Snowflake as the warehouse, dbt Core for transformation, and Qlik Sense for reporting across both client- managed and Qlik Cloud. You don't need to have used every piece of it. You need to have done this kind of work somewhere, and be able to pick up the rest.

The immediate focus is a major retail reporting buildout — POS and sell-through, replenishment, inventory, and on-shelf availability for one of our largest accounts — alongside a longer-running migration of legacy reporting onto dbt and Snowflake. a growing program with real room to shape how it gets built.

What you will do

• Partner with business stakeholders to turn open-ended questions into clear reporting requirements and meaningful KPIs.

• Design and build Qlik Sense apps — load scripts, set analysis, master items — that are governed, documented, and trustworthy enough for people to use on their own.

• Develop, test, and document transformation models in dbt Core on Snowflake, following dimensional modeling best practices.

• Build and maintain ingestion pipelines into Snowflake with Airbyte, including incremental and CDC patterns from sources such as MSSQL/Azure SQL and SAP.

• Maintain and extend our code-based pipelines — Python scripts orchestrated through scheduled GitHub Actions workflows.

• Own data quality, monitoring, and reliability for everything you build, and help hold that standard across the wider reporting estate.

• Act as a bridge between the BI team and the rest of the business on data sources, data access, and what's available to report on.

• Teach. Show non-technical teams how to use what you've built, and bring new tools and practices back to the BI team.

• Maintain documentation for the systems, processes, and decisions behind your work.

• Work in Git and follow our code review and CI/CD practices.

What we are looking for

• 4+ years in BI engineering, analytics engineering, or data engineering — with genuine ownership of reporting, not pipelines alone.

• Expert SQL and a strong grasp of dimensional and data modeling.

• Production experience transforming data in a cloud warehouse. dbt on Snowflake is our stack; close equivalents count.

• You've built and owned dashboards a real business audience relied on. Qlik Sense experience is a significant advantage.

• Comfortable working independently and end to end, from source system to finished report.

• Excellent verbal and written communication — you can explain a complex data problem to someone who doesn't work in data.

• Careful, methodical troubleshooting and close attention to detail.

• Bachelor's degree in a STEM field, or equivalent practical experience.

Nice to have

• Deep Qlik Sense expertise: load scripting, set analysis, security rules, and QMC administration across on-prem and Qlik Cloud.

• Retail or CPG background — retailer data portals, syndicated and POS data sources (Circana, NielsenIQ), and EDI workflows.

• Familiarity with SAP data: ECC table structures, BW InfoProviders, and IDoc/EDI extraction.

• Strong Python for pipeline development, automation, and API integrations.

• Experience with a modern ELT tool such as Airbyte, Fivetran, or Stitch, including CDC-based replication.

• Experience supporting a large, multi-tenant reporting environment.

Your first 90 days

You'll have ramped on our stack and shipped your first reporting deliverable end to end — source system to dashboard — tested and documented well enough that the rest of the team can build on it

About Lifetime Brands

Lifetime Brands is a leading global provider of kitchenware, tableware and other products used in the home. We offer brands you trust, value without compromise and an unwavering commitment to innovation. Our products make it easier for you to prepare food, serve meals, entertain guests, and decorate your home. We offer a comprehensive suite of benefits, which includes: *All full-time employees (and family members) are eligible to participate in our Medical, Dental, and Vision plans *Flexible Spending Accounts for Health and Dependent Care *Short-Term Disability & Long-Term Disability *Company Paid Basic Life and Accidental Death & Dismemberment Insurance *Eligibility in the Company's 401K plan, after 90 days of employment *Paid Time Off (vacation/sick) - accrual of 15 days per calendar year for non-warehouse positions; accrual of 10 days per calendar year for hourly based warehouse positions *10 Company Paid Holidays *Employee Product Discounts *Tuition Assistance *Employee Assistance Program *Volunteer Opportunities- 4 hours of paid optional volunteer time (annually) *Seattle, WA based employees are provided with commute trip reduction incentives *Benefits are offered to employees who work 30 hours or more In addition to the above, we offer voluntary benefits.

Lifetime Brands, is an Equal Opportunity Employer. All qualified applicants are encouraged to apply, and will be considered without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, protected veteran status, or other legally protected characteristics, and will not be discriminated against on the basis of disability.

This job posting contains a pay range, which represents the range of salaries or hourly rates that Lifetime Brands believes, in good faith, at the time of this posting that it might be willing to pay for the posted job. Lifetime Brands expects to hire for this position near the middle of the range. Only in truly rare and exceptional circumstances, where an external candidate has experience, credentials or expertise that far exceed those required or expected for the position, would Lifetime Brands consider paying a salary or rate near the higher end of the range.

Job Details

Job Family BI

Job Function Information Systems

Pay Type Salary

Hiring Min Rate 75,000 USD

Hiring Max Rate 90,000 USD