American Dining Creations
Join to apply for the
Data and BI Engineer
role at
American Dining Creations American Dining Creations provided pay range: $110,000.00/yr - $120,000.00/yr Job 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. Responsibilities
Design, build, and optimize robust ETL pipelines to ingest, transform, and load data from diverse sources. 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 and intuitive 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 technical architectures, infrastructure components, 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 various AI and ML 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. Familiarity with Agile/Scrum methodology. Familiarity with AI/Machine Learning and Advanced analytics is a plus. Strong communication, problem-solving and collaboration skills. Ability to manage multiple priorities simultaneously. Knowledge of data governance, security, and compliance best practices. 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. American Food & Vending and American Dining Creations strongly focus on service, technology, partnerships, and hospitality, which is evident in everything we do. American Food & Vending Offers
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.
#J-18808-Ljbffr
Data and BI Engineer
role at
American Dining Creations American Dining Creations provided pay range: $110,000.00/yr - $120,000.00/yr Job 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. Responsibilities
Design, build, and optimize robust ETL pipelines to ingest, transform, and load data from diverse sources. 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 and intuitive 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 technical architectures, infrastructure components, 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 various AI and ML 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. Familiarity with Agile/Scrum methodology. Familiarity with AI/Machine Learning and Advanced analytics is a plus. Strong communication, problem-solving and collaboration skills. Ability to manage multiple priorities simultaneously. Knowledge of data governance, security, and compliance best practices. 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. American Food & Vending and American Dining Creations strongly focus on service, technology, partnerships, and hospitality, which is evident in everything we do. American Food & Vending Offers
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.
#J-18808-Ljbffr