Senior Data Engineer

Dice is the leading career destination for tech experts at every stage of their careers. Our client, Trail Blazer Consulting LLC, is seeking the following. Apply via Dice today!Visa: orJob Title: SR/Data EngineerLocation: 2 locations-one is in Woodbury, NY(Long Island) the other is in Calhoun, GaInterview: Video + onsitethis is a full time positionYou can work out of 2 locations-one is in Woodbury, NY(Long Island) the other is in Calhoun, Ga.For the first 3-6 months this is on-site (Full time) Followed by minimally 3 days on site)Candidate must be local to either location-orExcellent communication skills-company name is Confidentialthey are a mfr/dist firmNeed someone with similar industryMUST have the ability to bring solutions to the business that can be impactful and provide the strategic architectural solutions.Must have stable work history- this is a permanent job- No career consultants.MUST COME FROM A SMALLER FIRM [ 200-300 M. IN SALES ] NO LARGE FIRMSno relocation-Senior Data EngineerFocus: Microsoft Fabric, ETL, and Enterprise Data WarehouseLocation: Woodbury, NY 11797 or Calhoun, GA 30701Reports To: Senior IT LeadershipRole SummaryThe 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 BICore 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 solutionsRequired 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 teamsPreferred Experience Azure Synapse, Data Factory, or Databricks Salesforce and HubSpot data models and APIs Data governance, quality frameworks, and access controls