Data Architect

IES Holdings, Inc. • Sugar Land, TX

15d

About The Position

IES is building its enterprise data platform on Microsoft Fabric from the ground up — and we’re looking for the architect who will own it. This is a rare greenfield mandate to design the models, pipelines, and governance that turn source-system data into a single, trusted source of truth powering reporting and analytics across a large, multi-entity, growth-by-acquisition organization.
You’ll set the direction — how data is ingested, stored, modeled, secured, and consumed — with the autonomy to shape the platform end to end, external engineering partners to direct from day one, and a clear runway to build a team around you over time. If you want to own an enterprise data platform rather than inherit one, this is that role.

Requirements

• Deep, hands-on Microsoft Fabric experience (OneLake, Lakehouse/Warehouse, pipelines) — or a strong Azure Synapse / Databricks background with Azure SQL that transfers, and the ability to own Fabric quickly.
• 8+ years in data architecture, data engineering, or database administration, including designing enterprise data platforms.
• Expert-level SQL and strong database administration (performance tuning, security, backup/recovery, monitoring) across relational and cloud databases.
• Proven data modeling (dimensional and normalized) and ETL/ELT pipeline design.
• Hands-on experience establishing and monitoring data governance and master data management programs.
• Strong command of data quality, lineage, cataloging, and security/access controls.
• Communication — the ability to translate data concepts for both technical and business audiences.
• Bachelor’s degree in Computer Science, Information Systems, Data/Analytics, Engineering, or a related field — or equivalent practical experience.

Nice To Haves

• Microsoft Fabric certification (DP-600 Fabric Analytics Engineer, DP-700) or DP-300 (Azure Database Administrator).
• Experience integrating ERP source data (D365 F&O, Spectrum, Sage) into an analytics platform.
• Power BI semantic modeling and self-service analytics enablement.
• MDM tooling and data catalog/governance platforms (e.g., Microsoft Purview).
• Exposure to multi-entity, multi-segment enterprise environments and finance data domains.

Responsibilities

• Own the target-state architecture for the enterprise data platform on Microsoft Fabric — OneLake, Lakehouse/Warehouse, pipelines, and semantic models.
• Define the layered (medallion) architecture and the storage and compute patterns that balance scalability, performance, and cost.
• Set standards for ingesting data from source systems (e.g., D365 F&O, Spectrum, Sage) and for downstream consumption in Power BI.
• Guide platform adoption, sequencing, and licensing decisions as the estate matures.
• Design logical and physical data models — dimensional, normalized, and semantic — balancing performance, flexibility, and business usability.
• Architect and review data pipelines (ETL/ELT), transformations, and orchestration for reliability and maintainability, and direct engineering partners delivering them.
• Apply expert SQL and database administration — performance tuning, indexing, security, backup/recovery, and monitoring — across relational and cloud data stores, hands-on when the work calls for it.
• Establish data quality, reconciliation, and observability practices, monitoring pipeline health and driving remediation.
• Define and monitor the data governance program — ownership and stewardship, cataloging, lineage, classification, and access controls.
• Establish and monitor master data management (MDM) across key domains (e.g., customer, vendor, item, finance/GL), including matching, survivorship, and stewardship workflows.
• Track and report governance and MDM metrics — data quality, adoption, and compliance — to leadership, and partner with security and compliance on privacy, retention, and controls.
• Set and enforce data architecture standards, review key designs, and mentor data engineers and analysts.
• Advise leadership on data strategy, roadmap, trade-offs, and risk.

Benefits

• Competitive Pay
• Company 401K plan with Employer Contribution Match
• Company Paid Time Off
• Company Paid Life Insurance
• Choice of Medical Coverage including Prescription and Short Term Disability Plans
• Choice of Dental and Vision Coverage
• Optional Long-term Disability, Critical Illness, Accident, Legal and Pet Coverage
• Auto and Home Insurance Discount Programs

What This Job Offers

• Job Type: Full-time
• Career Level: Senior