American Dining Creations · 23 hours ago
Data and BI Engineer
New York, United States
Full-time
Onsite
Mid Level
$110K/yr - $120K/yr
3+ years expAmerican Dining Creations is a family-owned boutique company providing dining and catering services across the United States. They are seeking a highly skilled Data & BI Engineer to design, develop, and maintain scalable data solutions that support analytics and business decision-making, while collaborating with cross-functional teams to ensure the performance of their data systems.
Hospitality
No H1B
U.S. Citizen Only
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 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
Qualification
Required
Must be a US Citizen
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
Strong communication, problem solving and collaboration skills
Ability to manage multiple priorities simultaneously
Knowledge of data governance, security, and compliance best practices
Bachelor's or master's degree in computer science, Information Systems, Business Analytics or related field
Preferred
Familiarity with AI/Machine Learning and Advanced analytics is plus
Benefits
Weekly Pay
401K with company match
Employee Referral Bonus Program
Employee Assistance Program
Eligible employees offered Medical, Prescription, Dental, and Vision Plans
Company
American Dining Creations
At American Dining Creations, our culinary innovation and creativity have won us numerous awards, recognizing us as one of the nation’s premier food service companies.
1001-5000 employees
Funding
Current Stage
Late StageCompany data provided by crunchbase