Senior Data Engineer

We are seeking a Senior Data Engineer to support enterprise data and analytics initiatives within a large-scale, production-critical environment. This role will focus on building, maintaining, and optimizing data pipelines across a hybrid on-prem and cloud ecosystem, with a strong emphasis on modern data engineering practices and lakehouse architecture.

This is a highly visible role supporting operational and analytics teams, where you will play a key part in transforming raw data into reliable, structured datasets used across the business., * Design, build, and optimize batch and streaming data pipelines

• Develop and maintain ETL workflows using SSIS or similar tools
• Write and optimize complex SQL queries within SQL Server environments
• Design and maintain dimensional data models (star schema)
• Transform raw data into curated datasets for analytics and reporting
• Support business intelligence efforts, including Power BI reporting
• Work across relational databases, data lakes, and NoSQL systems
• Collaborate with cross-functional teams to deliver production-ready data solutions

• 5+ years of experience in data engineering or related roles
• Strong SQL skills with experience in performance tuning
• Hands-on ETL experience (SSIS or equivalent)
• Experience with SQL Server environments
• Strong understanding of data modeling (star schema / dimensional modeling)
• Experience supporting analytics and reporting workflows

Preferred:

• Experience with Databricks, Spark, or modern data platforms
• Exposure to cloud environments (Azure preferred)
• Experience with orchestration tools (Airflow or similar)
• Familiarity with CI/CD and Git-based workflows