Apply on Employer Site

Beauty by Imagination (BBI) · 4 hours ago

Data Engineer

New York, NY

Full-time

Hybrid

Mid Level

$100K/yr - $120K/yr

Beauty by Imagination is a global haircare company dedicated to boosting self-confidence with imaginative solutions for every hair moment. They are seeking a skilled Data Engineer to design, build, and maintain their enterprise Data Warehouse and analytics ecosystem, focusing on enabling AI-driven insights and automation.

BeautyConsumer GoodsWellness

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

Qualification

Data Warehouse designETL/ELT pipelinesSQL ServerPower BIData modelingPythonSSISCloud data platformsData securityAPI integrationsAnalytical skillsCommunication skillsProblem-solvingCollaboration

Required

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

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.)

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