Avatar for Jersey Mike's Subs
Serves fresh sliced subs and Philly cheesesteaks

Data Warehouse & Business Intelligence Architect

Posted: 3 weeks ago
Hires remotely in
Remote Work Policy

Remote only

Company Location
Manasquan
Visa Sponsorship

Not Available

RelocationAllowed
Skills
Python
SQL
Git
Data Models
Security
T-SQL
Data Security
REST APIs
Compliance
Version Control
Data Governance
Data Modeling
Data Quality
Webhooks
Metadata Management
Power BI
Azure Data Factory
Azure DevOps
Data Warehouses
Purview
Azure Synapse
Azure Data Services
Microsoft Fabric
ETL/ELT Pipelines
OneLake
Dimensional Models
Lakehouse Architecture
Fabric Pipelines
Naming Conventions
Data Architecture Standards
Cross-Departmental Planning
Medallion Architecture (Bronze/Silver/Gold)
Dimensional Modeling (Kimball)
Schema Definitions
Architecture Design Sessions
Promotion Workflows
Integrating Data from Multiple Source Systems (using Flat Files, APIs, on-Prem, and S
Microsoft Fabric Capabilities (OneLake, Lakehouse, Warehouse, Pipelines, Dataflows Ge
Data Integration to Extract and Transform Data from Multiple Systems Including Flat F
Folder Structure
CI/CD Via Azure DevOps
Continuous Improvement in Data Platform Reliability, Cost Efficiency, and Governance
Data Strategy Reviews
Python/PySpark for Data Processing and Automation
Partner Data
Delta Lake / Parquet Optimization (Z-Ordering, Partitioning, Compaction)
CI/CD for Data Solutions

About the job

Company Description

Jersey Mike’s is a fast-casual sub sandwich franchise with over 3,300 locations nationwide, offering fresh sliced subs, grilled-to-order and freshly baked bread. Established in 1956, the company is committed to providing delicious food made with premium ingredients and giving back to the communities it serves. Jersey Mike’s was ranked #1 in 2026 America’s top franchises by Entrepreneur Magazine and earned recognition in Nation’s Restaurant News, highlighting its rapid growth and dedication. With a history of philanthropy, the brand gives back through initiatives like its Annual Day of Giving and has raised millions for local charities. Jersey Mike’s is driven by its commitment to quality, community, and making a difference.

Position Summary

The Data Warehouse and Business Intelligence Architect will play a key role in designing and implementing Jersey Mike’s enterprise data platform CDO (Central Data Office) on Microsoft Fabric (Azure). This individual will collaborate closely with business, analyst, and IT teams to architect and deliver modern data solutions that enable actionable insights across Finance, Operations, Supply Chain, Business Development, and Marketing.

The Architect will be responsible for building the foundational data warehouse, data engineering, data pipelines, and data models that power our analytics ecosystem. The ideal candidate will have a strong technical background in Microsoft Fabric, Azure Data Services, SQL, Python, and data modeling, with hands-on experience integrating data from multiple source systems (using flat files, APIs, on-prem, and SaaS). This position reports directly to the Director of Data & Analytics.

Key Responsibilities

Responsibilities include, but are not limited to, the following (other responsibilities may be assigned as needed to support business growth):

  • Design end to end data architecture leveraging Microsoft Fabric capabilities (OneLake, Lakehouse, Warehouse, Pipelines, Dataflows Gen2)
  • Design robust data models, schema definitions and ensure the data warehouse can support complex analytical workloads.
  • Develop and maintain data integration to extract and transform data from multiple systems including flat files (CSV, Excel, JSON), APIs, partner data feeds, and third-party SaaS platforms.
  • Ensure data quality, security, and compliance across all datasets, implementing Purview for lineage, classification, and access control.
  • Establish and document data architecture standards, including folder structure, naming conventions, version control, CI/CD via Azure DevOps, and promotion workflows.
  • Drive continuous improvement in data platform reliability, cost efficiency, and governance through automation and monitoring.
  • Participate in data strategy reviews, architecture design sessions, and cross-departmental planning.

Qualifications

  • Bachelor’s degree in Computer Science, Information Systems, or related field; Master’s preferred.
  • 7+ years of experience in data engineering, data architecture, or BI development, including 2+ years with Microsoft Fabric or Azure Synapse.
  • Proven experience designing data warehouses, dimensional models, and ETL/ELT pipelines.
  • Proficient in SQL (T-SQL) and Python/PySpark for data processing and automation.
  • Experience with Power BI, Azure Data Factory or Fabric Pipelines, OneLake, and Lakehouse architecture.
  • Experience integrating REST APIs, webhooks, and partner data.
  • Experience with Delta Lake / Parquet optimization (Z-ordering, partitioning, compaction)
  • Experience of Dimensional modeling (Kimball) and medallion architecture (bronze/silver/gold).
  • Strong understanding of data governance, metadata management, and data security.
  • Hands-on experience implementing CI/CD for data solutions using Git / Azure DevOps.
  • Strong analytical, problem-solving, and communication skills.
  • Self-starter with ability to work independently and manage multiple priorities.

Preferred Skills:

  • Experience in retail or QSR (Quick Service Restaurant) data ecosystems is a plus
  • Experience with dbt, Purview, and Power BI performance tuning.
  • Excellent documentation and stakeholder communication skills.

Jersey Mike’s is an equal employment opportunity employer. Applicants who need reasonable accommodations due to disability to assist with the application process should contact the Human Resource Department.

About the company

Jersey Mike's Subs company logo
Serves fresh sliced subs and Philly cheesesteaks5000+ Employees
Company Location
Manasquan
Company Size
5000+
Learn more about Jersey Mike's Subs image

Funding

AMOUNT RAISED
$8B
FUNDED OVER
1 round
Round
S
$8000000000
Seed - Nov 2024