BI Analytics Engineer

About the roleLifetime 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 data team supports 500 users and 150 production reports on a modern stack Airbyte for ingestionSnowflake as the warehouse dbt Core for transformation and Qlik Sense for reporting across both client-managed and Qlik Cloud. You dont need to have used every piece of it. You need to have done this kind of worksomewhere and be able to pick up 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 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 governeddocumented 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 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. Youve 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 whodoesnt work in data. Careful methodical troubleshooting and close attention to detail. Bachelors degree in a STEM field or equivalent practical 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 first 90 daysYoull 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