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. Key Responsibilities: • 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 Required Qualifications: • 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