Join Ensign-Bickford Industries, Inc. (EBI) and you’ll be part of a team that leads science, innovation, and technology on different industry fronts. Working here will provide you with an exciting and motivating career full of development and growth opportunities throughout our businesses. We are a global company that prides itself on having passionate, diverse and dedicated employees who work together to achieve uncommon results. Job Description As a Data Engineer at Ensign-Bickford Industries, Inc. you will play a pivotal role in designing, developing, and maintaining robust data pipelines, business workflows, and custom database event processes. Embedded within the EBI Data & Analytics Team, your expertise will support our data-driven culture while exploring AI/ML capabilities to support EBI’s winning vision. You will collaborate closely with business stakeholders to gather requirements and deliver high-quality, scalable data solutions that meet the organization’s evolving needs. You will also be expected to bring a continuous improvement mindset to the role, actively seeking opportunities to optimize processes, enhance solution performance, and incorporate industry best practices into the integration lifecycle. By fostering a culture of innovation and efficiency, you will help ensure our data integration capabilities remain reliable, agile, and aligned with business objectives. This position is located our Simsbury, CT location. Job Responsibilities + Partner with business stakeholders and IT Teams to gather technical requirements, including data mappings, transformations, and data flows. + Design and develop efficient ETL pipelines for data collection, transformation, and storage from diverse sources (MSSQL, Oracle, ERP, LIMS, MES). + Utilize business workflows and event-driven architecture to inject custom functionality into IFS ERP, enhancing system performance. + Maintain and update comprehensive documentation on data flow, lineage, and dependencies. + Implement automated validation, monitoring, and troubleshooting processes to ensure data quality, consistency, and performance. + Adhere to data strategy, policies, controls, and programs to ensure the enterprise data is accurate, complete, secure, and reliable. + Stay up-to-date on emerging technologies to continually improve data processing and management capabilities. This includes data lakes, data warehouses and cloud services. + Identify opportunities for continuous improvement in processes, workflows, and system performance. Required Qualifications + Bachelor’s degree in Computer Science, Information Systems, or a related field, or equivalent experience. + Minimum 5 years of experience as a Data Engineer or in a similar role, preferably in industries using ERP, LIMS, or MES systems. + Extensive experience and in-depth knowledge of relational database management systems (RDBMS), including but not limited to MSSQL, Oracle, and Azure SQL Database. Proven ability to design, implement, and maintain complex database solutions, ensuring data integrity, performance optimization, and security compliance. Proficient in writing and optimizing complex SQL queries and experienced with PL/SQL for developing stored procedures, functions, and triggers. + Knowledge of ETL development lifecycle principles, data pipelines and data transformation methods (e.g. SSIS, Boomi) + Strong communication skills and ability to collaborate effectively with both technical and non-technical stakeholders. + Knowledge of data governance, data quality, and data security best practices + Proven team player who thrives in a collaborative environment. + Ability to learn new technologies and adapt to changing business needs. + Ability to work independently and as part of a team. + Candidate must be a U.S. Person. Preferred Qualifications + Proven track record of implementing data-driven solutions in enterprise environments. + Experience in data model design to support reporting in data warehouse. + Excellent problem-solving skills with ability to troubleshoot complex data issues. Knowledge of LEAN Problem Solving a plus. + Custom ERP system development a plus. (e.g. Custom events, custom scripting) + Familiarity with AI/ML applications in business contexts a plus. + Programming Skills: Proficiency in programming languages and tools such as Python, SQL, and data visualization tools like PowerBI or Tableau a plus. Ensign-Bickford Industries, Inc. is an Equal Opportunity Employer (EOE). Qualified applicants are considered for employment without regard to race, religion, color, sex, age, disability, sexual orientation, genetic information, national origin, or veteran status. Ensign-Bickford Industries, (http://e-bind.com) (EBI), founded in 1836, is a privately-owned high technology conglomerate that participates in businesses that are relevant to the future of the world and have multigenerational growth prospects. Over the last 186 years, EBI has grown into a global science and technology leader in pet food science, space and defense, and diagnostic solutions. Our businesses are unified by a common shared operating system and a common set of Core Values. Watch the video above to learn more about some of the incredible challenges we take on every day to deliver the best product for our customers, and ultimately the world. The simple truth is: When you are a part of our team, you stand head and shoulders above the rest. We conduct business in a manner that reflects the highest human and ethical standards, with a commitment to mutually beneficial partnerships, and a belief in the efficacy of genuine economic and social service. Click here to learn about our Core Values (https://ensign-bickfordind.com/ebi-core-values/) AFB International + AFB is the leader in pet food flavor enhancers. Ensuring product performance for pet food manufacturers—and their customers—is our business. ⠀ Cawood (https://cawood.co.uk/) + Cawood is the UK’s leading scientific group, recognized for its technical capability and value-added service to customers in land-based industries. ⠀ Ensign-Bickford Aerospace & Defense Company (http://www.ensign-bickfordind.com/subsidiaries/ensign-bickford-aerospace-defense/) + EBAD is a global leader in precision energetic systems and other innovative explosives, non-explosive and electromechanical solutions for the defense and aerospace markets. ⠀ EnviroLogix (http://www.ensign-bickfordind.com/subsidiaries/envirologix-inc/) + EnviroLogix is an industry leader in the development and manufacturing of tests for the rapid detection of GMOs and mycotoxins throughout the worldwide food production chain.