Data Engineer Job at Beauty by Imagination (BBI), New York, NY

ZWZTN1cxZlk1WDdKVUl6ajh6bWZFRVp3Vmc9PQ==
  • Beauty by Imagination (BBI)
  • New York, NY

Job Description

Job Description

About Beauty by Imagination:

Beauty by Imagination is a global haircare company dedicated to boosting self-confidence with imaginative solutions for every hair moment. We are a platform company of diverse, market-leading brands, including Wet Brush, Goody, Bio Ionic, and Ouidad — all of which are driven to be the most trusted choice for happy, healthy hair. Our talented team is passionate about delivering high-performing products for consumers and salon professionals alike.

Position Overview:

We are looking for a skilled Data Engineer to design, build, and maintain our enterprise Data Warehouse (DWH) and analytics ecosystem — with a growing focus on enabling AI-driven insights, automation, and enterprise-grade AI usage. In this role, you will architect scalable pipelines, improve data quality and reliability, and help lay the foundational data structures that power tools like Microsoft Copilot, Copilot for Power BI, and AI-assisted analytics across the business.

You’ll collaborate with business stakeholders, analysts, and IT teams to modernize our data environment, integrate complex data sources, and support advanced analytics initiatives. Your work will directly influence decision-making, enterprise reporting, and next-generation AI capabilities built on top of our Data Warehouse.

Key Responsibilities

  • Design, develop, and maintain Data Warehouse architecture, including ETL/ELT pipelines, staging layers, and data marts.
  • Build and manage ETL workflows using SQL Server Integration Services (SSIS) and other data integration tools.
  • Integrate and transform data from multiple systems, including ERP platforms such as NetSuite.
  • Develop and optimize SQL scripts, stored procedures, and data transformations for performance and scalability.
  • Support and enhance Power BI dashboards and other BI/reporting systems.
  • Implement data quality checks, automation, and process monitoring.
  • Collaborate with business and analytics teams to translate requirements into scalable data solutions.
  • Contribute to data governance, standardization, and documentation practices.
  • Support emerging AI initiatives by ensuring model-ready data quality, accessibility, and semantic alignment with Copilot and other AI tools.

Required Qualifications

  • Proven experience with Data Warehouse design and development (ETL/ELT, star schema, SCD, staging, data marts).
  • Hands-on experience with SSIS (SQL Server Integration Services) for building and managing ETL workflows.
  • Strong SQL skills and experience with Microsoft SQL Server.
  • Proficiency in Power BI or other BI tools (Tableau, Looker, Qlik).
  • Understanding of data modeling, performance optimization, and relational database design.
  • Familiarity with Python, Airflow, or Azure Data Factory for data orchestration and automation.
  • Excellent analytical and communication skills.

Preferred Qualifications

  • Experience with cloud data platforms (Azure, AWS, or GCP).
  • Understanding of data security, governance, and compliance (GDPR, SOC2).
  • Experience with API integrations and real-time data ingestion.
  • Background in finance, supply chain, or e-commerce analytics.
  • Experience with NetSuite ERP or other ERP systems (SAP, Oracle, Dynamics, etc.).

AI Focused Preferred Skills:

  • Experience implementing AI-driven analytics or automation inside Data Warehouses.
  • Hands-on experience using Microsoft Copilot, Copilot for Power BI, or Copilot Studio to accelerate SQL, DAX, data modeling, documentation, or insights.
  • Familiarity with building RAG (Retrieval-Augmented Generation) or AI-assisted query patterns using SQL Server, Synapse, or Azure SQL.
  • Understanding of how LLMs interact with enterprise data, including grounding, semantic models, and data security considerations (Purview, RBAC).
  • Experience using AI tools to optimize ETL/ELT workflows, generate SQL scripts, or streamline data mapping/design.
  • Exposure to AI-driven data quality monitoring, anomaly detection, or pipeline validation tools.
  • Experience with Microsoft Fabric, semantic models, or ML-integrated analytics environments.

Soft Skills

  • Strong analytical and problem-solving mindset.
  • Ability to communicate complex technical concepts to business stakeholders.
  • Detail-oriented, organized, and self-motivated.
  • Collaborative team player with a growth mindset.

Impact

You will play a key role in shaping the company’s modern data infrastructure — building scalable pipelines, enabling advanced analytics, and empowering the organization to safely and effectively adopt AI-powered insights across all business functions.

Our Tech Stack

  • SQL Server, SSIS, Azure Synapse
  • Python, Airflow, Azure Data Factory
  • Power BI, NetSuite ERP, REST APIs
  • CI/CD (Azure DevOps, GitHub)

What We Offer

  • Location: New York, NY (Hybrid work model)
  • Employment Type: Full-time
  • Compensation: Competitive salary based on experience
  • Benefits: Health insurance, 401(k), paid time off
  • Opportunities for professional growth and participation in enterprise AI modernization initiatives

Job Tags

Full time,

Similar Jobs

General Dynamics Information Technology

Cyber Splunk Engineer Job at General Dynamics Information Technology

 ...Certified Admin | Splunk - SplunkExperience:10 + years of related experienceUS Citizenship Required:YesJob Description:We are GDIT. We support and secure some of the most complex government, defense, and intelligence projects across the country. We are looking to... 

IST Management

Shipping/Mailroom Associate Job at IST Management

 ...dependable and detail-oriented Shipping Associate to support daily logistics operations at our medium-sized print facility. This entry-level role is responsible for receiving, handling, staging, and shipping incoming and outgoing materials. The ideal candidate is organized... 

Luxottica

Sales Associate LensCrafters Job at Luxottica

 ...Information LensCrafters is bringing its optical retail experience to Macys department stores in the U.S. Macys and Luxottica, a world leader in eyecare, have a successful history together. Our relationship is built around a shared mission of providing customers... 

Instacart

Machine Learning Engineer (PhD Intern) Job at Instacart

 ...serve the varied needs of our community. We work to deliver an essential service that...  ...they do their best workwhether its from home, an office, or your favorite coffee shop...  ...ads. We are looking for talented Ph.D. students to have an internship in our fast moving... 

RCM Healthcare Services

School Nurse / Licensed Vocational Nurse (LVN) or Registered Nurse (RN) Job at RCM Healthcare Services

 ...School Nurse / Licensed Vocational Nurse (LVN) orRegistered Nurse(RN) We are currently hiring Licensed Vocational Nurses (LVNs)and Registered Nurses (RNs)to join our dedicated school nursing team in Los Angeles. In this role, you will provide specialized care to...