DWBI Architect

JERSEY MIKES FRANCHISE SYSTEMS LLC; Tinton Falls (NJ); Sur place; USD 150 000 - 180 000; Plein temps

Résumé du poste

Jersey Mike’s is seeking a DWBI Architect in Tinton Falls, NJ to design and implement a modern data platform using Microsoft Fabric. You will collaborate with Finance, Operations, and Marketing to deliver scalable data solutions and actionable insights.

The role requires 7+ years in data engineering/architecture, strong SQL/Python skills, and experience with Fabric/Azure data services. This is a full-time on-site position with competitive compensation.

Qualifications

• Bachelor’s degree in CS, IS, or related field; master’s preferred.
• 7+ years in data engineering/architecture; 2+ years with Fabrics/Azure.
• Proven data warehouse, dimensional modeling, ETL/ELT experience.
• SQL (T-SQL) and Python/PySpark for data processing.
• Experience with Power BI and Fabric/Azure data services.
• REST APIs, webhooks, and partner data integration.
• Delta Lake, Parquet optimization, and data governance.
• CI/CD for data solutions using Git/Azure DevOps.
• Strong communication and ability to work independently.

Responsabilités

• Design end-to-end data architecture using Microsoft Fabric.
• Build data models and scalable data warehouse to support analytics.
• Develop data pipelines from multiple sources (files, APIs, SaaS).
• Ensure data quality, security, and compliance with Purview.
• Document standards and CI/CD promotion workflows.
• Improve reliability, cost efficiency, and governance.
• Collaborate with Finance, Operations, Supply Chain, Marketing.

Connaissances

Microsoft Fabric

Azure Synapse

SQL (T-SQL)

Python/PySpark

Data modeling

ETL/ELT pipelines

Power BI

REST APIs

Delta Lake

Dimensional modeling

CI/CD

Data governance

Azure DevOps

OneLake

Lakehouse

Formation

Bachelor's degree in CS/IS

Master’s degree preferred

Outils

Power BI

Azure Data Factory

Fabric Pipelines

OneLake

Delta Lake

Azure DevOps

Description du poste

If you are unable to complete this application due to a disability, contact this employer to ask for an accommodation or an alternative application process.

DWBI Architect

Full-Time Tinton Falls, NJ, US

8 days ago Requisition ID: 1009

Salary Range: $150,000.00 To $180,000.00 Annually

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 integrationto 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.