[Remote] Sr Data Engineer
Note: The job is a remote job and is open to candidates in USA. 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
Skills
- • 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
Company Overview