Sign up to access all features of our service.
  • Job search
  • Favorites
  • Create a CV
    New
  • Salaries
  • Subscriptions

Onsite_Data Architect- MS Fabric_

Themesoft Inc

Job Title: Data Architect - MS Fabric
Location: Columbus, IN
Duration: 6-12+ months
Contract


Role Summary


Seeking a Data Modeling Architect to define and implement the enterprise modeling framework for an advanced data fabric architecture. This role translates business capabilities, domain concepts, and source-system structures into governed conceptual, logical, physical, and semantic models.
The architect establishes reusable data contracts and canonical definitions that support interoperability, discoverability, trusted data products, and analytics across Microsoft Fabric and connected enterprise platforms. The role requires strong data modeling expertise and hands-on implementation experience with Microsoft Fabric, including OneLake, Lakehouse, Warehouse, Data Pipelines, and Power BI semantic models.
The architect works directly with business domain owners and the Data Team to align models with enterprise architecture standards, operational processes, and measurable business outcomes.


Key Responsibilities


Enterprise Ontology and Domain Modeling
Define an enterprise ontology and domain taxonomies that establish consistent business terminology, entity definitions, relationships, and business rules across functional domains.
Develop conceptual and logical models that capture domain boundaries, shared entities, reference data, cardinality, hierarchies, and cross-domain relationships.
Select appropriate modeling patterns, including normalized entity-relationship models, dimensional models, Data Vault, and canonical data models, based on integration and consumption requirements.
Define authoritative sources, system-of-record relationships, data ownership, and master and reference data alignment for shared business entities.
Data Fabric and Physical Implementation
Design physical models for Microsoft Fabric Lakehouse and Warehouse workloads, including Delta table structures, partitioning strategies, keys, schema evolution, and query-performance considerations.
Design and govern open table-format implementations using Apache Iceberg, Apache Hudi, and Delta Lake across lakehouse workloads.
Select the appropriate table format based on interoperability, transaction requirements, ingestion patterns, query-engine compatibility, performance, cost, governance requirements, and operational supportability.
Define physical table-design standards for partitioning, clustering or data layout, compaction, file sizing, retention, schema evolution, partition evolution, and metadata management.
Establish patterns for ACID transactions, snapshot isolation, time travel, rollback, auditability, and reproducible data consumption across curated data products.
Define incremental-processing patterns using change data capture, merge and upsert operations, deletes, deduplication, slowly changing dimensions, and late-arriving data handling.
Define table-maintenance and optimization processes, including compaction, small-file remediation, orphan-file cleanup, snapshot expiration, retention controls, and performance monitoring.
Define interoperable data product schemas and data contracts to support governed exchange across ingestion, transformation, serving, and consumption layers.
Design source-to-target mappings and transformation specifications for ERP, CRM, operational systems, APIs, and other enterprise data sources.
Apply bronze, silver, and gold layer patterns while defining fit-for-purpose data products and reusable integration assets across OneLake, Lakehouse, and Warehouse.
Work with engineering teams to implement batch and near-real-time integration patterns, including incremental ingestion, change data capture, and event-driven data flows where appropriate.
Define standards for schema versioning, backward compatibility, and model lifecycle management as source systems and business requirements evolve.
Establish cross-platform interoperability standards for data products consumed through Microsoft Fabric, Databricks, Snowflake, Spark, Trino, and compatible query engines.
Semantic Layer, Metadata, and Governance
Design governed Power BI and Fabric semantic models with conformed dimensions, consistent measures, calculation logic, and business-friendly terminology.
Establish metadata requirements for business glossaries, technical catalogs, lineage, classifications, ownership, and policy enforcement using Microsoft Purview or equivalent capabilities.
Align models with data quality rules, validation controls, observability requirements, and master data management practices.
Maintain traceability from business concepts and data contracts through source-to-target mappings, physical assets, and semantic models.
Partner with security teams to account for role-based access, sensitivity labels, and appropriate data access controls in model design.
Business Partnership and Team Standards
Facilitate working sessions with business stakeholders, domain owners, architects, and delivery teams to validate definitions, resolve cross-domain conflicts, and document design decisions.
Provide architectural guidance and design reviews for data engineering, analytics, and integration initiatives across TMHNA.
Contribute to work standardization across the Data Team by defining modeling conventions, reusable templates, review checklists, repository practices, and implementation patterns.
Establish shared standards for open table formats, including table-format selection criteria, metadata governance, lifecycle management, and migration approaches.
Mentor architects, engineers, and analysts on domain modeling, semantic consistency, data contracts, open table formats, and Microsoft Fabric design practices.


