Data Architect

General Job Description

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.

WHAT YOU’LL OWN

Platform & Architecture (Microsoft Fabric)

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

Data Engineering, Modeling & Database Administration

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

Governance & Master Data Management

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

Direction, Standards & Enablement

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

Specific Qualifications

Required

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

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

Company Overview

IES is a national provider of industrial products and infrastructure services to a variety of end markets, including electrical, mechanical and communications contracting solutions for the commercial, industrial, residential and renewable energy markets. IES is publicly traded on NASDAQ under the symbol IESC. As of the end of IES’s 2025 fiscal year ending September 30, 2025, IES produced over $3.3 billion in revenue and employed over 10,200 employees at over 174 domestic locations across the United States.

Our commitment to our employees is reflected by our actions:

• Safety is Priority One – and our record shows it
• 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

EEO & Affinitive Action

The IES policy on equal employment opportunity prohibits discrimination based on race, color, religion, national origin, sex, age, gender identity, sexual orientation, individuals with disabilities, protected veterans, or any other protected status or characteristic. This policy applies to recruiting, hiring, transfers, promotions, terminations, compensation, benefits, and all other terms and conditions of employment, and also states that retaliation against any employee who files a complaint regarding possible violations of this policy will not be tolerated. IES is also committed to taking affirmative steps to promote the employment of minorities, women, individuals with disabilities, and protected veterans. IES develops affirmative action programs to support its commitment to equal employment opportunity, consistent with company policy and the company’s obligations as a contractor to the United States government.

View Your Equal Employment Opportunity rights under the law. "Know Your Rights: Workplace Discrimination is Illegal; Conozca sus Derechos: La Discriminación en el Lugar de Trabajo es Ilegal

Disability Accommodation

IES is an Equal Opportunity/Affirmative Action Employer. IES provides reasonable accommodation for individuals protected by Section 503 of the Rehabilitation Act of 1973, the Vietnam Era Veterans' Readjustment Assistance Act of 1974 and Title I of the Americans with Disabilities Act of 1990. Applicants who need accommodation in the job application process should contact the IES corporate office at View phone number on click.appcast.io or any IES office to request assistance.

IES Participates in E-Verify/IES participa en el programa E-Verify

E-Verify Information/ Información sobre E-Verify

English/Español

Right to Work/Ley de Derecho al Trabajo

English/Español