Senior Data Engineer

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