Required Qualifications


10 or more years of experience in data architecture or data engineering, including at least four years of hands-on conceptual, logical, and physical data modeling.
Experience defining enterprise ontologies, domain models, shared business vocabularies, and governed semantic models.
Hands-on experience with Microsoft Fabric, including OneLake, Lakehouse, Warehouse, Data Pipelines, Dataflows Gen2, and semantic models, or comparable experience with Microsoft data platforms such as Synapse, Azure Data Factory, and Azure SQL.
Strong knowledge of entity-relationship modeling, dimensional and star-schema modeling, Data Vault, and canonical modeling patterns.
Experience defining data contracts, source-to-target mappings, schema evolution rules, and integration specifications across heterogeneous platforms.
Hands-on experience designing, implementing, or governing lakehouse tables using at least one of Apache Iceberg, Apache Hudi, or Delta Lake, with working knowledge of the other formats and their architectural tradeoffs.
Strong understanding of open table-format capabilities, including ACID transactions, snapshots, time travel, schema evolution, partition evolution, metadata files, file management, and concurrent read and write behavior.
Experience designing incremental data-processing patterns, including change data capture, merge and upsert logic, deduplication, deletes, late-arriving data, and slowly changing dimensions.
Experience establishing operational standards for table maintenance, including compaction, clustering or layout optimization, file sizing, retention, cleanup processes, and snapshot management.
Knowledge of how table formats interact with distributed compute and query engines such as Spark, Microsoft Fabric, Databricks, Snowflake, Trino, or equivalent platforms.
Ability to evaluate table-format selection based on workload type, streaming versus batch ingestion, cross-engine access, governance requirements, performance, cost, and operational complexity.
Practical experience with Delta Lake, medallion architecture, and lakehouse data design.
Knowledge of metadata management, business glossaries, technical lineage, data catalogs, and policy-driven governance.
Experience with data modeling tools such as erwin, ER/Studio, SQLDBM, Lucidchart, or equivalent tools.
Ability to explain architectural decisions and tradeoffs to business and technical stakeholders and drive alignment across domains.
Experience developing shared modeling standards, conducting design reviews, and working across concurrent enterprise initiatives.




Tools and Technologies
Data fabric architecture
Data products, data contracts, domain-oriented design, metadata-driven integration, interoperability, lineage, policy enforcement, cross-engine data access
Microsoft Fabric
OneLake, Lakehouse, Warehouse, Data Pipelines, Dataflows Gen2, semantic models, workspace and capacity concepts
Open table formats
Apache Iceberg, Apache Hudi, Delta Lake, ACID transactions, snapshots, time travel, rollback, schema evolution, partition evolution, compaction, retention, file lifecycle management
Lakehouse engineering
Delta tables, Parquet, table metadata, transaction logs, manifest files, merge and upsert patterns, change data capture, slowly changing dimensions, incremental processing
Modeling
Enterprise ontology, domain and canonical models, entity-relationship modeling, dimensional modeling, Data Vault, schema evolution
Integration and engineering
Azure Data Factory, Synapse, Spark, Databricks, Snowflake, APIs, change data capture, event-driven integration, batch and near-real-time processing
Analytics and semantic layer
Power BI, DAX, conformed dimensions, governed measures, Tableau
Governance and security
Microsoft Purview, business glossary, data catalog, lineage, Entra ID, role-based access control, sensitivity labels, table ownership, schema versioning, quality controls, observability, retention policies
Cloud platform
Microsoft Azure




