Senior Data Engineer

Key Responsibilities

• Design, develop, and maintain enterprise data ingestion pipelines supporting full data loads, incremental processing, and change data capture.
• Build and support SQL Server-based and API-driven data integration solutions.
• Develop and maintain ETL/ELT workflows that move data into centralized data platforms.
• Optimize SQL queries, indexes, and database performance to ensure scalable, efficient processing.
• Troubleshoot production issues involving data quality, pipeline failures, and performance bottlenecks.
• Design monitoring, alerting, and validation processes to improve pipeline reliability and data integrity.
• Participate in architectural discussions focused on scalability, performance, reliability, and operational efficiency.
• Collaborate with architects, application teams, and data engineering partners to support end-to-end data movement.
• Create and maintain technical documentation, process flows, and implementation diagrams.

Required Qualifications

• Strong experience designing and supporting enterprise data ingestion and synchronization pipelines.
• Advanced SQL Server expertise, including: Query optimization, Performance tuning, Index design, Blocking and locking analysis, Troubleshooting complex database issues.
• Hands-on experience developing SSIS packages and data movement workflows.
• Experience building and supporting ETL/ELT pipelines within data warehouse or data lake environments.
• Experience with cloud-based data engineering solutions using AWS services such as: S3, Lambda, Glue, Athena, CloudWatch, CloudTrail.
• Experience designing cloud-native data pipelines.
• Experience with .NET-based data processing solutions.
• Working knowledge of Python for data engineering tasks.
• Experience implementing data validation, reconciliation, and data quality processes.
• Experience designing monitoring, observability, and alerting for production data pipelines.
• Experience using Git, Bitbucket, or similar source control and release management tools.
• Strong analytical, troubleshooting, and problem-solving skills.
• Excellent communication skills with the ability to collaborate across technical teams.

Preferred Qualifications

• Experience using DBT (Data Build Tool) for modern data transformation.
• Familiarity with AWS architectural best practices and cloud design principles.
• Knowledge of data governance, data lineage, and data ownership practices.
• Experience contributing to technical architecture decisions and mentoring other engineers.
• Experience working within enterprise-scale data engineering environments.