Sr Data Engineer

Beauty by Imagination is a global haircare company dedicated to boosting self-confidence with imaginative solutions for every hair moment through brands including Wet Brush, Goody, Bio Ionic, and Ouidad. The Senior Data Engineer will create and manage a data warehouse, integrate data from NetSuite, IRI, and point-of-sale sources, and own ETL processes. The role also involves developing Power BI dashboards, supporting data analysts, aligning data architecture with organizational goals, and managing third-party data analytics resources.

Responsibilities:

• Design, construct, test, and maintain robust data architectures to align with business requirements
• Build and manage API’s for data extraction and transformation
• Develop and optimize ETL processes for efficient data extraction, transformation, and loading from various sources
• Develop data extracts to feed data warehouse data to other internal and/or external systems
• Create and manage Power BI dashboards and reports, providing actionable insights to business stakeholders
• Assist data analysts in the development of reports and dashboards, ensuring data accuracy and relevance
• Maintain and improve SQL, Power BI, Cognos, and other data engineering tools and practices
• Collaborate with various departments to understand data needs and provide technical solutions that align with business objectives
• Ensure data integrity and security, adhering to data governance and compliance standards
• Continuously evaluate and recommend improvements to existing data systems and processes
• Conduct research for industry and business questions using large data sets
• Recommend ways to improve data reliability, efficiency, and quality
• Deliver Data Analytics using AI

Requirements:

• • Bachelor's degree in Computer Science, IT, or related field
• • Proven experience in data engineering, especially in a manufacturing/distribution environment
• • Extensive experience in data collection and standardizing database schema to accommodate bespoke data sources
• • Proficiency in SQL, JSON, XML. Power BI, Cognos, Python, and other relevant tools
• • Strong understanding of ETL processes and tools (like Fivtran, SSIS, Azure Data Factory Pipelines)
• • Experience Building/managing API
• • Experience with data warehouse design and management
• • Experience Building Database Objects (Design and create schemas, tables, views, and indexes)
• • Experience Writing Code (complex stored procedures, functions, and triggers)
• • Experience Optimizing Performance (Query Optimization, Execution Plans, Index Management)
• • Experience with Analysis Services, multi-dimensional databases, parent child dimensions, alternate hierarchies, OLAP/ROLAP cubes
• • Experience deploying database on SQL server with role-based access control (RBAC) for admins and users
• • Excellent problem-solving skills and attention to detail
• • Ability to work collaboratively in a team environment and communicate effectively with non-technical stakeholders
• • Prefer experience with Microsoft Fabric, Azure Data Factory, Data Lake)
• • Prefer Experience configuring MCP Servers connecting data models to LLMs