Senior Data Engineer

SoHo Dragon

. Design, construct, test, and maintain robust data architectures aligned with business requirements .

Posted 9/18/2026full-timeNew York City • New York • United StatesSeniorWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates expertise in data engineering, including proficiency in SQL, ETL processes, and data architecture design. Capable of delivering actionable insights through data analytics and managing data integrity and security in compliance with governance standards.

Highest-signal resume keywords

Data EngineeringSQL ProficiencyETL Process OptimizationAPI ManagementPower BI Dashboard Creation

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

SQLETLData ArchitectureData Warehouse DesignPythonJSONXMLStored ProceduresQuery OptimizationData Analytics

Soft Skills

Problem-SolvingAttention to DetailCollaborationEffective Communication

Tools & Technologies

Power BICognosFivetranSSISAzure Data FactoryMicrosoft FabricData LakeAnalysis Services

Industry Keywords

ManufacturingDistributionData GovernanceData IntegrityCompliance Standards

Tech Stack

Tools & technologies

AzureCognosETLPythonSQLSSIS

About the role

Key responsibilities & impact

Design, construct, test, and maintain robust data architectures aligned with business requirements
Build and manage APIs for data extraction and transformation
Develop and optimize ETL processes for extracting, transforming, and loading data from various sources
Develop data extracts to feed data warehouse data to internal and external systems
Create and manage Power BI dashboards and reports
Provide actionable insights to business stakeholders
Assist data analysts in developing reports and dashboards
Maintain and improve SQL, Power BI, Cognos, and other data engineering tools and practices
Collaborate with departments to understand data needs and provide technical solutions aligned with business objectives
Ensure data integrity and security in accordance with data governance and compliance standards
Evaluate and recommend improvements to existing data systems and processes
Conduct research for industry and business questions using large data sets
Recommend improvements to data reliability, efficiency, and quality
Deliver data analytics using AI
Guide and manage third-party resources contracted for data analytics projects

Requirements

What you’ll need

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 such as Fivetran, SSIS, and Azure Data Factory Pipelines
Experience building and managing APIs
Experience with data warehouse design and management
Experience building database objects, including schemas, tables, views, and indexes
Experience writing complex stored procedures, functions, and triggers
Experience optimizing performance through query optimization, execution plans, and index management
Experience with Analysis Services, multidimensional databases, parent-child dimensions, alternate hierarchies, and OLAP/ROLAP cubes
Experience deploying databases on SQL Server with role-based access control (RBAC) for administrators and users
Prefer experience with Microsoft Fabric, Azure Data Factory, and 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

Comp & perks

Medical insurance
Vision insurance
Dental insurance
401(k)