Our Company Lancer Worldwide, a Hoshizaki Company, is an award-winning global leader in beverage dispensing. Through innovation and a commitment to dedication in action, we create products that benefit our customers worldwide, and give them a distinct advantage in the marketplace. We offer our teammates the opportunity to grow personally and professionally, to contribute to the success of a dynamic organization, and to serve others in a manner that exceeds their expectations. We welcome talented, passionate, and highly motivated individuals to join our team.

Summary/Objective The Data Engineer will lead the design, development, and implementation of a modern business intelligence framework using Microsoft Azure technologies. This role is responsible for building scalable ETL pipelines, integrating data from multiple sources, and enabling data-driven decision-making across the organization. The ideal candidate will have deep expertise in Azure Synapse Analytics and/or Microsoft Fabric and will play a key role in shaping the company's BI strategy. This position requires strong technical, analytical, and communication skills, and reports to the Software Development Manager.

Key Performance Indicators • BI Adoption Rate: Track user engagement and utilization of BI tools across departments. • Project Efficiency and Timeliness: Measure the ability to lead, plan, develop, implement, and administer BI software within the set timelines and budget. • Solution Usability and Performance: Evaluate the usability, performance, and scalability of the implemented BI solutions. • Compliance and Standards: Maintain adherence to development, data governance and audit standards. • Collaboration and Communication: Assess the effectiveness of collaboration with business managers, other analysts, support areas, and vendors.

Essential Functions • Architect and build a comprehensive BI strategy aligned with business goals. • Design, develop, and maintain ETL/ELT pipelines using Azure Data Factory, Synapse Pipelines, or Microsoft Fabric Dataflows. • Architect and implement data models, lake houses, and warehouses in Azure Synapse, Microsoft Fabric, or on-premises systems. • Develop and maintain Power BI datasets, reports, and dashboards, ensuring performance and usability. • Lead the implementation of data governance, security, and compliance practices across BI systems. • Drive the adoption of DevOps and CI/CD practices for data engineering workflows. • Ensure data quality, lineage, and documentation across all data assets. • Support data migration, transformation, and integration efforts across legacy and modern systems. • Collaborate with business stakeholders to gather requirements and insights and translate them into scalable BI solutions. • Provide technical leadership and mentorship to team members and cross-functional collaborators. • Participate in strategic planning for BI initiatives and contribute to the overall data strategy. • Provide off-hours support and assist with special projects as needed.

Knowledge, Skills & Abilities

Technical Expertise: • Proficiency in Azure Synapse Analytics, Microsoft Fabric, Azure Data Factory, and Power BI. • Strong SQL skills and experience with T-SQL, DAX, MDX, and Python. • Familiarity with Delta Lake, Parquet, and data Lakehouse architecture. • Experience with Azure Data Lake Storage Gen2, Azure SQL, and Dataverse is a plus. • Experience integrating with JSON APIs and working with SSIS.

Strategic Thinking: • Ability to design BI solutions aligned with business goals and long-term scalability. • Experience defining and implementing BI governance frameworks.

Collaboration & Communication: • Strong interpersonal and communication skills to work with technical and non-technical stakeholders, including Operations, Engineering, Sales, and Accounting. • Spanish proficiency preferred.

Problem-Solving & Initiative: • Self-starter with the ability to troubleshoot, document, and resolve data issues independently. • Passion for continuous learning and innovation in data technologies.

Project & Time Management: • Ability to manage multiple priorities and deliver high-quality work under tight deadlines. • Experience leading or contributing to Agile/Scrum-based projects is a plus.

Education & Experience • Bachelor's degree in business, Computer Science, or a related field. • Minimum 3 years of experience in architecting and developing data analytics solutions. • Proven experience with advanced data modeling, ETL development and BI software (Power BI). • Proficiency in SQL, Python, MDX, DAX, and JSON API integrations. • Experience with Microsoft Azure tools (Synapse, Fabric, SSIS). • Strong cross-functional communication skills (Operations, Engineering, Sales, Accounting).

Education & Experience • Bachelor's degree in Information Technology, Computer Science, or a related field, or equivalent experience. • Minimum 5 years of experience in IT systems engineering, with a focus on hybrid infrastructure and cloud technologies. • Certifications: Microsoft Azure Fundamentals, Microsoft Certified Professional (MCP), Security+.

Work Environment While performing the duties of this job, the employee is exposed to typical office environment with some exposure to manufacturing site operations. The noise level in the work environment is usually moderate.

Physical Demands The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. This includes the requirement to type quickly and write, to talk, and hear, and to listen and process information, then utilize it to provide employees and customers with desired information. The employee is frequently required to sit, walk, stand, and reach.

Notice To Third Party Agencies Please note that LANCER does not accept unsolicited resumes from recruiters or employment agencies. In the absence of a signed Recruitment Fee Agreement, LANCER will not consider or agree to payment of any referral compensation or recruiter fee. In the event a recruiter or agency submits a resume or candidate without a previously signed agreement, LANCER explicitly reserves the right to pursue and hire those candidate(s) without any financial obligation to the recruiter or agency. Any unsolicited resumes, including those submitted to hiring managers, are deemed to be the property of LANCER.

EEO Statement Lancer provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws. 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.

TBD