American Food & Vending
Overview
Data & BI Engineer role at American Food & Vending. This position combines responsibilities across data engineering, ETL development, business intelligence and data analysis. The ideal candidate will have hands-on experience with ETL pipelines, BI tools, cloud platforms, Python, and Snowflake, and will be responsible for designing, developing, and maintaining scalable data solutions that support analytics and business decision-making. They will collaborate closely with cross-functional teams to ensure the availability, reliability, and performance of our data systems and solutions. Base pay range
$110,000.00/yr - $120,000.00/yr Summary
We are seeking a highly skilled and versatile Data & BI Engineer to join our data-driven team. This role combines responsibilities across data engineering, ETL development, business intelligence and data analysis. The ideal candidate will have hands-on experience with ETL pipelines, BI tools, cloud platforms, Python, and Snowflake, and will be responsible for designing, developing, and maintaining scalable data solutions that support analytics and business decision-making. They will collaborate closely with cross-functional teams to ensure the availability, reliability, and performance of our data systems and solutions. Responsibilities
Design, build, and optimize robust ETL pipelines to ingest, transform, and load data from diverse sources (Structured and Unstructured). Build and maintain integrations with internal and external data sources and APIs. Develop and maintain data models, schemas, and metadata for analytical and operational use. Implement data validation, testing, cleansing, and quality checks to ensure data integrity. Work with orchestration tools for workflow automation and monitoring data pipeline operation. Design and develop user-friendly visualizations/dashboards to communicate insights effectively using Power BI or similar BI tools. Collaborate with stakeholders to gather requirements and translate them into BI solutions. Monitor and troubleshoot BI and ETL processes to ensure performance and reliability. Provide insights through data visualization and performance metrics. Work with cloud platforms such as Azure for data storage and processing. Utilize Snowflake for data warehousing; write complex SQL queries and stored procedures for data extraction, transformation, and loading processes. Implement CI/CD pipelines and version control using tools like Git or Azure DevOps. Document technical designs, workflows, and best practices to facilitate knowledge sharing and maintain system documentation. Qualifications
3+ years of relevant experience with detailed knowledge of data warehouse architectures, ETL tools, and BI/analytic tools. 2+ years of experience with BI tools such as Power BI, Tableau, or QlikView. Hands-on experience with Snowflake, including Snowpipe, Streams, Stored Procedures and related features. Strong analytical skills with the ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy. Strong understanding of database technologies, management systems, and data modeling techniques. Proficiency in Python. Strong SQL skills and experience with relational and cloud databases. Familiarity with cloud technology and Agile/Scrum methodology. Knowledge of data governance, security, and compliance best practices. Strong communication, problem solving and collaboration skills; ability to manage multiple priorities. Familiarity with AI/Machine Learning and advanced analytics is a plus. Education
Bachelor’s or master's degree in computer science, Information Systems, Business Analytics or related field. About Us
American Food & Vending began vending operations in Ithaca, NY, over eighty years ago and has become one of the largest privately held hospitality service partners in the United States. As a family-owned boutique company, we have evolved into a dining and catering service provider. Our services include café dining, mobile ordering, catering, events, grab-and-go programs, vending and refreshment solutions, advanced micro markets, coffee services, pantry services, and more. We are committed to enhancing the guest experience and partnering with our communities to provide outstanding service, innovation, sustainability, and customization. We offer weekly pay, 401K with company match, employee referral and assistance programs, and eligible medical/dental/vision plans. Benefits
Weekly Pay 401K with company match Employee Referral Bonus Program Employee Assistance Program Eligible employees offered Medical, Prescription, Dental, and Vision Plans American Food & Vending is an Equal Opportunity Employer. Chat with Scout, our virtual hiring assistant to apply for this position right from your mobile device. Text JOB to 315-803-6049 to get started! Seniority level
Mid-Senior level Employment type
Full-time Job function
Business Development and Sales Industries: Hospitality We are not responsible for other listings; study the job details above for accurate information.
#J-18808-Ljbffr
Data & BI Engineer role at American Food & Vending. This position combines responsibilities across data engineering, ETL development, business intelligence and data analysis. The ideal candidate will have hands-on experience with ETL pipelines, BI tools, cloud platforms, Python, and Snowflake, and will be responsible for designing, developing, and maintaining scalable data solutions that support analytics and business decision-making. They will collaborate closely with cross-functional teams to ensure the availability, reliability, and performance of our data systems and solutions. Base pay range
$110,000.00/yr - $120,000.00/yr Summary
We are seeking a highly skilled and versatile Data & BI Engineer to join our data-driven team. This role combines responsibilities across data engineering, ETL development, business intelligence and data analysis. The ideal candidate will have hands-on experience with ETL pipelines, BI tools, cloud platforms, Python, and Snowflake, and will be responsible for designing, developing, and maintaining scalable data solutions that support analytics and business decision-making. They will collaborate closely with cross-functional teams to ensure the availability, reliability, and performance of our data systems and solutions. Responsibilities
Design, build, and optimize robust ETL pipelines to ingest, transform, and load data from diverse sources (Structured and Unstructured). Build and maintain integrations with internal and external data sources and APIs. Develop and maintain data models, schemas, and metadata for analytical and operational use. Implement data validation, testing, cleansing, and quality checks to ensure data integrity. Work with orchestration tools for workflow automation and monitoring data pipeline operation. Design and develop user-friendly visualizations/dashboards to communicate insights effectively using Power BI or similar BI tools. Collaborate with stakeholders to gather requirements and translate them into BI solutions. Monitor and troubleshoot BI and ETL processes to ensure performance and reliability. Provide insights through data visualization and performance metrics. Work with cloud platforms such as Azure for data storage and processing. Utilize Snowflake for data warehousing; write complex SQL queries and stored procedures for data extraction, transformation, and loading processes. Implement CI/CD pipelines and version control using tools like Git or Azure DevOps. Document technical designs, workflows, and best practices to facilitate knowledge sharing and maintain system documentation. Qualifications
3+ years of relevant experience with detailed knowledge of data warehouse architectures, ETL tools, and BI/analytic tools. 2+ years of experience with BI tools such as Power BI, Tableau, or QlikView. Hands-on experience with Snowflake, including Snowpipe, Streams, Stored Procedures and related features. Strong analytical skills with the ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy. Strong understanding of database technologies, management systems, and data modeling techniques. Proficiency in Python. Strong SQL skills and experience with relational and cloud databases. Familiarity with cloud technology and Agile/Scrum methodology. Knowledge of data governance, security, and compliance best practices. Strong communication, problem solving and collaboration skills; ability to manage multiple priorities. Familiarity with AI/Machine Learning and advanced analytics is a plus. Education
Bachelor’s or master's degree in computer science, Information Systems, Business Analytics or related field. About Us
American Food & Vending began vending operations in Ithaca, NY, over eighty years ago and has become one of the largest privately held hospitality service partners in the United States. As a family-owned boutique company, we have evolved into a dining and catering service provider. Our services include café dining, mobile ordering, catering, events, grab-and-go programs, vending and refreshment solutions, advanced micro markets, coffee services, pantry services, and more. We are committed to enhancing the guest experience and partnering with our communities to provide outstanding service, innovation, sustainability, and customization. We offer weekly pay, 401K with company match, employee referral and assistance programs, and eligible medical/dental/vision plans. Benefits
Weekly Pay 401K with company match Employee Referral Bonus Program Employee Assistance Program Eligible employees offered Medical, Prescription, Dental, and Vision Plans American Food & Vending is an Equal Opportunity Employer. Chat with Scout, our virtual hiring assistant to apply for this position right from your mobile device. Text JOB to 315-803-6049 to get started! Seniority level
Mid-Senior level Employment type
Full-time Job function
Business Development and Sales Industries: Hospitality We are not responsible for other listings; study the job details above for accurate information.
#J-18808-Ljbffr