Data Architect

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

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

Requirements

• 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, enterprise data architecture or related disciplines is required.
• Experience documenting and communicating technical architecture decisions and recommendations is required.
• Experience working 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.
• Experience designing data models for operational reporting, business intelligence, and KPI Frameworks and analytics solutions is preferred.
• Experience supporting AI, machine learning, Copilot, or advanced analytics initiatives is preferred.
• Criminal background checks and drug/alcohol checks are required.
• Must be able to work in the United States; organization participates in E-Verify.

Core Competencies

Demonstrates expertise in enterprise data architecture, including the design and implementation of data models, integration solutions, and governance practices. Proficient in SQL, Microsoft Fabric, and Azure technologies to support scalable data platforms and advanced analytics initiatives.

Highest-signal resume keywords

• Enterprise Data Architecture
• SQL Proficiency
• Microsoft Fabric
• Data Governance Frameworks
• Data Modeling

ATS Optimization Keywords

Hard Skills

• Data Architecture
• Data Modeling
• Database Design
• Data Integration
• SQL
• Data Governance
• Data Warehousing
• Data Lakes
• ETL Processes
• Performance Tuning

Soft Skills

• Communication
• Collaboration
• Documentation

Certifications & Qualifications

• Microsoft Data Certifications
• Certified Data Management Professional
• Azure Data Engineer
• Azure Data Fundamentals

Industry Keywords

• DAMA-DMBOK Principles
• Data Governance
• Enterprise Data Management
• Compliance
• Data Quality

Tools & Technologies

• Microsoft Fabric
• Azure SQL
• SQL Server
• Data Factory
• Cloud Platforms