Senior Data Engineer

Senior Data Engineer

Focus: Microsoft Fabric, ETL, and Enterprise Data Warehouse
Location: Woodbury, NY 11797 or Calhoun, GA 30701
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