BI Analytics Engineer

Lifetime Brands, Inc.; Village of Garden City, Northern (NY, KY); Hybrid; USD 120,000 - 170,000; Full time

Job summary

Lifetime Brands, Inc. is seeking a BI Analytics Engineer to build data products and own end-to-end reporting, ensuring trusted dashboards for decision-makers.

You will work with a modern stack including Snowflake, dbt Core, Qlik Sense, and Airbyte to support 500+ users and a major retail reporting buildout. You will collaborate with business stakeholders, design robust data models, and maintain ingestion pipelines while teaching teams how to use what you build.

Qualifications

• : 4+ years in BI/analytics/data engineering with ownership of reporting
• : Strong SQL and data modeling skills with a cloud warehouse experience
• : Experience building dashboards used by business users
• : Ability to communicate complex data problems to non-technical audiences

Responsibilities

• Partner with stakeholders to define reporting requirements and KPIs
• Design and build Qlik Sense apps with load scripts and master items
• Develop, test, and document dbt Core transformations on Snowflake
• Build and maintain Snowflake ingestion pipelines with Airbyte
• Maintain code-based pipelines via GitHub Actions
• Own data quality, monitoring, and reliability across reporting suite
• Bridge BI and business teams on data sources and access
• Teach non-technical teams how to use built artifacts
• Maintain documentation for systems and decisions
• Follow Git and CI/CD practices

Skills

SQL

Data modeling

Dashboard ownership

Communication

Education

Bachelor's degree in STEM

Tools

Snowflake

dbt Core

Qlik Sense

Airbyte

GitHub Actions

Python

Job description

About the role

Lifetime Brands is looking for a BI Analytics Engineer to build the data products our business runs on — and tomake sure people actually use them. You own reporting end to end: the pipelines that move the data, themodels 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 worksomewhere, and be able to pick up the rest.

The immediate focus is a major retail reporting buildout — POS and sell-through, replenishment, inventory, andon-shelf availability for one of our largest accounts — alongside a longer-running migration of legacy reportingonto 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 andmeaningful 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 dimensionalmodeling best practices.
• Build and maintain ingestion pipelines into Snowflake with Airbyte, including incremental and CDC patternsfrom sources such as MSSQL/Azure SQL and SAP.
• Maintain and extend our code-based pipelines — Python scripts orchestrated through scheduled GitHubActions workflows.
• Own data quality, monitoring, and reliability for everything you build, and help hold that standard acrossthe wider reporting estate.
• Act as a bridge between the BI team and the rest of the business on data sources, data access, and what'savailable to report on.
• Teach. Show non-technical teams how to use what you've built, and bring new tools and practices back tothe 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 ofreporting, 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; closeequivalents count.
• You've built and owned dashboards a real business audience relied on. Qlik Sense experience is a significantadvantage.
• 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 whodoesn'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 todashboard — tested and documented well enough that the rest of the team can build on it