Senior DWBI Architect — Azure Fabric & Lakehouse

Energy Jobline ZR; Eatontown (NJ); On-site; USD 130,000 - 180,000; Full time

Job summary

Jersey Mike’s is seeking a Data Warehouse and BI Architect to lead the design and implementation of an enterprise data platform on Microsoft Fabric (Azure). You will architect data warehouses, models, and pipelines and collaborate with Finance, Operations, Supply Chain, and Marketing to deliver actionable insights.

The role requires hands-on experience with Fabric/Azure Synapse, SQL, Python, data modeling, and data governance.

Qualifications

• Bachelor’s degree in Computer Science, Information Systems, or related field.
• 7+ years of experience in data engineering, data architecture, or BI development, including 2+ years with Microsoft Fabric or Azure Synapse.
• 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).
• Strong understanding of data governance, metadata management, and data security.

Responsibilities

• 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, 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.

Skills

7+ years data engineering/architecture

SQL (T-SQL) and Python/PySpark

CI/CD using Git / Azure DevOps

Data governance and security

Strong analytical & communication

Education

Bachelor’s degree in Computer Science, Information Systems, or related field

Master’s degree

Tools

Power BI

Azure Data Factory / Fabric Pipelines

OneLake

Lakehouse

Delta Lake / Parquet optimization

Job description

Jersey Mike’s is seeking a Data Warehouse and BI Architect to lead the design and implementation of an enterprise data platform on Microsoft Fabric (Azure). You will architect data warehouses, models, and pipelines and collaborate with Finance, Operations, Supply Chain, and Marketing to deliver actionable insights.

The role requires hands-on experience with Fabric/Azure Synapse, SQL, Python, data modeling, and data governance.