Senior Data Engineer

Job Description

We are seeking a highly experienced Senior Data Integration / ETL Engineer to design, build, and support enterprise-scale data integration solutions. The ideal candidate will have deep expertise in Microsoft SQL Server, ETL/ELT frameworks, modern data integration patterns, and large-scale data platforms , along with strong analytical and communication skills.

This role involves working closely with cross-functional teams to deliver reliable, scalable, and high-quality data products following industry best practices and SDLC standards.

Roles & Responsibilities

Design, develop, and maintain enterprise-grade data integrations using ETL/ELT tools such as SSIS, Databricks , or equivalent platforms.

Build and optimize data pipelines leveraging relational databases, APIs, and event-driven messaging patterns.

Develop and manage complex SQL Serverbased solutions , including stored procedures, views, performance tuning, and query optimization.

Implement and support data integration patterns , including batch ETL, ELT, near-real-time ingestion, and API-based integrations.

Work with Change Data Capture (CDC) and Change Tracking mechanisms to support incremental and real-time data movement.

Design and validate data models for both OLTP and OLAP workloads, ensuring scalability and performance.

Collaborate on Master Data Management (MDM) initiatives to ensure consistent and governed enterprise data.

Participate actively in the data product SDLC , including requirement analysis, design, development, testing, deployment, and production support.

Ensure data quality, integrity, and consistency across integrated systems.

Collaborate with architects, developers, QA teams, and business stakeholders in a highly collaborative Agile environment .

Document technical designs, data flows, and operational procedures clearly and concisely.

Required Qualifications & Experience

Education

Bachelors degree (BA/BS) in Business, Computer Science, Computer Engineering, Electrical Engineering, Systems Analysis , or a related field, or equivalent practical experience.

Experience

10+ years of hands-on experience with Microsoft SQL Server or equivalent enterprise RDBMS platforms.

10+ years of experience building data integrations and ETL pipelines using tools such as SSIS, Databricks , or similar technologies.

Strong hands-on experience with ETL/ELT architecture patterns , event-driven messaging, and API-based integrations.

Preferred / Nice-to-Have Qualifications

Masters degree (MS/MA) in a relevant technical or business discipline.

15+ years of experience with the Microsoft SQL technology stack .

Experience working within Enterprise Architecture and Service Delivery models such as TOGAF and ITIL .

Certification in a Cloud Data Engineering or related cloud technology curriculum.

Key Skills & Competencies

Strong understanding of data integration and data modeling patterns for OLAP and OLTP systems

Familiarity with Master Data Management (MDM) concepts and platforms

Excellent analytical, problem-solving, and technical skills

Strong planning, organizational, and documentation abilities

Excellent verbal and written communication skills

Ability to work effectively in a collaborative, team-oriented environment