Work Authorization
Applicants must be legally authorized to work in the United States.


Equal Employment Opportunity
Themesoft Inc is an Equal Employment Opportunity employer. We consider qualified applicants without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability, veteran status, or any other status protected by applicable federal, state, or local law.


Vacancy posted 22 days ago
Similar jobs that could be interesting for youBased on the Onsite_Data Architect- MS Fabric_ in Columbus, OH vacancy
  • $132.23k - $176.31k

     ...the AI‑powered world, connecting people, data, and applications through our expansive fiber...  ...The Senior Lead Marketing Data Platform Architect is responsible for defining, governing, and...  ...: AL AR AZ FL GA IA ID IN KS KY LA ME MO MS MT ND NE NM OH OK PA SC SD TN UT VT WI WV... 
    Suggested
    Full time
    Temporary work

    Lumen

    Columbus, OH
    12 hours ago
  • $85.9k - $108.8k

     ...life,” so if this speaks to you, let’s connect! At CESO, a Data Architect is responsible for designing, implementing, and maintaining the...  ...lakehouse, warehouse, and data pipeline solutions using Microsoft Fabric, SQL, and Azure technologies. Work with business... 
    Suggested
    Temporary work
    Casual work
    Flexible hours

    CESO, Inc.

    Columbus, OH
    1 day ago
  • $20.91 - $45.04 per hour

     ...and sensor solutions enable the distribution of power, signal and data to advance next-generation transportation, renewable energy,...  ...or GED Are currently enrolled in, or pursuing, a BA/BS or MA/MS Degree in Business Analytics , Data Analytics or Data Science from... 
    Suggested
    Remote job
    Work experience placement
    Summer work
    Internship
    Local area

    TE Connectivity

    Columbus, OH
    1 day ago
  • We Are:The beginning of a new Data & AI decade that will reshape work and society has begun. Accenture is stepping...  ...and Power Ecosystem. You Are:You are a data/senior data architect who designs enterprise data fabric solutions that provide unified, intelligent, automated... 
    Suggested
    Work experience placement
    Live in
    Work at office
    Local area

    Accenture

    Columbus, OH
    3 days ago
  •  ...Title Quality Data Analyst - ONSITE ID Job Locations US-NJ-Newark Category Healthcare Professionals Type Regular...  ...exploratory data analysis and database management a must. Expertise in MS Office required and experience with statistical software... 
    Suggested
    Full time
    Remote work

    University Hospital, Newark NJ

    Delaware, OH
    4 days ago
  • TP Mechanical in Columbus, OH is hiring a Fabrication Mechanical Construction Supervisor to oversee day-to-day shop and field operations,...  ...ensuring safety, on-time delivery, and adherence to design specs for data center and industrial projects. You will lead fabricators,... 

    TP Mechanical

    Columbus, OH
    12 hours ago
  • $41 - $58 per hour

     ...ArchitectJob Description\nThe Project Architect will lead and participate in...  ..., consultants, contractors, fabricators, and regulatory agencies to...  ...with mission critical, data center, industrial, healthcare...  ...Workplace Type\nThis is a fully onsite position in Columbus,OH.\... 
    Contract work
    Temporary work
    For contractors
    Work at office

    Actalent

    Westerville, OH
    55 minutes ago
  • $110k - $155k

     ...Overview Are you looking for a highly rewarding opportunity that provides extensive career growth opportunity? Gilbane is seeking a Data Architect to provide strategic and technical leadership in the design, evaluation, and governance of enterprise technology capabilities.... 
    For contractors
    Work at office
    Remote work

    Gilbane Building Company

    Columbus, OH
    4 days ago
  •  ...Data Solution Analyst Location: Columbus, Ohio (Hybrid- 2 Days onsite - Local Candidates Highly Preferred) Duration: 6-12 Months Plus As a Data Solution Analyst, you’ll translate functional data and analytic requirements into solutions for consumption and use by... 
    Local area

    GlobalPoint

    Columbus, OH
    17 hours ago
  • $41 - $58 per hour

     ...Job Title: Project Architect Job Description The Project Architect...  ..., consultants, contractors, fabricators, and regulatory agencies to...  ...Experience with mission critical, data center, industrial,...  ...Workplace Type This is a fully onsite position in Columbus,OH. About... 
    Contract work
    Temporary work
    For contractors
    Work at office

    Actalent

    Columbus, OH
    1 hour ago
  • $105,000 per day

     ...more secure future. The Storage Architect provides advanced technical...  ...zoning, iSCSI, FCoE, unified fabric, HBAs/CNAs, storage controllers...  ...Solutions Architect ExpertHitachi Data Systems Qualified Professional...  ...: Must be able to work onsite full-time at one of the following... 
    Full time
    Immediate start

    AGE solutions

    Columbus, OH
    12 hours ago
  •  ...DescriptionJob DescriptionData ArchitectWe are seeking a seasoned Data Architect to design, evaluate, and guide modern data architectures...  ...Strong experience with Azure data tools (e.g., Azure Data Factory, Fabric, Synapse, Databricks, ADLS).• Proven ability to evaluate and... 

    Proteam Solutions

    Dublin, OH
    4 days ago
  •  ...career with us is a journey, not a destination. This could be the next best step in your technical career. Join us. As a Lead Architect for Data products at Corporate Oversight and Governance Technology (COGT) with in the Corporate technology LOB, youare an integral... 

    Testing Site - JPMC

    Columbus, OH
    2 days ago
  •  ...AnnuallyIndustry Banking;Financial ServicesSelling Points Lead impactful data architecture initiatives in a hybrid work environment. Drive...  ...and enable scalable data solutions.Job DescriptionSenior Data Architect OverviewThe Senior Data Architect will define and implement... 

    Green Key Resources

    Columbus, OH
    2 days ago
  •  ...Data Architect (AWS, Azure, GCP) CapTech is a team of master builders, creators, and problem solvers who help clients grow efficient, successful...  ...their individual needs. Employees must be available to work onsite in a client location or a CapTech office as requested. We... 
    Work at office
    Remote work
    Visa sponsorship
    Work visa
    Flexible hours

    CapTech Consulting

    Columbus, OH
    4 days ago
  •  ...extraordinary, Hexion is where you belong. Anything is possible when you imagine everything.Position OverviewThe Principal Industrial AI Data Architect is responsible for designing and governing the data architecture that enables reliable, scalable AI across industrial... 
    Remote work
    Worldwide

    Hexion

    Columbus, OH
    2 days ago
  •  ...Bellevue, PA0738 Processing Center Job Description A Senior Data Governance Analyst is a key member of the Data Governance...  ...projects, methodologies (connect and collect, hub and spoke, data fabrics, etc.) and leading commercial vendors that relate to data acquisition... 
    Full time
    Work experience placement
    Casual work
    Work at office
    Shift work

    Northwest Bank

    Columbus, OH
    17 hours ago
  • Job Description Job Description Role Summary Senior leader responsible for Oracle EBS Supply Chain solution strategy, architecture, implementation, transformation and support engagements across global enterprises. Key Responsibilities Lead Oracle EBS Supply...

    The Dignify Solutions, LLC

    Columbus, OH
    23 days ago
  •  ...a list that spans across the country.Job DescriptionCapTech Data Architects match our clients’ business goals with available technologies...  ...their individual needs. Employees must be available to work onsite in a client location or a CapTech office as requested. We allow... 
    Work at office
    Remote work
    Visa sponsorship
    Work visa
    Flexible hours

    CapTech

    Columbus, OH
    1 day ago
  •  ...power of change to create value and shared success for our clients, people, shareholders, partners, and communities.You Are:A senior data architecture leader with deep experience in enterprise data platforms, insurance data ecosystems, and policy administration... 
    Work experience placement
    Live in
    Work at office
    Local area

    Accenture

    Columbus, OH
    3 days ago
  •  ...Engineering, and Talent, with advanced capabilities in AI and Data, Industry and Process, and Technology. We serve approximately 9...  ...are a cross-Financial Services skilled senior Data 360 and AI Architect within Accenture’s Financial Services Salesforce Business Group... 
    Work experience placement
    Live in
    Work at office
    Local area

    Accenture

    Columbus, OH
    1 day ago
  • $124k - $280k

     ...ServicesSpecialismData, Analytics & AIManagement LevelSenior ManagerJob Description & SummaryThe Opportunity As a Applied AI Health Data Architect you will shape data architecture solutions that support health services provider clients, bringing together data engineering,... 
    Full time
    H1b

    PwC

    Columbus, OH
    2 days ago
  • $70k - $115k

     ...Senior Business Data AnalystThe Sr Business Data Analyst role has a national salary range of $70,000 - $115,000. For roles within California...  ...cross-functional projects, requiredMust be able to work fully onsite if role based out of a warehouse, requiredOur Organization is an... 

    Deutsche Post Und Dhl

    Columbus, OH
    18 hours ago
  •  ...Pricing Data Analyst The Pricing Data Analyst owns how Rogue prices its products. Partnering across Finance, Sales, Procurement,...  ...question through to solution. The Pricing Data Analyst is a fully onsite role in Columbus, Ohio. Remote work is not available. Applicants... 
    Work at office
    Remote work
    Shift work

    Rogue

    Columbus, OH
    4 days ago
  •  ...Data Solution ArchitectVertiv is building a modern, AI-ready data ecosystem that powers analytics, domain data products, and digital...  .... As part of this journey, we are seeking a Data Solution Architect who is highly hands-on and execution-focused, responsible for translating... 

    Vertiv Holdings

    Columbus, OH
    17 hours ago
  •  ...real robot problems as well-defined ML problems, train models on data that a fleet of production robotic cells generates every day, and...  ...robotic cells, with low-latency inference and monitoring.Who You AreAn MS or PhD in Computer Science, Robotics, Machine Learning, or a... 

    Path Robotics

    Columbus, OH
    4 hours ago
  •  ...Indianapolis, IN Metro (Hybrid / 3-Day Onsite) (Open to Regional/EST Candidates with Onsite...  ...startups on high-impact projects across Data, AI, Cloud, and Software Engineering. Our...  ..., computational biologists, and software architects to translate operational friction into... 
    Full time
    Contract work
    For contractors
    3 days per week

    Xenon7

    Columbus, OH
    3 days ago
  •  ...premier environmental engineering firm, is seeking a mid-level Architect to lead design efforts in our Midwest Region and support the needs...  ...in Autodesk Revit BIM software, AutoCAD, Rendering software, MS Word, Excel, and PowerPoint What We Offer: Comprehensive health... 
    Temporary work
    For contractors
    Immediate start
    Flexible hours

    Hazen and Sawyer

    Columbus, OH
    12 hours ago
  • $90.8k - $136.2k

     ...hold up in the real world. ~ Experience with query languages and data analysis; familiarity with SQL, MongoDB querying, Amplitude,...  ...Wellbeing: Health (Medical & Prescription), Dental, and Vision Care, Onsite Health Centers (MO & IL), Employee Assistance Program, Wellness... 
    Full time
    Flexible hours
    Shift work

    World Wide Technology

    Columbus, OH
    2 days ago
  • $77.2k - $115.8k

     ...ensuring the smooth operation of hardware, software, networks, and data systems, while providing top-notch technical support to...  ...employees: Health and Wellbeing: Health, Dental, and Vision Care, Onsite Health Centers, Employee Assistance Program, Wellness program... 
    Full time
    Remote work
    Shift work

    World Wide Technology

    Columbus, OH
    4 days ago

Do you want to receive more vacancies?

Subscribe and receive similar vacancies to Onsite_Data Architect- MS Fabric_. Be the first to apply!