A Senior Data Engineer is accountable for the design and implementation of Lineage’s data assets. Specifically, this includes being responsible for developing normalized, dimensional, and hybrid data models to support reporting, analytics, and APIs used by other internal and external applications. The Senior Data Engineer will focus on the following: 1. Data Ingestion - moving source system data to central data assets 2. Data Modeling - determining field-level data usage 3. Data Wrangling - identifying queries/algorithms to efficiently transform data from source system formats to a unified RDBMS schema 4. Data Quality - ensuring complete and uninterrupted data mappings from source to central data assets At Lineage, we leverage cloud services, best-of-breed technologies, and external teams to augment our capabilities with sufficient capacity. This means that in addition to being a great technologist and individual contributor, you need to be able to review and collaborate with partners to ensure that we get the same quality from them too. As a company, Lineage leverages state-of-the-art technology to meet our customers’ needs, assist in our international growth, and create an infrastructure that enables Lineage to lead the industry. As the ideal candidate for this position, you will exhibit the technical expertise, business acumen and flexibility required to successfully work with all levels of Lineage’s organization. Essential Job Functions: · Perform detailed data analysis and translate business requirements into logical and physical data models · Participate in complex technical data discussions on modeling, integration, and overall technology solutions and design · Possess the ability to a create robust, scalable, and sustainable data architecture that supports requirements and provides for future expansion · Integrate additional data sets into the Operational Data Store to support organizational needs · Re-engineer existing physical data structures and recommend efficiencies as it relates to data storage and retrieval · Automate, monitor, and support data mappings, and re-design if required to make them faster and/or more reliable · Design and implement system components which reconcile and audit the results of the extract/transform or conversion of data from source systems to the target structures · Conduct quantitative and qualitative analyses of large and complex data · Work closely with DBAs to help ensure the physical design meets the functional and performance requirements of the applications utilizing the data · Collaborate with report and API developers on data mapping and report / application design · Work closely with DBAs to help ensure the physical design meets the functional and performance requirements of the applications utilizing the data · Collaborate with report and API developers on data mapping and report / application design Requirements: · Possess prior experience in designing and building data ingestion and storage solutions · Exhibit knowledge related to full life cycle experience in Data Modeling, Data Integration, and Master Data Management · Architect and implement data structures for a reporting solution from enterprise OLTP systems · Mastery of SQL with ability to perform analytical queries as well as updates to data sets · Grow and maintain a broad and deep knowledge of data technologies and techniques · Possess a willingness to be coached and proactively seek feedback · Handle multiple assignments/projects simultaneously · Properly set priority and order for work · Work in a fast-paced, agile environment · Ask for help and provide it to others · Understand your skills and your talents and apply them appropriately · Learn and apply new technologies and business concepts · Maintain personal accountability for getting things done on time and with quality results · Demonstrate excellent verbal and written communication skills including the ability to explain technical concepts to business leaders · Be willing and able to travel on occasion (<1 week per month) Education and/or Experience: · 5+ years - Data Engineering / Modeling experience; delivering both logical models and physical designs with experience translating business needs into data requirements · A degree in Computer Science, a related discipline, or equivalent work experience of 6+ years overall IT or the equivalent combination of education, training and experience from which comparable skills can be acquired · Experience with a mix of relational database technologies like Microsoft SQL-Server, Oracle, PostgreSQL, MySQL, etc. · Experience with data modeling tools like Erwin, PowerDesigner, and Toad Data Modeler Preferred Skills: · Previous Supply Chain or Logistics industry experience strongly preferred · Experience working with data from the following technologies is a plus: ERP, WMS, TMS, CRM, HRIS · Prior software development experience is also preferred Why Lineage? This is an excellent position to begin your career path within Lineage! Success in this role enables greater responsibilities and promotions! A career at Lineage starts with learning about our business and how each team member plays a part each and every day to satisfy our customers’ requirements. Beyond that, you’ll help us grow and learn on our journey to be the very best employer in our industry. We’ll ask you for your opinion and ensure we do our part to keep you developing and engaged as we grow our business. Working at Lineage is energizing and enjoyable. We value respect and care about our team members. Lineage is an Equal Employment Opportunity Employer and is committed to compliance with all federal, state, and local laws that prohibit workplace discrimination and unlawful harassment and retaliation. Lineage will not discriminate against any applicant on the basis of race, color, age, national origin, religion, physical or mental disability or any other protected status under federal, state and local law. Benefits Lineage provides safe, stable, reliable work environments, medical, dental, and basic life and disability insurance benefits, 401k retirement plan, paid time off, annual bonus eligibility, and a minimum of 7 holidays throughout the calendar year. More vacancies in the Netherlands (https://nl.indeed.com/cmp/Lineage-055976f9?from=mobviewjob&tk=1hs858ajlmnao847&fromjk=e757d669ba21113f&attributionid=mobvjcmp) Not sure which role is right for you? Let us do the work! Share your contact information and a resume or CV. A member of our recruiting team will reach out to you to explore roles we think could be a good match. At Lineage, we have a shared purpose: We are transforming the food supply chain to eliminate waste and help feed the world. Our shared purpose drives everything we do in all parts of our organization, from the warehouse floor to the corner office. The work we do is noble, and our team members are passionate about the impact they make every day. Working at Lineage is not just a job – it’s an opportunity to innovate and put your mark on how food moves from the farm to dinner tables around the world. As a member of the Lineage Logistics team, you are a critical link in the food supply chain. If you are having trouble applying, contact our Human Resources team here: Contact Us | Lineage Logistics (https://www.lineagelogistics.com/contact-us) At Lineage Logistics, helping to feed the world is more than a job – it’s a purpose we live every day. Lineage is one of the world’s leading temperature-controlled logistics companies. Driven by our core values, we’re reimagining the global food supply chain. Lineage helps customers ranging from Fortune 500 companies to small family-owned businesses increase the efficiency and protect the integrity of their temperature-controlled supply chain. In recognition of the company’s leading innovations, Lineage was recognized as the No 1. Data Science company on Fast Company’s annual list of the World’s Most Innovative Companies in 2019, in addition to ranking 23rd overall in an evaluation of thousands of companies worldwide. As part of the Lineage family, you’ll have the opportunity to grow your career as we continually expand, using technology and award-winning innovations, to meet the needs of customers around the world.