Senior Data Engineer

RESPONSIBILITIES:
Kforce has a client in Woodbury, NY that is seeking a Senior Data Engineer.

Summary:
The Senior Data Engineer owns the design, implementation, and evolution of Stanton's enterprise data platform. This role is accountable for ETL pipelines, data warehouse and lakehouse architecture, and enterprise data modeling as Stanton transitions from an on-premise SQL environment to a modern cloud-based analytics platform. This 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-premise SQL stored procedures to a scalable, governed analytics environment.

Core Responsibilities:
* Design and implement the Microsoft Fabric lakehouse and data warehouse, and lead the transition from on-premise SQL-based solutions
* Develop and maintain ETL and ELT pipelines using Fabric Data Factory, SQL, and notebooks
* Apply scripting or notebook-based approaches, including Python 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
* Optimize platform performance, scalability, reliability, and cost
* Support and stabilize existing Tableau datasets and dashboards
* Evaluate Power BI adoption and define migration approach and standards
* Implement data quality checks, monitoring, and governance controls
* Maintain documentation for pipelines, models, and integration patterns
* Partner with IT and business stakeholders to translate requirements into data solutions

REQUIREMENTS:
* 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 warehouse, lake, or lakehouse architectures in a cloud environment
* Experience integrating ERP systems, CRM, and SaaS data sources
* Experience supporting BI tools, including Tableau 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

The pay range is the lowest to highest compensation we reasonably in good faith believe we would pay at posting for this role. We may ultimately pay more or less than this range. Employee pay is based on factors like relevant education, qualifications, certifications, experience, skills, seniority, location, performance, union contract and business needs. This range may be modified in the future.

We offer comprehensive benefits including medical/dental/vision insurance, HSA, FSA, 401(k), and life, disability & ADD insurance to eligible employees. Salaried personnel receive paid time off. Hourly employees are not eligible for paid time off unless required by law. Hourly employees on a Service Contract Act project are eligible for paid sick leave.

Note: Pay is not considered compensation until it is earned, vested and determinable. The amount and availability of any compensation remains in Kforce's sole discretion unless and until paid and may be modified in its discretion consistent with the law.

This job is not eligible for bonuses, incentives or commissions.

Kforce is an Equal Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, pregnancy, sexual orientation, gender identity, national origin, age, protected veteran status, or disability status.

By clicking ?Apply Today? you agree to receive calls, AI-generated calls, text messages or emails from Kforce and its affiliates, and service providers. Note that if you choose to communicate with Kforce via text messaging the frequency may vary, and message and data rates may apply. Carriers are not liable for delayed or undelivered messages. You will always have the right to cease communicating via text by using key words such as STOP.