Senior Data Engineer in Woodbury, NY 11797 or Calhoun, GA 30701

Senior Data Engineer

Location: Woodbury, NY 11797 or Calhoun, GA 30701

Duration: Full time

Interview Mode: video

Job Description:

SR/Data Engineer

MUST have excellent communication skills as this position requires the ability to engage with business stakeholders.

Strong analytics exp along with the technical background

Ability to bring solutions to the business that can be impactful and provide the strategic architectural solutions .

This is a small dept-they don t want candidates from large environments. Need to know how to work independently- Client does 200-300 M in sales-

Do not send resumes that are AI formatted- client knows how to pick them out and will disqualify automatically.

MUST BE ABLE to work the first 6 months (on-site-full time) followed by minimally 3 days onsite and remainder of the week remote-

or necessary

NO RELOCATIONS

There are 2 different locations that they can work out of Woodbury, NY(which is Long Island) anyone from NJ will not be considered it is too far- NO EXCEPTIONS- )The other location is Calhoun , Georgia .Salary to 150K

MUST COME from similar industry- (Mfr/distribution)

Stable work history-no career consultants-

Must be able to supply references when needed. When submitting resumes -you must send a detailed write-up as to how their exp relates to this job as well as size of companies As well as the distance they are from the location they would be working at. IF THERE IS NO WRITE UP I WILL NOT CALL THE CANDIDATE!

BE sure you read the entire job description and send to the candidates so they know what is necessary- do not just read this briefing-

Senior Data Engineer

Focus: Microsoft Fabric, ETL, and Enterprise Data Warehouse

Reports To: Senior IT Leadership

Role Summary

The Senior Data Engineer owns the design, implementation, and evolution of Company s enterprise data platform. This role is accountable for ETL pipelines, data warehouse and Lakehouse architecture, and enterprise data modeling as Company transitions from an on-premises SQL environment to a modern cloud-based analytics platform.

Company is in the process of establishing Microsoft Fabric as the future-state data platform. The Senior Data Engineer will define standards, shape architecture, and lead the transition from existing on-premises SQL stored procedures to a scalable, governed analytics environment.

This role is critical as Company modernizes its enterprise analytics capabilities, replacing legacy on-premise SQL workflows with a scalable, governed cloud platform that will support future growth, advanced analytics, and self-service BI

Core Responsibilities

End-to-end ownership of data pipelines, models, and analytics architecture - from design through production support

Acts as the technical decision-maker for data platform standards and patterns

Comfortable operating in environments with evolving requirements and incomplete data

Ability to translate available data from pipelines into value-added analytics to the business s benefit

Expected to proactively identify business solutions, data gaps, quality issues, and architectural improvements

Design and implement the Microsoft Fabric Lakehouse and data warehouse, and lead the transition from on-premises SQL-based solutions

Develop and maintain ETL and ELT pipelines using Fabric Data Factory, SQL, and notebooks

Ability to define and establish the semantic layer to enable servicing data to business resources for self service visualizations

Apply scripting or notebook-based approaches, including Python/R/etc. where appropriate, for data transformation, automation, and data quality enforcement

Integrate data from AS400 ERP, Salesforce, HubSpot, and other SaaS platforms

Design analytical data models, fact and dimension tables, and curated data marts

Implement CI/CD practices for data pipelines and analytics assets, enabling agile, reliable, and controlled production deployments

Operate in an Agile delivery environment

Optimize platform performance, scalability, reliability, and cost

Support and stabilize existing datasets and dashboards

Drive Power BI adoption and define migration approach for legacy tools and standards

Design and implement data quality checks, monitoring, alerting, recovery mechanisms, and governance controls

Maintain documentation for pipelines, models, and integration patterns

Partner with IT and business stakeholders to translate requirements into data solutions

Required Qualifications

Bachelor s degree in Computer Science, Information Systems, or equivalent experience

5+ years of experience in data engineering, including enterprise data warehouse and analytics platforms

Advanced SQL skills with strong analytical and enterprise data modeling experience

Experience designing and operating data warehouses, lakes, or Lakehouse architectures in a cloud environment

Experience integrating ERP systems, CRM, and SaaS data sources

Experience supporting BI tools, including Tableau (phasing out) and Power BI

Strong communication skills with technical and business teams

Preferred Experience

Azure Synapse, Data Factory, or Databricks

Salesforce and HubSpot data models and APIs

Data governance, quality frameworks, and access controls