Senior Data & Analytics Engineer

About the role

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.

Responsibilities

• 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