Senior BI Engineer at Lanter Delivery Systems LLC
United States
$165k - $175k
<div><p style="margin:0in;font-size:15px;font-family:Carlito;" data-pasted="true"><span style='font-family:"Calibri",sans-serif;'>Founded in 1981, Lanter Delivery Systems is a national logistics company and a leader in overnight, unattended delivery of auto, agricultural and industrial parts from their customer's distribution centers to dealer locations. In the 21st century we live in a business culture that demands cost and logistical efficiencies combined with increased productivity. Lanter's strategic, process driven approach has been embraced by the marketplace and is setting new standards in the automotive and agricultural manufacturing marketplace. We see a bright future on the road before us and we are very excited about bringing our solutions to a variety of new industries.</span></p><p style="margin:0in;font-size:15px;font-family:Carlito;"><br></p><p style="margin:0in;font-size:15px;font-family:Carlito;"><span style='font-family:"Calibri",sans-serif;'>The ideal candidate will embody our company's Non-Negotiables:</span></p><p style="margin:0in;font-size:15px;font-family:Carlito;"><br></p><div style="margin:0in;font-size:15px;font-family:Carlito;"><ul style="margin-bottom:0in;list-style-type: disc;margin-left: 0in;"><li style="margin:0in;font-size:15px;font-family:Carlito;"><strong><span style='font-family:"Calibri",sans-serif;'>Walk in Humble Confidence</span></strong><span style='font-family:"Calibri",sans-serif;'> - We are experts at what we do, but we never assume we know everything</span></li><li style="margin:0in;font-size:15px;font-family:Carlito;"><strong><span style='font-family:"Calibri",sans-serif;'>Be Open, Honest and Respectful</span></strong><span style='font-family:"Calibri",sans-serif;'> - We say what has to be said in a tactful, courteous way</span></li><li style="margin:0in;font-size:15px;font-family:Carlito;"><strong><span style='font-family:"Calibri",sans-serif;'>Be Fearless</span></strong><span style='font-family:"Calibri",sans-serif;'> - We never fail, we only learn</span></li><li style="margin:0in;font-size:15px;font-family:Carlito;"><strong><span style='font-family:"Calibri",sans-serif;'>We are One Team</span></strong><span style='font-family:"Calibri",sans-serif;'> - We achieve more together by collaboration and consensus</span></li><li style="margin:0in;font-size:15px;font-family:Carlito;"><strong><span style='font-family:"Calibri",sans-serif;'>Delivery on Commitments</span></strong><span style='font-family:"Calibri",sans-serif;'> - We do what we say we will do</span></li><li style="margin:0in;font-size:15px;font-family:Carlito;"><strong><span style='font-family:"Calibri",sans-serif;'>We have a Passion to Serve</span></strong><span style='font-family:"Calibri",sans-serif;'> - We are dedicated, hardworking individuals who provide exceptional service to our customers and to each other</span></li><li style="margin:0in;font-size:15px;font-family:Carlito;"><strong><span style='font-family:"Calibri",sans-serif;'>We put Safety First</span></strong><span style='font-family:"Calibri",sans-serif;'> - We prioritize the safety of our team members and customers above all else in our business</span></li><li style="margin:0in;font-size:15px;font-family:Carlito;"><strong><span style='font-family:"Calibri",sans-serif;'>We Strive for Operational Excellence</span></strong><span style='font-family:"Calibri",sans-serif;'> - We are dedicated to a culture of continuous improvements, driving quality and productivity</span></li></ul></div><p style="margin:0in;font-size:15px;font-family:Carlito;"><strong> </strong></p><p style="margin:0in;font-size:15px;font-family:Carlito;"><strong><span style='font-family:"Calibri",sans-serif;'>Position Summary:</span></strong></p><p style="margin:0in;font-size:15px;font-family:Carlito;"><span style='font-family:"Calibri",sans-serif;'>As a Senior BI Engineer, you'll play a key role in strengthening Lanter's enterprise data capabilities by designing scalable data models that turn diverse source-system data into reliable, reusable information for analytics and reporting. A key focus of this role is solving complex data modeling challenges. This includes bringing together data from across customers, business units, industries, and operational systems to create models that account for varying business rules, exceptions, and data requirements. Your work will help support increasingly sophisticated use cases, including real-time visibility into routes, shipments, stops, and the freight or items associated with them.</span></p><p style="margin:0in;font-size:15px;font-family:Carlito;"><br></p><p style="margin:0in;font-size:15px;font-family:Carlito;"><span style='font-family:"Calibri",sans-serif;'>Working within Lanter's Azure data environment, you'll also develop and support ETL/ELT pipelines, write advanced SQL queries, and enable reporting through BI tools. As a senior technical contributor, you'll be a go-to resource for complex BI and data modeling work, helping ensure solutions are scalable, reliable, and aligned with evolving business needs.</span></p><p style="margin:0in;font-size:15px;font-family:Carlito;"><br></p><p style="margin:0in;font-size:15px;font-family:Carlito;"><strong><span style='font-family:"Calibri",sans-serif;'>Essential Duties and Key Deliverables:</span></strong></p><div style="margin:0in;font-size:15px;font-family:Carlito;"><ul style="margin-bottom:0in;list-style-type: disc;margin-left: 0in;"><li style="margin:0in;font-size:15px;font-family:Carlito;"><span style='font-family:"Calibri",sans-serif;'>Design scalable enterprise data models that integrate complex data from multiple operational systems into consistent, reusable structures for analytics and reporting.</span></li><li style="margin:0in;font-size:15px;font-family:Carlito;"><span style='font-family:"Calibri",sans-serif;'>Translate business needs into data models and reporting-ready datasets that account for varying business rules, data quality, source-system complexities, and use cases such as real-time operational visibility.</span></li><li style="margin:0in;font-size:15px;font-family:Carlito;"><span style='font-family:"Calibri",sans-serif;'>Build, enhance, and support ETL/ELT processes within the Azure data environment.</span></li><li style="margin:0in;font-size:15px;font-family:Carlito;"><span style='font-family:"Calibri",sans-serif;'>Develop and optimize SQL queries, datasets, and BI reporting solutions that enable accurate, timely business analysis.</span></li><li style="margin:0in;font-size:15px;font-family:Carlito;"><span style='font-family:"Calibri",sans-serif;'>Partner with business and technical stakeholders to translate analytics and reporting needs into scalable data solutions.</span></li><li style="margin:0in;font-size:15px;font-family:Carlito;"><span style='font-family:"Calibri",sans-serif;'>Support data warehouse and BI initiatives tied to pharmaceutical requirements, the Descartes implementation, AI-related data needs, and other strategic priorities.</span></li></ul></div><p style="margin:0in;font-size:15px;font-family:Carlito;"><br></p><p style="margin:0in;font-size:15px;font-family:Carlito;"><strong><span style='font-family:"Calibri",sans-serif;'>Required Experience and Skills:</span></strong></p><div style="margin:0in;font-size:15px;font-family:Carlito;"><ul style="margin-bottom:0in;list-style-type: disc;margin-left: 0in;"><li style="margin:0in;font-size:15px;font-family:Carlito;"><span style='font-family:"Calibri",sans-serif;'>5+ years of progressive experience in business intelligence engineering, data engineering, analytics engineering, or a related data role.</span></li><li style="margin:0in;font-size:15px;font-family:Carlito;"><span style='font-family:"Calibri",sans-serif;'>Deep hands-on data modeling experience, including designing integrated enterprise and/or dimensional models, establishing entities and relationships, determining grain and business rules, and reconciling differing source-system requirements.</span></li><li style="margin:0in;font-size:15px;font-family:Carlito;"><span style='font-family:"Calibri",sans-serif;'>Advanced SQL and strong ETL/ELT experience working with data from multiple operational systems.</span></li><li style="margin:0in;font-size:15px;font-family:Carlito;"><span style='font-family:"Calibri",sans-serif;'>Hands-on experience with modern cloud-based data platforms and data lakes; experience with Databricks on Azure and Azure Data Lake is strongly preferred, with comparable cloud data platform experience considered transferable.</span></li><li style="margin:0in;font-size:15px;font-family:Carlito;"><span style='font-family:"Calibri",sans-serif;'>Experience translating complex or ambiguous business and reporting requirements into scalable, maintainable data solutions.</span></li><li style="margin:0in;font-size:15px;font-family:Carlito;"><span style='font-family:"Calibri",sans-serif;'>Experience developing or supporting BI and reporting solutions using Sigma, Power BI, or a comparable platform.</span></li><li style="margin:0in;font-size:15px;font-family:Carlito;"><span style='font-family:"Calibri",sans-serif;'>Strong analytical, problem-solving, communication, and cross-functional collaboration skills, with the ability to independently own complex work.</span></li></ul></div><p style="margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:.5in;text-indent:0in;font-size:15px;font-family:Carlito;"><br></p><p style="margin:0in;font-size:15px;font-family:Carlito;"><strong><span style='font-family:"Calibri",sans-serif;'>Preferred Experience:</span></strong></p><div style="margin:0in;font-size:15px;font-family:Carlito;"><ul style="margin-bottom:0in;list-style-type: disc;margin-left: 0in;"><li style="margin:0in;font-size:15px;font-family:Carlito;"><span style='font-family:"Calibri",sans-serif;'>Experience in logistics, transportation, supply chain, or other environments with complex operational data.</span></li><li style="margin:0in;font-size:15px;font-family:Carlito;"><span style='font-family:"Calibri",sans-serif;'>Experience with Descartes or similar transportation/logistics technology platforms.</span></li><li style="margin:0in;font-size:15px;font-family:Carlito;"><span style='font-family:"Calibri",sans-serif;'>Experience supporting AI or advanced analytics data initiatives.</span></li></ul></div><p style="margin:0in;font-size:15px;font-family:Carlito;"><br></p><p style="margin:0in;font-size:15px;font-family:Carlito;"><strong><span style='font-family:"Calibri",sans-serif;'>Supervisory Responsibilities:</span></strong></p><p style="margin:0in;font-size:15px;font-family:Carlito;"><span style='font-family:"Calibri",sans-serif;'>This position has no direct supervisory responsibilities; however, the Senior BI Engineer is expected to provide technical guidance, review work, and serve as a go-to resource for complex BI engineering and data modeling needs.</span></p><p style="margin:0in;font-size:15px;font-family:Carlito;"><br></p><h1 style="margin-top:8.55pt;margin-right:0in;margin-bottom:.0001pt;margin-left:19.65pt;font-size:16px;font-family:Carlito;margin:0in;"><span style='font-size:15px;font-family:"Calibri",sans-serif;'>Position Type:</span></h1><p style="margin:0in;font-size:15px;font-family:Carlito;"><span style='font-family:"Calibri",sans-serif;'>This is a full-time, remote position, with a preference for candidates who can work from our St. Louis, Missouri headquarters.</span></p><p style="margin:0in;font-size:15px;font-family:Carlito;"><br></p><h1 style="margin-top:8.55pt;margin-right:0in;margin-bottom:.0001pt;margin-left:19.65pt;font-size:16px;font-family:Carlito;margin:0in;"><span style='font-size:15px;font-family:"Calibri",sans-serif;'>Travel:</span></h1><p style="margin:0in;font-size:15px;font-family:Carlito;"><span style='font-family:"Calibri",sans-serif;'>Travel may be required periodically for company meetings, training, or other business needs.</span></p><p style="margin:0in;font-size:15px;font-family:Carlito;"><br></p><p style="margin:0in;font-size:15px;font-family:Carlito;"><strong><span style='font-family:"Calibri",sans-serif;'>Work Environment:</span></strong></p><p style="margin:0in;font-size:15px;font-family:Carlito;"><span style='font-family:"Calibri",sans-serif;'>This job is performed in a professional remote or office environment. The role routinely uses standard office equipment such as computers, phones, and other job-related technology or systems. The team member may be required to sit for extended periods of time while working at a computer and communicating with internal and external business partners.</span></p><p style="margin:0in;font-size:15px;font-family:Carlito;"><br></p><p style='margin-top:.25in;margin-right:0in;margin-bottom:4.0pt;margin-left:0in;font-size:32px;font-family:"Georgia",serif;color:#666666;font-style:italic;margin:0in;'><strong><span style='font-size:15px;font-family:"Calibri",sans-serif;color:windowtext;font-style:normal;'>Physical Demands:</span></strong></p><p style="margin:0in;font-size:15px;font-family:Carlito;"><span style='font-family:"Calibri",sans-serif;'>The team member is regularly required to listen, communicate verbally and in writing, sit for extended periods of time, use a computer and other office equipment, and occasionally lift up to 15 pounds at a time.</span></p><p style="margin:0in;font-size:15px;font-family:Carlito;"><br></p><p style='margin-top:.25in;margin-right:0in;margin-bottom:4.0pt;margin-left:0in;font-size:32px;font-family:"Georgia",serif;color:#666666;font-style:italic;margin:0in;'><strong><span style='font-size:15px;font-family:"Calibri",sans-serif;color:windowtext;font-style:normal;'>Other Duties:</span></strong></p><h1 style="margin-top:8.55pt;margin-right:0in;margin-bottom:.0001pt;margin-left:19.65pt;font-size:16px;font-family:Carlito;margin:0in;"><span style='font-size:15px;font-family:"Calibri",sans-serif;font-weight:normal;'>This job description is not designed to cover a comprehensive listing of activities, duties, or responsibilities required of the team member for this job. Duties, responsibilities, and activities may vary by location based on business needs and may change at any time with or without notice.</span></h1><h1 style="margin-top:0in;margin-right:0in;margin-bottom:.0001pt;margin-left:9.0pt;font-size:16px;font-family:Carlito;"><br></h1><h1 style="margin-top:8.55pt;margin-right:0in;margin-bottom:.0001pt;margin-left:19.65pt;font-size:16px;font-family:Carlito;margin:0in;"><span style='font-size:15px;font-family:"Calibri",sans-serif;'>EEO Statement:</span></h1><p style="margin:0in;font-size:15px;font-family:Carlito;margin-right:12.95pt;border:none;"><span style='font-family:"Calibri",sans-serif;'>Lanter Delivery Systems provides equal employment opportunities (EEO) to all team members and applicants for employment without regard to race, color, religion, sex, national origin, age, disability, or genetics. In addition to federal law requirements, Lanter Delivery Systems complies with applicable state and local laws governing nondiscrimination in employment in every location in which the company has facilities. This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation, and training. Lanter Delivery Systems expressly prohibits any form of workplace harassment based on race, color, religion, gender, sexual orientation, gender identity or expression, national origin, age, genetic information, disability, or veteran status. Improper interference with the ability of Lanter Delivery Systems team members to perform their job duties may result in discipline up to and including discharge.</span></p></div>
Apply Now