Designs and maintains data warehouse architecture, APIs, ETL pipelines, database objects, and data extracts from sources such as NetSuite, IRI, and point-of-sale systems. Develops Power BI dashboards and supports analysts with reporting. Ensures data quality, security, governance, and performance while researching large datasets and delivering AI-enabled analytics. Collaborates with business stakeholders and manages third-party analytics resources.
Sr Data Engineer
Full-time | Commack, NY | Hybrid
Position Overview:
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.
Required Skills/Qualifications:
- 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
Benefits
Medical insurance, Vision insurance, Dental insurance, 401(k)
SoHo Dragon New York, New York, USA Office
30 Broad Street, New York, NY, United States, 1004
Similar Jobs
Artificial Intelligence • Fintech • Payments • Social Impact • Analytics • Financial Services • Automation
Own and build January’s foundational data systems, including end-to-end pipelines, data quality standards, legacy migrations, recovery processes, and documentation. Partner with engineers, analysts, operations, and product teams to establish trusted, scalable data infrastructure. Prioritize high-impact improvements, manage stakeholder needs, define ownership boundaries, and use AI to create increasingly self-healing systems.
Top Skills:
AIData PipelinesData Platforms
.png)
Consumer Web • eCommerce • Machine Learning • Software • Sports • Analytics
Build and own scalable data platforms and ingestion pipelines using BigQuery, dbt, and modern ingestion tools. Design batch and CDC workflows, improve reliability and observability, implement governance and access controls, and support analytics and AI agents. Develop Python services and internal tooling, contribute to architecture and lakehouse experiments, collaborate with stakeholders, and mentor engineers. The role requires strong SQL, Python, cloud infrastructure, testing, CI/CD, and AI-assisted development experience.
Top Skills:
Ai Coding AgentsAmazon Web ServicesAPIsCdcCi/CdClaude CodeDbtEstuaryGitGoogle BigqueryGoogle Cloud PlatformHevoLakehouseMcpOpen Table FormatsPythonSQL
Artificial Intelligence • Fintech • Healthtech • Software
Lead the design, implementation, and support of healthcare data integrations and pipelines. Build internal tools and data abstractions, improve integration scalability and quality, mentor engineers, establish best practices, and collaborate with product, delivery, platform, and support teams. Apply rigorous software engineering practices including automated testing, CI/CD, version control, and observability while advancing data semantics, claims processing, cataloging, and lineage.
Top Skills:
Apache AirflowCi/CdDagsterData MeshDbtDjangoEltETLFhirFivetranGoHl7KafkaKotlinMedallion ArchitecturePythonSnowflakeSqlalchemyX12
What you need to know about the NYC Tech Scene
As the undisputed financial capital of the world, New York City is an epicenter of startup funding activity. The city has a thriving fintech scene and is a major player in verticals ranging from AI to biotech, cybersecurity and digital media. It also has universities like NYU, Columbia and Cornell Tech attracting students and researchers from across the globe, providing the ecosystem with a constant influx of world-class talent. And its East Coast location and three international airports make it a perfect spot for European companies establishing a foothold in the United States.
Key Facts About NYC Tech
- Number of Tech Workers: 549,200; 6% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Capgemini, Bloomberg, IBM, Spotify
- Key Industries: Artificial intelligence, Fintech
- Funding Landscape: $25.5 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Greycroft, Thrive Capital, Union Square Ventures, FirstMark Capital, Tiger Global Management, Tribeca Venture Partners, Insight Partners, Two Sigma Ventures
- Research Centers and Universities: Columbia University, New York University, Fordham University, CUNY, AI Now Institute, Flatiron Institute, C.N. Yang Institute for Theoretical Physics, NASA Space Radiation Laboratory
