Sr. Data Engineer

Tenth Revolution Group
Commack, NY, United States
3 days ago
Apply on www.thejobnetwork.com
Prepare application

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Expert
Working hours
Regular working hours

Tech stack

Artificial Intelligence Airflow Amazon Web Services Microsoft Azure Extract Transform Load (ETL) Data Mapping Data Mart Data Security Data Structures Data Warehousing Relational Databases Database Queries
+28 more
Python (Programming Language) Microsoft Dynamics Microsoft SQL Server SQL Azure Oracle (Applications) Performance Tuning Role-Based Access Control Power BI Cloud Services Microsoft Copilot SAP (Applications) SQL Databases SQL Server Integration Services Tableau (Software) Enterprise Data Management Azure Data Factory Retrieval-Augmented Generation Large Language Models Netsuite Erp Microsoft Fabric Microsoft Copilot Studio Data Analytics Qlikview Star Schema Real Time Data Looker Analytics Data Pipelines Api Management

Job description

We are looking for a skilled Data Engineer to design, build, and maintain our enterprise Data Warehouse (DWH) and analytics ecosystem - with a growing focus on enabling AI-driven insights, automation, and enterprise-grade AI usage. In this role, you will architect scalable pipelines, improve data quality and reliability, and help lay the foundational data structures that power tools like Microsoft Copilot, Copilot for Power BI, and AI-assisted analytics across the business. You’ll collaborate with business stakeholders, analysts, and IT teams to modernize our data environment, integrate complex data sources, and support advanced analytics initiatives. Your work will directly influence decision-making, enterprise reporting, and next-generation AI capabilities built on top of our Data Warehouse., n

Design, develop, and maintain Data Warehouse architecture, including ETL/ELT pipelines, staging layers, and data marts.

Requirements

n

Proven experience with Data Warehouse design and development (ETL/ELT, star schema, SCD, staging, data marts).

\n

Hands-on experience with SSIS (SQL Server Integration Services) for building and managing ETL workflows.

\n

Strong SQL skills and experience with Microsoft SQL Server.

\n

Proficiency in Power BI or other BI tools (Tableau, Looker, Qlik).

\n

Understanding of data modeling, performance optimization, and relational database design.

\n

Familiarity with Python, Airflow, or Azure Data Factory for data orchestration and automation.

\n

Excellent analytical and communication skills., n

Experience with cloud data platforms (Azure, AWS, or GCP).

\n

Understanding of data security, governance, and compliance (GDPR, SOC2).

\n

Experience with API integrations and real-time data ingestion.

\n

Background in finance, supply chain, or e-commerce analytics.

\n

Experience with NetSuite ERP or other ERP systems (SAP, Oracle, Dynamics, etc.).

\n

\n

AI Focused Preferred Skills:

\n

Experience implementing AI-driven analytics or automation inside Data Warehouses.

\n

Hands-on experience using Microsoft Copilot, Copilot for Power BI, or Copilot Studio to accelerate SQL, DAX, data modeling, documentation, or insights.

\n

Familiarity with building RAG (Retrieval-Augmented Generation) or AI-assisted query patterns using SQL Server, Synapse, or Azure SQL.

\n

Understanding of how LLMs interact with enterprise data, including grounding, semantic models, and data security considerations (Purview, RBAC).

\n

Experience using AI tools to optimize ETL/ELT workflows, generate SQL scripts, or streamline data mapping/design.

\n

Exposure to AI-driven data quality monitoring, anomaly detection, or pipeline validation tools.

\n

Experience with Microsoft Fabric, semantic models, or ML-integrated analytics environments.

\n

\n

Soft Skills

\n

Strong analytical and problem-solving mindset.

\n

Ability to communicate complex technical concepts to business stakeholders.

\n

Detail-oriented, organized, and self-motivated.

\n

Collaborative team player with a growth mindset.

Benefits & conditions

Build and manage ETL workflows using SQL Server Integration Services (SSIS) and other data integration tools.

\n

Integrate and transform data from multiple systems, including ERP platforms such as NetSuite.

\n

Develop and optimize SQL scripts, stored procedures, and data transformations for performance and scalability.

\n

Support and enhance Power BI dashboards and other BI/reporting systems.

\n

Implement data quality checks, automation, and process monitoring.

\n

Collaborate with business and analytics teams to translate requirements into scalable data solutions.

\n

Contribute to data governance, standardization, and documentation practices.

\n

Support emerging AI initiatives by ensuring model-ready data quality, accessibility, and semantic alignment with Copilot and other AI tools.

\n

\n

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on www.thejobnetwork.com
Prepare application

Good distractions

Loading talks and stories from around this role…