Senior Data Engineer

Job Description Summary: Amphenol Industrial Operations is seeking a highly skilled and motivated Senior Data Engineer to lead the design, development, and optimization of enterprise data solutions that support manufacturing operations, business intelligence, and strategic decision-making across our global organization. This role is responsible for building and maintaining scalable, secure, and high-performance data pipelines and infrastructure that transform data from ERP systems, manufacturing applications, cloud platforms, remote databases, and other business systems into trusted and actionable information.   Company Introduction: Amphenol Industrial Operations, headquartered in Endicott, New York with global manufacturing, sales and marketing locations, specializes in delivering a comprehensive range of high-reliability power and signal connectors along with interconnection systems designed specifically for industrial applications. Our solutions cater to diverse industrial sectors such as alternative energy, power generation and storage, rail and mass transit, process control, automotive manufacturing, heavy equipment, wireless base stations, and petrochemical industries.                                                                                                          Our product portfolio encompasses power interconnects utilizing RADSOK® contact technology, ruggedized military derivative commercial cylindrical connectors such as AC Threaded (SAE AS50151 style), PT (MIL-DTL-26482 style) and GT reverse bayonet style, assemblies and harnesses using these and other industry standard interconnect. With a dedicated team of over 900 skilled professionals and certifications including ISO9001 and IATF 16949, Amphenol Industrial Operations consistently meets the highest standards of quality and performance.                                                                                                                         Amphenol Industrial Operations proudly operates as a division of Amphenol Corporation, headquartered in Wallingford, Connecticut. Duties/Responsibilities: Design and implement robust, scalable ETL/ELT pipelines across multiple SQL Server environments and cloud platforms. Collaborate with developers, and business stakeholders to understand data requirements and translate them into technical solutions. Develops and maintains comprehensive documentation of data processes, reports, applications, and procedures to ensure consistency, knowledge sharing, and alignment with organizational standards. Ensure data quality, integrity, and security through validation, monitoring, and governance practices. Maintain and evolve data models, schemas, and metadata for analytics and reporting. Designs, develops, and deploys scalable reporting and dashboard solutions to support business intelligence, data visualization, and operational efficiency, ensuring appropriate security measures.Troubleshoot and resolve data issues, ensuring high availability and performance of data systems. Integrate data from a variety of business systems including ERP, SharePoint, external systems. Design, implement, and maintain secure cross-region data integration processes to extract data from remote databases in China and Turkey, validate and transform it, and consolidate it into the U.S.-based ERP database while ensuring data integrity, reliability, performance, and compliance with organizational security standards. Optimize SQL queries, stored procedures, indexes, database objects, and data-loading processes to improve performance, scalability, and resource utilization. Monitor scheduled data pipelines, database jobs, and integration processes; implement logging, alerting, retry mechanisms, and exception handling to identify and resolve failures promptly.   Qualifications - Education/Experience: Bachelor’s degree in Computer Science, Information Systems, Engineering, Data Science, or a related discipline. 6+ years of professional data engineering experience. Strong experience designing, developing, and supporting production data pipelines. Strong understanding of: Data engineering principles Data modeling ETL/ELT development Data quality management Enterprise reporting and analytics Experience working with large datasets and complex data structures. Strong analytical and problem-solving skills. Advanced experience with Microsoft SQL Server, including T-SQL, stored procedures, views, functions, indexing, query optimization, execution plans, and performance troubleshooting. Demonstrated experience designing, developing, and supporting ETL/ELT pipelines across multiple databases, business systems, and geographic regions.  Experience developing reports, dashboards, and business intelligence solutions using tools such as Power BI, SQL Server Reporting Services, or equivalent reporting platforms.   Knowledge/Skills: Knowledge of ETL/ELT development concepts, including data extraction, transformation, incremental loading, scheduling, dependency management, and error recovery. Strong knowledge of data engineering principles, architectures, design patterns, and industry best practices. Strong understanding of relational data modeling, database normalization, dimensional modeling, data warehousing, and metadata management. Knowledge of ETL/ELT development concepts, including data extraction, transformation, incremental loading, scheduling, dependency management, and error recovery.  Strong understanding of data quality management, including validation, reconciliation, completeness checks, duplicate prevention, auditing, and exception handling. Ability to integrate data from ERP systems, SharePoint, APIs, flat files, external applications, cloud platforms, and remote databases.