Senior BI Engineer
About The Position
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. 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.
Requirements
- 5+ years of progressive experience in business intelligence engineering, data engineering, analytics engineering, or a related data role.
- 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.
- Advanced SQL and strong ETL/ELT experience working with data from multiple operational systems.
- 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.
- Experience translating complex or ambiguous business and reporting requirements into scalable, maintainable data solutions.
- Experience developing or supporting BI and reporting solutions using Sigma, Power BI, or a comparable platform.
- Strong analytical, problem-solving, communication, and cross-functional collaboration skills, with the ability to independently own complex work.
Nice To Haves
- Experience in logistics, transportation, supply chain, or other environments with complex operational data.
- Experience with Descartes or similar transportation/logistics technology platforms.
- Experience supporting AI or advanced analytics data initiatives.
Responsibilities
- Design scalable enterprise data models that integrate complex data from multiple operational systems into consistent, reusable structures for analytics and reporting.
- 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.
- Build, enhance, and support ETL/ELT processes within the Azure data environment.
- Develop and optimize SQL queries, datasets, and BI reporting solutions that enable accurate, timely business analysis.
- Partner with business and technical stakeholders to translate analytics and reporting needs into scalable data solutions.
- Support data warehouse and BI initiatives tied to pharmaceutical requirements, the Descartes implementation, AI-related data needs, and other strategic priorities.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Senior
Education Level
No Education Listed
