> Markdown version of [/jobs/ext/3053635-sr-data-engineer](https://www.wearedevelopers.com/jobs/ext/3053635-sr-data-engineer). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Sr Data Engineer - **Company:** Soho Dragon - **Location:** New York, NY, United States - **Experience:** Expert - **Contract:** Permanent contract - **Skills:** Application Programming Interfaces (APIs), Artificial Intelligence, Big Data, Databases, System Configuration, Information Engineering, Data Governance, Data Integration, Data Integrity, Extract Transform Load (ETL), Data Mining, Data Systems, Data Warehousing, Database Schema, IBM Cognos Business Intelligence, JSON, Python (Programming Language), Microsoft SQL Server, Online Analytical Processing, Netsuite, Query Optimization, Role-Based Access Control, Power BI, Software Tools, SQL Stored Procedures, SQL Databases, SQL Server Integration Services, Extensible Markup Language (XML), Azure Data Factory, Large Language Models, Microsoft Fabric, Data Lakes, Information Technology, Data Analytics, Software Coding, Network Server - **Published:** September 24, 2026 - **Apply:** https://sohodragon.bamboohr.com/careers/1279 ## About the Role * 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. * Prefer experience with Microsoft Fabric, Azure Data Factory, Data Lake) * Prefer Experience configuring MCP Servers connecting data models to LLMs * Excellent problem-solving skills and attention to detail. * Ability to work collaboratively in a team environment and communicate effectively with non-technical stakeholders ## Description Our client, a global haircare company, is seeking a highly skilled and motivated Sr Data Engineer to create and manage a data warehouse, integrating data from various sources including NetSuite, IRI, and other point-of-sale data sources. This role is pivotal in owning the ETL processes, developing Power BI dashboards, and supporting our data analysts in report and dashboard creation. The ideal candidate will be adept at developing architecture such as databases and large-scale processing systems and aligning data projects with organizational goals. This position is also responsible for guiding and managing the third-party resources contracted for data analytics projects. Essential Job Duties & 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. ## Related Videos - [Alibaba Big Data and Machine Learning Technology](https://www.wearedevelopers.com/videos/37-alibaba-big-data-and-machine-learning-technology) - [Beyond Dashboards: Fixing Text-to-SQL with Semantic RAG](https://www.wearedevelopers.com/videos/2036-beyond-dashboards-fixing-text-to-sql-with-semantic-rag) - [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works) - [Tips and Tricks for Working with JSON](https://www.wearedevelopers.com/videos/1229-tips-and-tricks-for-working-with-json) - [Data Analytics with Microsoft Fabric: End-to-End Use Case with Data Agents](https://www.wearedevelopers.com/videos/1547-data-analytics-with-microsoft-fabric-end-to-end-use-case-with-data-agents) - [Modern Data Architectures need Software Engineering](https://www.wearedevelopers.com/videos/1030-modern-data-architectures-need-software-engineering) ## Related Articles - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [Top Big Data Technologies That You Need to Know](https://www.wearedevelopers.com/magazine/108-top-big-data-technologies-that-you-need-to-know) - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers) - [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk) - [Coffee with Developers - Maria Apazoglou - Making AI understandable for all in production](https://www.wearedevelopers.com/magazine/475-coffee-with-developers-maria-apazoglou-making-ai-understandable-for-all-in-production)