Senior Data Engineer

Job description

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.