What are the responsibilities and job description for the BI Reporting Engineer position at Lifetime Brands Talent Acquisition?
We're expanding our data engineering team to support a major reporting buildout for one of our key retail accounts. This person will own the full data lifecycle — ingestion, transformation, and reporting — to deliver trusted, self-service analytics to the account team and their stakeholders.
You'll work across our modern data stack (Airbyte → Snowflake → dbt → Qlik) in an environment serving 500 users and 150 production reports. This is a hands-on, end-to-end role: you'll build the pipelines that move the data, the models that shape it, and the dashboards that put it in front of decision-makers.
What You'll Do
- Build and maintain ingestion pipelines into Snowflake using Airbyte, including incremental/CDC patterns from source systems such as MSSQL/Azure SQL and SAP-sourced data
- Maintain and extend custom data pipelines written in code and orchestrated through GitHub Actions — for example, our cloud feeds pipeline currently runs as a Python script on a scheduled GitHub Actions workflow.
- Develop, test, and document transformation models in dbt Core on Snowflake, following dimensional modeling best practices.
- Design and build Qlik Sense reporting (both client-managed and Qlik Cloud) — load scripts, set analysis, master items, and well-governed apps — to support the account's reporting needs.
- Partner directly with the account team to translate business questions into reporting requirements, focusing on areas like POS/sell-through, replenishment, inventory, and on-shelf availability.
- Own data quality, monitoring, and reliability for the pipelines and reports you build, and help maintain standards across the broader reporting estate.
- Contribute to ongoing platform initiatives, including the migration of legacy SAP BW reporting to dbt/Snowflake.
- Use version control (Git) and follow established CI/CD and code review practices.
Required Qualifications
- 4 years in data engineering, analytics engineering, or a closely related role.
- Expert SQL skills and strong understanding of dimensional/data modeling.
- Hands-on experience with dbt (dbt Core preferred) for transformation and testing.
- Production experience with a cloud data warehouse — Snowflake strongly preferred.
- Experience with a modern ELT/ingestion tool (Airbyte, Fivetran, Stitch, or similar), including incremental and CDC-based replication.
- Experience building reports/dashboards in a modern BI tool; Qlik Sense strongly preferred.
- Comfortable working independently across the full stack and communicating with non-technical business stakeholders.
Preferred Qualifications
- Deep Qlik Sense expertise: load scripting, set analysis, security rules, and QMC administration across on-prem and Qlik Cloud.
- Retail or CPG domain experience, especially with retailer data portals and syndicated/POS data sources (e.g., Circana, NielsenIQ) and EDI workflows.
- Familiarity with SAP data — ECC tables
- Strong programming skills in Python or Scala for pipeline development, automation, and API integrations. We maintain custom pipelines (such as our cloud feeds pipeline) as Python script run via GitHub Actions, so comfort building and maintaining code-based workflows is a real
plus. - Experience supporting a large, multi-tenant reporting environment.
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.
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.
Salary : $75,000 - $90,000