Position Summary Hirschi Companies is a multi-entity construction and asset enterprise operating across Nevada, Arizona and Utah. Hirschi has invested in an Enterprise Intelligence Platform built on

Microsoft Fabric:

a lakehouse with medallion architecture spanning all operating entities, a unified semantic model, and executive dashboards used in daily decision-making. The platform was built with an implementation partner, and ownership is now moving in-house. The Enterprise Data & AI Architect is the person it moves to. This is a hands-on builder role at the intersection of data engineering, business analysis and applied AI. AI and automation carry equal weight with platform ownership. The platform is already built; the bar is that everything the implementation partner can do on it, you can do. Completing knowledge transfer and running the platform independently is the first order of business. You will report to the VP of Technology, who owns the relationships with executive leadership and the business presidents; requirements and priorities reach you through that channel. Within that structure you have real ownership: architecture decisions, tooling decisions, and the roadmap recommendation for what the platform does next. Essential Job Responsibilities Own the Microsoft Fabric Enterprise Intelligence Platform end to end: Bronze, Silver and Gold medallion layers on Delta Lake across all operating entities, with documented lineage and entity relationships. Complete knowledge transfer from the implementation partner and operate the platform independently; the bar is that everything the partner can do on the platform, you can do. Build, operate and extend data pipelines and notebooks (PySpark, SQL) ingesting from ERP, project, CRM, time tracking, fleet, safety and work management systems, plus historical financial data from legacy platforms; ERP additions (new entities, modules and fields) are absorbed without rework. Bring new source systems and new ERP data onto the platform end to end: pipeline build, semantic model extension, and the new Power BI dashboards that come with them, from requirements through production.

Run the data quality framework:

validation tests, reconciliation to the ERP and the monthly close, and a variance log leadership can trust. Operate pipeline monitoring, alerting and break-fix in-house; manage Fabric capacity, cost and performance. Maintain CI/CD through Azure DevOps Git across dev, UAT and production, with code review and environment promotion as standard practice. Own the unified Power BI semantic model: star schema, DAX measures, time intelligence, and documentation kept AI-ready with business-friendly naming. Maintain and extend the executive dashboards, reconciled to source with no manual adjustment, and design and build new dashboards and report pages with drill-down from enterprise to entity to job. Implement and maintain row-level security tied to Entra ID groups, with data classification applied to PII, payroll and financial data before anything goes live. Participate in the vendor-led SharePoint buildout: digest the knowledge transfer, give input on structure, metadata and data-related applications, and own feeding SharePoint data into Fabric. Integrate SharePoint, monday.com and Fabric so project data flows without duplicate entry. Document the business process for each division and partner with the VP of Technology to find and prioritize the processes worth automating with AI. Translate operational questions into KPIs, models and reports, working from requirements the VP of Technology gathers and prioritizes with business leadership. Identify business problems AI can solve, then build and ship the solutions: document processing, workflow automation, agents over governed data. Build Hirschi's first machine learning, forecasting and prediction models on the Fabric platform. Build process automations across Microsoft 365, monday.com and operational systems that remove manual re-entry and duplicate work.

Support AI governance:

usage policy, data handling rules, role-based access to confidential data, and adoption that is measured rather than assumed. Drive adoption through training and role-based enablement, and maintain platform documentation so the enterprise never depends on what lives in one person's head. Must Have - Required Qualifications 7+ years in data engineering, business intelligence or analytics engineering, including 2+ years hands-on with Microsoft Fabric or a closely comparable lakehouse platform (Databricks, Synapse) with a fast ramp to Fabric. At least 2 enterprise-level platform buildouts (a lakehouse or BI platform serving multiple business units or entities) carried end to end, from architecture through production operation.

Work samples are required:

sanitized architecture diagrams, semantic models or dashboards, in a portfolio or a live walkthrough. Deep experience with medallion architecture, Delta Lake, and pipeline development in PySpark and SQL.

Expert-level Power BI:

semantic model design, DAX, row-level security, performance tuning, and dashboards non-technical leaders actually use. At least one current Microsoft Fabric certification (DP-600 Fabric Analytics Engineer or DP-700 Fabric Data Engineer), or earned within the first 90 days of hire.

Demonstrated applied AI experience:

AI solutions built and shipped against business problems (automation, document processing, agents, forecasting), with AI-assisted development as part of daily work.

Strong business analysis skills:

gathering requirements, documenting business processes, and explaining technical tradeoffs in business terms. Working knowledge of SharePoint and the Power Platform (Lists, Power Apps, Power Automate) sufficient to give informed input on data applications and integrate SharePoint data into the platform. Experience with Git-based CI/CD, preferably Azure DevOps, across dev, UAT and production environments.

Self-directed:

able to own an enterprise platform without a large team around you. Must be authorized to work in the United States. Must pass a mandatory drug test and background check. Must pass Hirschi's Driver Approval Process. Must be able to read and write in English at a level sufficient to follow instructions, complete documentation, and communicate effectively. Must be able to lift 25 lbs. Nice to Have - Preferred Qualifications Machine learning and forecasting: hands-on experience building and deploying prediction models in Python (Fabric data science workloads, Azure ML or similar). Nothing predictive exists at Hirschi yet, so candidates who bring this are strongly preferred. Additional Microsoft certifications beyond the required Fabric certification: the second of

DP-600/DP-700, PL-300

(Power BI), AI-102 (Azure AI Engineer). Construction, real estate or asset-heavy industry experience, especially with ERP data from Viewpoint Vista or similar, and platforms like Procore. Microsoft Purview or comparable data governance and classification tooling. Experience integrating work management platforms (monday.com or similar) by API. Experience taking over a platform from a consulting partner and running it as the in-house owner. Bilingual (English/Spanish).

Core Competencies Technical Excellence:

Builds and runs reliable, well-documented data and AI infrastructure with attention to quality and scalability.

Analytical Thinking:

Identifies root causes quickly and applies structured problem-solving to complex data issues.

Ownership:

Takes full accountability for platform uptime, data quality, and architecture decisions, with no vendor dependency as the default path.

Communication:

Frames technical decisions in business terms the VP of Technology can carry to leadership.

Collaboration:

Partners effectively with the VP of Technology, vendors, and cross-functional teams.

Discipline:

Follows proper sequencing and governance standards without shortcuts. Join us to be at the forefront of technological innovation! This role offers an exciting opportunity to influence our enterprise data & AI architecture landscape while working with cutting-edge tools and methodologies that shape the future of our organization's digital journey.

Pay:

$145,000.00 - $170,000.00 per year

Benefits:

401(k) Dental insurance Employee assistance program Health insurance Life insurance Paid time off Retirement plan Vision insurance People with a criminal record are encouraged to apply Application Question(s): Demonstrated applied AI experience: AI solutions built and shipped against business problems (automation, document processing, agents, forecasting), with AI-assisted development as part of daily work. Experience with Git-based CI/CD, preferably Azure DevOps, across dev, UAT and production environments. At least one current Microsoft Fabric certification (DP-600 Fabric Analytics Engineer or DP-700 Fabric Data Engineer), or earned within the first 90 days of hire.

Experience:

Data Engineering, business intelligence and analytics: 7 years (Required) enterprise level platform buildouts or Bi platform: 2 years (Required)

Work Location:

In person