> Markdown version of [/jobs/ext/3110219-data-warehouse-and-business-intelligence-architect](https://www.wearedevelopers.com/jobs/ext/3110219-data-warehouse-and-business-intelligence-architect). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Data Warehouse and Business Intelligence Architect - **Company:** Jersey Mike's - **Location:** United States - **Experience:** Experienced - **Contract:** Franchise - **Skills:** Microsoft Excel, Application Programming Interfaces (APIs), Microsoft Azure, Business Intelligence Development, Software as a Service, Information Systems, Continuous Delivery, Continuous Integration, Data Architecture, Information Engineering, Data Governance, Data Integration, Extract Transform Load (ETL), Data Security, Dataspaces, Data Systems, Data Warehousing, Dimensional Modeling, Document-Oriented Databases, JSON, Python (Programming Language), Meta-Data Management, Performance Tuning, Power BI, Standard Sql, SQL Databases, Transact-SQL, Parquet, Data Processing, Azure Data Factory, Data Strategy, Git, Microsoft Fabric, Data Lakes, Pyspark, Information Technology, Data Analytics, Restful APIs, Azure Synapse Analytics, Webhooks, Software Version Control, Data Pipelines - **Published:** September 27, 2026 - **Apply:** https://www.thejobnetwork.com/job/0a49fcd1-3e5e-44f1-b315-5c23a306d749/dwbi-architect ## About the Role * 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. ## Description 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., 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. ## Related Videos - [Parquet, Delta, Iceberg & Ducklake - An introduction for developers](https://www.wearedevelopers.com/videos/100075-parquet-delta-iceberg-ducklake-an-introduction-for-developers) - [Modern Data Architectures need Software Engineering](https://www.wearedevelopers.com/videos/1030-modern-data-architectures-need-software-engineering) - [Tips and Tricks for Working with JSON](https://www.wearedevelopers.com/videos/1229-tips-and-tricks-for-working-with-json) - [How a Small Team Shrank a Microsoft Monorepo by 94%](https://www.wearedevelopers.com/videos/1236-how-a-small-team-shrank-a-microsoft-monorepo-by-94) - [Enjoying SQL data pipelines with dbt](https://www.wearedevelopers.com/videos/823-enjoying-sql-data-pipelines-with-dbt) - [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works) ## Related Articles - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [How We Built a Worry-Free System That Runs for 10+ Years – And What We’d Do Again](https://www.wearedevelopers.com/magazine/751-how-we-built-a-worry-free-system-that-runs-for-10-years-and-what-we-d-do-again) - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers) - [Top Big Data Technologies That You Need to Know](https://www.wearedevelopers.com/magazine/108-top-big-data-technologies-that-you-need-to-know) - [Coffee with Developers - Maria Apazoglou - Making AI understandable for all in production](https://www.wearedevelopers.com/magazine/475-coffee-with-developers-maria-apazoglou-making-ai-understandable-for-all-in-production) - [Everything a Developer Needs to Know About MCP with Neo4j](https://www.wearedevelopers.com/magazine/604-everything-a-developer-needs-to-know-about-mcp-with-neo4j)