Sr Data Engineer / Data Architect

Integra • Dallas, TX

21h

About The Position

The Senior Data Engineer / Data Architect designs, implements, and evolves Integra’s enterprise data platform, focusing on a modern Azure-based Lakehouse environment that integrates data across ERP, scheduling, construction management, manufacturing, HR, CRM, and operational systems. This hands-on role establishes scalable data architecture and engineering standards, develops canonical and semantic data models, and delivers trusted data products for ERP modernization, enterprise reporting, advanced analytics, and self-service business intelligence. It combines strategic architecture responsibilities with direct technical contributions across Microsoft Fabric, Azure Databricks, data integration, governance, quality, lineage, observability, and platform optimization.

The role defines enterprise architecture standards and reusable patterns; designs Bronze, Silver, and Gold Lakehouse architectures; develops metadata-driven ingestion and processing frameworks, ELT pipelines, and data quality and reconciliation controls; and builds Delta Lake layers and Spark/PySpark transformation pipelines. It integrates enterprise systems, develops source-to-canonical mappings, enables governed analytics and reporting, and provides technical guidance on architecture, engineering practices, performance, and reliability. The position partners with business and technology stakeholders to translate requirements into scalable, supportable data solutions.

Integra describes itself as a vertically integrated company delivering turnkey data center infrastructure solutions, with work spanning site selection, design, manufacturing, procurement, commissioning, and warranty. Its culture emphasizes collaboration, accountability, and continuous improvement.

Requirements

• Bachelor’s degree in Computer Science, Information Systems, Data Engineering, or a related discipline, or equivalent professional experience.
• At least 8 years of experience in Data Engineering, Data Architecture, or a related discipline.
• Proven experience designing and implementing enterprise-scale cloud data platforms and modern Lakehouse architectures.
• Strong hands-on experience with Azure data services, advanced SQL, Python, PySpark, Spark, Delta Lake, Parquet, ETL/ELT design, metadata-driven frameworks, and performance optimization.
• Practical experience with Microsoft Fabric and/or Azure Databricks, including platform-specific Lakehouse, pipeline, orchestration, governance, and semantic modeling capabilities.
• Experience integrating data from multiple enterprise applications and business domains.
• Strong knowledge of canonical, dimensional, and star schema modeling; conformed dimensions; master data management; governance; lineage; and metadata management.
• Strong communication and stakeholder management skills, including the ability to translate business requirements into scalable technical solutions.
• Ability to operate as both an enterprise data architect and a hands-on senior engineering contributor.

Nice To Haves

• Experience with Oracle Fusion ERP, Deltek Costpoint, Primavera P6, Procore, Salesforce, SAP S/4HANA, Autodesk Construction Cloud, or comparable enterprise platforms.
• Knowledge of financial and ERP, project controls, construction and engineering, or manufacturing data domains.

Responsibilities

• Define and maintain enterprise data architecture standards, best practices, and reusable patterns supporting application modernization and future system migrations.
• Design scalable Bronze, Silver, and Gold Lakehouse architectures and enterprise semantic models for reporting, analytics, and governed self-service BI.
• Develop and govern canonical data models across ERP, CRM, scheduling, construction management, manufacturing, HR, and other operational domains.
• Establish standards for data integration, metadata, lineage, data quality, governance, security, and trusted business definitions.
• Design and implement metadata-driven ingestion and processing frameworks for structured, semi-structured, and API-based data sources.
• Build scalable ELT pipelines, Change Data Capture processes, incremental loading strategies, reconciliation controls, and audit capabilities.
• Implement monitoring, alerting, logging, observability, and operational support frameworks across the data platform.
• Optimize platform performance, scalability, reliability, storage architecture, and cloud cost management.
• Design and implement enterprise Lakehouse solutions using Microsoft Fabric and/or Azure Databricks.
• Build and maintain Delta Lake-based Bronze, Silver, and Gold data layers and develop Spark and PySpark transformation pipelines.
• Implement data quality controls, lineage tracking, governance processes, job orchestration, and reusable engineering standards.
• Evaluate platform options based on business requirements, scalability, operational considerations, and cost optimization.
• Integrate data from ERP, scheduling, project controls, construction management, manufacturing, HR, CRM, and other operational platforms.
• Define and maintain source-to-canonical mappings across enterprise applications, including Oracle Fusion ERP, Deltek Costpoint, Primavera P6, Procore, Salesforce, and comparable systems.
• Partner with business and technology stakeholders to translate requirements into scalable, supportable data solutions.
• Support ERP modernization and broader enterprise transformation initiatives through reliable data integration and architecture.
• Partner with Finance, Operations, Project Controls, and Business Intelligence teams to support enterprise reporting and analytics platforms.
• Define business metrics, KPIs, semantic models, conformed dimensions, and data standards in alignment with stakeholder requirements.
• Enable reusable, governed, and trusted data products for self-service analytics and executive reporting.
• Improve enterprise data quality, governance, lineage, metadata management, and observability across the platform.
• Provide technical guidance on architecture decisions, engineering practices, performance tuning, and platform reliability.
• Promote scalable patterns that reduce technical debt and support future business growth.
• Communicate technical concepts, risks, dependencies, and recommendations clearly to business and technology stakeholders.

Benefits

• Competitive pay with incentive opportunities recognizing results and contributions.
• Medical, dental, and vision coverage.
• Life and disability insurance programs.
• Voluntary benefits options.
• Generous paid time off.
• Education assistance and tuition support.
• Retirement and savings programs.

What This Job Offers

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