Senior Data Engineer — Hybrid Data Warehouse & BI Lead

sohodragon; New York (NY); Hybrid; USD 120,000 - 170,000; Full time

Benefits offered by this job

Medical insurance

Vision insurance

Dental insurance

401(k)

Job summary

sohodragon seeks a Senior Data Engineer to own the data warehouse, ETL processes, and BI reporting. You will integrate NetSuite, IRI, and POS data, develop scalable data architectures, and guide third-party analytics resources. Hybrid role in Commack, NY with collaboration across teams.

The role focuses on building robust data pipelines, dashboards, and data governance to deliver actionable insights for business stakeholders.

Qualifications

• Bachelor’s degree in Computer Science, IT, or related field.
• Proven experience in data engineering in manufacturing/distribution environments.
• Extensive experience with data collection and standardizing database schemas for bespoke sources.
• Strong SQL, JSON, XML, Power BI, Python skills.

Responsibilities

• Design, construct, test, and maintain robust data architectures.
• Build and manage APIs for data extraction and transformation.
• Develop and optimize ETL processes across multiple sources.
• Create data extracts to feed data warehouses to internal/external systems.
• Create and manage Power BI dashboards and reports for stakeholders.
• Assist analysts in developing reports and dashboards with accurate data.
• Maintain and improve SQL, Power BI, Cognos, and related tools.
• Collaborate with departments to provide data solutions aligned with business goals.

Skills

SQL

Power BI

Python

ETL

Data warehouse

APIs

RBAC

Azure

SQL Server

Cognos

Education

Bachelor's degree in Computer Science, IT, or related field

Tools

SQL Server

Azure Data Factory

Cognos

SSIS

Job description

sohodragon seeks a Senior Data Engineer to own the data warehouse, ETL processes, and BI reporting. You will integrate NetSuite, IRI, and POS data, develop scalable data architectures, and guide third-party analytics resources. Hybrid role in Commack, NY with collaboration across teams.

The role focuses on building robust data pipelines, dashboards, and data governance to deliver actionable insights for business stakeholders.