Senior Data & Analytics Engineer

The Senior Data & Analytics Engineer supports the continued development and reliability of Lanter’s enterprise data platform. Working within an Azure and Databricks environment, this position builds and enhances data pipelines, integrates new data sources, develops reporting-ready datasets, and implements automated testing to protect the integrity of production ETL/ELT processes. This hands-on role works across data engineering, analytics, data modeling, governance, and reporting. The position partners with business and technical stakeholders to translate complex requirements into accurate, scalable, and understandable data solutions. Essential Duties and Key Deliverables:

• Build and operate ETL/ELT pipelines using Databricks, SQL, Python, Spark/PySpark, and Azure Data Lake.
• Develop an integrated enterprise gold-layer model spanning source systems, customers, and operating companies.
• Build dimensional serving-layer and data-mart models with deliberate decisions regarding grain, keys, conformed dimensions, historical data, and slowly changing dimensions.
• Implement automated regression testing using defined inputs and expected outputs to validate pipelines and transformations.
• Own orchestration, observability, performance, failure diagnosis, replay and recovery, root-cause fixes, and cost management for assigned production solutions.
• Partner with stakeholders to reconcile business definitions and establish data requirements, rules, ownership, and governance standards.
• Apply disciplined engineering practices, including Git, code review, reusable components, automated testing, controlled deployments, and technical documentation.
• Develop analytics and reporting solutions using Sigma, Power BI, or comparable platforms.
• Support strategic data initiatives across Lanter’s business units and industry verticals, including AI, operational visibility, and analytics enablement.
• Independently own deliverables and provide technical guidance on complex data and analytics needs., This position has no direct supervisory responsibilities but is expected to provide technical guidance and serve as a resource for complex data and analytics needs., Travel may be required periodically for company meetings, training, or other business needs. Work Environment: 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.

Physical Demands: 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.

Other Duties

• 5+ years of experience in data engineering, analytics engineering, BI engineering, or a related field.
• Strong, recent, hands-on experience developing production pipelines with Python and Spark/PySpark.
• Advanced SQL skills and hands-on experience with Databricks, Azure Data Lake, and Azure DevOps or comparable technologies.
• Experience designing integrated enterprise models and dimensional data marts, including grain, keys, conformed dimensions, history, and slowly changing dimensions.
• Experience implementing automated testing, regression testing, data-quality controls, and pipeline validation.
• Experience operating production data solutions, including monitoring, optimization, troubleshooting, recovery, and cost management.
• Experience with Git, code review, CI/CD, reusable development practices, and technical documentation.
• Ability to translate complex business requirements into scalable data and analytics solutions.
• Strong communication, collaboration, problem-solving, and independent ownership skills.

Preferred Experience:

• Experience in logistics, transportation, supply chain, or another operationally complex environment.
• Experience supporting data governance, AI, or advanced analytics initiatives., This is a full-time, remote position. Proximity to Lanter’s St. Louis headquarters is preferred but not required, and there is no regular onsite work requirement.

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. The ideal candidate will embody our company’s Non-Negotiables: * Walk in Humble Confidence - We are experts at what we do, but we never assume we know everything

• Be Open, Honest and Respectful - We say what has to be said in a tactful, courteous way
• Be Fearless - We never fail, we only learn
• We are One Team - We achieve more together by collaboration and consensus
• Delivery on Commitments - We do what we say we will do
• We have a Passion to Serve - We are dedicated, hardworking individuals who provide exceptional service to our customers and to each other
• We put Safety First - We prioritize the safety of our team members and customers above all else in our business
• We Strive for Operational Excellence - We are dedicated to a culture of continuous improvements, driving quality and productivity