Enterprise Data Architect: Azure, Fabric & Lakehouse

Jobtailor; Columbus (OH); On-site; USD 120,000 - 150,000; Full time

Job summary

Jobtailor in Columbus, OH, seeks an experienced Data Architect to develop and maintain enterprise data architecture standards and models. You will design scalable data structures, APIs, and integration solutions, partnering with engineers on lakehouse and warehouse initiatives using Microsoft Fabric, SQL, and Azure technologies.

The role requires strong SQL, data modeling, governance knowledge, and the ability to translate business requirements into robust data designs.

Qualifications

• Bachelor's degree in Computer Science, Information Systems, Data Management, Engineering, or equivalent experience is required.
• Minimum of 5 years of experience in data architecture, data engineering, database administration, analytics engineering, or related disciplines is required.
• Experience documenting and communicating technical architecture decisions and recommendations is required.
• Experience with Microsoft Fabric, SQL Server, Azure SQL, data warehouses, data lakes, Data Factory or lakehouse architectures is required.
• Proficiency in SQL and working with relational and analytical data structures is required.
• Strong understanding of data architecture principles, data modeling, database design, and integration patterns is required.
• Knowledge of DAMA-DMBOK principles, data governance frameworks, and enterprise data management best practices is required.
• Understanding of security, access controls, privacy requirements, and compliance considerations related to enterprise data is required.
• Master's degree is preferred.
• Experience supporting cloud modernization, digital transformation, or enterprise data platform initiatives is preferred.
• Microsoft Fabric, Azure Data Engineer, Azure Data Fundamentals, or related certifications are preferred.
• Relevant certifications such as Certified Data Management Professional, Microsoft data certifications, or similar, are preferred.

Responsibilities

• Develop, implement, and maintain enterprise data architecture standards, frameworks, design patterns, and best practices.
• Develop and maintain logical, physical, dimensional, and semantic data models.
• Design enterprise database architectures, backend data structures, and scalable schema designs.
• Design and oversee enterprise data integration solutions, including APIs, ELT/ETL processes, cloud platforms, and reporting environments.
• Partner with Data Engineers on lakehouse, warehouse, and data pipeline solutions using Microsoft Fabric, SQL, and Azure technologies.
• Translate business requirements into technical data designs.
• Assist with enterprise data governance and compliance practices, including data quality, ownership, stewardship, classification, and retention.
• Provide architectural guidance on database optimization, indexing, partitioning, and performance tuning.
• Review data solutions for architecture, security, and business alignment; maintain documentation, data catalogs, and lineage information.
• Design data platform architectures supporting disaster recovery, backup, business continuity, and high availability.
• Support AI-ready data platforms for advanced analytics, machine learning, automation, and future AI initiatives.
• Evaluate data-related opportunities and communicate recommendations to relevant organizational parties.
• Collaborate with technical and non-technical stakeholders to gather requirements, align priorities, and deliver enterprise data solutions.
• Perform other duties as assigned.

Skills

SQL Proficiency

Data Modeling

Data Architecture

Data Governance

Communication

Education

Bachelor's degree in CS/IS/Data Management

Master's degree (preferred)

Tools

Microsoft Fabric

Azure SQL

SQL Server

Data Factory

Job description

Jobtailor in Columbus, OH, seeks an experienced Data Architect to develop and maintain enterprise data architecture standards and models. You will design scalable data structures, APIs, and integration solutions, partnering with engineers on lakehouse and warehouse initiatives using Microsoft Fabric, SQL, and Azure technologies.

The role requires strong SQL, data modeling, governance knowledge, and the ability to translate business requirements into robust data designs.