Business Intelligence (BI) Engineer

Job Description

Village Super Market Is Hiring: Business Intelligence (BI) Engineer role open

Build trusted data products that help retail leaders make faster, smarter decisions.

About Village Super Market:

For more than 80 years, Village Super Market has served communities throughout the tri-state area with a commitment to quality, service, and care. As a growing, entrepreneurial organization, we combine our proud history with forward-thinking strategies that protect our people, strengthen our operations, and position the company for continued success. 

About the Role:

The Business Intelligence (BI) Engineer will support NY Fairway & GG Leadership by delivering trusted data, reporting, and analytics solutions that enhance operational visibility and enable informed business decisions. This role will design and develop scalable processes to ingest, integrate, and transform data from SAP ERP, retail enterprise systems, SaaS applications, APIs, and other operational platforms into analytics-ready datasets within Google BigQuery.

The BI Engineer will also play a key role in advancing self-service analytics and reporting through ThoughtSpot, ensuring business leaders and stakeholders have access to reliable, actionable insights. The ideal candidate brings strong SQL and Python development skills, along with hands-on experience in cloud data engineering, API integrations, dimensional data modeling, and modern data warehousing practices.

What You’ll Do:

\n
• Design, build, and maintain scalable batch and streaming data pipelines that bring information from SAP ERP, SaaS applications, REST APIs, on-premises databases, and other enterprise systems into Google Cloud.
\n
• Develop automated Python- and SQL-based ELT/ETL workflows that transform source data into reliable, analytics-ready datasets in Google Cloud Storage and BigQuery.
\n
• Create and optimize BigQuery staging, curated, semantic, and dimensional data models, using partitioning, clustering, and cost-efficient query design to improve performance.
\n
• Build trusted datasets and semantic structures for ThoughtSpot, dashboards, enterprise reporting, self-service analytics, and downstream AI initiatives.
\n
• Partner with Fairway Market and Gourmet Garage leadership and teams across Retail, Merchandising, Finance, Loss Prevention, Operations, and IT to translate business needs into scalable data and analytics solutions.
\n
• Automate workflow orchestration, monitoring, alerting, and recurring data processes using GCP-native services such as BigQuery Scheduler, Cloud Functions, Cloud Tasks, and Cloud Composer.
\n
• Strengthen data quality and governance by validating calculations and reporting outputs, monitoring data consistency, maintaining technical documentation, and supporting metadata and enterprise data standards.
\n

What You Bring:

\n
• Bachelor’s degree in Accounting, Finance, Data Engineering, Computer Science, or equivalent professional experience.
\n
• At least five years of experience in BI development or data engineering.
\n
• Advanced SQL skills, including complex joins, aggregations, window functions, common table expressions, and query optimization.
\n
• Hands-on Python experience for API ingestion, scripting, automation, and data processing.
\n
• Experience building ETL/ELT pipelines, REST API integrations, JSON-based ingestion, and dimensional data models.
\n
• Practical experience with Google Cloud Platform, BigQuery, and Google Cloud Storage.
\n
• Strong communication and collaboration skills, with the ability to connect technical solutions to business outcomes.
\n

Preferred Experience:

\n
• ThoughtSpot, Tableau, Power BI, MicroStrategy, or comparable enterprise BI platforms.
\n
• Retail data, SAP ERP ingestion, ThoughtSpot Data Modeler, or BigQuery Data Transfer Service.
\n
• Cloud Functions, Cloud Tasks, Cloud Composer/Airflow, Dataflow, or Data Fusion.
\n
• Medallion architecture, CI/CD for data pipelines, or a Google Cloud certification such as Professional Data Engineer
\n

Why Join Village Super Market?

\n
• A family-led culture centered on people, growth, and development.
\n
• A highly visible leadership role with a direct impact on customer trust, associate safety, regulatory compliance, and operational performance.
\n
• An entrepreneurial environment that values collaboration, innovation, accountability, and practical solutions.
\n
• Career-growth opportunities across multiple banners and business functions.
\n
• Competitive compensation, comprehensive benefits, and professional-development opportunities.
\n

Ready to Make an Impact?

If you enjoy solving complex data challenges, building dependable cloud solutions, and helping business teams act on trusted insights, we encourage you to apply.

Village Super Market, Inc. is an equal opportunity employer. We welcome applicants from all backgrounds and are committed to an inclusive workplace.

Salary Range: $101,000 - $116,000