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