Senior Data Engineer

About this role

Senior Data Engineer

Experience: 6–8 years
Work Schedule: Must be able to provide some overlap with US Pacific Time for client meetings

About the Role

We are looking for a Senior Data Engineer with strong experience in SQL Server, ETL/ELT, data modeling, and data quality to build and maintain reliable data pipelines and a shared data foundation across multiple source systems.

The ideal candidate will be comfortable working with complex and inconsistent data environments, legacy systems, flat-file/report-based integrations, and multiple databases. This role requires strong analytical and problem-solving skills, along with the ability to work independently and communicate data-related issues clearly to technical and business stakeholders.

Key Responsibilities

• Extract and integrate data from SQL databases, spreadsheets, ERP report exports, and other source systems.

• Clean, standardize, match, and reconcile data across multiple systems.

• Perform data quality checks, deduplication, validation, and reconciliation.

• Design, develop, and maintain reliable ETL/ELT pipelines and data loads.

• Build standardized data models that integrate data from multiple source systems.

• Develop and maintain operational and reporting data models.

• Create and maintain a data dictionary with agreed definitions, mappings, and business rules.

• Develop reliable integration processes for systems with limited or no APIs using report exports, flat files, or other appropriate methods.

• Write and optimize complex SQL queries, stored procedures, and database processes.

• Perform SQL Server performance tuning and troubleshoot database-related issues.

• Implement appropriate data masking, access controls, and least-privilege practices.

• Investigate data discrepancies and identify root causes.

• Collaborate with BI analysts and application developers to support reporting and application requirements.

• Document data processes, mappings, and technical solutions.

• Communicate technical findings and data issues clearly to stakeholders.

Required Qualifications

•
6–8 years of professional experience in Data Engineering.

• Strong hands-on expertise with Microsoft SQL Server.

• Advanced SQL skills, including query optimization and performance tuning.

• Strong experience with ETL/ELT development and data integration.

• Experience with one or more of the following:

• SSIS

• Azure Data Factory

• Python

• Strong understanding of data modeling for operational and reporting environments.

• Hands-on experience with data quality processes, including:

• Data cleansing

• Data matching

• Deduplication

• Data validation

• Data reconciliation

• Experience integrating data from ERP systems through reports, exports, flat files, or similar methods.

• Experience with data masking, security, and access controls.

• Strong analytical, troubleshooting, and problem-solving skills.

• Ability to work independently and manage data engineering tasks with minimal supervision.

• Strong written and verbal communication skills.

Preferred Qualifications

• Experience creating Power BI data models.

• Experience working with inventory, procurement, supply-chain, or ERP data.

• Experience in agriculture, food, manufacturing, or related industries.

• Experience working directly with client-side IT teams and business stakeholders.

• Experience working with legacy systems and highly inconsistent or fragmented data.

What You'll Bring

• Strong ownership and attention to detail.

• A structured approach to solving complex data problems.

• Ability to work effectively with messy and incomplete data.

• Ability to translate technical data issues into clear business explanations.

• A proactive approach to identifying data-quality and integration challenges.

• Ability to collaborate effectively with technical and non-technical stakeholders.

If you are a hands-on Senior Data Engineer with strong SQL Server, ETL, data modeling, and data-quality experience, we’d love to hear from you.

Originally posted on Himalayas