Data Architect

Medieval Times Dinner & Tournament is North America’s leading dinner attraction. Medieval Times employs over 2,000 enthusiastic, team members throughout North America and Canada. Medieval Times is an exciting entertainment & dining experience with 10 locations entertaining millions of visitors each year. We are looking for a Data Architect to join our corporate team in Irving, Texas!

The Data Architect is responsible for leading the enterprise-wide data architecture strategy, enterprise reporting, and business intelligence initiatives. This role collaborates with technical business partners and cross-functional teams to understand business requirements and architect, integrate, implement, and support enterprise systems using Microsoft technologies including SQL Server, Microsoft Fabric, Power Platform, and Dynamics Business Central.

• Design and develop reports and dashboards using Power BI (including Paginated Reports).
• Manage Microsoft SQL Server environments including performance tuning, query optimization, and data integration using Azure Functions and Azure Data Factory.
• Architect and maintain data warehouses and data lakes using Azure Data Factory, Azure SQL Database, Azure Data Lake Storage (ADLS), and Microsoft Fabric.
• Lead deployment readiness of SQL-based reporting solutions, including build, test, and release of Power BI reports, SSRS reports, and SQL scripts using Azure Dev Ops and CI/CD pipelines.
• Collaborate with system administrators and application owners to ensure enterprise data platforms (e.g., Microsoft SQL Server, SSRS, Dynamics 365 Business Central, Microsoft CRM, Active Directory, Entra ) are properly configured, integrated, and optimized to support data architecture and analytics initiatives.
• Ensure compliance with Microsoft security standards and data governance policies, and GDPR and PCI Security Council guidelines.

Programming & Development: Proficient in SQL, T-SQL, DAX, M Query, Power Shell, C#, VBScript, XML, Excel formulas.

Data & BI Tools: Power BI (including DAX Studio, datasets, and server configuration), Power BI Report Builder, SSRS, SSAS (Tabular and OLAP), Power Automate, Logic Apps, Azure Functions, Azure Data Factory.

Systems & Platforms: Microsoft Fabric, Azure, Microsoft SQL Server, Windows Server, Entra/AD, Microsoft Exchange, SharePoint, Dynamics Business Central, Microsoft CRM, familiarity with Microsoft-based Retail/Payment Solutions and PCI compliance.

Language

Skills:

Ability to read technical documentation, navigate Microsoft Learn, Git Hub repos, product manuals; interpret feature guides, release notes; write clear reports, documentation, and business correspondence; deliver effective verbal communication to all organization levels.

Mathematical

Skills:

Proficiency in performing financial & quantitative calculations, discounts, interest, commissions, proportions, percentages; applying concepts to real-world scenarios.

Reasoning Ability: Strong problem-solving skills analyzing and resolving practical issues; interpreting and executing instructions in various formats (written, verbal, diagrams, schedules).

Bachelor’s degree in computer science, Information Systems, Mathematics, or a related field, or a minimum of three years of relevant work experience in data management or analytics. Minimum of two years of experience working with Microsoft SQL Server, including writing queries and managing databases. At least two years of experience implementing and configuring Microsoft enterprise applications such as Reporting Services, Power BI, or comparable reporting systems.

Strong understanding of reporting and analytics using Power BI, SSRS, or other Microsoft reporting tools is required. Familiarity with Azure Data Services (e.g., Azure SQL, Azure Data Factory, Microsoft Fabric) is preferred but not required. Experience with Power Platform tools (Power BI, Power Automate, Power Apps) is a plus.

Medieval Times offers a competitive package with full benefits including Medical, Dental, Vision, STD, 401(k) with company match, show discounts, and more!