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 Server–based 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 • Bachelor’s 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 • Master’s 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